//Book Room
protected void sendBtn_Click(object sender, EventArgs e)
{
db.change("INSERT INTO BookRoom (name,fullname,email,phone,indate,outdate,intime,outtime,room_no) values('" + txtname.Text + "' , '" + txtlastName.Text + "','" + textmail.Text + "','" + txtphone.Text + "', '" + indate.Text + "', '" + outdate.Text + "', '" + DropDownroomtype.Text + "', '" + noofromm.Text + "','" + DropDownList1.SelectedItem + "')");
Response.Write("<script>alert('book Successfully ')</script>");
string room = "update room set isAvailble = '1' where roomno = '" + DropDownList1.SelectedItem + "'";
db.change(room);
bindlst();
}
protected void Button1_Click(object sender, EventArgs e)
{
db.change("update About set main_title = '" + mainTitle.Text + "', main_description = '" + maindescription.Text + "', title1 = '" + title1.Text + "', description1 = '" + description1.Text + "', title2 = '" + title2.Text + "', description2 = '" + description2.Text + "', title3 ='" + title3.Text.ToString().Replace("'", "''") + "', description3 ='" + description3.Text + "', title4 = '" + title4.Text + "', description4 = '" + description4.Text + "', title5 = '" + title5.Text + "', description5 = '" + description5.Text + "', title6 = '" + title6.Text + "', description6 = '" + description6.Text + "', images = '" + FileUpload11.FileName + "'");
}
