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