protected void SubmitButton_Click(object sender, EventArgs e) { da = new SqlDataAdapter("insert into Hotel_Details(H_Type,H_Stars,H_Name,H_Country,Room_Category,H_City,Amount,Description)values('" + typeDropDownList.SelectedItem.Text + "','" + StarDropDownList.SelectedItem.Text + "','" + NameTextBox.Text + "','" + DropDownCountry.SelectedItem.Text + "','" + DropdownCategory.SelectedItem.Text + "','" + DropDownCity.SelectedItem.Text + "'," + AmtTextBox.Text + ",'" + DescTextBox.Text + "')", con); dt = new DataTable(); da.Fill(dt); cmtLabel.Text = "Data Submit"; typeDropDownList.ClearSelection(); StarDropDownList.ClearSelection(); NameTextBox.Text = ""; DropDownCountry.ClearSelection(); DropdownCategory.ClearSelection(); DropDownCity.ClearSelection(); AmtTextBox.Text = ""; DescTextBox.Text = ""; da = new SqlDataAdapter("select * from Hotel_Details order by H_Id desc", con); dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count > 0) { GridViewHotelDetails.DataSource = dt; GridViewHotelDetails.DataBind(); } else { GridViewHotelDetails.DataSource = ""; GridViewHotelDetails.DataBind(); } }
protected void SubmitButton_Click(object sender, EventArgs e) { da = new SqlDataAdapter("insert into [Homestay-Resort_Details](HR_Type,HR_Stars,HR_Category,HR_Name,HR_Country,HR_City,Amount,Description)values('" + DropDownListType.SelectedItem.Text + "','" + NameDropDownList.SelectedItem.Text + "','" + DropdownCategory.SelectedItem.Text + "','" + NameTextBox.Text + "','" + DropDownCountry.SelectedItem.Text + "','" + DropDownCity.SelectedItem.Text + "'," + TextBoxAmount.Text + ",'" + DescTextBox.Text + "')", con); dt = new DataTable(); da.Fill(dt); CmtLabel.Text = "Data Submit"; DropDownListType.ClearSelection(); NameDropDownList.ClearSelection(); DropdownCategory.ClearSelection(); NameTextBox.Text = ""; DropDownCountry.ClearSelection(); DropDownCity.ClearSelection(); TextBoxAmount.Text = ""; DescTextBox.Text = ""; CmtLabel.Text = "Data Submit"; da = new SqlDataAdapter("select * from [Homestay-Resort_Details] order by HR_ID desc", con); dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count > 0) { GridViewHomestayDetails.DataSource = dt; GridViewHomestayDetails.DataBind(); } else { GridViewHomestayDetails.DataSource = ""; GridViewHomestayDetails.DataBind(); } }
protected void SubmitButton_Click(object sender, EventArgs e) { da = new SqlDataAdapter("insert into Transport_Details(T_Type,T_category,T_Name,To_Country,To_City,From_Country,From_City,Date,Time,Amount,Description)values('" + typeDropDownList.SelectedItem.Text + "','" + DropdownCategory.SelectedItem.Text + "','" + NameTextBox.Text + "','" + DropDownToCountry.SelectedItem.Text + "','" + DropDownToCity.SelectedItem.Text + "','" + DropDownFromCountry.SelectedItem.Text + "','" + DropDownFromCity.SelectedItem.Text + "','" + TextBox1.Text + "','" + TimeTextBox.Text + "'," + AmtTextBox.Text + ",'" + DescTextBox.Text + "')", con); dt = new DataTable(); da.Fill(dt); Label2.Text = "Data Sumbmit"; TextBox1.Text = ""; DropdownCategory.ClearSelection(); DropDownToCountry.ClearSelection(); DropDownToCity.ClearSelection(); DropDownFromCountry.ClearSelection(); DropDownFromCity.ClearSelection(); NameTextBox.Text = ""; typeDropDownList.ClearSelection(); TimeTextBox.Text = ""; AmtTextBox.Text = ""; DescTextBox.Text = ""; da = new SqlDataAdapter("select T_Id,T_Type,T_Category,T_Name,To_Country,To_City,From_Country,From_City,convert(varchar,Date,106)Date,Time,Amount,Description from Transport_Details order by T_Id DESC", con); dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count > 0) { GridViewTransportDetails.DataSource = dt; GridViewTransportDetails.DataBind(); } else { GridViewTransportDetails.DataSource = ""; GridViewTransportDetails.DataBind(); } }
protected void SubmitButton_Click(object sender, EventArgs e) { da = new SqlDataAdapter("insert into Package_Details(P_Type,P_Category,Country,City,Days,Amount,Description)values('" + DropDownListType.SelectedItem.Text + "','" + DropdownCategory.SelectedItem.Text + "','" + DropDownCountry.SelectedItem.Text + "','" + DropDownCity.SelectedItem.Text + "','" + TextBoxDays.Text + "'," + TextBoxAmount.Text + ",'" + TextBoxDesc.Text + "')", con); dt = new DataTable(); da.Fill(dt); Label1.Text = "Data Submit Successfully"; DropDownCountry.ClearSelection(); DropDownCity.ClearSelection(); DropdownCategory.ClearSelection(); DropDownListType.ClearSelection(); TextBoxDays.Text = ""; TextBoxAmount.Text = ""; TextBoxDesc.Text = ""; da = new SqlDataAdapter("select * from Package_Details order by P_Id desc", con); dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count > 0) { GridViewPackageDetails.DataSource = dt; GridViewPackageDetails.DataBind(); } else { GridViewPackageDetails.DataSource = ""; GridViewPackageDetails.DataBind(); } }