62,025
社区成员
发帖
与我相关
我的任务
分享
sql中@参数应用 /// <summary>
/// 增加一条数据
/// </summary>
public int Add(ICE.Model.TBL_VALET_REQEUST model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into TBL_VALET_REQEUST(");
strSql.Append("Order_ID,Ticket_No,Pick_Up_Time,Remark)");
strSql.Append(" values (");
strSql.Append("@Order_ID,@Ticket_No,@Pick_Up_Time,@Remark)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Order_ID", SqlDbType.VarChar,50),
new SqlParameter("@Ticket_No", SqlDbType.VarChar,50),
new SqlParameter("@Pick_Up_Time", SqlDbType.DateTime),
new SqlParameter("@Remark", SqlDbType.Text)};
parameters[0].Value = model.Order_ID;
parameters[1].Value = model.Ticket_No;
if (model.Pick_Up_Time.ToString() == "0001-1-1 0:00:00")
{
parameters[2].Value = System.DBNull.Value;
}
else
{
parameters[2].Value = model.Pick_Up_Time;
}
parameters[3].Value = model.Remark;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 1;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
下面是存储过程
SqlConnection myconnection = new SqlConnection(ConfigurationSettings.AppSettings[“MyConn"]);
myconnection.Open();//添加参数name
SqlCommand mycommand = new SqlCommand("checkmenber",myconnection);
mycommand.CommandType = CommandType.StoredProcedure;
SqlParameter ParameterName = new SqlParameter("@name",SqlDbType.Char);
ParameterName.Value = nametext.Text;
mycommand.Parameters.Add(ParameterName);
另一个例子
SqlCommand com = new SqlCommand("UserAddPro", con);
com.CommandType = CommandType.StoredProcedure;
SqlParameter pram1 = new SqlParameter("UserID", SqlDbType.BigInt);
SqlParameter pram2 = new SqlParameter("UserName", SqlDbType.NVarChar);
SqlParameter pram3 = new SqlParameter("UserPwd", SqlDbType.NVarChar);
SqlParameter pram4 = new SqlParameter("DptName", SqlDbType.NVarChar);
SqlParameter pram5 = new SqlParameter("PopeDom", SqlDbType.NVarChar);
pram1.Value = comboBoxAddID.Text;
pram2.Value = empNameStr;
pram3.Value = textBoxAddPwd1.Text;
pram4.Value = dptNameStr;
pram5.Value = comboBoxAddPope.Text;
com.Parameters.Add(pram1);
com.Parameters.Add(pram2);
com.Parameters.Add(pram3);
com.Parameters.Add(pram4);
com.Parameters.Add(pram5);
try
{
com.ExecuteNonQuery();
MessageBox.Show("添加成功");
this.userManageTableAdapter1.Fill(this.empInfManageDBDataSetUserManage.UserManage);
reader.Close();
con.Close();
}
catch
{
MessageBox.Show("添加失败");
reader.Close();
con.Close();
}