Sunday, March 11, 2012

CascadingDropDown and SQL Server

well, XML is same as dataset

i am sure you can get dataset from database.


Alright, could anyone give me an example? Surprise
Seehttp://ajax.asp.net/ajaxtoolkit/Walkthrough/CCDWithDB.aspx

Hey

I'm looking for something where I can use code to retrieve data from a SQL database using SqlConnection, SqlCommand, SqlDataAdapter and a DataSet.

An example of the idea that I was hoping for is, not a DataSet file:

SqlConnection EdwardSQLConnection =newSqlConnection(DatabaseConnectionString);
SqlCommand SQLCommand1 =newSqlCommand("SELECT * FROM Invoices", EdwardSQLConnection);
SqlDataAdapter SQLDataAdapter1 =newSqlDataAdapter(SQLCommand1);
DataSet InvoicesDataSet =newDataSet();
SQLDataAdapter1.Fill(InvoicesDataSet);

Any suggestions? I would like to keep the code as simple to understand as possible since I only started looking at AJAX today.

Thanks!!!
Edwar

No comments:

Post a Comment