æ°æ®åºè¿æ¥å§ï¼æç»åä¸æ®µlè¿æ¥SQLserver代ç ï¼
public static int ExecuteNonQuery(string connectionString, CommandType cmdType, string cmdText, params SqlParameter[] commandParameters) {
SqlCommand cmd = new SqlCommand();
using (SqlConnection conn = new SqlConnection(connectionString)) {
PrepareCommand(cmd, conn, null, cmdType, cmdText, commandParameters);
int val = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
return val;
}
}
SqlParameter[] sp = new SqlParameter[]{
new SqlParameter("@userid",bc.UserID),
new SqlParameter("@name",bc.Name),
new SqlParameter("@text",bc.Text),
new SqlParameter("@sort",bc.Sort)
};
string sql = "insert bg_class(userid,name,text,sort) values(@userid,@name,@text,@sort)";
return SqlHelper.ExecuteNonQuery(Connection.GetConnection(), CommandType.Text, sql,
sp);
追é®åªæ¹æ°æ®åºè¿æ¥ä»£ç åï¼ç¨åºç代ç ä¸åä¿®æ¹åï¼
追çåºè¯¥ä¸éè¦ï¼æ没æä¹ç¨è¿Accessæ°æ®åº