请问高手，用c#连接ACCESS的,如何更新数据库？

[wuyu8081]

private void UseManaw_Load(object sender, EventArgs e)
{
OleDbConnection myconnection = conn.con();
string strInsert = "select * from 用户";
OleDbDataAdapter oda = new OleDbDataAdapter(strInsert,myconnection);
DataSet ds = new DataSet();
oda.Fill(ds);
usename1.Text = ds.Tables[0].Rows[0][1].ToString();
passwordl.Text = ds.Tables[0].Rows[0][2].ToString();


}//获取用户名和密码。
private void UseManab_Click(object sender, EventArgs e)
{
OleDbConnection myconnection = conn.con();
string strInsert = "select * from 用户";
OleDbDataAdapter oda = new OleDbDataAdapter(strInsert, myconnection);
OleDbCommandBuilder cb = new OleDbCommandBuilder(ada);
DataSet ds = new DataSet();
oda.Fill(ds);
。。。修改后如何更新。
}
菜鸟这里先谢了！

[ojekleen]

OleDbConnection myconnection = conn.con();
sqlcommand cmd=new sqlcommand("insert into 用户 values ("","" ),myconnection );
myconnection .open();
cmd.executenonquery();
myconnection .close();

[viki117]

[Quote=引用 1 楼 ojekleen 的回复:]
OleDbConnection myconnection = conn.con();
sqlcommand cmd=new sqlcommand("insert into 用户 values ("","" ),myconnection );
myconnection .open();
cmd.executenonquery();
myconnection .close();
[/Quote]

[JaggerLee]

[Quote=引用 3 楼 cww2010 的回复:]
首先加载

……


private void 更新()
{
ds.Tables[0].Rows[0][1].ToString()=usename1.Text;
ds.Tables[0].Rows[0][2].ToString()=passwordl.Text
oda.Update(ds);
}
[/Quote]

正解!

[cww2010]

首先加载
OleDbDataAdapter oda;
DataSet ds;
private void UseManaw_Load(object sender, EventArgs e)
{
OleDbConnection myconnection = conn.con();
string strInsert = "select * from 用户";
oda = new OleDbDataAdapter(strInsert,myconnection);
OleDbCommandBuilder cb = new OleDbCommandBuilder(ada);
ds = new DataSet();
oda.Fill(ds);
usename1.Text = ds.Tables[0].Rows[0][1].ToString();
passwordl.Text = ds.Tables[0].Rows[0][2].ToString();
}
private void 更新()
{
ds.Tables[0].Rows[0][1].ToString()=usename1.Text;
ds.Tables[0].Rows[0][2].ToString()=passwordl.Text
oda.Update(ds);
}

[wuyu8081]

3楼那里没错，更新了oda,可是没更新数据库里的记录　是不是还要加上哪句　才能更新数据库里的记录。