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);
修改后如何更新。
}
菜鸟这里先谢了!
{
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);
修改后如何更新。
}
菜鸟这里先谢了!
sqlcommand cmd=new sqlcommand("insert into 用户 values ("","" ),myconnection );
myconnection .open();
cmd.executenonquery();
myconnection .close();
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);
}