Datalist View

Zeb Rehman

14y3.2k.NET

Hi Friends!
I want to implement datalist functionality in my project. I want the datalist to get the data from a column in a table and show it in the datalist. Please can somebody tell me how to bind the datalist with the database column. Thanks in advance.
Regards
Zeb-ur-Rehman.

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Satyapriya Nayak14y ago

Accepted answer

Hi Zeb,

Try this...

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

Untitled Page

      Employee Details

ID	NAME	SALARY	ADDRESS	DESIGNATION
<%#Eval("empid")%>	<%#Eval("empname")%>	<%#Eval("empsal")%>	<%#Eval("empadd")%>	<%#Eval("empdes")%>

Font-Bold="True" ForeColor="#FF3300">

onclick="btnPrevious_Click">
onclick="btnNext_Click">

using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
    string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
    string str ;
    SqlCommand com;
    SqlDataAdapter sqlda;
    DataSet ds;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            binddatalist();
        }
    }
    private void binddatalist()
    {
        SqlConnection con = new SqlConnection(strConnString);
        con.Open();
        str = "select * from employee";
        com = new SqlCommand(str, con);
        sqlda = new SqlDataAdapter(com);
        ds = new DataSet();
        sqlda.Fill(ds, "employee");
        PagedDataSource Pds1 = new PagedDataSource();
        Pds1.DataSource = ds.Tables[0].DefaultView;
        Pds1.AllowPaging = true;
        Pds1.PageSize = 3;
        Pds1.CurrentPageIndex = CurrentPage;
        lbl1.Text = "Showing Page: " + (CurrentPage + 1).ToString() + " of " + Pds1.PageCount.ToString();
        btnPrevious.Enabled = !Pds1.IsFirstPage;
        btnNext.Enabled = !Pds1.IsLastPage;
        dl1.DataSource = Pds1;
        dl1.DataBind();
        con.Close();
    }
    public int CurrentPage
    {
        get
        {
            object s1 = this.ViewState["CurrentPage"];
            if (s1 == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(s1);
            }
        }

        set { this.ViewState["CurrentPage"] = value; }
    }

    protected void btnPrevious_Click(object sender, EventArgs e)
    {
        CurrentPage -= 1;
        binddatalist();

    }
    protected void btnNext_Click(object sender, EventArgs e)
    {
        CurrentPage += 1;
        binddatalist();

    }
}

Thanks
If this post helps you mark it as answer

Zeb Rehman14y ago
Well thank you very much brother. You have solved one of my great problem. I can't express my felling in word's. Once again thank you very very much for your kind help.....
Satyapriya Nayak14y ago
Hi Zeb,

Try this...

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="DataList_link_data_gridview._Default" %>

    Untitled Page





    runat="server" Font-Bold="True" onitemcommand="DataList1_ItemCommand">




Student Id



Completed





using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
namespace DataList_link_data_gridview
{
    public partial class _Default : System.Web.UI.Page
    {
        string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
        string str;
        SqlCommand com;
        SqlDataAdapter sqlda;
        DataSet ds;

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                binddatalist();
            }
        }
        private void binddatalist()
        {
            SqlConnection con = new SqlConnection(strConnString);
            con.Open();
            str = "select * from student";
            com = new SqlCommand(str, con);
            sqlda = new SqlDataAdapter(com);
            ds = new DataSet();
            sqlda.Fill(ds, "student");
            DataList1.DataMember = "student";
            DataList1.DataSource = ds;
            DataList1.DataBind();
            con.Close();
        }

        protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
        {

        string s = DataList1.DataKeys[e.Item.ItemIndex].ToString();
        Response.Redirect(String.Format("Default2.aspx?id={0}", s));
        }
    }
}

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default2.aspx.cs" Inherits="DataList_link_data_gridview.Default2" %>

    Untitled Page












using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
namespace DataList_link_data_gridview
{
    public partial class Default2 : System.Web.UI.Page
    {
        string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
        string str;
        SqlCommand com;
        SqlDataAdapter sqlda;
        DataSet ds;

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
            SqlConnection con = new SqlConnection(strConnString);
            con.Open();
            str = "select * from student where sid='" + Request.QueryString["id"] + "'";
            com = new SqlCommand(str, con);
            sqlda = new SqlDataAdapter(com);
            ds = new DataSet();
            ds.Clear();
            ds.Reset();
            sqlda.Fill(ds, "student");
            GridView1.DataMember = "student";
            GridView1.DataSource = ds;
            GridView1.DataBind();
            con.Close();
            }

        }

    }
}

Thanks
Zeb Rehman14y ago
Well thank you very much Mr. Nayak that really helped me a lot. I want to display hyperlink in datalist which are the values taken from table and then when user click on one of the hyperlink that redirect me toward a page to which i passed the value of the hyperlink in url.(Department_Name is retrieved from Department table. When user click on specific Department name it redirect me to page demo.aspx with value of department name. e.g http://localhost:5385/demo.aspx?val=Zeb). Once again thanks for your help.
Zeb Rehman14y ago
Well thank you very much Mr. Nayak that really helped me a lot. I want to display hyperlink in datalist which are the values taken from table and then when user click on one of the hyperlink that redirect me toward a page to which i passed the value of the hyperlink in url.(Department_Name is retrieved from Department table. When user click on specific Department name it redirect me to page demo.aspx with value of department name. e.g http://localhost:5385/demo.aspx?val=Zeb). Once again thanks for your help.