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(); } }
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")); } }
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(); } }
/// <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()); } } }