手把手教你mvc导入excel(2)

public static partial class FooterDAL { /// <summary> /// 添加 /// </summary> /// <param></param> /// <param></param> /// <param></param> /// <param></param> /// <param></param> /// <returns></returns> public static int Addfoot(string categary, string fcategary, string fTitle, string fUrl) { string sql = string.Format("insert into Foot (categary,fcategary,fTitle,fUrl)values(@categary,@fcategary,@fTitle,@fUrl)"); SqlParameter[] parm = { new SqlParameter("@categary",categary) ,new SqlParameter("@fcategary",fcategary) ,new SqlParameter("@fTitle",fTitle) ,new SqlParameter("@fUrl",fUrl) }; return new DBHelperSQL<Foot>(CommonTool.dbname).ExcuteSql(sql,parm); } }

//FooterDAL将datatable,就是excel里面的数据添加到sql数据库