string sqlstr = "select * from table1";
da = new OleDbDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
this.dataGridView1.DataSource = ds.Tables[0];
da = new OleDbDataAdapter(sqlstr, conn);
ds = new DataSet();
da.Fill(ds);
this.dataGridView1.DataSource = ds.Tables[0];
this.dataGridView1.DataSource = ds.Tables[0];
dv.RowFilter = "ID > 3 ";
this.dataGridView1.DataSource = dv.Table;
{
dataGridViewColor.AllowUserToAddRows = true;
string sql = "select * from DS_ShopEssenceInfoColor";
SqlConnection sqlconn = new SqlConnection(sqlclass.mySql());
SqlDataAdapter sqlDad = new SqlDataAdapter(sql,sqlconn);
SqlCommand sqlcomm = new SqlCommand(sql,sqlconn);
sqlconn.Open();
SqlDataReader sqlDR = sqlcomm.ExecuteReader();
if (sqlDR != null)
{
while(sqlDR.Read())
{
dataGridViewColor.Rows[0].Cells[0].Value = sqlDR[0].ToString();
dataGridViewColor.Rows[0].Cells[1].Value = sqlDR[1].ToString();
dataGridViewColor.Rows[0].Cells[2].Value = sqlDR[2].ToString();
dataGridViewColor.Rows[0].Cells[3].Value = sqlDR[3].ToString();
}
sqlDR.Close();
}
}我的代码是这样的,这样只显示一条记录