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_Id,Product_Name,Qty,TotalAmt 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 Rice,30,4000 on the label.Text

Dorababu Meka · Answer

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

Display Specific Row Data in C#

Answers (8)