Data list in Asp.net

Question

HI friends What is the use of data list in asp.net ?

Satyapriya Nayak · Answer

Hi Akshay 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. The DataList control may be bound to a database table an XML file or another list of items. Here is an example Display Picture and record In Datalist First create a table student Create table student (sid varchar(50)sname varchar(50)saddress varchar(50) smarks intpic varchar (50)) Store the picture in the program folder and save there name in pic column of the table with there extension like (.gif.jpg.bmp) 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 Thanks

Vulpes · Answer

Well it's described in MSDN as a data bound list control that displays items using templates. To understand what this means and why you might want to use it rather than a DataGrid or Repeater control then I'd read these articles: http://msdn.microsoft.com/en-us/library/aa479015.aspx http://www.c-sharpcorner.com/uploadfile/puranindia/datagrid-and-datalist-controls-in-Asp-Net/