How to retrieve data from database onto asp table??

Question

How to retrieve data from database onto asp(front end web page) table??

Roei Bar · Answer

here is a way using DataTable and DataBindingNavigator String strConn = "Server = .\sqlexpress;Database = NorthWind;Integrated Security = SSPI;" ; dataGridView1.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode .AllCells; conn = new SqlConnection (strConn); da = new SqlDataAdapter ( "Select Categories.CategoryName, Products.ProductName, Products.UnitPrice From Categories Inner Join Products on Products.CategoryID = Categories.CategoryID" , conn); SqlCommandBuilder cmd = new SqlCommandBuilder (da); ds = new DataSet (); da.Fill(ds, "Categories" ); bs = new BindingSource (ds, "Categories" ); dataGridView1.DataSource = bs; bindingNavigator1.BindingSource = bs; using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace CSharpBindingSource { public partial class Form1 : Form { SqlDataAdapter da; SqlConnection conn; DataSet ds; BindingSource bs; public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { String strConn = "Server = .;Database = NorthWind;Integrated Security = SSPI;"; conn = new SqlConnection(strConn); da = new SqlDataAdapter("Select * From Employees", conn); SqlCommandBuilder cmd = new SqlCommandBuilder(da); ds = new DataSet(); da.Fill(ds, "Employees"); bs = new BindingSource(ds, "Employees"); dataGridView1.DataSource = bs; bindingNavigator1.BindingSource = bs; } private void toolStripButton1_Click(object sender, EventArgs e) { bs.EndEdit(); da.Update(ds, "Employees"); } } }

Kirtan Patel · Answer

Friend , Here is Code I have written for it take a Look dont forget to mark " Do you like answer " it will give me some credits :) protected void Button1_Click( object sender, EventArgs e) { SqlConnection con = new SqlConnection ( @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True" ); con.Open(); SqlCommand comm = new SqlCommand ( "Select * from Users" , con); SqlDataReader reader = comm.ExecuteReader(); while (reader.Read()) { TableRow r = new TableRow (); TableCell c1 = new TableCell (); TableCell c2 = new TableCell (); c1.Text = reader[ "Username" ].ToString(); c2.Text = reader[ "Password" ].ToString(); r.Cells.Add(c1); r.Cells.Add(c2); Table1.Rows.Add(r); } }

asif basha · Answer

asp.net table

Kirtan Patel · Answer

Do you want Data in HTML Table in Classic Asp or asp.net ???

How to retrieve data from database onto asp table??

Answers (4)