473,725 Members | 2,244 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Binding to Gridview

I'm having trouble getting a gridview to bind. I probably missing something
completely obvious and would appreciate any help on offer.

I'm passing parameters via querystring, and have created a stored proc as
follows:

qGetSearchResul ts:

SELECT
Adverts.AdvertI D,
Location.Locati on,
Jobtitle.JobTit le,
Speciality.Spec iality FROM (((Adverts
INNER JOIN Employer ON Adverts.Employe rID = Employer.Employ erID)
INNER JOIN Jobtitle ON Adverts.JobTitl eID = Jobtitle.JobTit leID)
INNER JOIN Location ON Employer.Locati onID = Location.Locati onID)
INNER JOIN Speciality ON Adverts.Special ityID = Speciality.Spec ialityID
WHERE
(@JobTitleID IS NULL OR Adverts.JobTitl eID = @JobTitleID)
AND (@JobTitleID IS NULL OR Adverts.JobTitl eID = @JobTitleID)
AND (@SpecialityID IS NULL OR Adverts.Special ityID = @SpecialityID)
AND (@LocationID IS NULL OR Employer.Locati onID = @LocationID)
AND (@KeyWords IS NULL OR Adverts.InfoTex t LIKE '%' + @KeyWords + '%')
AND (((Adverts.Star tDate)<=GetDate ())
AND (Adverts.EndDat e)>=GetDate())
ORDER BY Location.Locati on

I have verified this works as expected in the Query Designer.

On the page, I have placed a DataSource Control and a GridView. The code
for both is as follows:

<asp:GridView ID="gvSearchRes ults" runat="server" AllowSorting="T rue"
AutoGenerateCol umns="False"
DataKeyNames="A dvertID" DataSourceID="d sSearchResults" >
<Columns>
<asp:CommandFie ld ShowSelectButto n="True" />
<asp:BoundFie ld DataField="Adve rtID" HeaderText="Adv ertID"
InsertVisible=" False"
ReadOnly="True" SortExpression= "AdvertID" />
<asp:BoundFie ld DataField="Loca tion" HeaderText="Loc ation"
SortExpression= "Location" />
<asp:BoundFie ld DataField="JobT itle" HeaderText="Job Title"
SortExpression= "JobTitle" />
<asp:BoundFie ld DataField="Spec iality" HeaderText="Spe ciality"
SortExpression= "Speciality " />
</Columns>
</asp:GridView>

<asp:SqlDataSou rce ID="dsSearchRes ults" runat="server"
ConnectionStrin g="<%$ ConnectionStrin gs:xxxx %>"
SelectCommand=" qGetSearchResul ts" SelectCommandTy pe="StoredProce dure">
<SelectParamete rs>
<asp:QueryStrin gParameter Name="JobTitleI D" QueryStringFiel d="JobTitleID "
Type="Int32" />
<asp:QueryStrin gParameter Name="Specialit yID"
QueryStringFiel d="SpecialityID " Type="Int32" />
<asp:QueryStrin gParameter Name="LocationI D" QueryStringFiel d="LocationID "
Type="Int32" />
<asp:QueryStrin gParameter Name="KeyWords" QueryStringFiel d="KeyWords"
Type="String" />
</SelectParameter s>
</asp:SqlDataSour ce>

If I navigate to the page using a URL and querystring like this:

searchResults.a spx?LocationID= &SpecialityID=& KeyWords=&JobTi tleID=35

the GridView refuses to appear, despite the fact that executing the Stored
Proc in SQL Server gives me 10 results.

What have I missed?
Mike
Oct 7 '06 #1
4 2605
You need to do a DataBind for the control sometime before the page renders.
myDataGrid.Data Bind


"Mike" <ne****@dotnet. comwrote in message
news:uS******** ******@TK2MSFTN GP04.phx.gbl...
I'm having trouble getting a gridview to bind. I probably missing
something completely obvious and would appreciate any help on offer.

I'm passing parameters via querystring, and have created a stored proc as
follows:

qGetSearchResul ts:

