dimanche 10 mai 2015

devexpress gridview embedded button not working?

Hello Dear Developers i had a problem with my code. using embedded remove button its supposed to be remove my database row but its not working here's my code Well The Problem is my GridView cant delete any row, Here's My code PS Sorry for bad language

    private void CheckDeleteButton(object sender, NavigatorButtonClickEventArgs e)
    {


        if (e.Button.ButtonType == NavigatorButtonType.Remove)
        {
            e.Handled = !(XtraMessageBox.Show(this, "Та энэ мэдээллийг устгахдаа итгэлтэй байна уу.", "Анхаар", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes);

        }
    }
    void RowDeletingDts(object sender, DataRowChangeEventArgs e)
    {
        if (this._ID == "") return;
        DataTable dt = (sender as DataTable);

        string[] args = dt.TableName.Split(':');
        string tablename = args[0];
        string key1 = args[1], key2;
        if (args.Length > 2)
            key2 = args[2];

        if (e.Row[key1].ToString() == "") return;
        sqlCom = dbcs.CreateCommand();
        String FamilyQuery = "";

        FamilyQuery = "DELETE FROM " + tablename + " WHERE " + key1 + " = '" + int.Parse(e.Row[key1].ToString()) + "'";

        sqlCom.CommandText = FamilyQuery;
        sqlCom.CommandType = CommandType.Text;
        dbcs.Open();
        sqlCom.ExecuteNonQuery();
        dbcs.Close();

    } 

Aucun commentaire:

Enregistrer un commentaire