public void PopulateSubjects() { con.Open(); cmd = new SqlCommand("select subject,branch,semester,subid from subjects join branch on branch.branchid=subjects.branchid", con); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); con.Close(); SubjectGridView.DataSource = ds; SubjectGridView.DataBind(); }
protected void SubmitBtn_Click(object sender, EventArgs e) { using (SchoolDBContext db = new SchoolDBContext()) { if (byId_rdb.Checked) { try { int id = Int32.Parse(QueryBox.Text); Subject subject = db.Subjects.Find(id); DataTable dt = new DataTable(); dt.Clear(); dt.Columns.Add("ID"); dt.Columns.Add("Name"); DataRow dr = dt.NewRow(); dr[0] = subject.Id; dr[1] = subject.Name; dt.Rows.Add(dr); SubjectGridView.DataSource = dt; SubjectGridView.DataBind(); } catch (NullReferenceException) { lblExceptionsMsg.Text = "Invalid ID entered. Please re-enter a valid ID"; } catch (Exception ex) { lblExceptionsMsg.Text = "Unknown Error, Please re-submit your inquiry. Exception Message : " + ex.Message; } } else if (byName_rdb.Checked) { try { string name = QueryBox.Text; var subjectList = db.Subjects.Where(s => s.Name.Contains(name)).ToList(); DataTable dt = new DataTable(); dt.Clear(); dt.Columns.Add("ID"); dt.Columns.Add("Name"); foreach (Subject subject in subjectList) { DataRow dr = dt.NewRow(); dr[0] = subject.Id; dr[1] = subject.Name; dt.Rows.Add(dr); } SubjectGridView.DataSource = dt; SubjectGridView.DataBind(); } catch (NullReferenceException) { lblExceptionsMsg.Text = "Invalid Name entered. Please re-enter a valid Name"; } catch (Exception ex) { lblExceptionsMsg.Text = "Unknown Error, Please re-submit your inquiry. Exception Message : " + ex.Message; } } } }