protected void Page_Load(object sender, EventArgs e)
        {
            Class1 loadData = new Class1();
            loadData.ReadData("select LargePhoto from Production.ProductPhoto where ProductPhotoID='69'");


            ListBox1.DataSource = loadData.sqlDataTable;
            
            ListBox1.DataTextField = "ProductPhotoID";
            ListBox1.DataBind();
            //DropDownList1.DataSource = loadData.sqlDataTable;
            //DropDownList1.DataTextField = "Name";
            ////DropDownList1.DataValueField = "";
            //DropDownList1.DataBind();
        }
 protected void Button3_Click(object sender, EventArgs e)
 {
     Class1 delete = new Class1();
     delete.InsertUpdateDelete("delete from Production.ProductCategory Where Name='"+DropDownList1.SelectedValue +"'");
 }
 protected void Button2_Click(object sender, EventArgs e)
 {
     Class1 saveData = new Class1();
     saveData.InsertUpdateDelete("insert into Production.ProductCategory(Name) values ('" + TextBox1.Text.ToString() + "')");
 }