how to diplay data in label from database

Question

how to display data in label from database?

Sumit Joshi · Answer

Hi Susanta Rout @ Page Language ="C#" AutoEventWireup ="true" CodeBehind ="Default.aspx.cs" Inherits ="Displaying_Data_From_Db_to_Label._Default" %> DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> html xmlns ="http://www.w3.org/1999/xhtml" > head runat ="server"> title > Untitled Page title > head > body > form id ="form1" runat ="server"> div > asp : Label ID ="labelname1" runat ="server" Text ="Label"> asp : Label > asp : Label ID ="labelage1" runat ="server" Text ="Label"> asp : Label > br /> asp : Label ID ="labelname2" runat ="server" Text ="Label"> asp : Label > asp : Label ID ="labelage2" runat ="server" Text ="Label"> asp : Label > br /> asp : Label ID ="labelname3" runat ="server" Text ="Label"> asp : Label > asp : Label ID ="labelage3" runat ="server" Text ="Label"> asp : Label > div > form > body > html > using System; using System.Collections; 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; namespace Displaying_Data_From_Db_to_Label { public partial class _Default : System.Web.UI. Page { string strConnString = ConfigurationManager .ConnectionStrings[ "ConnectionString" ].ConnectionString; string str; SqlCommand com; protected void Page_Load( object sender, EventArgs e) { SqlConnection con = new SqlConnection (strConnString); con.Open(); str = "select * from emp" ; com = new SqlCommand (str, con); SqlDataReader reader = com.ExecuteReader(); reader.Read(); labelname1.Text = reader[ "Name" ].ToString(); reader.Read(); labelname2.Text = reader[ "Name" ].ToString(); reader.Read(); labelname3.Text = reader[ "Name" ].ToString(); reader.Close(); con.Close(); con.Open(); SqlDataReader reader1 = com.ExecuteReader(); reader1.Read(); labelage1.Text = reader1[ "Age" ].ToString(); reader1.Read(); labelage2.Text = reader1[ "Age" ].ToString(); reader1.Read(); labelage3.Text = reader1[ "Age" ].ToString(); reader.Close(); con.Close(); } } } If helpful mark as Correct Answer

Sumit Joshi · Answer

Thank You Susanta

Susanta Rout · Answer

helpful mr sumit joshi.thanks

Upendra Pratap Shahi · Answer

Hello Susanta Rout , Do well as Sumit Joshi said. This helped you. Sumit Joshi +1 vote.

how to diplay data in label from database

Answers (4)