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 = "Възникнала е грешка!"; } }