110,571
社区成员
发帖
与我相关
我的任务
分享
SqlConnection myConn = new SqlConnection(ConDb.connStr);
SqlCommand cmd = new SqlCommand(strDlxx, myConn);
SqlParameter pstrpzhm = new SqlParameter("@strpzhm", SqlDbType.Char, 20);
pstrpzhm.Value = this.Cobpzhm.Text.Trim();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(pstrpzhm);
try
{
if (myConn.State == ConnectionState.Closed) myConn.Open();
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
//do something ex
}
finally
{
if (myConn.State == ConnectionState.Open) myConn.Close();
}
cmd.Parameters.AddWithValue("@strpzhm", this.Cobpzhm.Text.Trim());