SELECT
Adverts.AdvertI D,
Location.Locati on,
Jobtitle.JobTit le,
Speciality.Spec iality FROM (((Adverts
INNER JOIN Employer ON Adverts.Employe rID = Employer.Employ erID)
INNER JOIN Jobtitle ON Adverts.JobTitl eID = Jobtitle.JobTit leID)
INNER JOIN Location ON Employer.Locati onID = Location.Locati onID)
INNER JOIN Speciality ON Adverts.Special ityID = Speciality.Spec ialityID
WHERE
(@JobTitleID IS NULL OR Adverts.JobTitl eID = @JobTitleID)
AND (@JobTitleID IS NULL OR Adverts.JobTitl eID = @JobTitleID)
AND (@SpecialityID IS NULL OR Adverts.Special ityID = @SpecialityID)
AND (@LocationID IS NULL OR Employer.Locati onID = @LocationID)
AND (@KeyWords IS NULL OR Adverts.InfoTex t LIKE '%' + @KeyWords + '%')
AND (((Adverts.Star tDate)<=GetDate ())
AND (Adverts.EndDat e)>=GetDate())
ORDER BY Location.Locati on

I have verified this works as expected in the Query Designer.

On the page, I have placed a DataSource Control and a GridView. The code
for both is as follows:

<asp:GridView ID="gvSearchRes ults" runat="server" AllowSorting="T rue"
AutoGenerateCol umns="False"
DataKeyNames="A dvertID" DataSourceID="d sSearchResults" >
<Columns>
<asp:CommandFie ld ShowSelectButto n="True" />
<asp:BoundFie ld DataField="Adve rtID" HeaderText="Adv ertID"
InsertVisible=" False"
ReadOnly="True" SortExpression= "AdvertID" />
<asp:BoundFie ld DataField="Loca tion" HeaderText="Loc ation"
SortExpression= "Location" />
<asp:BoundFie ld DataField="JobT itle" HeaderText="Job Title"
SortExpression= "JobTitle" />
<asp:BoundFie ld DataField="Spec iality" HeaderText="Spe ciality"
SortExpression= "Speciality " />
</Columns>
</asp:GridView>

<asp:SqlDataSou rce ID="dsSearchRes ults" runat="server"
ConnectionStrin g="<%$ ConnectionStrin gs:xxxx %>"
SelectCommand=" qGetSearchResul ts" SelectCommandTy pe="StoredProce dure">
<SelectParamete rs>
<asp:QueryStrin gParameter Name="JobTitleI D" QueryStringFiel d="JobTitleID "
Type="Int32" />
<asp:QueryStrin gParameter Name="Specialit yID"
QueryStringFiel d="SpecialityID " Type="Int32" />
<asp:QueryStrin gParameter Name="LocationI D" QueryStringFiel d="LocationID "
Type="Int32" />
<asp:QueryStrin gParameter Name="KeyWords" QueryStringFiel d="KeyWords"
Type="String" />
</SelectParameter s>
</asp:SqlDataSour ce>

If I navigate to the page using a URL and querystring like this:

searchResults.a spx?LocationID= &SpecialityID=& KeyWords=&JobTi tleID=35

the GridView refuses to appear, despite the fact that executing the Stored
Proc in SQL Server gives me 10 results.

What have I missed?
Mike

Oct 8 '06 #2
I thought this happened automatically if you plonked a sqlDataSource and a
data control on a page. It does on other pages where I have done so.

Nevertheless, I think there must be something wrong with the stored proc.
So I am doing a switch case for the 15 possible variations of querystring
values and creating 15 procs, then binding the gridview programmaticall y in
the Page_Load event to the correct proc depending on which values were
passed. That seems to work. I just hope no one asks me to add a fifth
querystring variable....
"Mr Struggler" <lkjhlkjwrote in message
news:O3******** ******@TK2MSFTN GP03.phx.gbl...
You need to do a DataBind for the control sometime before the page
renders.
myDataGrid.Data Bind


"Mike" <ne****@dotnet. comwrote in message
news:uS******** ******@TK2MSFTN GP04.phx.gbl...
>I'm having trouble getting a gridview to bind. I probably missing
something completely obvious and would appreciate any help on offer.

I'm passing parameters via querystring, and have created a stored proc as
follows:

qGetSearchResu lts:

