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. The SqlDataSource control uses ADO.NET classes to interact with any database supported by ADO.NET. You can use the SqlDataSource control with other controls that display data, such as the GridView, FormView and DetailsView controls to display and manipulate data using little or no code.
Questions tagged [sqldatasource]
967 questions
-2
votes
1 answer
Populating the SQLDatasource SelectCommand
How do I take this string and drop it into the select command?
String SqlC = "select * from dbo.FindIt where " + SqlStr;
The object is to populate the SelectCommand:
Juliemac
- 7
- 4
-2
votes
1 answer
which type of data source we are using for high performance?
In Performance Point Services we must create a connection to the data source or sources we want to use in dashboard. All data used in Performance Point Services is external data, living in data repositories outside of Performance Point. After we…
Aarya
- 1
- 1
-2
votes
1 answer
Having an int as a sql parameter
I'm using a sql data source in asp.net, trying to have a variable here
SELECT TOP @Number *
From Table
I want the variable to be from a dropdown that postsback on the same page. All the options in that dropdown are ints. How do I add the…
David Black
- 1
- 1
-2
votes
2 answers
ASP.NET C# : How to load a dataview object using sql classes via the code behind?
I know I can drag/drop an sqlDataSource object onto my webform and then get my connection string from my webconfig file and link it and done... But I don't want to do it that way. I want to do it programmatically.
as it can be done in a windows form…
hellooojoe
- 1
- 3
-2
votes
1 answer
When I try to insert data from textboxes to SqlDataSource, it gives me error "Object reference not set to an instance of an object"
protected void btnInsert_Click(object sender, EventArgs e)
{
string custName = ddlCustomerName.SelectedValue;
string listing = ddlListing.SelectedValue;
sdsCustomers.InsertParameters["@CustomerID"].DefaultValue =…
UGuess
- 17
- 4
-3
votes
3 answers
How to execute a query when dropdownlist selected index changes
I have a DropDownList which is populated using a sqldatasource, i.e., from database and their is a grid view which is populated with another sqldatasource connected to using the value of dropdownlist.
But it does not execute the query dynamically. I…
akshaykumar6
- 2,147
- 4
- 18
- 31