protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string id = GridViewCourse.DataKeys[e.RowIndex].Value.ToString();
bool success = dao.DeleteBody(id, 4);
if (success)
{
Response.Write("<script>alert('删除成功！')</script>");
//刷新该页面
SqlConnection sqlConnection = SqlTools.Connection();
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter("select Course.id ,Course.Name as'coursename',Teacher.Name as'teachername',Course.Date,course.time,place,week,Score from Course left join Teacher on Course.Teacher=Teacher.id", sqlConnection);
DataSet dataSet = new DataSet();
GridViewCourse.DataKeyNames = new string[] { "id" };
sqlDataAdapter.Fill(dataSet);
GridViewCourse.DataSource = dataSet;
GridViewCourse.DataBind();
sqlConnection.Close();
}
else
{
Response.Write("<script>alert('删除失败！')</script>");
}
}
void FillGrid_CourseDetail()
{
if ((string)Session["AdminSessionID"] != null)
{
string xCode = Session["AdminSessionID"].ToString();
SqlDataAdapter GDA = new SqlDataAdapter(" " +
" select Code,CourseName,CourseDT=convert(varchar(11),CourseDate,105), CourseTime,Location, " +
" Price,CourseDescription,SpeakerName,SpeakerDetails, " +
" VideoURL1,VideoURL2 from fp_WorkShop where WSStatus='Y' " +
" ", Con);
DataSet GDS = new DataSet();
Con.Open();
GDA.Fill(GDS);
Con.Close();
GridViewCourse.DataSource = GDS;
GridViewCourse.DataBind();
}
else
{
Response.Redirect("SessionExpired.aspx");
}
}
protected void ShowData(string strFindCourse = "")
{
List <Course> Courses = _db.Courses.Include(c => c.Teacher).Where(s => s.NameOfCourse.Contains(strFindCourse)).ToList();
GridViewCourse.DataSource = Courses;
GridViewCourse.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection sqlConnection = SqlTools.Connection();
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter("select Course.id ,Course.Name as'coursename',Teacher.Name as'teachername',Course.Date,course.time,place,week,Score from Course left join Teacher on Course.Teacher=Teacher.id", sqlConnection);
DataSet dataSet = new DataSet();
GridViewCourse.DataKeyNames = new string[] { "id" };
sqlDataAdapter.Fill(dataSet);
GridViewCourse.DataSource = dataSet;
GridViewCourse.DataBind();
sqlConnection.Close();
}
protected void bindGrid()//method for binding gridview
{
ListToTable lsttodt = new ListToTable();
var lst = courseRepository.GetCourseList();
DataTable dt = lsttodt.ToDataTable(lst);
if (dt != null && dt.Rows.Count > 0)
{
GridViewCourse.DataSource = dt;
GridViewCourse.DataBind();
}
else
{
GridViewCourse.DataBind();
}
}
protected void bindData()
{
SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["Comp229Assign03ConnectionString"].ToString());
SqlCommand comm = new SqlCommand("SELECT * FROM Students", connection);
try
{
connection.Open();
SqlDataReader reader = comm.ExecuteReader();
GridViewCourse.DataSource = reader;
GridViewCourse.DataBind();
reader.Close();
}
finally
{
connection.Close();
}
}
