How to retrieve data from database onto asp table??

 

 
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");
}
}
}