sqldatasource Questions
6
Solved
I am trying to do this as asked earlier. The only difference that I found is additional List item that was included in above code.
I tried to use AppendDataBoundItems=true but it is still not work...
Narcose asked 13/8, 2010 at 7:54
7
Solved
I have a sql query for my SelectCommand on my SqlDataSource. It looks like the following:
SELECT * FROM Books WHERE BookID = @BookID
A TextBox feeds the @BookID parameter using an Asp:ControlPar...
Nasal asked 27/3, 2009 at 13:18
4
I need to manually clear the cache on a SqlDataSource with caching enabled. I've tried setting EnableChaching = false, and CacheDuration = 0 (as well as = 1) and none seem to expire the content alr...
Sociology asked 1/6, 2009 at 20:13
4
Solved
I'm new to SqlServer, right now I have SqlLocalDb installed to work locally. Good, but I can see two connection strings typically and both works:
Data Source=(localdb)\v11.0;Integrated Security=tr...
Alvin asked 22/2, 2013 at 13:11
10
I want to pass variable from the code behind to the SelectCommand of a SqlDataSource?
I don't want to use built-in parameter types (like ControlParameter, QueryStringParameter, etc)
I need to pas...
Addy asked 27/1, 2009 at 23:24
7
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click
Dim LoginChecker As New SqlDataSource()
LoginChecker.ConnectionString = ConfigurationManager.Connec...
Viridescent asked 7/11, 2010 at 17:15
8
Solved
I'm trying to set the value of the sqldatasource's selectcommand parameter @ClientID as in the code below, but it's not working out.
My code:
Dim strCommand = "SELECT caller_id, phone, name, e...
Instinct asked 12/6, 2009 at 19:33
5
Solved
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 e...
Mound asked 9/5, 2013 at 11:38
5
Solved
On my page I have a DropDownList which I populate with database values from an SqlDataSource (see code below).
How can I add my own text or a blank line before the values?
<asp:DropDownList ID...
Schaper asked 11/6, 2009 at 21:12
3
For SqlDataSource I can configure the external source for the incoming paramater.
For example it might be a QueryString, Session, Profile and so on.
However I do not have an option to use User as a...
Thermochemistry asked 5/10, 2010 at 12:57
4
Solved
If a web page needs some data, why not just have a SQLDataSource call a stored procedure? Why use an ObjectDataSource to call a business object that then calls the stored procedure? I understand th...
Caesium asked 30/7, 2009 at 15:17
2
Solved
I need to display data in grid view with merged rows for some columns. Please help me to prepare a grid view in below defined format:
And the original data comes from database is in below format:...
Eshman asked 22/4, 2013 at 13:10
3
Solved
I am getting this exception and can not figure out why: Cannot insert the value NULL into column 'UserId'
This is my code:
<asp:TextBox ID="FirstNameBox" runat="server" />
<br />
<...
Lagging asked 11/3, 2013 at 19:10
3
Solved
Being new to using the declarative syntax of SqlDataSource I am trying to figure out a way to set the value of a parameter to a stored procedure. I have a Client_ID that is passed via the Request O...
Fattish asked 16/3, 2011 at 13:37
1
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 SqlDataSource....
Noble asked 11/1, 2013 at 16:20
2
Solved
I am using SqlDataSource to show records based on the logged in user ,
<asp:SqlDataSource ID="ModifyCustomerDataSource" SelectCommand="SELECT cApplicationNo,cFirstName,cMiddleName,cLastName,nTe...
Barstow asked 17/5, 2012 at 9:32
4
Solved
I want to understand the purpose of datasets when we can directly communicate with the database using simple SQL statements.
Also, which way is better? Updating the data in dataset and then transfe...
Pycnidium asked 1/10, 2011 at 13:31
1
Solved
Whenever I connect to HSQLDB from my application deployed on JBoss 5.1, it throws exception as : Caused by: org.jboss.resource.JBossResourceException: Could not create connection; - nested throwabl...
Corium asked 9/2, 2011 at 18:37
4
Solved
I can't get my GridView to enable a user to sort a column of data when I'm using a custom SqlDataSource.
I have a GridView in which the code in the ASP reference to it in the HTML is minimal:
<...
Xyster asked 26/9, 2008 at 9:11
3
Solved
I plan on allowing a user to open a modalpopupextender containing a gridview witha Filter text box. I want it so when the user types in a filter, the filter is applied to the gridview and the conte...
Somerset asked 27/10, 2010 at 20:41
2
Solved
In the codebehind you would add the TVP as a SqlDbType.Structured for a stored procedure
But this doesn't exist in an ASP.NET SqlDataSource control.
I have stored my Datatables in session variable...
Aquiline asked 13/7, 2010 at 0:35
4
I am getting the error mentioned in the title.
I am using a 36 charecter ID. This error is only thrown In my sqldatasource in my asp.net webform.
It is not a problem when I perform updates in Ora...
Biancabiancha asked 7/5, 2010 at 11:9
2
Solved
I haveasp:GridView displaying client requests using asp:SqlDataSource. I want to limit displayed information by client:
View.aspx has to display everything, View.aspx?client=1 has to display only ...
Thaumaturgy asked 21/4, 2010 at 22:39
2
Solved
I have an asp.net page that has several SqlDataSources defined that feed data into some graphs. The graph product does not handle "no data" gracefully, and throws an exception. I'd like this to han...
Billy asked 9/2, 2010 at 18:1
2
Solved
I have really weird situation.
I've created new aspx page, and without using ANY custom logic objects (everything created with visual studios wizards) tried to create grid view from sqldatasource....
Furan asked 17/11, 2009 at 15:39
1 Next >
© 2022 - 2024 — McMap. All rights reserved.