Display Specific Row Data in C#

Question

Hello how can iIDisplay Specific Row wise Data on the Labels of windows form based application. For Example I Want to display 2nd row data on the labels So what Strategy will be Used for this

Dorababu Meka · Answer

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

Amit Singh · Answer

Sql Query: SELECT Product_IdProduct_NameQtyTotalAmt From Product WHERE Product_Id=@Product_Id for (int i = 0; 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()); }

Sumar Khan · Answer

Sql Query result

Dorababu Meka · Answer

OK the image that you posted is the one which binded to datagridview or is it sql query result

Sumar Khan · Answer

No. on Four labels

Dorababu Meka · Answer

So in one label you want to display all the values ?

Sumar Khan · Answer

Above three rows I want to Display only Product_id =2 data which is Rice304000 on the label.Text

Dorababu Meka · Answer

Can you briefly explain the problem that you are trying to achieve