473,405 Members | 2,421 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,405 software developers and data experts.

SqlDataSource and DataSet question

Hi,
I would like to know what the DataSet name is and where the DataSet is for
a SqlDataSource like this:

<asp:SqlDataSource ID="SqlDataSourceA" runat="server" ConnectionString="<%$
ConnectionStrings:ServiceConnectionStringA %>"
SelectCommand="SELECT TestNo, AcceptDate, status FROM TestForm ORDER BY
TestNo">
</asp:SqlDataSource>

where the connectionStrings in te Web.Config is as:
<connectionStrings>
<add name="ETCServiceTestConnectionStringA" connectionString="Data
Source=172.16.10.1;Initial Catalog=Service;User
ID=service;Password=mypwd"
providerName="System.Data.SqlClient" />
</connectionStrings>

Thanks for help.
Jason

May 23 '07 #1
2 4836
Hi,
There is no dataset their !

Husam Al-aáraj

"Jason Huang" wrote:
Hi,
I would like to know what the DataSet name is and where the DataSet is for
a SqlDataSource like this:

<asp:SqlDataSource ID="SqlDataSourceA" runat="server" ConnectionString="<%$
ConnectionStrings:ServiceConnectionStringA %>"
SelectCommand="SELECT TestNo, AcceptDate, status FROM TestForm ORDER BY
TestNo">
</asp:SqlDataSource>

where the connectionStrings in te Web.Config is as:
<connectionStrings>
<add name="ETCServiceTestConnectionStringA" connectionString="Data
Source=172.16.10.1;Initial Catalog=Service;User
ID=service;Password=mypwd"
providerName="System.Data.SqlClient" />
</connectionStrings>

Thanks for help.
Jason

May 23 '07 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Jason Shohet | last post by:
I'm using the new SqlDataSource with the beta. Below I have my code: asp:SqlDataSource ID="ds" Runat="server" SelectCommand="SELECT employee_ssno, firstname, lastname FROM employee_temp order by...
1
by: Neil | last post by:
Is it possible to reference the dataset of a sqldatasource from code? I've looked at the properties for the sqldatasource but don't see anything obvious. In particular, I have a bit field in the...
1
by: bcornett | last post by:
I am needing a way to extract a dataset from a sqldatsource. I am doing this to create a Generic Printing page. I will pass the dataset and an arraylist of grid_view propeties to this Generic...
0
by: cyberbless | last post by:
I would like to dynamically assign a Select Statment to a a SqlDataSource. Problem is the SqlDataSource.Select() Command requires a "dataSourceSelectArgument" as one of its arguments. 1. What...
7
by: | last post by:
I'm using ASP.NET 2.0, C#, SQL Server 2005, and databound controls like the DataList and the GridView. Right now I'm using SqlDataSource as part of very quick and dirty site; I'm not looking to...
6
by: djc | last post by:
I had previously (in asp.net 1.1 and asp.net web matrix) just done this to populate a listbox with data from a database: ------------ this was from the page load event ---------------- 'fill...
6
by: Ken Fine | last post by:
I'm using SQLDataSource, which generates some kind of dataset, and then I attach that datasource to various data display controls such as DataList and repeater which loop through to the end of the...
2
by: John Kotuby | last post by:
Hi all, I am relatively new to ASP.NET 2.0 programming. I have some experience with classic ASP and VB6. In Visual Web Developer (VS 2005) there a numerous ways to work with data. In my...
1
by: Jason Huang | last post by:
Hi, I would like to know what the DataSet name is and where the DataSet is for a SqlDataSource like this: <asp:SqlDataSource ID="SqlDataSourceA" runat="server" ConnectionString="<%$...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.