SELECT
Adverts.Advert ID,
Location.Locat ion,
Jobtitle.JobTi tle,
Speciality.Spe ciality FROM (((Adverts
INNER JOIN Employer ON Adverts.Employe rID = Employer.Employ erID)
INNER JOIN Jobtitle ON Adverts.JobTitl eID = Jobtitle.JobTit leID)
INNER JOIN Location ON Employer.Locati onID = Location.Locati onID)
INNER JOIN Speciality ON Adverts.Special ityID = Speciality.Spec ialityID
WHERE
(@JobTitleID IS NULL OR Adverts.JobTitl eID = @JobTitleID)
AND (@JobTitleID IS NULL OR Adverts.JobTitl eID = @JobTitleID)
AND (@SpecialityID IS NULL OR Adverts.Special ityID = @SpecialityID)
AND (@LocationID IS NULL OR Employer.Locati onID = @LocationID)
AND (@KeyWords IS NULL OR Adverts.InfoTex t LIKE '%' + @KeyWords + '%')
AND (((Adverts.Star tDate)<=GetDate ())
AND (Adverts.EndDat e)>=GetDate())
ORDER BY Location.Locati on

I have verified this works as expected in the Query Designer.

On the page, I have placed a DataSource Control and a GridView. The code
for both is as follows:

<asp:GridVie w ID="gvSearchRes ults" runat="server" AllowSorting="T rue"
AutoGenerateCo lumns="False"
DataKeyNames=" AdvertID" DataSourceID="d sSearchResults" >
<Columns>
<asp:CommandFi eld ShowSelectButto n="True" />
<asp:BoundFiel d DataField="Adve rtID" HeaderText="Adv ertID"
InsertVisible= "False"
ReadOnly="True " SortExpression= "AdvertID" />
<asp:BoundFiel d DataField="Loca tion" HeaderText="Loc ation"
SortExpression ="Location" />
<asp:BoundFiel d DataField="JobT itle" HeaderText="Job Title"
SortExpression ="JobTitle" />
<asp:BoundFiel d DataField="Spec iality" HeaderText="Spe ciality"
SortExpression ="Speciality " />
</Columns>
</asp:GridView>

<asp:SqlDataSo urce ID="dsSearchRes ults" runat="server"
ConnectionStri ng="<%$ ConnectionStrin gs:xxxx %>"
SelectCommand= "qGetSearchResu lts" SelectCommandTy pe="StoredProce dure">
<SelectParamet ers>
<asp:QueryStri ngParameter Name="JobTitleI D" QueryStringFiel d="JobTitleID "
Type="Int32" />
<asp:QueryStri ngParameter Name="Specialit yID"
QueryStringFie ld="SpecialityI D" Type="Int32" />
<asp:QueryStri ngParameter Name="LocationI D" QueryStringFiel d="LocationID "
Type="Int32" />
<asp:QueryStri ngParameter Name="KeyWords" QueryStringFiel d="KeyWords"
Type="String " />
</SelectParameter s>
</asp:SqlDataSour ce>

If I navigate to the page using a URL and querystring like this:

searchResults. aspx?LocationID =&SpecialityID= &KeyWords=&JobT itleID=35

the GridView refuses to appear, despite the fact that executing the
Stored Proc in SQL Server gives me 10 results.

What have I missed?
Mike


Oct 8 '06 #3
OK your using 2005, I'm not familar with that yet
"Mike" <ne****@dotnet. comwrote in message
news:eF******** ******@TK2MSFTN GP04.phx.gbl...
>I thought this happened automatically if you plonked a sqlDataSource and a
data control on a page. It does on other pages where I have done so.

Nevertheless, I think there must be something wrong with the stored proc.
So I am doing a switch case for the 15 possible variations of querystring
values and creating 15 procs, then binding the gridview programmaticall y
in the Page_Load event to the correct proc depending on which values were
passed. That seems to work. I just hope no one asks me to add a fifth
querystring variable....
"Mr Struggler" <lkjhlkjwrote in message
news:O3******** ******@TK2MSFTN GP03.phx.gbl...
>You need to do a DataBind for the control sometime before the page
renders.
myDataGrid.Dat aBind


"Mike" <ne****@dotnet. comwrote in message
news:uS******* *******@TK2MSFT NGP04.phx.gbl.. .
>>I'm having trouble getting a gridview to bind. I probably missing
something completely obvious and would appreciate any help on offer.

I'm passing parameters via querystring, and have created a stored proc
as follows:

qGetSearchRes ults:

