static void Main(string[] args)
{
SqlConnection conn = new SqlConnection(@"Data Source=(LocalDB)\SQLLocalDb;Initial Catalog=SportsStore;Integrated Security=True;Connect Timeout=15;Encrypt=False;TrustServerCertificate=False");
//SP_Demo(conn);
//await ReaderAccess(conn);
DsProducts ds = new DsProducts();
ProductsTableAdapter adapter = new ProductsTableAdapter();
adapter.Connection = conn;
conn.Open();
adapter.Fill(ds.Products);
ds.Products.AddProductsRow("Pen", "Pen with A Man", "Stationery", 12.50M);
ds.WriteXml(@"C:\Lab\Products2.xml", System.Data.XmlWriteMode.DiffGram);
adapter.Update(ds.Products);
conn.Close();
conn.Dispose();
}
private static void Main()
{
var dataSet = new NorthwindDataSet();
var tblAdapter = new ProductsTableAdapter();
tblAdapter.Fill(dataSet.Products);
var tblAdapterCategories = new CategoriesTableAdapter();
tblAdapterCategories.Fill(dataSet.Categories);
foreach (var row in dataSet.Products)
{
Console.WriteLine($"{row.ProductName}");
}
var peterProduct = dataSet.Products.FirstOrDefault(x => x.ProductName == "Peter");
var gabrielProduct = dataSet.Products.FirstOrDefault(x => x.ProductName == "Gabriel");
if (gabrielProduct == default(NorthwindDataSet.ProductsRow) && peterProduct == default(NorthwindDataSet.ProductsRow))
{
var newRow = dataSet.Products.NewProductsRow();
newRow.ProductName = "Gabriel";
newRow.Discontinued = false;
newRow.CategoriesRow = dataSet.Categories.First();
dataSet.Products.AddProductsRow(newRow);
}
else if (peterProduct == default(NorthwindDataSet.ProductsRow))
{
gabrielProduct.BeginEdit();
gabrielProduct.ProductName = "Peter";
gabrielProduct.EndEdit();
}
else if (gabrielProduct == default(NorthwindDataSet.ProductsRow))
{
peterProduct.Delete();
}
tblAdapter.Update(dataSet);
Console.ReadLine();
}
private void button1_Click(object sender, EventArgs e)
{
pta.Update(sado.Products);
MessageBox.Show("Sauvegarde Réussie");
}