How to retrieve data from datatable to textboxes

Question

Hi All I have DataTable. I need to display that data into textboxes.. DataTable contains the following values.. EmpID EmpName Dept Salary City 1 siva Technolo 1000 Hyderabad i need to display these row values into my textboxes of the follows.. txtID.text=EmpID txtName=EmpName txtDept=Dept txtSalary=Salary txtCity=City how can do this

Ankit Shivnakr · Answer

Hi Try this DataTable dt = new DataTable() txtID.text= dt.Rows[0][ EmpID ].ToString(); txtName .text = dt.Rows[0][ EmpName ].ToString(); txtDept .text = dt.Rows[0][ Dept ].ToString(); txtSalary .text = dt.Rows[0][ Dept ].ToString(); txtCity .text = dt.Rows[0][ City ].ToString();

Satyapriya Nayak · Answer

Hi Siva Try this... Untitled Page onclick=btnfirst_Click /> onclick=btnprevious_Click /> onclick=btnnext_Click/> onclick=btnlast_Click/> using System; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; public partial class _Default : System.Web.UI.Page { string connStr = ConfigurationManager.ConnectionStrings[ConnectionString].ConnectionString; SqlCommand com; SqlDataAdapter sqlda; string str; static DataSet ds; static DataTable dt; static int r1; static int r2; protected void Page_Load(object sender EventArgs e) { SqlConnection con = new SqlConnection(connStr); try { if (!IsPostBack) { con.Open(); str = select * from employee; com = new SqlCommand(str con); sqlda = new SqlDataAdapter(com); ds = new DataSet(); sqlda.Fill(ds employee); dt = ds.Tables[employee]; r1 = dt.Rows.Count; if (r1 > 0) { showfirst(); } r2 = 0; } } catch (Exception ex) { Response.Write(ex.Message); } con.Close(); bindgrid(); } public void bindgrid() { SqlConnection con = new SqlConnection(connStr); con.Open(); str = select * from employee; com = new SqlCommand(str con); sqlda = new SqlDataAdapter(com); ds = new DataSet(); sqlda.Fill(ds employee); GridView1.DataSource = ds; GridView1.DataMember = employee; GridView1.DataBind(); con.Close(); } public void showfirst() { TextBox1.Text = dt.Rows[0].ItemArray[0].ToString(); TextBox2.Text = dt.Rows[0].ItemArray[1].ToString(); TextBox3.Text = dt.Rows[0].ItemArray[2].ToString(); TextBox4.Text = dt.Rows[0].ItemArray[3].ToString(); TextBox5.Text = dt.Rows[0].ItemArray[4].ToString(); } protected void btnfirst_Click(object sender EventArgs e) { showfirst(); } protected void btnprevious_Click(object sender EventArgs e) { SqlConnection con = new SqlConnection(connStr); try { if (r2 > 0) { r2 -= 1; TextBox1.Text = dt.Rows[r2].ItemArray[0].ToString(); TextBox2.Text = dt.Rows[r2].ItemArray[1].ToString(); TextBox3.Text = dt.Rows[r2].ItemArray[2].ToString(); TextBox4.Text = dt.Rows[r2].ItemArray[3].ToString(); TextBox5.Text = dt.Rows[r2].ItemArray[4].ToString(); } } catch (Exception ex) { Response.Write(ex.Message); } finally { con.Close(); } } protected void btnnext_Click(object sender EventArgs e) { try { if (r2 { r2 += 1; TextBox1.Text = dt.Rows[r2].ItemArray[0].ToString(); TextBox2.Text = dt.Rows[r2].ItemArray[1].ToString(); TextBox3.Text = dt.Rows[r2].ItemArray[2].ToString(); TextBox4.Text = dt.Rows[r2].ItemArray[3].ToString(); TextBox5.Text = dt.Rows[r2].ItemArray[4].ToString(); } } catch (Exception ex) { Response.Write(ex.Message); } } protected void btnlast_Click(object sender EventArgs e) { try { TextBox1.Text = ds.Tables[employee].Rows[r1 - 1].ItemArray[0].ToString(); TextBox2.Text = ds.Tables[employee].Rows[r1 - 1].ItemArray[1].ToString(); TextBox3.Text = ds.Tables[employee].Rows[r1 - 1].ItemArray[2].ToString(); TextBox4.Text = ds.Tables[employee].Rows[r1 - 1].ItemArray[3].ToString(); TextBox5.Text = ds.Tables[employee].Rows[r1 - 1].ItemArray[4].ToString(); } catch (Exception ex) { Response.Write(ex.Message); } } } Thanks If this post helps you mark it as answer

Krishna Garad · Answer

You can try this txtId.Text=dt.Rows[0][EmpId].ToString(); txtname.Text=dt.Rows[0][EmpName].ToString(); txtDept.Text=dt.Rows[0][Dept].ToString(); txtSalary.Text=dt.Rows[0][Salary].ToString(); txtCity.Text=dt.Rows[0][City].ToString();