Datalist and datagrisview i .net

Hi Vineet,

First of all there is no datagridview in asp.net ,its called Gridview.


The DataList control is used to display a repeated list of items that are bound to the control. However, the DataList control adds a table around the data items by default.


Ex:-

Default.aspx code

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>






   

   

   

   
   
       
       

Student Details

   
               
               
               
               
               
               
               
               
               
               
               
               
               
               
               
               

sid	sname	saddress	smarks	pic
<%#Container.DataItem("sid")%>	<%#Container.DataItem("sname")%>	<%#Container.DataItem("saddress")%>	<%#Container.DataItem("smarks")%>

               
   
   

Default.aspx.vb code

Imports System.Data.SqlClient
Imports System.Data
Partial Class _Default
    Inherits System.Web.UI.Page
    Dim strConnString As String = System.Configuration.ConfigurationManager.ConnectionStrings.Item("ConnectionString").ToString()
    Dim con As New SqlConnection(strConnString)
    Dim com As SqlCommand
    Dim str As String
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        If Not IsPostBack Then
            con.Open()
            Str = "select * from student"
            com = New SqlCommand(Str, con)
            Dim reader As SqlDataReader
            reader = com.ExecuteReader
            DataList1.DataSource = reader
            DataList1.DataBind()
            reader.Close()
            con.Close()
        End If
    End Sub
End Class



Gridview:- Displays the values of a data source in a table where each column represents a field and each row represents a record. The GridView control enables you to select, sort, and edit these items

Ex:-

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





   


   

   

                AllowPaging="True" PageSize="2" BackColor="#FF9999"
            onpageindexchanging="GridView1_PageIndexChanging">
           
           
                                
                   
                                               
                   
               
               
                  
                   
                       
                   
               
               
               
                  
                   
                       
                   
               
               
               
               
                  
                   
                       
                   
               
               
               
                  
                   
                       
                   
               
               
           
       
   

   

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 connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
    SqlCommand com;
    SqlDataAdapter sqlda;
    DataSet ds;
    string str;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            BindGrid();
        }
    }
    void BindGrid()
    {
        SqlConnection con = new SqlConnection(connStr);
        con.Open();
        str = "select * from student";
        com = new SqlCommand(str, con);
        sqlda = new SqlDataAdapter(com);
        con.Close();
        ds = new DataSet();
        sqlda.Fill(ds, "student");
        GridView1.DataSource = ds;
        GridView1.DataMember = "student";
        GridView1.DataBind();

    }
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        BindGrid();
    }
}



Thanks