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 int,pic 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/

Data list in Asp.net

Answers (2)