SqlDataAdapter comm= new SqlDataAdapter(conn,myconn);
DataSet ds=new DataSet();
comm.fill(ds);
DataGrid1.DataSource=ds;
DataGrid1.DataBind();
DataSet ds=new DataSet();
comm.fill(ds);
DataGrid1.DataSource=ds;
DataGrid1.DataBind();
{
string connstr,sql;
connstr="server=10.0.21.100;uid=sa;pwd=sa;database=OA_TM";
sql="select * from GM_METHOD_FIELD";
SqlConnection conn=new SqlConnection(connstr);
SqlDataAdapter da=new SqlDataAdapter(sql,conn);
DataSet ds=new DataSet();
da.Fill(ds,"GM_METHOD_FIELD");
DataGrid1.DataSource=ds.Tables["GM_METHOD_FIELD"];
if(!Page.IsPostBack)
{
DataGrid1.DataBind();
}
}
SqlConnection myconn=new SqlConnection(Strconn); SqlDataAdapter madp=new SqlDataAdapter(conn,myconn);
madp.Fill(ds);
DataGrid1.DataSource=ds.Tables[0].DefaultView;
DataGrid1.DataBind();
DataGrid1.DataBind();