Datalist and datagrisview i .net

Question

Hi..... I want to know difference between datalist and datagridview in asp.net ? How to show data in the datagridview and datalist from database ? Please explain with example ? Thanks......

Satyapriya Nayak · Answer

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 Untitled Page Student Details sid sname saddress smarks pic ' runat="server" /> 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:- Untitled Page AllowPaging="True" PageSize="2" BackColor="#FF9999" onpageindexchanging="GridView1_PageIndexChanging"> ' runat="server" /> '> '> '> '> 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

Vineet Kumar Saini · Answer

Thanks Nayak Ji....

Datalist and datagrisview i .net

Answers (2)