Display Specific Row Data in C#

SELECT Product_Id,Product_Name,Qty,TotalAmt From Product WHERE Product_Id=@Product_Id

 

 

for (int i = 0; i < ds.Tables.Count; i++)
{
lbl1.Text=Convert.ToInt32(ds.Tables[0].Row[0]["Product_Id"].ToString());
lbl2.Text=ds.Tables[0].Row[0]["Product_Name"].ToString();
lbl3.Text=Convert.ToInt32(ds.Tables[0].Row[0]["Qty"].ToString());
lbl4.Text=Convert.ToInt32(ds.Tables[0].Row[0]["TotalAmt"].ToString());
} 

Ok filter your query like

 

Select Product_Name, Qty, TotalAmount where Product_id = 2

 

as per your need use datareader or dataset to fill the data. Loop through dataset and assign the values to the labels