how to fetch value from db to a label control ?

Subin Thomas

7y805.NET

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

how to get the data to label control

5 Replies

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

Amit Kumar7y ago
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);

}
}
+1
Rajanikant Hawaldar7y ago
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();
}
}
}

+1
Salman Beg7y ago
First of all, retrieve the data from database using ado.net and bind that value to label as, lbl1.Text="Your DB value"; thanks
+1
Manoj Bhoir7y ago
Hi Subin,

You can fetch data from database using Select query.

Then assign query result to your label.
Lable1.Text = "Text From Database";
+1
Piyush Pansuriya7y ago
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
+2