How to display data in Table in ASP.NET

Question

Hi, How to display data in Table from sql server in ASP.NET ?

Satyapriya Nayak · Answer

Hi Dea, If this post helps you mark it as answer Thanks

Rohatash Kumar · Answer

Hi, see our recommended section on the right side.

Satyapriya Nayak · Answer

Hi Dea, To display data in table format you have to use table control. 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 sqlda As SqlDataAdapter Dim com As SqlCommand Dim ds As DataSet Dim dt As DataTable Dim str As String Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Dim con As New SqlConnection(strConnString) Try con.Open() str = "select * from student " com = New SqlCommand(str, con) ds = New DataSet sqlda = New SqlDataAdapter(com) sqlda.Fill(ds, "student") dt = ds.Tables("student") For i = 0 To dt.Rows.Count - 1 Dim tr As New TableRow For j = 0 To dt.Columns.Count - 1 Dim tc As New TableCell tc.Text = dt.Rows(i).ItemArray(j) tr.Cells.Add(tc) Table1.Rows.Add(tr) Next Next con.Close() Catch ex As Exception Response.Write(ex.Message) End Try End Sub End Class Thanks If this post helps you please mark it as answer

How to display data in Table in ASP.NET

Answers (3)