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
votes
0answers
15 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
13 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
32 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
44 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
33 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 ...
0
votes
1answer
32 views
GridView Row is not updating after SQLDatasource query changed?
I have a grid view and i have bonded sql data source to that. on page i have drop down, as soon as selected value of drop down get changes, i change the select query of sql data source and again ...
4
votes
2answers
48 views
Using a dropdownlist control inside a formview
I am new to asp.net and i have a problem using a dropdownlist control inside a formview and passing its value to the related sqldatasource. When i use the code below i get the following exception
...
0
votes
1answer
47 views
GridView when the page is refreshed
I have a GridView and a Button in a web form.
I change SelectCommand of SqlDataSource when user click on the button.
Then the result has been shown in GridView. But when the page is refreshed, results ...
0
votes
1answer
38 views
Set selectparameter from textbox in ASP.NET
<SelectParameters>
<asp:ControlParameter ControlID="TextBox1" Name="model" Type="String" />
</SelectParameters>
My program actually works, I am just ...
0
votes
1answer
34 views
Change the SqlDataSource SelectCommand
I have a SqlDataSource for a gridveiw. I want to change SelectCommand of that SqlDataSource.
My select command is:
select *
from JobLog
where UserName = @username
and PrinterName = @printer
...
0
votes
1answer
28 views
Set Sqldatasource parameter dynamically
I have create a gridview and a SqlDataSource, which has parameter in the where clause, which has a source in a dropdown menu. That works fine.
I also have an input textfield. I would like the value ...
0
votes
1answer
51 views
SqlDataSource-Query in a repeater to use repeater-elements
I would like to do the following with asp.net and C#:
An SqlDataSource fetches a list of templates from the database. Then, in a repeater, for each template a DropDownList-element is created, that ...
1
vote
1answer
79 views
Updating gridview with SqlDataSource in asp.net
i want to update the records from the gridview using SqlDataSource, here is what i am doing.
below is my gridview markup
<asp:GridView ID="grdManageFaculties" runat="server" AllowPaging="True" ...
0
votes
0answers
83 views
Ext.NET: System.Exception: String was not recognized as a valid DateTime
i have a date colum like this
<ext:DateColumn ID="DateColumn4" runat="server" DataIndex="Purchasedate" Text="Purchasedate" Format="yyyy-MM-dd" Flex="1" />
when it is clicked ,it shows ...
