protected void Grd_State_RowEditing(object sender, GridViewEditEventArgs e) { Grd_State.EditIndex = e.NewEditIndex; getcon(); string str = "select state_name,state_id from tbl_state where country_id='" + DropDown_CountryState.SelectedItem.Value + "'"; SqlCommand cmd = new SqlCommand(str, con); SqlDataAdapter ad1 = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); ad1.Fill(dt); if (dt.Rows.Count > 0) { Grd_State.DataSource = dt; Grd_State.DataBind(); } con.Close(); }
protected void Grd_State_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) { getcon(); Grd_State.EditIndex = -1; string str1 = "select state_name,state_id from tbl_state"; SqlCommand cmd1 = new SqlCommand(str1, con); SqlDataAdapter ad1 = new SqlDataAdapter(cmd1); DataTable dt1 = new DataTable(); ad1.Fill(dt1); if (dt1.Rows.Count > 0) { Grd_State.DataSource = dt1; Grd_State.DataBind(); } con.Close(); }
protected void Grd_State_RowDeleting(object sender, GridViewDeleteEventArgs e) { getcon(); string dk = Grd_State.DataKeys[e.RowIndex].Values[0].ToString(); string str = "delete from tbl_state where state_id='" + dk + "'"; SqlCommand cmd = new SqlCommand(str, con); cmd.ExecuteNonQuery(); string str1 = "select state_name,state_id from tbl_state where country_id='" + DropDown_CountryState.SelectedItem.Value + "'"; SqlCommand cmd1 = new SqlCommand(str1, con); SqlDataAdapter ad = new SqlDataAdapter(cmd1); DataTable dt1 = new DataTable(); ad.Fill(dt1); if (dt1.Rows.Count > 0) { Grd_State.DataSource = dt1; Grd_State.DataBind(); } con.Close(); }
protected void Btn_ViewState_Click(object sender, EventArgs e) { getcon(); if (DropDown_CountryState.SelectedIndex > 0) { Label1.Visible = false; string str1 = "select state_name,state_id from tbl_state where country_id='" + DropDown_CountryState.SelectedItem.Value + "'"; SqlCommand cmd1 = new SqlCommand(str1, con); SqlDataAdapter ad1 = new SqlDataAdapter(cmd1); DataTable dt1 = new DataTable(); ad1.Fill(dt1); if (dt1.Rows.Count > 0) { Grd_State.DataSource = dt1; Grd_State.DataBind(); } } else { Label1.Visible = true; } con.Close(); }
protected void Grd_State_RowUpdating(object sender, GridViewUpdateEventArgs e) { getcon(); string dk = Grd_State.DataKeys[e.RowIndex].Values[0].ToString(); string cname = ((TextBox)Grd_State.Rows[e.RowIndex].Cells[0].Controls[0]).Text; string str = "update tbl_state set state_name='" + cname + "'where state_id='" + dk + "'"; SqlCommand cmd = new SqlCommand(str, con); cmd.ExecuteNonQuery(); Grd_State.EditIndex = -1; string str1 = "select state_name,state_id from tbl_state where country_id='" + DropDown_CountryState.SelectedItem.Value + "'"; SqlCommand cmd1 = new SqlCommand(str1, con); SqlDataAdapter ad1 = new SqlDataAdapter(cmd1); DataTable dt1 = new DataTable(); ad1.Fill(dt1); if (dt1.Rows.Count > 0) { Grd_State.DataSource = dt1; Grd_State.DataBind(); } con.Close(); }