SELECT
Adverts.Adver tID,
Location.Loca tion,
Jobtitle.JobT itle,
Speciality.Sp eciality FROM (((Adverts
INNER JOIN Employer ON Adverts.Employe rID = Employer.Employ erID)
INNER JOIN Jobtitle ON Adverts.JobTitl eID = Jobtitle.JobTit leID)
INNER JOIN Location ON Employer.Locati onID = Location.Locati onID)
INNER JOIN Speciality ON Adverts.Special ityID = Speciality.Spec ialityID
WHERE
(@JobTitleI D IS NULL OR Adverts.JobTitl eID = @JobTitleID)
AND (@JobTitleID IS NULL OR Adverts.JobTitl eID = @JobTitleID)
AND (@SpecialityID IS NULL OR Adverts.Special ityID = @SpecialityID)
AND (@LocationID IS NULL OR Employer.Locati onID = @LocationID)
AND (@KeyWords IS NULL OR Adverts.InfoTex t LIKE '%' + @KeyWords + '%')
AND (((Adverts.Star tDate)<=GetDate ())
AND (Adverts.EndDat e)>=GetDate())
ORDER BY Location.Locati on

I have verified this works as expected in the Query Designer.

On the page, I have placed a DataSource Control and a GridView. The
code for both is as follows:

<asp:GridVi ew ID="gvSearchRes ults" runat="server" AllowSorting="T rue"
AutoGenerateC olumns="False"
DataKeyNames= "AdvertID" DataSourceID="d sSearchResults" >
<Columns>
<asp:CommandF ield ShowSelectButto n="True" />
<asp:BoundFie ld DataField="Adve rtID" HeaderText="Adv ertID"
InsertVisible ="False"
ReadOnly="Tru e" SortExpression= "AdvertID" />
<asp:BoundFie ld DataField="Loca tion" HeaderText="Loc ation"
SortExpressio n="Location" />
<asp:BoundFie ld DataField="JobT itle" HeaderText="Job Title"
SortExpressio n="JobTitle" />
<asp:BoundFie ld DataField="Spec iality" HeaderText="Spe ciality"
SortExpressio n="Speciality " />
</Columns>
</asp:GridView>

<asp:SqlDataS ource ID="dsSearchRes ults" runat="server"
ConnectionStr ing="<%$ ConnectionStrin gs:xxxx %>"
SelectCommand ="qGetSearchRes ults" SelectCommandTy pe="StoredProce dure">
<SelectParame ters>
<asp:QueryStr ingParameter Name="JobTitleI D"
QueryStringFi eld="JobTitleID " Type="Int32" />
<asp:QueryStr ingParameter Name="Specialit yID"
QueryStringFi eld="Speciality ID" Type="Int32" />
<asp:QueryStr ingParameter Name="LocationI D"
QueryStringFi eld="LocationID " Type="Int32" />
<asp:QueryStr ingParameter Name="KeyWords" QueryStringFiel d="KeyWords"
Type="Strin g" />
</SelectParameter s>
</asp:SqlDataSour ce>

If I navigate to the page using a URL and querystring like this:

searchResults .aspx?LocationI D=&SpecialityID =&KeyWords=&Job TitleID=35

the GridView refuses to appear, despite the fact that executing the
Stored Proc in SQL Server gives me 10 results.

What have I missed?
Mike



Oct 8 '06 #4
I did mention GridView in my OP as opposed to DataGrid, but nevermind :-)
I've found the answer after many frustrating hours.

My requirement is a common one(I believe). I want to give the user the
option to search on any combination of 4 criteria. This means that one or
more of the criteria could well be NULL. Consequently, the parameter value
will be NULL, and I set that as a default value in the stored proc for each
parameter.

The default for the sqlDataSource is that it doesn't bother to do anything
if you leave any parameter as NULL, so you have to go into its properties
and change the CancelSelectOnN ullParameter value to false. It's true by
default. When I say it doesn't do anything, I mean nothing at all. It
doesn't even throw an exception, which I would expect it to do if it was not
prepared to handle NULL values.

The configuration wizard allows you to enter default values for the
parameters as wel as their source. It doesn't allow you to supply NULL as a
default. If you type NULL in, it treats it as a string and complains.

I've got 3 books on ASP.NET 2.0 and this is not mentioned in any one of
them, nor could I find it without deep burrowing through google, despite the
fact that I must have read *almost* every article on dynamic search
conditions and the sqlDataSource on the Internet.

