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.