static dsAdventure PopularDataSetTipado()
{
dsAdventureTableAdapters.ProductTableAdapter da = new dsAdventureTableAdapters.ProductTableAdapter();
dsAdventure ds = new dsAdventure();
da.Fill(ds.Product);
return(ds);
}
static dsAdventure PopularDataSetTipado()
{
dsAdventureTableAdapters.ProductTableAdapter da = new dsAdventureTableAdapters.ProductTableAdapter();
dsAdventure ds = new dsAdventure();
da.Fill(ds.Product);
return(ds);
//Quando o DataTable é configurado na mão no DataSet é necessário executar o código abaixo para carregá-lo:
/*
* SqlConnection cn = new SqlConnection();
* cn.ConnectionString = @"Data Source=(local);Initial Catalog=AdventureWorks;Integrated Security=SSPI";
* SqlCommand cmd = new SqlCommand();
* cmd.Connection = cn;
* cmd.CommandText = "SELECT * FROM Production.Product";
* SqlDataAdapter da = new SqlDataAdapter();
* da.SelectCommand = cmd;
* dsAdventure ds = new dsAdventure();
* da.Fill(ds, ds.Product.TableName);
* return ds;
*/
}
