1. student表:存储学生信息. StudentID(pk)
2. Class表 课程信息. ClassId(pk)
3. SelectClass表: 选择课程 StudentID(fk) 存储所有选择的课程ClassId(fk)
很简单的吧,具体字段,用到哪些就给定哪些吧。
ASP和数据库连接要用到连接字符串:
你可以参考下面的网址
http://www.connectionstrings.com/oracle至于怎么连接,参考:
string ls_cnn =" Provider=sqloledb;Server="XXX";Database="Student";Uid=sa;Pwd="XX";";
System.Data.OleDb.OleDbConnection ls_c = new OleDbConnection(ls_cnn);
System.Data.OleDb.OleDbDataAdapter ldp_d = new OleDbDataAdapter( " SELECT * FROM Owner ",ls_c);
System.Data.OleDb.OleDbCommand lcm_cm = new OleDbCommand();
ls_c.Open();
// lcm_cm.Connection = ls_c;
// lcm_cm.CommandText = "Selcet * from Owner";
System.Data.DataSet lds_ds = new DataSet();
try
{
ldp_d.Fill(lds_ds,"dt_aa");
}
catch(Exception exe)
{
string aa= exe.Message;
Console.WriteLine(exe.Message);
}
DataTable dt_cnn = lds_ds.Tables["dt_aa"];
int li_num = dt_cnn.Rows.Count;
int li_clounm = dt_cnn.Columns.Count;
ls_c.Close();