I've rewritten the page and the stored proc so many times I'm bored looking
at it, and all the time my original code works perfectly well with that one
amendment to one property.

Now that I know what to google for, I find I'm not the only person to be
driven round the bend on this one:

http://blogs.wdevs.com/colinangusmac...09/08/197.aspx
http://www.danielroot.com/CodeSpeak/...5/Default.aspx
http://sqlblogcasts.com/blogs/tonyro...06/06/792.aspx
http://www.dotnetmonster.com/Uwe/For...ce-not-binding
http://www.mooredynasty.com/Blog/Blo...Period=2006_01

etc, etc.

I nearly threw my hands up and went back to classic ASP, but now I've
invested so much time in this one flaming page, I've got to stick with
learning Dotnet.

Phew. Rant over :-)

Mike

"Mr Struggler" <lkjhlkjwrote in message
news:uQ******** ******@TK2MSFTN GP05.phx.gbl...
OK your using 2005, I'm not familar with that yet
"Mike" <ne****@dotnet. comwrote in message
news:eF******** ******@TK2MSFTN GP04.phx.gbl...
>>I thought this happened automatically if you plonked a sqlDataSource and a
data control on a page. It does on other pages where I have done so.

Nevertheless , I think there must be something wrong with the stored proc.
So I am doing a switch case for the 15 possible variations of querystring
values and creating 15 procs, then binding the gridview programmaticall y
in the Page_Load event to the correct proc depending on which values were
passed. That seems to work. I just hope no one asks me to add a fifth
querystring variable....
"Mr Struggler" <lkjhlkjwrote in message
news:O3******* *******@TK2MSFT NGP03.phx.gbl.. .
>>You need to do a DataBind for the control sometime before the page
renders.
myDataGrid.Da taBind


"Mike" <ne****@dotnet. comwrote in message
news:uS****** ********@TK2MSF TNGP04.phx.gbl. ..
I'm having trouble getting a gridview to bind. I probably missing
something completely obvious and would appreciate any help on offer.

I'm passing parameters via querystring, and have created a stored proc
as follows:

qGetSearchRe sults:

SELECT
Adverts.Adve rtID,
Location.Loc ation,
Jobtitle.Job Title,
Speciality.S peciality FROM (((Adverts
INNER JOIN Employer ON Adverts.Employe rID = Employer.Employ erID)
INNER JOIN Jobtitle ON Adverts.JobTitl eID = Jobtitle.JobTit leID)
INNER JOIN Location ON Employer.Locati onID = Location.Locati onID)
INNER JOIN Speciality ON Adverts.Special ityID = Speciality.Spec ialityID
WHERE
(@JobTitle ID IS NULL OR Adverts.JobTitl eID = @JobTitleID)
AND (@JobTitleID IS NULL OR Adverts.JobTitl eID = @JobTitleID)
AND (@SpecialityID IS NULL OR Adverts.Special ityID = @SpecialityID)
AND (@LocationID IS NULL OR Employer.Locati onID = @LocationID)
AND (@KeyWords IS NULL OR Adverts.InfoTex t LIKE '%' + @KeyWords + '%')
AND (((Adverts.Star tDate)<=GetDate ())
AND (Adverts.EndDat e)>=GetDate())
ORDER BY Location.Locati on

I have verified this works as expected in the Query Designer.

On the page, I have placed a DataSource Control and a GridView. The
code for both is as follows:

<asp:GridVie w ID="gvSearchRes ults" runat="server" AllowSorting="T rue"
AutoGenerate Columns="False"
DataKeyNames ="AdvertID" DataSourceID="d sSearchResults" >
<Columns>
<asp:Command Field ShowSelectButto n="True" />
<asp:BoundFi eld DataField="Adve rtID" HeaderText="Adv ertID"
InsertVisibl e="False"
ReadOnly="Tr ue" SortExpression= "AdvertID" />
<asp:BoundFi eld DataField="Loca tion" HeaderText="Loc ation"
SortExpressi on="Location" />
<asp:BoundFi eld DataField="JobT itle" HeaderText="Job Title"
SortExpressi on="JobTitle" />
<asp:BoundFi eld DataField="Spec iality" HeaderText="Spe ciality"
SortExpressi on="Speciality " />
</Columns>
</asp:GridView>

