protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
SqlDataSourceMis.SelectCommand = "SELECT [Grade] FROM [CoursesTaken] WHERE [StudentID] = '" + StudentID + "' AND CourseID = '" + DropDownList1.SelectedValue + "'";
DataView dv = (DataView)SqlDataSourceMis.Select(DataSourceSelectArguments.Empty);
TextBox2.Text = (String)dv.Table.Rows[0].ItemArray[0];
}
protected void Button1_Click1(object sender, EventArgs e)
{
SqlDataSourceMis.InsertCommand = "INSERT INTO CoursesTaken (Grade, CourseID, StudentID) VALUES ('" + TextBox1.Text + "', '" + DropDownList2.SelectedValue + "' , '" + StudentID + "')";
SqlDataSourceMis.Insert();
Response.Redirect(Request.Url.AbsoluteUri);
}
protected void Button3_Click(object sender, EventArgs e)
{
SqlDataSourceMis.DeleteCommand = "DELETE FROM CoursesTaken WHERE CourseID = '" + DropDownList1.SelectedValue + "' AND StudentID = '" + StudentID + "'";
SqlDataSourceMis.Delete();
Response.Redirect(Request.Url.AbsoluteUri);
}
protected void Button2_Click(object sender, EventArgs e)
{
SqlDataSourceMis.UpdateCommand = "UPDATE CoursesTaken SET Grade = '" + TextBox2.Text + "' WHERE CourseID = '" + DropDownList1.SelectedValue + "' AND StudentID = '" + StudentID + "'";
SqlDataSourceMis.Update();
Response.Redirect(Request.Url.AbsoluteUri);
}
