private void Read_Values_From_Datatable_Load(object sender, EventArgs e)
{
NwindDataSetTableAdapters.ProductsTableAdapter ta = new NwindDataSetTableAdapters.ProductsTableAdapter();
ta.Fill(ds.Products);
CB_Product.DataSource = ds.Products;
CB_Product.ValueMember = "ProductId";
CB_Product.DisplayMember = "ProductName";
CB_Product.SelectedIndex = -1;
DGV_Products.DataSource = ds.Products;
}
private void CB_Product_SelectionChangeCommitted(object sender, EventArgs e)
{
DataRow dr = ds.Products.Select("productID=" + CB_Product.SelectedValue.ToString())[0];
TB_QuantityPerUnit.Text = dr["QuantityPerUnit"].ToString();
TB_UnitPrice.Text = dr["UnitPrice"].ToString();
TB_UnitsInStock.Text = dr["UnitsInStock"].ToString();
}
3.jpg