62,244
社区成员




public DataView mybind()
{
string s = System.Configuration.ConfigurationManager.AppSettings["strconn"];
using (SqlConnection conn = new SqlConnection(s))
{
string sel = "select * from art";
conn.Open();
SqlDataAdapter dr = new SqlDataAdapter(sel, conn);
DataSet ds = new DataSet();
dr.Fill(ds);
grid.DataSource = ds;
grid.DataBind();
}
return;
}
click直接调用函数就行
protectedvoid Button1_Click(object sender, EventArgs e)
{
mybind();
}
public void mybind()
{
string s = System.Configuration.ConfigurationManager.AppSettings["strconn"];
using (SqlConnection conn = new SqlConnection(s))
{
string sel = "select * from art";
conn.Open();
SqlDataAdapter dr = new SqlDataAdapter(sel, conn);
DataSet ds = new DataSet();
dr.Fill(ds);
grid.DataSource = ds;
grid.DataBind();
}
}
using (SqlConnection conn = new SqlConnection(s))
{}
public DataSet mybind()
{
string s = System.Configuration.ConfigurationManager.AppSettings["strconn"];
DataSet ds = new DataSet();
using (SqlConnection conn = new SqlConnection(s))
{
string sel = "select * from art";
conn.Open();
SqlDataAdapter dr = new SqlDataAdapter(sel, conn);
dr.Fill(ds);
}
return ds;
}
改成这样的试试吧。