In this blog we will know
how to Display Data from Database to Label.
<%@
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();
}
}
}