给你参考一下!
OleDbCommand insertCom=new OleDbCommand();
insertCom.CommandText="insert into insurance(name,specify,yearnumber,typeworkid,sumorwin) values(?,?,?,?,?) ";
insertCom.Parameters.Add(new OleDbParameter("@name",OleDbType.VarChar,100,"name"));
insertCom.Parameters.Add(new OleDbParameter("@specify",OleDbType.VarChar,100,"specify"));
insertCom.Parameters.Add(new OleDbParameter("@yearnumber",OleDbType.Integer,100,"yearnumber"));
insertCom.Parameters.Add(new OleDbParameter("@typeworkid",OleDbType.VarChar,50,"typeworkid"));
insertCom.Parameters.Add(new OleDbParameter("@sumorwin",OleDbType.VarChar,10,"sumorwin"));
insertCom.Parameters[0].Value=txtBox1.Text.Trim();
insertCom.Parameters[1].Value=txtBox2.Text.Trim();
insertCom.Parameters[2].Value=int.Parse(txtBox3.Text.Trim());
insertCom.Parameters[3].Value=typeworkid;
insertCom.Parameters[4].Value=cmBox2.Text;
insertCom.Connection=oleCon;
if(oleCon.State==System.Data.ConnectionState.Closed)
{
oleCon.Open();
}
insertCom.ExecuteNonQuery();
OleDbCommand insertCom=new OleDbCommand();
insertCom.CommandText="insert into insurance(name,specify,yearnumber,typeworkid,sumorwin) values(?,?,?,?,?) ";
insertCom.Parameters.Add(new OleDbParameter("@name",OleDbType.VarChar,100,"name"));
insertCom.Parameters.Add(new OleDbParameter("@specify",OleDbType.VarChar,100,"specify"));
insertCom.Parameters.Add(new OleDbParameter("@yearnumber",OleDbType.Integer,100,"yearnumber"));
insertCom.Parameters.Add(new OleDbParameter("@typeworkid",OleDbType.VarChar,50,"typeworkid"));
insertCom.Parameters.Add(new OleDbParameter("@sumorwin",OleDbType.VarChar,10,"sumorwin"));
insertCom.Parameters[0].Value=txtBox1.Text.Trim();
insertCom.Parameters[1].Value=txtBox2.Text.Trim();
insertCom.Parameters[2].Value=int.Parse(txtBox3.Text.Trim());
insertCom.Parameters[3].Value=typeworkid;
insertCom.Parameters[4].Value=cmBox2.Text;
insertCom.Connection=oleCon;
if(oleCon.State==System.Data.ConnectionState.Closed)
{
oleCon.Open();
}
insertCom.ExecuteNonQuery();
解决方案 »
- 如何在office2010中隐藏菜单栏
- 请教高手:在ASP.NET如何制作一个浮动的层,无论是缩放窗口还是拉动滚动条,这个层总是在左边中间位置?
- =====二天了没有搞定MySQL中文乱码问题。=====
- Javascript动态生成的TextBox,在C#中怎么能取到值,忘高手指教!
- 我用DevExpress.XtraReports生成一个报表,里面含有图像,转成Excel文档后,为什么看不见图像呢?
- C#如何索引私有成员变量
- 咨询一个关于TSQL里面DISTINCT的问题
- 关于 XML - DOM 的问题 , 在线等待 (QQ: 9531511) , 100 分
- 我是新人,求解答!谢了
- 请问怎样将一个DataSet的内容写进一个Excel文件,最好能给出代码
- [WinForm]有没有直接的方法画出Button的样子?
- 为什么我的水晶报表在vb.net下面能用,在c#下面不能用
objConn=new OleDbConnection(Constant.strConn);
objCmd = new OleDbCommand(sql, objConn);
SqlParameter pid = new SqlParameter("@id",SqlDbType.VarChar);
pid.value = TextBoxName.Text;
objCmd.Parameter.Add(pid);try //扑捉异常错误
{
objConn.Open();
objReader = objCmd.ExecuteReader();
while (objReader.Read())
{
strname=objReader["id"].ToString();
strpwd=objReader["pwd"].ToString();
}
objReader.Close(); } catch
{
Response.Write ("<script defer>alert(\"数据库错误! \");</script>");
return;
} finally
{ objConn.Close();
}