DataSet

Question posted by: Tony Johansson (Guest) on August 20th, 2008 11:45 AM

Hello!

This is also a working console program.
It seems to me that a DataSet is actually the result of the query as in my
example
because the result is from two tables.
Is this correct understood ?

What will happen if you change some row and then call the update for
DataAdapter object ?


static void Main(string[] args)
{
//Specify SQL Server-specific connection string
SqlConnection thisConnection = new SqlConnection(
@"Server=UHT-DEMO1; Integrated Security=True;" +
"Database=northwind");

//Create DataAdapter object
SqlDataAdapter thisAdapter = new SqlDataAdapter(
"Select Customers.CustomerID, OrderID, ContactName from
Customers, Orders " +
"where Customers.CustomerID = Orders.CustomerID and " +
"OrderID = 10248", thisConnection);

//Create DataSet to contain related data tables, rows and
columns
DataSet thisDataSet = new DataSet();

//Fill DataSet using query defined previously for DataAdapter
thisAdapter.Fill(thisDataSet, "Test");

foreach (DataRow theRow in thisDataSet.Tables["Test"].Rows)
Console.WriteLine("Row = {0}", theRow["CustomerID"] + "\t" +
theRow["ContactName"]);

thisConnection.Close();
Console.WriteLine("Program finished, press Enter/Return to
continue");
Console.Read();
}

Quote | Subscribe