<asp:SqlData Source ID="dsSearchRes ults" runat="server"
ConnectionSt ring="<%$ ConnectionStrin gs:xxxx %>"
SelectComman d="qGetSearchRe sults" SelectCommandTy pe="StoredProce dure">
<SelectParam eters>
<asp:QuerySt ringParameter Name="JobTitleI D"
QueryStringF ield="JobTitleI D" Type="Int32" />
<asp:QuerySt ringParameter Name="Specialit yID"
QueryStringF ield="Specialit yID" Type="Int32" />
<asp:QuerySt ringParameter Name="LocationI D"
QueryStringF ield="LocationI D" Type="Int32" />
<asp:QuerySt ringParameter Name="KeyWords" QueryStringFiel d="KeyWords"
Type="String " />
</SelectParameter s>
</asp:SqlDataSour ce>

If I navigate to the page using a URL and querystring like this:

searchResult s.aspx?Location ID=&SpecialityI D=&KeyWords=&Jo bTitleID=35

the GridView refuses to appear, despite the fact that executing the
Stored Proc in SQL Server gives me 10 results.

What have I missed?
Mike



Oct 8 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
18539
by: sck10 | last post by:
Hello, I have a GridView that is using the following to connect to a SQL Server 2000 stored procedure: <asp:SqlDataSource ID="dsWebDocList" SelectCommand="sp_web_WebDocument" ConnectionString="<%$ ConnectionStrings:cnnSQL_Connect %>" Runat="server"> <SelectParameters> <asp:Parameter Type="String" DefaultValue="FindWebDocAll"
3
3482
by: Hans Merkl | last post by:
Hi, I was wondering if it's possible to bind the header text of a GridView column to a method of an object I have. At the moment I am setting the header texts in Page_Load but I was wondering if I can do with databinding. thanks Hans Merkl
1
2029
by: Smash | last post by:
I have problem binding gridview.... At first i didn't want to bind gridview at first page load...so in my objectdatasource_selecting event i wrote this: If Not Page.IsPostBack Then e.Cancel = True End If Thats solved the problem for the first bind....
3
6992
by: mateo | last post by:
Hello, I have a GridView inside which i want to show 3 dropdownList (one for each Column). So i've created 3 TemplateField Continent Country City
5
11221
by: Amit | last post by:
Hello, I have a simple search screen, with two drop-downs and a text box. There's also a GridView control that is using a SqlDataSource control to show the matching results. The SqlDataSource uses the control values in its query as parameters. Two questions: 1. When the Find button is clicked, how do I tell the GridView to load the data? 2. How do I stop the GridView from data binding when the page first loads? I don't want to...
8
8532
by: AG | last post by:
ASP.NET 2.0, VS 2005 I have a gridview with paging enabled, bound to an objectdatasource. Both were dropped on to the page and configured via the wizards. Basically working as expected. The gridview's databind method is apparently called when the page is loaded as I have no code calling the databind method. How can I keep the gridview from databinding automatically and control it myself?
3
2650
by: RobertTheProgrammer | last post by:
Hi folks, I've got another problem. Basically, I'm trying to use a nested GridView, however the nexted GridView displays no values (even though in debug I'm getting valid values into my DataSet. It's probably a binding issue somewhere, but I'm not sure where. Here's the ASP (slightly edited to remove verbosity): <asp:GridView ID="GridViewMain" runat="server" AutoGenerateColumns="False" BackColor="White" BorderColor="#999999" ...
0
1529
by: Sobin Thomas | last post by:
Hi All, How can I bind the Gridview control to Sql Datasource control on a button click(I see majority of the articles binding datasource at page load) I need to enable the paging and sorting of the Gridview control also .Actually I am able to bind the sql datasource control to the Gridview on button Click but on clicking the GridView for paging or sorting , the Gridview vanishes!! In short, I want to bind the GridView control to a...
1
2021
by: Sobin Thomas | last post by:
Hi All, How can I bind the Gridview control to Sql Datasource control on a button click(I see majority of the articles binding datasource at page load) I need to enable the paging and sorting of the Gridview control also .Actually I am able to bind the sql datasource control to the Gridview on button Click but on clicking the GridView for paging or sorting , the Gridview vanishes!! In short, I want to bind the GridView control to a...
0
9393
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9248
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9164
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9092
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6695
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4506
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4775
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2622
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2151
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.