try
                {
                    conn.Open();


                    FbDataAdapter yourTableAdapter = new FbDataAdapter();
                    DataSet dataset = new DataSet();
                    dataset.DataSetName = "Dataset1";
                 
            
                 
                    Nomer_su_drpd.DataSource =  dataset;
                    Nomer_su_drpd.DataTextField = dataset.Tables["EMPLOYEES"].Columns["NAME"].ToString();
                    Nomer_su_drpd.DataValueField = dataset.Tables["EMPLOYEES"].Columns["ID"].ToString();
                    Nomer_su_drpd.DataBind();



                }
                catch (FbException ex)
                {
                    Response.Write(ex.Message);
                }
                finally
                {
                    conn.Close();
                }