Search

Saturday, July 18, 2015
0 comments

How to bind label control in asp.net

5:30 AMSaturday, July 18, 2015
Step-1: Open Visual Studio IDE
Step-2 : Create New Web Project

ASP.NET empty website


Step-3: In Solution Explorer Add new item 
Solution Explorer Add new item


Step-4: Select web form in middle pane also select c# in left pane

Step-5: Change name of the webform as "labelbind.aspx" also select place code in separate file check box
Step-6:   Right click on  Project name and add new item  again.
Step-7: Open a new dialog window Select SQL SERVER database  name as a "database.mdf"
Step-8: After click ok Button . a new dialog appear on the screen 
Do you want to place the file in App_data folder
Step-9: Click Ok Button in dialog window
Step-10: Open Server Explorer
Step-11 Make a new table inside Database

Step-12:
make a new table


Step-13: fill This Table with Some value
Step-14: Open  " labelbind.aspx " page
Step-15: Drag and Drop label control onto the labelbind.aspx page from toolbox

Step-16: Add this code in Design page



<%@ Page Language="C#" AutoEventWireup="true" CodeFile="labelbind.aspx.cs" Inherits="labelbind" %>

<!DOCTYPE html>

<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="">
            UserId:<%# myname %>


        </asp:Label>
    </div>
    </form>
</body>
</html>

Step-17 Add this code in .cs file


using System;
using System.Data.SqlClient;

public partial class labelbind : System.Web.UI.Page
{
    public string myname;
    SqlConnection con = new SqlConnection();
    SqlCommand cmd = new SqlCommand();


    protected void Page_Load(object sender, EventArgs e)
    {
        con.ConnectionString = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True";
        con.Open();
        cmd.CommandText = "select * from [Employee]";
        cmd.Connection = con;
        SqlDataReader rd = cmd.ExecuteReader();
        while (rd.Read())
        {
            myname = rd["Emp_Name"].ToString ();

        }
        this.DataBind();

     

    }
}


OutPut 


bind label output

Protected by Copyscape Online Copyright Protection Software

0 comments :

Post a Comment

 
Toggle Footer
Top