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