How to Bind Datalist control using Sqldataadapter, Datatable and Query in Asp.net(C#, VB)? | ASPMANTRA | Asp.Net,MVC,AngularJs,Jquery,Javascript,Sql Server AND WCF snippets and tutorial

How to Bind Datalist control using Sqldataadapter, Datatable and Query in Asp.net(C#, VB)?


Introduction: In this post I will explain you how to bind the Datalist  data control in Asp.net.

Description:
I have created a table name STUDENT_DETAIL.
STUDENT_ID
int
STUDENT_NAME
varchar(50)
STUDENT_ADDRESS
varchar(50)
STUDENT_CLASS
varchar(50)

STUDENT_ID is primary key.
Now open the Visual Studio>Go to File>New>Website. Add the Connectionstring in web.config file of website.
<configuration>
       <connectionStrings>
    <add name="connection" connectionString="Data Source=SYS-1F78031ED0A;Initial Catalog=TestBlog;Integrated Security=True"/>
       </connectionStrings>
       <system.web>
        <compilation debug="true" targetFramework="4.0" />
    </system.web>
</configuration>


After that add new web form to website, drag and drop the Datalist Data control from Toolbox.
  <asp:DataList ID="dlstudent" runat="server" DataKeyField="STUDENT_ID">
            <HeaderStyle Font-Bold="True" BorderColor="Black" />
            <HeaderTemplate>
             <table border="1"><tr style="background-color:Blue;color:White;">
             <td><b>Student Name</b> </td>
             <td>Student Address</td>
             <td>Student Class</td>
             </tr>
            </HeaderTemplate>
            <ItemTemplate>
            <tr style="font-style:italic;">
              <td align="center"><asp:Label ID="lblname" runat="server"
                    Text='<%# Eval("STUDENT_NAME") %>'></asp:Label></td>
                <td align="center"><asp:Label ID="lbladdress" runat="server"
                    Text='<%# Eval("STUDENT_ADDRESS") %>'></asp:Label></td>
               <td align="center"><asp:Label ID="lblclass" runat="server"
                    Text='<%# Eval("STUDENT_CLASS") %>'></asp:Label></td></tr>
            </ItemTemplate>
                       </asp:DataList>
                                  <table border="1">
             <tr style="color:Red;><td>
                 <asp:Label ID="Label1" runat="server" Text=""></asp:Label></td></tr></table>
After that go to .aspx.cs page and add namespace.
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

Create function to bind Datalist.

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["connection"].ToString());
    protected void Page_Load(object sender, EventArgs e)
    {
        if (con.State == ConnectionState.Closed)
            con.Open();
        if (!IsPostBack)
        {
            BindDatalist();
        }
    }
    private void BindDatalist()
    {
        SqlDataAdapter adp = new SqlDataAdapter("Select * from STUDENT_DETAIL", con);
        DataTable dt = new DataTable();
        adp.Fill(dt);
        if (dt.Rows.Count > 0)
        {
            dlstudent.DataSource = dt;
            dlstudent.DataBind();
        }
        else
        {         
            dlstudent.DataSource = null;
            dlstudent.DataBind();
            Label1.Text = "NO data found";
        }
    }



In VB:
Go to .aspx.vb page and add namespace.
Imports System.Data
Imports System.Data.SqlClient
Imports System.Configuration

Cretae function to bind Datalist.
Dim con As New SqlConnection(ConfigurationManager.ConnectionStrings("connection").ToString())
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        If con.State = ConnectionState.Closed Then
            con.Open()
        End If
        If Not IsPostBack Then
            BindDatalist()
        End If
    End Sub
    Private Sub BindDatalist()
        Dim adp As New SqlDataAdapter("Select * from STUDENT_DETAIL", con)
        Dim dt As New DataTable()
        adp.Fill(dt)
        If dt.Rows.Count > 0 Then
            dlstudent.DataSource = dt
            dlstudent.DataBind()
        Else
            dlstudent.DataSource = Nothing
            dlstudent.DataBind()
            lblmessage.Text = "No Data Found"
        End If
    End Sub

Debug the project and check the result.


Related Articles on Datalist:

Ø  How to Bind, Edit, Delete and Update in Datalistin Asp.net(C#, VB)?

Ø  How to Bind Datalist in Asp.net

Is it helpful?

If yes post your comment to admire my work. You can like me on Facebook, Google+, Linkedin and Twitter via hit on Follow us Button and also can get update follow by Email.

Post a Comment

[blogger]

MKRdezign

Contact Form

Name

Email *

Message *

Powered by Blogger.
Javascript DisablePlease Enable Javascript To See All Widget