public int Insert(KaoJuan kaojuan)
{
string sql = "insert into KaoJuan values(@KaoJuanName,@PageFen,@CourseName,@CourseID)";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@KaoJuanName", kaojuan.KaoJuanName),
new SqlParameter("@PageFen", kaojuan.PageFen),
new SqlParameter("@CourseName", kaojuan.CourseName),
new SqlParameter("@CourseID", kaojuan.CourseID)
};
return(DBHelper.GetExcuteNonQuery(sql, sp));
}
protected void Button2_Click(object sender, EventArgs e)
{
KaoJuan kj = new KaoJuan();
kj.KaoJuanName = TextBox4.Text.Trim();
kj.PageFen = int.Parse(TextBox5.Text.Trim());
kj.CourseName = ddlCourse.SelectedItem.Text.Trim();
kj.CourseID = int.Parse(ddlCourse.SelectedValue);
KaoJuanService.Insert(kj);
SqlDataReader dr;
//单选题
dr = DBHelper.GetDataReader("select top " + TextBox1.Text + " * from ObQuestion where CourseID='" + ddlCourse.SelectedValue + "' order by newid()");
GridView1.DataSource = dr;
GridView1.DataBind();
}
public static int Insert(KaoJuan kaojuan)
{
return(ikaojuan.Insert(kaojuan));
}
