//运行加载数据
private void Form1_Load(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("server=.;database=Forum;uid=sa;pwd=123456");
conn.Open();
string sql = "select * from Post";
SqlCommand comd = new SqlCommand(sql, conn);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(comd);
//放数据到DateSet前,先清除之前的数据
ds.Clear();
da.Fill(ds);
comd.ExecuteNonQuery();
this.ddView.DataSource = ds.Tables[0].DefaultView;
ds = null;
da = null;
comd.Dispose();
conn.Close();
}
private void Form1_Load(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("server=.;database=Forum;uid=sa;pwd=123456");
conn.Open();
string sql = "select * from Post";
SqlCommand comd = new SqlCommand(sql, conn);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(comd);
//放数据到DateSet前,先清除之前的数据
ds.Clear();
da.Fill(ds);
comd.ExecuteNonQuery();
this.ddView.DataSource = ds.Tables[0].DefaultView;
ds = null;
da = null;
comd.Dispose();
conn.Close();
}