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
10 views
Nothing happens when I click on page on GridView with paging
I'm new to C# and .NET, but stuck on this for a couple days now, I am using MVC 3 (.NET 4.0) Web Application.
I looked through tutorials to make a GridView based on a SqlDataSource with the code ...
1
vote
1answer
16 views
Implementing editing in ASP.NET DataGrid when data comes from several related tables
Today while working on one of my client's project I came up with an issue for which I am unable to figure out the solution. So I am Throwing it on to you guys.
I am using a databound GridView ...
0
votes
0answers
14 views
RadGrid PerformInsert with SqlDataSource
I have a RadGrid binded to a SqlDataSource .
and I want to fire RadGrid PerformInsert Command, I don't want to use the SqlDataSource Insert() Function because my SqlDataSource is a Custom class ...
0
votes
3answers
27 views
“Server” vs “Data Source” in connection string
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=true;
...
0
votes
0answers
4 views
Re-execute datasource sproc for dropdownlist control
I have a DropDownList which has a stored procedure for a datasource, as well as a button. I want the sproc to be executed each time the button is clicked so that the DropDownList contents are updated. ...
0
votes
1answer
11 views
Link a method to a datsource
So ATM my code is working fine. I use a SqlDataSource to link to a grid data source and display a table. It displays a column from the table and is used as a hyperlink to navigate to a different page.
...
0
votes
1answer
25 views
Connecting two MySQL data source using a single Connection object
Actually I need to connect two mysql datasource which are created in my application server. I'm using JPA2.0
I tried the following code. but i'm getting exception "java.lang.IllegalStateException: ...
0
votes
3answers
29 views
Giving alias in JOIN command in sqldatasource
I am using JOIN command to connect two tables in SqlDataSource.
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:CS %>"
...
1
vote
0answers
29 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 ...
0
votes
0answers
22 views
Create and navigate an SQL query in VB.NET
I'm fairly new to VB.NET (upgrading from VB6 and VBA). I'm trying to write a sub that queries a datasource (datasource is setup and working) that I can then navigate in VB.
Im trying to do what I ...
0
votes
4answers
71 views
Proper populating of dropdown list in asp.net dynamically
I am a newbie in asp.net, I want to ask what is more proper in terms of populating the dropdown list in asp.net? using a Datasource or using a sqldatareader and a for loop.
I am using the ...
0
votes
2answers
81 views
populating dropdownlist from another dropdown selection in ASP.Net Web Form
I am trying to Populate data into the Company DropDownList after selecting the Country from the CountryDropDownList. Complete newbiew on ASP.Net Web Form. So please excuse little knowledge.
I have ...
1
vote
0answers
37 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 ...
0
votes
1answer
40 views
How to Enforce Gridview Line Breaks
I am trying to use an sqldatasource object to populate a grid view but I wish to combined two of the rows in the database into one row with a line break in the grid view (for aesthetic appeal only). ...
0
votes
0answers
29 views
SqlDataSource with Data from a Dataset
Please, I do have a "asp:GridView" inside a page that uses a plain "asp:SqlDataSource" as source for viewing, deleting and updating data from a table.
I need to convert this to something "not in the ...