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