how to fetch value from db to a label control ?

Question

i have few labels i want data onto the label control from database how to get the data to label control

Piyush Pansuriya · Answer

Hi, Please refer below links: https://www.c-sharpcorner.com/blogs/display-data-from-database-to-label1 https://forums.asp.net/t/1436375.aspx?Retrieve+data+and+display+in+a+Label+control https://stackoverflow.com/questions/28948592/display-data-from-database-to-label

Manoj Bhoir · Answer

Hi Subin, You can fetch data from database using Select query. Then assign query result to your label. Lable1.Text = "Text From Database" ;

Amit Kumar · Answer

Hi, Use the below code it will help you.Here's an example using the ADO.NET way..C# private void getData( string user) { DataTable dt = new DataTable();SqlConnection connection = new SqlConnection( "YOUR CONNECTION STRING HERE" ); connection.Open();SqlCommand sqlCmd = new SqlCommand( "SELECT * from TABLE1 WHERE UserID = @username" , connection); SqlDataAdapter sqlDa = new SqlDataAdapter(sqlCmd); sqlCmd.Parameters.AddWithValue( "@username" ,user); sqlDa.Fill(dt); if (dt.Rows.Count > 0) { TextBox1.Text = dt.Rows[0][ "ColumnName1" ].ToString(); TextBox2.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( this .User.Identity.Name); } }

Rajanikant Hawaldar · Answer

Hi Subin Thomus, go through below code public void SetLabelsText() { var con = ConfigurationManager.ConnectionStrings["Yourconnection"].ToString();//connection string from config file Person matchingPerson = new Person(); using (SqlConnection myConnection = new SqlConnection(con)) { string oString = "Select * from Employees where FirstName=@fName";//write your query here SqlCommand oCmd = new SqlCommand(oString, myConnection); oCmd.Parameters.AddWithValue("@Fname", fName); // use only when need to pass para.. myConnection.Open(); using (SqlDataReader oReader = oCmd.ExecuteReader()) { while (oReader.Read()) { label1.Text = oReader["FirstName"].ToString(); label2.Text = oReader["LastName"].ToString(); } myConnection.Close(); } } }

Salman Beg · Answer

First of all, retrieve the data from database using ado.net and bind that value to label as, lbl1.Text="Your DB value"; thanks

how to fetch value from db to a label control ?

Answers (5)