How to add the value from database to label in Asp.net & C#

https://www.c-sharpcorner.com/blogs/display-data-from-database-to-label1 https://www.neerajcodesolutions.com/2015/03/how-to-display-database-value-in-label.html?m=1. C# Code private void GetData() {DataTable dt = new DataTable();SqlConnection connection = new SqlConnection("YOUR CONNECTION STRING HERE");connection.Open();SqlCommand sqlCmd = new SqlCommand("SELECT * from TABLE1", connection);sqlDa.Fill(dt);if (dt.Rows.Count > 0){TextBox1.Text = dt.Rows[0]["ColumnName1"].ToString(); //Where ColumnName is the Field from the DB that you want to displayTextBox2.Text = dt.Rows[0]["ColumnName2"].ToString();Label1.Text = dt.Rows[0]["ColumnName3"].ToString();Label2.Text = dt.Rows[0]["ColumnName4"].ToString();}connection.Close(); }protected void Page_Load(object sender, EventArgs e) {if (!Page.IsPostBack){GetData();}}

1 Reply

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

Rajanikant Hawaldar6y ago
Accepted answer
https://www.c-sharpcorner.com/blogs/display-data-from-database-to-label1 https://www.neerajcodesolutions.com/2015/03/how-to-display-database-value-in-label.html?m=1. C# Code private void GetData() {DataTable dt = new DataTable();SqlConnection connection = new SqlConnection("YOUR CONNECTION STRING HERE");connection.Open();SqlCommand sqlCmd = new SqlCommand("SELECT * from TABLE1", connection);sqlDa.Fill(dt);if (dt.Rows.Count > 0){TextBox1.Text = dt.Rows[0]["ColumnName1"].ToString(); //Where ColumnName is the Field from the DB that you want to displayTextBox2.Text = dt.Rows[0]["ColumnName2"].ToString();Label1.Text = dt.Rows[0]["ColumnName3"].ToString();Label2.Text = dt.Rows[0]["ColumnName4"].ToString();}connection.Close(); }protected void Page_Load(object sender, EventArgs e) {if (!Page.IsPostBack){GetData();}}