Ejemplo n.º 1
0
        protected void Page_Load(object sender, EventArgs e)
        {
            connection = new SqlConnection(System.Configuration.ConfigurationManager.
                                           ConnectionStrings["ConnectionIndividuals"].ConnectionString);
            connection.Open();


            if (!IsPostBack)
            {
                //set hidden customer details
                MainDetails.Visible = false;
                ConfirmData.Visible = false;
                //set false afteradd
                afterAdd = false;
                RefillCheckBox();
                //fill listbox
                ArrayList Genders = new ArrayList();

                Genders.Add("Female");
                Genders.Add("Male");
                Genders.Add("Other");

                Gender.DataSource = Genders;
                Gender.DataBind();
            }
        }
Ejemplo n.º 2
0
    private void bindGender()
    {
        SqlCommand cmd = new SqlCommand("sp_gender1", con);

        cmd.CommandType = CommandType.StoredProcedure;

        SqlDataAdapter adp = new SqlDataAdapter(cmd);
        DataTable      dt  = new DataTable();

        adp.Fill(dt);
        if (dt.Rows.Count != 0)
        {
            Gender.DataSource     = dt;
            Gender.DataTextField  = "GenderName";
            Gender.DataValueField = "GenderId";
            Gender.DataBind();
            Gender.Items.Insert(0, new ListItem("-Select-", "0"));
        }
    }
Ejemplo n.º 3
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            Gender.DataSource     = da.displaygender();
            Gender.DataTextField  = "Gender";
            Gender.DataValueField = "GenderID";
            Gender.DataBind();


            EmployeeType.DataSource     = da.displayEmployeeType();
            EmployeeType.DataTextField  = "EmployeeType";
            EmployeeType.DataValueField = "EmployeeTypeID";
            EmployeeType.DataBind();


            GridView1.DataSource = da.displayAllEmployees();
            GridView1.DataBind();
        }
    }
Ejemplo n.º 4
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                Gender.Items.Add("Male");
                Gender.Items.Add("Female");
                Gender.DataBind();

                for (int i = 1; i < 32; i++)
                {
                    Day.Items.Add(i.ToString());
                }
                for (int j = 1; j < 13; j++)
                {
                    Month.Items.Add(j.ToString());
                }
                for (int k = 1930; k < DateTime.Today.Year; k++)
                {
                    Year.Items.Add(k.ToString());
                }
            }
        }