コード例 #1
0
        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();
        }
コード例 #2
0
        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();
        }
コード例 #3
0
        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();
        }
コード例 #4
0
 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();
 }
コード例 #5
0
        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();
        }