private void buttonUpdate_Click(object sender, EventArgs e) { //Get the Data from textboxes m.ID = int.Parse(textBoxNID.Text); m.Room = comboBoxRoom.Text; m.Day = comboBoxDay.Text; m.Time = textBoxTime.Text; //Update Data in Databse bool success = m.Update(m); if (success == true) { //Updated successfully MessageBox.Show("Data Updated Successfully"); //Load Data on DataGridVeiw DataTable dt = m.Select(); dataGridView3.DataSource = dt; //Call the clear method Clear(); } else { //Failed to Update MessageBox.Show("Failed to update Try again...."); } }
public location location_update(int ID) { location = location.Select(ID); location.Location_ID = Convert.ToInt32(Update_Location_ID_txt.Text); location.type = Update_type_txt.Text; location.city = Update_city_txt.Text; location.state = Update_state_txt.Text; location.zip = Convert.ToInt32(Update_zip_txt.Text); location.county = Update_county_txt.Text; location.location_desc = Update_location_desc_txt.Text; location.n_long = Convert.ToDecimal(Update_n_long_txt.Text); location.s_long = Convert.ToDecimal(Update_s_long_txt.Text); location.e_long = Convert.ToDecimal(Update_e_long_txt.Text); location.w_long = Convert.ToDecimal(Update_w_long_txt.Text); location.n_lat = Convert.ToDecimal(Update_n_lat_txt.Text); location.s_lat = Convert.ToDecimal(Update_s_lat_txt.Text); location.e_lat = Convert.ToDecimal(Update_e_lat_txt.Text); location.w_lat = Convert.ToDecimal(Update_w_lat_txt.Text); location.Update(location); Insert_location_GridView.DataBind(); Update_location_GridView.DataBind(); Delete_location_GridView.DataBind(); return(location); }
public location location_update(int ID) { location = location.Select(ID); location.Location_ID = Convert.ToInt32(Update_Location_ID_txt.Text); location.type = Update_type_txt.Text; location.city = Update_city_txt.Text; location.state = Update_state_txt.Text; location.zip = Convert.ToInt32(Update_zip_txt.Text); location.county = Update_county_txt.Text; location.location_desc = Update_location_desc_txt.Text; location.n_long = Convert.ToDecimal(Update_n_long_txt.Text); location.s_long = Convert.ToDecimal(Update_s_long_txt.Text); location.e_long = Convert.ToDecimal(Update_e_long_txt.Text); location.w_long = Convert.ToDecimal(Update_w_long_txt.Text); location.n_lat = Convert.ToDecimal(Update_n_lat_txt.Text); location.s_lat = Convert.ToDecimal(Update_s_lat_txt.Text); location.e_lat = Convert.ToDecimal(Update_e_lat_txt.Text); location.w_lat = Convert.ToDecimal(Update_w_lat_txt.Text); location.Update(location); Insert_location_GridView.DataBind(); Update_location_GridView.DataBind(); Delete_location_GridView.DataBind(); return location; }