实验04简单考试测试页面11.doc

实验04 简单考试页面 设计并实现一个用于单项选择题和多项选择题的测试页面 数据库表的定义如下 单选题表（question） 多选题表（questioncheck） 成绩表（score） 1.首先在web.config文件中添加数据库连接语句 connectionStrings add name=shiti providerName=System.Data.SqlClient connectionString=Data Source=.;Initial Catalog=shiti;Integrated Security=True;Pooling=False/ /connectionStrings 或者下面的连接语句 connectionStrings add name=shitiConnectionString connectionString=Data Source=.;Initial Catalog=shiti;User ID=sa;Pooling=False;Password=sa providerName=System.Data.SqlClient / /connectionStrings 2.公共数据连接类代码为： public class DataConn { public DataConn(){ } public static string strconn = ConfigurationManager.ConnectionStrings[shiticonn].ConnectionString; public static SqlConnection CreateConn() { SqlConnection conn = new SqlConnection(strconn); return conn; } public static SqlDataReader ExecuterRead(string cmdtext, SqlConnection conn) { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = cmdtext; SqlDataReader dr = cmd.ExecuteReader(); return dr; } public static SqlDataReader ExecuterRead(string cmdtext, SqlConnection conn, params SqlParameter[] array1) { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = cmdtext; foreach (SqlParameter para in array1) cmd.Parameters.Add(para); SqlDataReader dr = cmd.ExecuteReader(); return dr; } public static int ExecuteNonRead(string cmdtext) { SqlConnection conn = CreateConn(); conn.Open(); SqlCommand cmd = new SqlCommand(cmdtext, conn); int i = cmd.ExecuteNonQuery(); conn.Close(); return i; } public static int ExecuteNonRead(string cmdtext, params SqlParameter[] array) { SqlConnection conn = CreateConn(); conn.Open(); SqlCommand cmd = new SqlCommand(cmdtext, conn); foreach (SqlParameter para in array) cmd