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....