SqlConnection cn = new SqlConnection("server=web;database=wlud;uid=sa;password=lhj123");
try
{
cn.Open();
SqlDataAdapter da = new SqlDataAdapter("select * from scjyc_article",cn);
DataSet ds = new DataSet();
da.Fill(ds,"test");
this.DataGrid1.DataSource = ds.Tables["test"];
this.DataGrid1.DataBind();
}
catch(Exception ex)
{
Response.Write(ex.Message);
}
finally
{
if(cn.State != ConnectionState.Closed)
{
cn.Close();
}
}
try
{
cn.Open();
SqlDataAdapter da = new SqlDataAdapter("select * from scjyc_article",cn);
DataSet ds = new DataSet();
da.Fill(ds,"test");
this.DataGrid1.DataSource = ds.Tables["test"];
this.DataGrid1.DataBind();
}
catch(Exception ex)
{
Response.Write(ex.Message);
}
finally
{
if(cn.State != ConnectionState.Closed)
{
cn.Close();
}
}
试一试...
up
up
{
SqlConnection myConn = new SqlConnection("server=wayne;uid=sa;pwd=;database=Northwind");
string strSQL1="select LastName,FirstName from Employees";
SqlDataAdapter Adapter1= new SqlDataAdapter(strSQL1, myConn);
DataSet ds = new DataSet();
Adapter1.Fill(ds,"Employees");
return ds;
}
protected void BindGrid()
{
MyDataGrid.DataSource=GetProductData().Tables["Employees"].DefaultView;
MyDataGrid.DataBind();
}