?using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using SMS;

public partial class add_grid_class : System.Web.UI.Page
{
    OPDataBase op = new OPDataBase();
    protected void Page_Load(object sender, EventArgs e)
    {
        string sql = "select Desn ,DepartmentID from Department";

        SqlDataReader dr;
        dr = op.getDataReader(sql);
        if (!IsPostBack)
        {
            while (dr.Read())
            {
                DropDownList1.Items.Add(new ListItem(dr["Desn"].ToString(), dr["DepartmentID"].ToString()));

            }
            DropDownList1.SelectedIndex = 0;
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string sql = "insert into Grade(Desn,DepartmentID,YearDate,Semester )values( '"+DropDownList2 .SelectedValue .ToString ()+"','"+
            DropDownList1 .SelectedValue .ToString ()+"','"+
            RadioButtonList1 .SelectedValue .ToString ()+"','"+
       RadioButtonList2 .SelectedValue .ToString ()+"')";
       
         op.BindCommand(sql, Label1);
        
  
       
       

    }
   
}