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

Question

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...

Bharathi Raja · Answer

string conString = Data Source=localhost;Initial Catalog=LoginScreen;Integrated Security=True ; SqlConnection con = new SqlConnection(conString); string selectSql = select * from Pending_Tasks ; SqlCommand com = new SqlCommand(selectSql con); try { con.Open(); using (SqlDataReader read = cmd.ExecuteReader()) { while (reader.Read()) { CustID.Text = (read[ Customer_ID ].ToString()); CustName.Text = (read[ Customer_Name ].ToString()); Add1.Text = (read[ Address_1 ].ToString()); Add2.Text = (read[ Address_2 ].ToString()); PostBox.Text = (read[ Postcode ].ToString()); PassBox.Text = (read[ Password ].ToString()); DatBox.Text = (read[ Data_Important ].ToString()); LanNumb.Text = (read[ Landline ].ToString()); MobNumber.Text = (read[ Mobile ].ToString()); FaultRep.Text = (read[ Fault_Report ].ToString()); } } } finally { con.Close(); }

Esakki Muthu · Answer

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