经过一番思量,感觉成绩存放采用动态创建表更合理。本来想着通过查询DB中现有表名来确定某专业成绩是否存在,后来决定重新建一个只有一个字段(专业名)的表来记录已经有哪些专业的成绩表存在。
using
System;
using System.Data;
using System.Data.OleDb;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
/**/ /// <summary>
/// Summary description for DbOperation
/// </summary>
public class DbOperation
... {
string Department;
double StuID;
string Course;
double Score;
public static string connString = ConfigurationManager.AppSettings["provider"].ToString()
+ HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["dbPath"])
+ ";";
public DbOperation()
...{
}
public DbOperation(string department,double stuID,string course,double score)
using System.Data;
using System.Data.OleDb;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
/**/ /// <summary>
/// Summary description for DbOperation
/// </summary>
public class DbOperation
... {
string Department;
double StuID;
string Course;
double Score;
public static string connString = ConfigurationManager.AppSettings["provider"].ToString()
+ HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["dbPath"])
+ ";";
public DbOperation()
...{
}
public DbOperation(string department,double stuID,string course,double score)