Top "Sqldatasource" questions

The SqlDataSource control enables you to use a Web control to access data located in a relational database, including Microsoft SQL Server and Oracle databases.

How to clear exisiting dropdownlist items when its content changes?

ddl2 populates based on ddl1 selected value successfully. My issue is the data that is already present in ddl2 does …

asp.net vb.net data-binding sqldatasource html-select
asp.net dropdownlist - add blank line before db values

On my page I have a DropDownList which I populate with database values from an SqlDataSource (see code below). How …

asp.net drop-down-menu sqldatasource dropdownbox
How to set SelectedValue of DropDownList in GridView EditTemplate

I am trying to do this as asked earlier. The only difference that I found is additional List item that …

c# asp.net data-binding sqldatasource
ASP.Net: drop down list and data source created dynamically

I have about 10 drop down list controls that get populated. Instead of copying/pasting and modifying a few fields on …

asp.net drop-down-menu sqldatasource dynamic-controls
How can I set the sqldatasource parameter's value?

I'm trying to set the value of the sqldatasource's selectcommand parameter @ClientID as in the code below, but it's not …

asp.net sqldatasource
"Server" vs "Data Source" in connection string

I'm new to SqlServer, right now I have SqlLocalDb installed to work locally. Good, but I can see two connection …

sql-server connection-string sqldatasource localdb
GridView with merged cells

I need to display data in grid view with merged rows for some columns. Please help me to prepare a …

c# asp.net gridview sqldatasource
How to sort columns in an ASP.NET GridView if using a custom DataSource?

I can't get my GridView to enable a user to sort a column of data when I'm using a custom …

c# asp.net gridview sqldatasource
Changing SqlDataSource.SelectCommand at runtime breaks pagination

I have a GridView bound to a SqlDataSource with a default SelectCommand defined as such: <asp:SqlDataSource ID="SqlDataSource1" …

asp.net gridview pagination sqldatasource selectcommand
Change select command of sqldatasource at runtime

HTML <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="id" DataSourceID="SqlDataSource1"> <Columns> <asp:…

c# asp.net data-binding gridview sqldatasource