using System;
using System.Data;
using System.Data.OleDb;
using System.Data.SqlClient;
namespace CSCommand
{
class Class1
{
[STAThread]
static void Main(string[] args)
{
DataSet ds = new DataSet();
FillMyDataSet(ds);
Console.WriteLine(ds.GetXml);
}
static void FillMyDataSet(DataSet ds)
{
string strConn, strSQL;
strConn="Provider=SQLOLEDB;User ID=sa;Password=gatsol;Initial Catalog=NorthWind;Data Source=211.236.186.207;";
OleDbDataAdapter daOrders, daDetails;
strSQL="Select OrderID, CustomerID, OrderDate From Orders Where CustomerID='Grosr' ";
daOrders = new OleDbDataAdapter(strSQL, strConn);
strSQL="Select OrderID, ProductID, Quantity, UnitPrice from [Order Details] Where OrderID in (Select OrderID From Orders Where CustomerID='Grosr') ";
daDetails = new OleDbDataAdapter(strSQL, strConn);
daOrders.Fill(ds,"Orders");
daDetails.Fill(ds,"Details");
}
}
}