protected void loadDropDownList()
{
UpdateDropDownList.DataSource = movieTable;
UpdateDropDownList.DataTextField = "MovieTitle";
UpdateDropDownList.DataValueField = "MovieID";
UpdateDropDownList.DataBind();
}
private void LoadCatagoryNameForUpdate()
{
string connStr = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
string sql = "SELECT * FROM Catagories";
SqlConnection con = new SqlConnection(connStr);
SqlCommand cmd = new SqlCommand(sql, con);
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
UpdateDropDownList.DataSource = reader;
UpdateDropDownList.DataTextField = "name";
UpdateDropDownList.DataValueField = "catagory_id";
UpdateDropDownList.DataBind();
con.Close();
}