SqlParameter 2

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54

SqlParameter string strSql = "Insert into News(TypeId,NewsCaption,NewsContent) values(@TypeId,@NewsCaption,@NewsContent)";    SqlParameter[] paras ={     new SqlParameter("@TypeId",SqlDbType.Int),     new SqlParameter("@NewsCaption",SqlDbType.NVarChar,200),     new SqlParameter("@NewsContent",SqlDbType.NText)    };    paras[0].Value = typeId;    paras[1].Value = caption;    paras[2].Value = content;      int rows = new SqlHelp().ExecuteNonQuery(strSql, paras);             public SqlHelp() {       connString = ConfigurationManager.AppSettings["sqlServer2005DbName"];    }        public int ExecuteNonQuery(string strQuery, SqlParameter[] paras) {   int rows = 0; //影响行数   try {    using (SqlConnection conn = new SqlConnection(connString)) {     using (SqlCommand command = new SqlCommand()) {      PrepareCommand(conn, command, strQuery, paras);      rows = command.ExecuteNonQuery();      return rows;     }    }   } catch {    throw;   }  }        //带参数的DML操作  private void PrepareCommand(SqlConnection conn, SqlCommand command, string strQuery, SqlParameter[] paras) {   if (conn.State != ConnectionState.Open) {    conn.Open();   }   command.Connection = conn;   command.CommandText = strQuery;   command.CommandType = CommandType.Text;   if (paras != null) {    foreach (SqlParameter parm in paras)     command.Parameters.Add(parm);   }  }