private void Class() { DDClass.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Select Class", "-1")); DDClass.AppendDataBoundItems = true; string constr = ConfigurationManager.ConnectionStrings["SMSConnectionString"].ConnectionString; string strQuery = "select Class from Class"; SqlConnection con = new SqlConnection(constr); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = strQuery; cmd.Connection = con; try { con.Open(); DDClass.DataSource = cmd.ExecuteReader(); DDClass.DataTextField = "Class"; DDClass.DataValueField = "Class"; DDClass.DataBind(); } catch (Exception ex) { throw ex; } finally { con.Close(); con.Dispose(); } }
/// <summary> /// Queries the database for the information needed to create a character, and displays /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { InitCreationData(); if (!IsPostBack) { DisplayRace(races[0]); DisplayClass(classes[0]); DisplayBackground(backgrounds[0]); DDRace.DataSource = races; DDRace.DataBind(); DDClass.DataSource = classes; DDClass.DataBind(); DDBackground.DataSource = backgrounds; DDBackground.DataBind(); RollStats(); } }