SqlConnection conn=new Sqlconnection("server=localhost;database=northwind;uid=sa;pwd=");
SqlCommand comm=conn.CreatCommand();
conn.Open();
 SqlDataAdapter adp=new SqlDataAdapter();
  DataSet ds=new DataSet();
 adp.SelectCommand=comm;
  adp.Fill(ds,"tablel");
   DataView dv=new DataView();
   dv=ds.Tables("table1").DefaultView;
     DataGrid1.DataSource=dv;
          DataGrid1.DataBind();