/// <summary>
        /// 执行带参数组sql语句返回行数
        /// </summary>
        /// <param name="sql"></param>
        /// <param name="values"></param>
        /// <returns></returns>
        public static int ExecuteCommand(string sql,params OleDbParameter[] values )
        {
            OleDbCommand cmd = new OleDbCommand(sql,Connection);
            cmd.Parameters.AddRange(values);
            Connection.Close();
            return  cmd.ExecuteNonQuery();
        }
 /// <summary>
       /// 插入新闻
       /// </summary>
       /// <param name="news"></param>
       /// <returns></returns>
       public static int AddNews(News news)
       {
           string sql = "insert into News([title],[Author],[EditTime],[Hits],[IsPublic],[IsHome],[IsTop],[Content],[categoryID])" +
               "values"+
               "(@title,@Author,@EditTime,@Hits,@IsPublic,@IsHome,@IsTop,@Content,@categoryID)";
           OleDbParameter[] para = new OleDbParameter[]
           {
               new OleDbParameter("@title",news.Title),
               new OleDbParameter("@Author",news.Author),
               new OleDbParameter("@EditTime",news.EditTime),
               new OleDbParameter("@Hits",news.Hits),
               new OleDbParameter("@IsPublic",news.IsPublic),
               new OleDbParameter("@IsHome",news.IsHome),
               new OleDbParameter("@IsTop",news.IsTop),
               new OleDbParameter("@Content",news.Content),
               new OleDbParameter("@categoryID",news.CategoryID)
           };
           return DBHelper.ExecuteCommand(sql, para);
       }
每次插入多这样写sql 语句,  感觉有点累 有没有方法
能实现自动组装sql ??
 高手 来指导指导啊 

解决方案 »

  1.   

    这样就差不多了
    public static int ExecuteCommand(string sql,params OleDbParameter[] values ) 
            { 
                OleDbCommand cmd = new OleDbCommand(sql,Connection); 
                cmd.Parameters.AddRange(values); 
                Connection.Close();   ?? 关闭? 
                return  cmd.ExecuteNonQuery(); 
            } 
      

  2.   

    SQLHelper呀,你把得到参数的方法封装起来。
      

  3.   

    我这个资源里有一个,学习使用DAL呀。
    http://download.csdn.net/source/871334
      

  4.   

    有办法,用企业库吧,只要根据数据库表生产实体就ok了,企业库可根据实体拼凑sql语句!!!