private void ShowDropdown()
{
DataSet dt = new DataSet();
ddlSubject.Items.Clear();
SqlConnection Con = new SqlConnection(ConnectionString);
SqlCommand cmd = new SqlCommand();
cmd.Connection = Con;
cmd.CommandText = "select * from Subject";
Con.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
ListItem li = new ListItem();
li.Text = dr["SubjectName"].ToString();
li.Value = dr["Subject_ID"].ToString();
ddlSubject.Items.Add(li);
}
Con.Close();
SqlDataAdapter dta = new SqlDataAdapter("select * from Subject order by Subject_ID DESC ", Con);
dta.Fill(dt);
GridViewSubject.DataSource = dt;
GridViewSubject.DataBind();
}
protected void ButtonSave_Click(object sender, EventArgs e)
{
try
{
eRegisterData.DAL oDal = new eRegisterData.DAL();
oDal.insertNewSubject(TextBoxSubject.Text);
LabelMessage.Text = "Успешно въвеждане!";
GridViewSubject.DataBind();
}
catch (Exception ex) { LabelMessage.Text = "Възникнала е грешка!"; }
}
