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 ...
0
votes
2answers
14 views
Export sqldatasource to excel not just list or gridview
I'm trying to export my listview, but not just the visible listview, I want to export the entire contents of the sqldatasource. The query returns 20 columns, only a small set (5) are displayed on the ...
0
votes
0answers
14 views
Must declare the scalar variable “@fname”. Error asp.net
I am getting the Scalar variable error when I am trying to select parameters in the Click Event. I am not sure if I am doing this the right way. Can somebody look at my code and explain me the issue?
...
0
votes
0answers
49 views
Error setting up Datasource using MySQL (4/5) in ColdFusion Admin
I'm very new to ColdFusion and mySQL but I'm trying to learn. Right now I'm using the learnCFinaweek site to try and get the basics down. I'm running into trouble when I try to add a new data ...
0
votes
1answer
25 views
SqlDataSource Based Dropdown list
I have created a dropdown list which fetched filtered data based on status.
But my already inserted data may have some entries that are not active at the moment.
Initially I applied a DatasourceID to ...
2
votes
2answers
26 views
Populating ASP.NET SqlDataSource from a Firebird 2.0 Stored Procedure
I am working on a project where I do not have any control over the versions of products that I have been asked to work with.
I am building an ASP.NET user control. Data is retrieved via ...
0
votes
2answers
13 views
Does a Sql Datasource run a select query on load if no contol binds is bound to it?
I have a quick question, I have a gridview and a datasource on a page however because the datasource will return over 1 million records and the page will be accessed by a lot of people at the same ...
0
votes
1answer
40 views
Adding rows to a Gridview that is bound to a SqlDataSource
I am trying to add a row to a gridview dynamically, while the gridview has a SqlDataSource bound to it. Is it possible to add a custom row while the data is still binding? I am coding in vb.
0
votes
2answers
31 views
How to get a gridview to show all table rows when no text is entered in a dependent textbox?
The below works correctly and filters my gridview based on the text entered in my textbox.
When no text is entered into my textbox I get no results and cannot understand why.
MY QUESTION
How to get ...
0
votes
1answer
16 views
Update with detailsview and sqldatasource
It is posible update a row with DetailsView control and Sqldatasource?
Any example?
Edit:
SOLVED
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ...
0
votes
2answers
53 views
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 not clear before appending the new data so ddl2 content just continues to grow ...
1
vote
1answer
29 views
error: Conversion failed when converting date and/or time from character string when i select date?
i have this gridview, and i use sqldatasource
this is my select command,
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:TAXIConnectionString ...
0
votes
1answer
37 views
using selectcommand on code behind with gridview
I have a sqldatascource that I need to pass null values to it and then use the selectcommand specified by a stored procedure and then using the result query to populate a gridview on the page load
...
0
votes
1answer
18 views
Why my FilterParameters is not work?
I have a gridview with some columns, id, name, address, phone
And a TextBox 'NameFilter'
My gridview is popularized for a SqlDataSource controler, I need filter my gridview registers with name, I'm ...
0
votes
1answer
24 views
Possible to fill SqlDataSource with SqlDataAdapter?
I currently have this code to populate ASP.NET gridview from code behind with DataTable.
protected void bindGridView()
{
SqlConnection sqlConn = new ...
0
votes
0answers
60 views
Incorrect syntax near 'int' when using updatecommand on a gridview
I have a problem that when ever I try to update a record in the database using gridview update event handler and an updatecommand in sqldatascource
I get the following exception
Incorrect syntax near ...
