110,571
社区成员
发帖
与我相关
我的任务
分享
dataGridView1.AutoGenerateColumns=true;
DataSet ds = new DataSet();
OleDbDataAdapter oda = new OleDbDataAdapter("select * from Student", connA);
oda.Fill(ds);
dataGridView1.DataSource = ds.Tables[0].DefaultView;
//connA是"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\clx\\SII.mdb";
D:\\clx\\SII.mdb是路径
这段是读取access的
string conn = "server=********;uid=sa;pwd=******;database=Test;";
string list = "SELECT Test01.ID , Test01.Class, Test02.Name, Test02.Sex FROM Test01 INNER JOIN Test02 ON Test01.ID = Test02.ID";
SqlCommand sqcomm;
SqlDataAdapter sqa = new SqlDataAdapter(list, conn);
DataSet ds = new DataSet();
SqlConnection sqc = new SqlConnection(conn);
sqcomm = new SqlCommand();
sqa.Fill(ds, "Test01");
dataGridView1.DataSource = ds.Tables["Test01"];
调用sql的
------------------------------------------------------------------
向SQL添加数据
sql = "select * from test02";
sqa = new SqlDataAdapter(sql, conn);
ds = new DataSet();
sqa.Fill(ds, "test02");
scb = new SqlCommandBuilder(sqa);
//sqcomm = new SqlCommand();
newRow = ds.Tables["test02"].NewRow();
newRow["ID"] = "35";
newRow["Name"] = "我很喜欢";
newRow["Sex"] = "女";
ds.Tables["test02"].Rows.Add(newRow);
sqa.Update(ds, "test02");
ds.AcceptChanges();//提交改变