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 ...
2
votes
0answers
89 views
Automatic creation of parameters with the SqlDataSource Control
I've recently converted an existing web application from 3.5 to framework 4.0 and noticed a page stopped working - with an "incorrect number of parameters" error.
Page is fairly simple and has a ...
2
votes
0answers
103 views
Dreamweaver data source won't work after the first try on Mac OS X
I have a problem with the Adobe Dreamweaver CS5 version 11.
I am running Mac OS X Leopard.
One fine day I found out about Adobe Dreamweaver's quick (& dirty) automated back-end programming.
I ...
2
votes
0answers
453 views
Can I use an <asp:SessionParameter Direction=“Output”/> to *set* a variable?
If I have a SqlDataSource with
InsertCommand="INSERT [Applications] ([UserID]) VALUES (@UserID);SELECT @ApplicationID=SCOPE_IDENTITY()"
Can I use a SessionParameter to store the returned value?
...
1
vote
0answers
174 views
How to filter using a dropdown in a gridview and display all values when none is selected
I have a web page with 3 values (1 text box, and 2 drop-downs) and displays result in a gridview. This is working great when the value that I want to search is in the drop-down. However, if the user ...
1
vote
0answers
91 views
SqlDataSource updating different fields with one UpdateCommand
I have a SqlDataSource that I would like to use for updating. I would be using two similar update commands, and I was wondering how I could do this in one SqlDataSource. I know how to do 'normal' ...
1
vote
0answers
424 views
getting return value from aspx sqldatasource
I've used the insert command through the code front in aspx and the output parameter is:
asp:Parameter Name="ReturnCustomerID" Type="String" Direction="Output"
and in the codebehind (C#) for ...
1
vote
0answers
104 views
adding order by to select command from webconfig
Hello I have an sql data source (below) and the select command is in the webconfig it is a simple select...from... . I use this select command a few times but the ORDER BY changes. Is there anyway to ...
1
vote
0answers
151 views
Set number of pages in gridview with custom source
Here is the scenario: I have gridView with sorting on TemplateField headers - SortExpression is set and gridView_Sorting function implemented.
I store sorting values and directions in ViewState.
I ...
1
vote
0answers
78 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. ...
1
vote
0answers
1k views
Insert database row via ASP.net 4.5 GridView on-board functionality?
I would like to insert a database entry by using standard functions of my GridView and SqlDataSource. Has there been any update on this topic since the dirty workarounds some versions ago (e.g. see ...
1
vote
0answers
201 views
nested repeater each with sqldatasource
<asp:HiddenField ID="hfOrderState" Value="1" runat="server" />
<asp:SqlDataSource ID="ReadyOrders" runat="server" EnableCaching="true"
DataSourceMode="DataSet" ...
1
vote
0answers
131 views
How to make SQLDataSource insert into view instead of the underlying table?
We have replaced 20 tables with a consolidated table, that separates each set of data via a "set id" (all the records for table "A" have a set_id of 1, table "B" is 2, etc.).
We then built views on ...
1
vote
0answers
175 views
Trouble handling exceptions with a SqlDataSource
I having trouble handling exception of a SqlDataSource. The SqlDataSource is currently being used by my ListView. My code doesn't seem to display an error message even though it looks correct to me. I ...
1
vote
0answers
347 views
how to use a procedure with Default parameter in gridview ASP.NET VS in sqldatasource
I want to use a stored procedure that can make some parameters with null value and then test it if the parameter is null or not and do some coding , the procedure is working fine ... but when i want ...
1
vote
0answers
472 views
SqlDataSource + Disabled Viewstate = Double DataBind
Here's a test page (.NET 4) I built to show the symptom I'm experiencing:
<%@ Page Language="C#" AutoEventWireup="true" ViewStateMode="Disabled" %>
<script runat="server">
protected ...
