27,579
社区成员
发帖
与我相关
我的任务
分享
conn.Open();
SqlCommand cmd1 = new SqlCommand("select count(*) from GLXT where BH = @BH", conn);
int count = Convert.ToInt32(cmd1.ExecuteScalar());
if (count == 0)
{
string sql = "insert into GLXT (BH,XB,NL) values (@BH,@XB,@NL)";
cmd = new SqlCommand(sql, conn);
}
else
{
string sql = "update GLXT set XB = @XB,NL = @NL where BH = @BH";
cmd = new SqlCommand(sql, conn);
}
SqlParameter[] parameters = new SqlParameter[3];
parameters[0] = new SqlParameter();
parameters[0].ParameterName = "@BH";
parameters[0].SqlDbType = SqlDbType.VarChar;
parameters[1] = new SqlParameter();
parameters[1].ParameterName = "@XB";
parameters[1].SqlDbType = SqlDbType.VarChar;
parameters[2] = new SqlParameter();
parameters[2].ParameterName = "@NL";
parameters[2].SqlDbType = SqlDbType.VarChar;
for (int i = 0; i < parameters.Length; i++)
{
cmd.Parameters.Add(parameters[i]);
}
if (count == 0)
{
string sql = "insert into GLXT (BH,XB,NL) values (@BH,@XB,@NL)";
cmd = new SqlCommand(sql, conn);
}
else
{
string sql = "update GLXT set XB = @XB,NL = @NL where BH = @BH";
cmd = new SqlCommand(sql, conn);
}
SqlCommand cmd1 = new SqlCommand("select count(*) from GLXT where BH = @BH", conn);
int count = Convert.ToInt32(cmd1.ExecuteScalar());