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
0answers
3 views
Dynamically Change SelectCommand in Sqldatasource and display new data
I have a RadChart and a Sqldatasource. The datasource is as following:
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:DataIntelli1ConnectionString ...
0
votes
0answers
21 views
Total Row Count SqlDataSource GridView
So I have a GridView set up to a SqlDataSource. Paging is enabled and I have a drop down menu that changes the number of rows displayed per page. I am able get the total of rows displayed in a single ...
1
vote
1answer
72 views
Cannot perform '=' operation on System.String and System.Int32?
I tried bind a label from result SqlDataSource.But I get this error
Cannot perform '=' operation on System.String and System.Int32
<asp:SqlDataSource ID="SqlDataSource1" ...
0
votes
1answer
24 views
Update FilterParameter values programatically?
How can I update filter parameter values of a SQLDataSource whom filter expression & filter parameter have already been defined in aspx? I am trying to add an alpha pager.
Code behind
protected ...
0
votes
1answer
23 views
How to set FilterParameters property of a datasource?
I have two dropdownlists, a checkbox and a gridview that contains images. the asp code looks like this.
<asp:DropDownList ID="dLSubCat" runat="server"
DataSourceID="SubCat" ...
0
votes
0answers
18 views
C# and EMgu CV in image data accessing & image matching
I'm currently using C# with Emgu CV to create a real-time face recognition programme in student registration system.
Upon the process in developing it, I have several problems been spotted in ...
0
votes
0answers
30 views
ASP.NET FormView Control, SQL Data Source - SQL Join Statement
I have a Form View control connected to a SQL data source control with a Select inner join statement that reads the users profile information from from database1/table1 and pulls an email address ...
0
votes
1answer
23 views
How to set datetime now in sqldatasource control parameter?
I have a sqldatasource.It gets data from SP in SQL.I have some parameters.I want to set dynamic.
<asp:SqlDataSource ID="SqlDataSource4" runat="server" ConnectionString="<%$
...
0
votes
0answers
40 views
Using SQL datasource to reflect the options in a drop down list
Ultimately I have a drop down list that show all individuals. I'm wanting the user to be able to click a link button(A-Z) so the options in the drop down list only hold the names that fall into the ...
1
vote
2answers
25 views
How to automatically generate parameters in an ASP.NET DataSource Update Command
I'm using ASP.NET forms to build some quite lengthy questionnaires. I'm creating each page using a FormView control with an attached SQL dataSource. The select query is easy enough- Visual Studio ...
0
votes
0answers
15 views
Updating multiple records using checkbox in .net
I have sqlDatasource as:
<asp:SqlDataSource Id="sds" runat="server" selectCommand="Select * from tableName"
updateCommand="Update table set field=@field, field1=@field1 where PKfield=@PKfield">
...
0
votes
0answers
37 views
How to bind in one Gridview from Multiple SqlDataSources
I want to bind one item from one sqldatasource and 2 other items from it's other datasources. Any idea how it can be these three things in one gridview?
example
<asp:GridView ID="GridView1" ...
0
votes
0answers
37 views
How can i pass XML value as session parameter from code behind file for SQLDatasource?
I have SQLDatasource which have session parameters for Stored procedure. The stored procedure have the parameter of type XML. How can i pass the session parameter from cs(Code Behind) file. Initially ...
0
votes
1answer
32 views
How can I access SqlDataSource already selected data, if it is bind to a GridView?
I have a GridView and a SqlDataSource. All binding done in aspx, works correctly and Select calls an SP with parameters.
Now I would like to access the bound data programmatically, in stuctured form, ...
0
votes
0answers
31 views
SQLDataSource Decimal sends wrong value to Access DB
Hello I have a problem with the Decimal Value and SQLDataSource
When I use the querybuilder and set my values directly to a name and a decimal value everything will be stored in my DB but when i set ...
