//Get the initial Select Box list of DVD names
protected void UISelectRepopulate()
{
SqlConnection conn;
SqlCommand comm;
SqlDataReader reader;
string connectionString = ConfigurationManager.ConnectionStrings["DVDconnstring"].ConnectionString;
conn = new SqlConnection(connectionString);
comm = new SqlCommand("SELECT DVDID, DVDtitle FROM DVDtable", conn);
try
{
conn.Open();
reader = comm.ExecuteReader();
DropDownListDVD.DataSource = reader;
DropDownListDVD.DataValueField = "DVDID";
DropDownListDVD.DataTextField = "DVDtitle";
DropDownListDVD.DataBind();
reader.Close();
dbErrorLabel.Text += "Select a DVD from the list to edit. ";
UIClearFields();
}
catch
{
dbErrorLabel.Text = "Error getting DVD list from database. Ensure SQL is properly connected";
}
finally
{
conn.Close();
}
}
private void LoadDVDList()
{
SqlConnection conn;
SqlCommand comm;
SqlDataReader reader;
string connectionString = ConfigurationManager.ConnectionStrings["DVDdbCS"].ConnectionString;
conn = new SqlConnection(connectionString);
comm = new SqlCommand("SELECT DVDID, DVDtitle FROM DVDtable ORDER BY DVDtitle", conn);
try
{
conn.Open();
reader = comm.ExecuteReader();
DropDownListDVD.DataSource = reader;
DropDownListDVD.DataValueField = "DVDID"; // note the binding here so we can use the ID
DropDownListDVD.DataTextField = "DVDtitle"; // but display the user friendly name
DropDownListDVD.DataBind();
reader.Close();
}
catch
{
LabelErrorMessage.Text = "Error loading the list of DVDs! <br />";
}
finally
{
conn.Close();
}
ButtonUpdateDVD.Enabled = false;
ButtonDeleteDVD.Enabled = false;
LabelErrorMessage.Text = "";
TextBoxDVDtitle.Text = "";
TextBoxDVDartist.Text = "";
TextBoxDVDrating.Text = "";
TextBoxDVDprice.Text = "";
}
