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