public ucProducts()
{
InitializeComponent();
InitDataTable();
sc = new wrProducts.Server2Client();
prd = new wrProducts.wsProducts();
sc = prd.GetProductValues();
DataTable d = new DataTable();
d = sc.dataTable;
for (int i = 0; i <= d.Rows.Count - 1; i++)
{
//CategoryName, ProductName, BuyingValue, SellingValue, TotalQuantity
DataRow r = dt.NewRow();
r["CategoryName"] = d.Rows[i].ItemArray[0].ToString();
r["ProductName"] = d.Rows[i].ItemArray[1].ToString();
r["BuyingValue"] = Convert.ToDouble(d.Rows[i].ItemArray[2]);
r["SellingValue"] = Convert.ToDouble(d.Rows[i].ItemArray[3]);
r["TotalQuantity"] = Convert.ToInt32(d.Rows[i].ItemArray[4]);
r["TotalBuyingValue"] = Convert.ToDouble(d.Rows[i].ItemArray[2]) * Convert.ToInt32(d.Rows[i].ItemArray[4]);
r["TotalSellingValue"] = Convert.ToDouble(d.Rows[i].ItemArray[3]) * Convert.ToInt32(d.Rows[i].ItemArray[4]);
dt.Rows.Add(r);
}
grd.DataSource = dt;
grd.Refresh();
}
