private void Button1_Click(object sender, System.EventArgs e)
{
OleDbConnection mycon=new OleDbConnection(conStr);
try
{
mycon.Open();
OleDbCommand cmd= new OleDbCommand();
cmd.Connection=mycon;
cmd.CommandText="update userinfo set username=@uasename,userpwd=@pwd,realname=@realname, gender=@gender,age=@age,userTel=@Tel,userAddr=@userAddr,userEmail=@Email where userid=@userid";
cmd.Parameters.Add("@username",OleDbType.BSTR).Value=TextBox1.Text;
cmd.Parameters.Add("@pwd",OleDbType.BSTR).Value=TextBox2.Text;
cmd.Parameters.Add("@realname",OleDbType.BSTR).Value=TextBox4.Text;
cmd.Parameters.Add("@gender",OleDbType.BSTR).Value=TextBox5.Text;
cmd.Parameters.Add("@age",OleDbType.Integer).Value=Convert.ToInt16(TextBox6.Text);
cmd.Parameters.Add("@Tel",OleDbType.BSTR).Value=TextBox7.Text;
cmd.Parameters.Add("@userAddr",OleDbType.BSTR).Value=TextBox8.Text;
cmd.Parameters.Add("@Email",OleDbType.BSTR).Value=TextBox9.Text;
cmd.Parameters.Add("@userid",OleDbType.Integer).Value=Convert.ToInt16(userid);
cmd.Prepare();
int m=cmd.ExecuteNonQuery(); if(m==1)
strReginfo="更新成功!";
else
strReginfo="更新失败!";
}
catch(Exception sqlerr)
{
throw new Exception(sqlerr.Message);
}
finally
{
mycon.Close();
}
}
{
OleDbConnection mycon=new OleDbConnection(conStr);
try
{
mycon.Open();
OleDbCommand cmd= new OleDbCommand();
cmd.Connection=mycon;
cmd.CommandText="update userinfo set username=@uasename,userpwd=@pwd,realname=@realname, gender=@gender,age=@age,userTel=@Tel,userAddr=@userAddr,userEmail=@Email where userid=@userid";
cmd.Parameters.Add("@username",OleDbType.BSTR).Value=TextBox1.Text;
cmd.Parameters.Add("@pwd",OleDbType.BSTR).Value=TextBox2.Text;
cmd.Parameters.Add("@realname",OleDbType.BSTR).Value=TextBox4.Text;
cmd.Parameters.Add("@gender",OleDbType.BSTR).Value=TextBox5.Text;
cmd.Parameters.Add("@age",OleDbType.Integer).Value=Convert.ToInt16(TextBox6.Text);
cmd.Parameters.Add("@Tel",OleDbType.BSTR).Value=TextBox7.Text;
cmd.Parameters.Add("@userAddr",OleDbType.BSTR).Value=TextBox8.Text;
cmd.Parameters.Add("@Email",OleDbType.BSTR).Value=TextBox9.Text;
cmd.Parameters.Add("@userid",OleDbType.Integer).Value=Convert.ToInt16(userid);
cmd.Prepare();
int m=cmd.ExecuteNonQuery(); if(m==1)
strReginfo="更新成功!";
else
strReginfo="更新失败!";
}
catch(Exception sqlerr)
{
throw new Exception(sqlerr.Message);
}
finally
{
mycon.Close();
}
}
解决方案 »
- js 设置和读取cookie
- 100 分! 我用 freetextbox 等在线编辑器时,为什么在使用时,在里面输入的字都是大字呢,我想录入在编辑器里面的字也是网页用的 9pt 字
- 这样的泛型方法怎么写?
- IIS中替换了DLL就不能正常工作了
- 关于public static与public方法区别的讨论,谢谢指点
- 订单插入后有时候查询不到订单
- 在datagride中插入自定义列后,怎么获得对应的值?
- Repeater 中如何使用 UrlEncode()?
- 关于DataGrid的行,列问题?
- 新手提问:用ASP.net开发都用什么环境比较好些?谢谢!
- 请问各位高手,怎么用cook来传递值,谢谢。
- 再问datagrid中的分页问题-送100分呀
int m=cmd.ExecuteNonQuery();
{
OleDbConnection myConn = new OleDbConnection(myConnection);
OleDbDataAdapter myDataAdapter = new OleDbDataAdapter();
myDataAdapter.SelectCommand = new OleDbCommand(mySelectQuery, myConn);
OleDbCommandBuilder custCB = new OleDbCommandBuilder(myDataAdapter); myConn.Open(); DataSet custDS = new DataSet();
myDataAdapter.Fill(custDS); //code to modify data in dataset here myDataAdapter.Update(custDS, myTableName); myConn.Close(); return custDS;
}
int id = 20;
string desc = "myFirstRegion" ;
OleDbConnection rConn = new OleDbConnection("Provider=SQLOLEDB;Data Source=localhost;Integrated Security=SSPI;Initial Catalog=Northwind;");
rConn.Open();
OleDbCommand command = new OleDbCommand(null, rConn); // Using the NorthWind database ...
command.CommandText = "insert into Region (RegionID, RegionDescription) values (@id, @desc)" ;
command.Parameters.Add ( "@id", id) ;
command.Parameters.Add ( "@desc", desc) ;
command.Prepare() ; // Calling Prepare after having setup commandtext and params.
command.ExecuteNonQuery(); // Change param values and call execute. This time the prepared command will be executed.
command.Parameters[0].Value = 21;
command.Parameters[1].Value = "mySecondRegion";
command.ExecuteNonQuery();
}
只是在更新Access时会出问题,但读取Access中的数据时也不会出现任何问题
是不是哪一个配置有问题?