How to view all data in the database to specific text boxes

abijith c

8y764

I created a database named sbill.

It contains fields like billno, date,amount, particulars, quantity, name.

I created a datagrid view and displayed billno, date, amount. and also added a button named view to each row in gridview.

I want to display all the fields in the database to specific textboxes when clicking on the view button in that row. only the contents of clicked row should be shown in the textboxes.

Pleas help me...

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bharathi Raja8y ago
1. string conString = "Data Source=localhost;Initial Catalog=LoginScreen;Integrated Security=True";
2. SqlConnection con = new SqlConnection(conString);
4. string selectSql = "select * from Pending_Tasks";
5. SqlCommand com = new SqlCommand(selectSql, con);
7. try
8. {
9. con.Open();
11. using (SqlDataReader read = cmd.ExecuteReader())
12. {
13. while(reader.Read())
14. {
15. CustID.Text = (read["Customer_ID"].ToString());
16. CustName.Text = (read["Customer_Name"].ToString());
17. Add1.Text = (read["Address_1"].ToString());
18. Add2.Text = (read["Address_2"].ToString());
19. PostBox.Text = (read["Postcode"].ToString());
20. PassBox.Text = (read["Password"].ToString());
21. DatBox.Text = (read["Data_Important"].ToString());
22. LanNumb.Text = (read["Landline"].ToString());
23. MobNumber.Text = (read["Mobile"].ToString());
24. FaultRep.Text = (read["Fault_Report"].ToString());
25. }
26. }
27. }
28. finally
29. {
30. con.Close();
31. }

Esakki Muthu8y ago

You have to write Gridview Button click event in that u can easly get the values of the selected (clicked) row column values and you can bind it in the textboxs,

Refere the below code,

https://www.aspsnippets.com/Articles/Implement-Button-Click-event-in-ASPNet-GridView-using-C-and-VBNet.aspx