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)); }