初学C#求dataGridView的基本用法 谢谢
OleDbConnection connection1 = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=E:\\db1.mdb");
DataSet ds;
private void FormSCScoreManage_Load(object sender, EventArgs e)
{
connection1.Open();
string sql = "select Student_ID as 学号,Student_Nam as 姓名,Student_Sex as 性别,Student_Age as 年龄,Student_Spe as 专业,Student-DParty as 所在系 from StudentInfo";
OleDbDataAdapter adp = new OleDbDataAdapter(sql, connection1);
ds = new DataSet();
adp.Fill(ds, "Student");
dataGridView1.DataSource = ds;
dataGridView1.DataSource = ds.Tables[0].DefaultView;
}
运行后在dataGridView中没有显示想要的内容,求高手指点。
OleDbConnection connection1 = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=E:\\db1.mdb");
DataSet ds;
private void FormSCScoreManage_Load(object sender, EventArgs e)
{
connection1.Open();
string sql = "select Student_ID as 学号,Student_Nam as 姓名,Student_Sex as 性别,Student_Age as 年龄,Student_Spe as 专业,Student-DParty as 所在系 from StudentInfo";
OleDbDataAdapter adp = new OleDbDataAdapter(sql, connection1);
ds = new DataSet();
adp.Fill(ds, "Student");
dataGridView1.DataSource = ds;
dataGridView1.DataSource = ds.Tables[0].DefaultView;
}
运行后在dataGridView中没有显示想要的内容,求高手指点。
dataGridView1.DataSource = ds.Tables["Student"];
DataSet ds;
private void FormSCScoreManage_Load(object sender, EventArgs e)
{
connection1.Open();
string sql = "select Student_ID as 学号,Student_Nam as 姓名,Student_Sex as 性别,Student_Age as 年龄,Student_Spe as 专业,Student-DParty as 所在系 from StudentInfo";
OleDbDataAdapter adp = new OleDbDataAdapter(sql, connection1);
ds = new DataSet();
//不是叫你加,是改
adp.Fill(ds, "Student");
dataGridView1.DataSource = ds.Tables["Student"];如果这不行,就是你的SQL语保存错或数据库没有打开
}