Display the database column value in the label

Question

Hi I am new to ASP.NET.I wanted to know how can i get the the database column value from database to the label box which i wanted to be displayed after inserting the values. Sita.

gagan sharma · Answer

SqlConnection con = new SqlConnection(); con.ConnectionString = ConfigurationManager.ConnectionStrings[CN].ConnectionString; string query = select * from Product; SqlDataAdapter adp = new SqlDataAdapter(query con); DataSet ds = new DataSet(); adp.Fill(ds); if (ds.Tables[0].Rows.Count > 0) { lblClient.Enabled = true; lblClient1.Enabled = true; lblClient2.Enabled = true; lblClient3.Enabled = true; lblClient.Text = ds.Tables[0].Rows[0].Field(P_Name); lblClient1.Text = ds.Tables[0].Rows[1].Field(P_Name); lblClient2.Text = ds.Tables[0].Rows[2].Field(P_Name); lblClient3.Text = ds.Tables[0].Rows[3].Field(P_Name); }

Muhammad Ishaq · Answer

Thanks

sita k · Answer

Hi I wanted to get the sequence value in to the text box while inserting the values in to the database. I have a customer table while inserting the details of the customer through client side i need to display the seq id of the cusomter after submitting the details.

Gohil Jayendrasinh · Answer

Hi DataTable dt = new DataTable(); -- fill datatable if (dt.Columns.Count > 0) { for (int i = 0; i { if (dt.Columns[i].ColumnName != null) { string columnname = Convert.ToString(dt.Columns[i].ColumnName); } } }

Dorababu Meka · Answer

Firstly establish a connection SqlConnection con=new SqlConnection(urconnectionstring); SqlCommand cmd=new SqlCommand(select query to retrieve the label valuecon); con.open(); SqlDataAdapter da=new SqlDataAdapter(); da.SelectCommand=cmd; Dataset ds=new DataSet(); da.Fill(ds); Label1.Text=ds.Tables[0].Rows[0][Coulmnname].ToString();