how to display database value in label in asp.net c#
In this article, we learn about the how to fetch the
database value in label, Normally we need to this for account page means after
the login, we will show the username in the label or other field show in label.
Database:-
Source Code:-
<%@
Page Language="C#" AutoEventWireup="true" CodeFile="labelvalue.aspx.cs" Inherits="labelvalue"
%>
<!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></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
</div>
</form>
</body>
</html>
Code behind(C#);-
using System;
using
System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using
System.Web.UI.WebControls;
using
System.Data.SqlClient;
public partial class labelvalue : System.Web.UI.Page
{
protected void Page_Load(object
sender, EventArgs e)
{
SqlConnection
con = new SqlConnection("Data Source=NEERAJ-PC;Initial
Catalog=CodeSolution;Persist Security Info=True;User ID=sa;
password=12345678");
con.Open();
SqlCommand
cmd = new SqlCommand("Select * from login where name ='Neeraj
Srivastava'", con);
SqlDataReader
dr = cmd.ExecuteReader();
if
(dr.Read())
{
Label1.Text = dr["name"].ToString();
}
con.Close();
}
}
Out-Put:-
how to display database value in label in asp.net c#
Reviewed by NEERAJ SRIVASTAVA
on
7:59:00 PM
Rating:
Reviewed by NEERAJ SRIVASTAVA
on
7:59:00 PM
Rating:
No comments: