110,557
社区成员
发帖
与我相关
我的任务
分享
public static int ExecuteSql(string SQLString, params SqlParameter[] cmdParms)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
try
{
PrepareCommand(cmd, connection, null, SQLString, cmdParms);
int rows = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
return rows;
}
catch (System.Data.SqlClient.SqlException e)
{
throw e;
}
}
}
}
public static int Question_Add(int a)
{
string sql ="select * from a where a=@a";
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@a", a),
};
try
{
int retVal = ExecuteSql(sql,para);
}
catch { }
return retVal;
}