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 ...
1
vote
1answer
8 views
Dynamic order by in SqlDataSource by a dropdownlist and grid view
I have a grid view that connect to the DataSqlSource. I want to sort my queries dynamically by a dropdownlist. for example by date,name,family etc.
I also join some tables in my queries.
I use this ...
-1
votes
0answers
31 views
Listbox Selected Item should display the next column in datasource
I am not able to figure out a way when a user selects an item in a listbox, a view/display next to the listbox should show another column from the same listbox datasource.
Concept is as follows:
...
0
votes
1answer
7 views
Control doesn't bind to SqlDataSource on page load with blank parameters
Suppose you have a SQLDataSource that looks like this:
<asp:SqlDataSource ID="sqldsSample" runat="server"
ConnectionString="<%$ ConnectionStrings:myConnectionString %>"
...
0
votes
0answers
17 views
SQLDataSource update command not working
(NOTE: I already found the error)
I have an SQLDataSource with a GridView. Insert/Update command is not sending to of the 3 parameters. At first view I don't have anything different than I have in ...
1
vote
0answers
40 views
Cascading dropDownLists in repeater. DropDownLists with SQL source and add/delete option
What is the trick to implement the following interface in ASP.NET?
I think the screenshot should explain everything.
Both dropDownLists work on SQL tables. [Categories],[Items] bound with ...
0
votes
0answers
25 views
SqlDataSource not being populated with parameter
I am executing an SSRS rpt and need to duplicate this in a web project with sqldatasource id's.
The ssrs rpt parameters work perfectly as far as being populated, but when I try to get the same thing ...
0
votes
1answer
52 views
Connecting 2 dropDownLists with SqlDataSource FilterExpression inside ASP:Repeater
Using 2 dropDownLists in repeater row how does one use the 1st one as a filter for 2nd?
The repeater layout is simple: [category_dropDown][item_dropDown][add_button]
The problem is that I can't ...
1
vote
1answer
39 views
SqlDataSource won't retrieve logged in user's data from database?
I tried retrieving the user's data based on the logged in UserId, but no progress. Any suggestions?
protected void SqlDataSource1_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
{
// ...
0
votes
1answer
30 views
How to Update GridView by changing SelectCommand string in SqlDataSource
OK - I think this should be simple/basic but I looked through many posts with similar issues but it is still not clear how to do this.
Basic setup is as follows - I have a TextBox called "product" ...
-1
votes
0answers
22 views
How to call a column in c# code behind from a subset of an ID attached to a dropdown list in asp.net using sqldatasource
Here's exactly what I want to do since the question might not be so clear. I binded an ID and a value(naturally) to a dropdown list using sqldatasource but I need to know the value of another ID which ...
4
votes
1answer
42 views
Access The Data Retrieved
I have been trying to find an answer to this question now for days and I find it hard to believe that this can't be done.
I want to get to the DataSet/DataTable that is built when a ...
0
votes
0answers
16 views
databinding with parameters to oracle via sql
We have a linked server set up in SQL Server to an oracle server.
I need to populate a gridview with some data. But I find that when I use a parameter with the datasource the query is very slow. ...
0
votes
1answer
105 views
Setting today as an ASP.Net SqlDataSource insert parameter default value
Using this ASP.Net we would like to see today's date appear in a date Textbox when the user clicks the "New" button of a DetailsView so they can see the date in the Textbox prior to actually inserting ...
0
votes
2answers
75 views
Pass parameter value to SqlDataSource ASP.NET User.Identity.Name
Need help! I can't get around why this doesn't work.
Page:
<asp:SqlDataSource ID="SelectUserInfo" runat="server" ConnectionString="<%$ ConnectionStrings:TradeRelay %>" ...
0
votes
1answer
52 views
Delete parameters in SqlDatasource in asp.net
i have a Gridview which is connected with SqlDataSource for Data.
I have Edit and Delete built in functionality. I have passed the Stored Procedure for the SelectCommand. Now i want to delete record ...
