how to bind DataList from database using C#

May 12 2019 by Admin

In this article, we have described how to bind DataList from the database using C# with example code.

In this article, we have described how to bind DataList from database using C# with example code. Basically, it's used to bind the list of data from the database. We have to get some employee information from SQL database using Ado.net in C#. You can go through to understand and learn.

About DataList control

DataList is a data-bound control in asp.net. We can easily use to customize user interface and manipulate the data.

Required Namespaces

You will need to use the following namespaces.

using System.Configuration;

using System.Data;

using System.Data.SqlClient;

aspx page

We have used the DataList control below. You can have a look at it and learn.

<html>

<title>how to bind dataList in asp.net using C#</title>

<style>

.bs-callout + .bs-callout {

margin-top: -5px;

}

.bs-callout {

border-left-color: purple !important;

}

.bs-callout {

padding: 20px !important;

margin: 20px 0 !important;

border: 3px solid #eee !important;

border-left-width: 5px !important;

border-radius: 3px !important;

}

</style>

</head>

<body>

<asp:DataList ID="dlemployeelist" runat="server" RepeatDirection="Horizontal" RepeatColumns="2">

<p>

</p>

<p><strong>Address</strong>:<%# Eval("address") %></p>

<p><strong>Gender</strong>:<%#Eval("gender") %></p>

<p><strong>Mobile</strong>:<%# Eval("MobileNo") %></p>

</div>

</ItemTemplate>

</asp:DataList>

</form>

</body>

</html>

C# code

We have explained below C# code with examples of some employee information in this article .You can have a look at it and learn.

public partial class Default2 : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

this.GetUserInfo();

}

private void GetUserInfo()

{

string connection = Convert.ToString(ConfigurationManager.ConnectionStrings["SQLConnection"]);

SqlConnection con = new SqlConnection(connection);

SqlCommand cmd = new SqlCommand("Select * from EmployeeDetail", con);

SqlDataAdapter sda = new SqlDataAdapter(cmd);

DataTable dt = new DataTable();

sda.Fill(dt);

dlemployeelist.DataSource = dt;

dlemployeelist.DataBind();

}

Download

Home > ASP.NET > how to bind DataList from database using C#

how to bind DataList from database using C#

Related Articles

How to use gridview in asp.net with C# using Mysql

2/1/2019 11:51:00 PM By Admin

2237 Views

How to use gridview with datatable in asp.net with C# using Mysql

2/3/2019 9:50:00 PM By Admin

1887 Views

How to bind gridview with datatable in asp.net with C# without using the database

2/3/2019 10:35:00 PM By Admin

5502 Views

How to bind gridview with datatable in asp.net with c# without using the database

2/3/2019 10:35:00 PM By Admin

2389 Views

How to fetch data from database in Asp.net

2/10/2019 10:05:00 PM By Admin

7495 Views

How to insert and retrieve data from the database in vue js using asp.net with C#

3/4/2019 7:54:00 AM By Admin

8221 Views

How to bind Repeater control from database in Asp.net

3/10/2019 10:51:00 AM By Admin

3926 Views

how to save and retrieve session value in asp.net

3/30/2019 5:59:00 AM By Admin

1917 Views

How to use Session variables asp.net c#

4/2/2019 11:24:00 AM By Admin

11853 Views

How to pass list of items using session in asp.net

4/2/2019 12:07:00 PM By Admin

3136 Views

Comments

Leave a Reply

Comment:^*

Please your Comment !

Email ID:^*

Enter Your Email Id ! Enter Your Validate Email Id !

Name:^*

Enter your Name !

RECENT POSTS

Technology

Information

Tags

Email Alerts

Home > ASP.NET > how to bind DataList from database using C#

Related Articles

How to use gridview in asp.net with C# using Mysql 2/1/2019 11:51:00 PM By Admin 2237 Views

How to use gridview with datatable in asp.net with C# using Mysql 2/3/2019 9:50:00 PM By Admin 1887 Views

How to bind gridview with datatable in asp.net with C# without using the database 2/3/2019 10:35:00 PM By Admin 5502 Views

How to bind gridview with datatable in asp.net with c# without using the database 2/3/2019 10:35:00 PM By Admin 2389 Views

How to fetch data from database in Asp.net 2/10/2019 10:05:00 PM By Admin 7495 Views

How to insert and retrieve data from the database in vue js using asp.net with C# 3/4/2019 7:54:00 AM By Admin 8221 Views

How to bind Repeater control from database in Asp.net 3/10/2019 10:51:00 AM By Admin 3926 Views

how to save and retrieve session value in asp.net 3/30/2019 5:59:00 AM By Admin 1917 Views

How to use Session variables asp.net c# 4/2/2019 11:24:00 AM By Admin 11853 Views

How to pass list of items using session in asp.net 4/2/2019 12:07:00 PM By Admin 3136 Views