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

01-02-2019 23:51:00 By Admin

2451 Views

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

03-02-2019 21:50:00 By Admin

2091 Views

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

03-02-2019 22:35:00 By Admin

5783 Views

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

03-02-2019 22:35:00 By Admin

2660 Views

How to fetch data from database in Asp.net

10-02-2019 22:05:00 By Admin

7799 Views

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

04-03-2019 07:54:00 By Admin

8571 Views

How to bind Repeater control from database in Asp.net

10-03-2019 10:51:00 By Admin

4254 Views

how to save and retrieve session value in asp.net

30-03-2019 05:59:00 By Admin

2166 Views

How to use Session variables asp.net c#

02-04-2019 11:24:00 By Admin

12238 Views

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

02-04-2019 12:07:00 By Admin

3442 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 01-02-2019 23:51:00 By Admin 2451 Views

How to use gridview with datatable in asp.net with C# using Mysql 03-02-2019 21:50:00 By Admin 2091 Views

How to bind gridview with datatable in asp.net with C# without using the database 03-02-2019 22:35:00 By Admin 5783 Views

How to bind gridview with datatable in asp.net with c# without using the database 03-02-2019 22:35:00 By Admin 2660 Views

How to fetch data from database in Asp.net 10-02-2019 22:05:00 By Admin 7799 Views

How to insert and retrieve data from the database in vue js using asp.net with C# 04-03-2019 07:54:00 By Admin 8571 Views

How to bind Repeater control from database in Asp.net 10-03-2019 10:51:00 By Admin 4254 Views

how to save and retrieve session value in asp.net 30-03-2019 05:59:00 By Admin 2166 Views

How to use Session variables asp.net c# 02-04-2019 11:24:00 By Admin 12238 Views

How to pass list of items using session in asp.net 02-04-2019 12:07:00 By Admin 3442 Views