string sql = "select * from Student";
SqlDataAdapter sdr = new SqlDataAdapter(sql, conn);
DataSet ds = new DataSet();
//DataTable dt=new DataTable();
//sdr.MissingSchemaAction = MissingSchemaAction.AddWithKey;
//SqlCommandBuilder builder = new SqlCommandBuilder(sdr);
//sdr.Fill(ds, "student");
sdr.Fill(ds);
this.dataGridView1.DataSource = ds.Tables[0].DefaultView;
//dataGridView1.DataSource=dt.DefaultView;
conn.Close();
SqlDataReader myDataReader = myCommand.ExecuteReader();
实例:
string connString=@"server=CJU/SQL2005;uid=sa;pwd=sa110;database=mysqldb";
SqlConnection conn=new SqlConnection(connString);
conn.Open();
string sql="select * from dbo.myTable";
//读入方式访问数据库:
SqlCommand com=new SqlCommand(sql,conn);
SqlDataReader rs=com.ExecuteReader();
while(rs.Read())
{
this.comboBox1.Items.Add("["+rs[0]+"]"+rs[1]);
this.listBox1.Items .Add("["+rs[0]+"]"+rs[1]);
}
this.comboBox1.Focus();
rs.Close();
//绑定方式访问数据库:
SqlDataAdapter sdr=new SqlDataAdapter(sql,conn);
DataSet ds=new DataSet();
sdr.Fill(ds);
this.dataGridView1.DataSource=ds.Tables[0].DefaultView;
conn.Close();