delete query on access database c#

Question

I am creating an application with MS Access as back-end. I am running delete query but it is not working Code:

conchek.ConnectionString = ConfigurationManager.ConnectionStrings["KedarnathDB"].ConnectionString;
conchek.Open();
OleDbCommand cmdc = new OleDbCommand("select * from ReceiptsTrns Where ID=@CallerName", conchek);
cmdc.Parameters.Add("@CallerName", OleDbType.Numeric).Value = txtRcptNo.Text.Trim();
OleDbDataReader rd = cmdc.ExecuteReader();

if (rd.HasRows)
{
 conchek.Close();
 con1.ConnectionString = ConfigurationManager.ConnectionStrings["KedarnathDB"].ConnectionString;
 con1.Open();
 OleDbCommand cmd = new OleDbCommand("DELETE from ReceiptsTrns Where ID=@RCName", con1);
 cmd.Parameters.Add("@RCName", OleDbType.Numeric).Value = txtRcptNo.Text.Trim();
 con1.Close();
 MessageBox.Show("Receipt deleted successfully");
}

else
{
 conchek.Close();
 MessageBox.Show("No receipt found with this number");
}

the code is running successfully but it is not reflecting the change when I see my MS Access database.

Please consider using something more robust than Access. The Access database engine is terrible compared to SQL Server Compact or Express. — Daniel Mann
– Daniel Mann, Commented Aug 27, 2013 at 16:22

nvoigt · Accepted Answer · 2013-06-11 06:11:49Z

2

You are missing an Execute call on your cmd. You create it and then close the connection, the database never gets to run the statement.

answered Jun 11, 2013 at 6:11

nvoigt

77.8k28 gold badges103 silver badges156 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Hanumendra Over a year ago

I tried this cmd.ExecuteNonQuery(); but it is still not showing up the change in Database

nvoigt Over a year ago

Did you check the return value (rows affected) and did it return 1?

Hanumendra Over a year ago

I did not get you, from where do I check this?

nvoigt Over a year ago

The ExecuteNonQuery() method returns a value. An Int32. That's the number of records affected on the database. As you want to delete a single record, it should return 1, if it doesn't, the statement did not do what you expected it to do.

indiPy · Accepted Answer · 2013-06-11 06:12:50Z

0

con1.ConnectionString =   ConfigurationManager.ConnectionStrings["KedarnathDB"].ConnectionString;

con1.Open();

OleDbCommand cmd = new OleDbCommand("DELETE from ReceiptsTrns Where ID=@RCName", con1);
cmd.Parameters.Add("@RCName", OleDbType.Numeric).Value = txtRcptNo.Text.Trim();
**cmd.ExecuteNoQuery();**
con1.Close();

answered Jun 11, 2013 at 6:12

indiPy

8,1223 gold badges31 silver badges39 bronze badges

3 Comments

Hanumendra Over a year ago

I did it but it is still not showing up the change in the database

indiPy Over a year ago

does @RCName has numeric/valid value?

Hanumendra Over a year ago

Yes! because it is working fine for the if condition, I have used the same column for it.

Mr.X · Accepted Answer · 2013-08-27 15:58:25Z

0

I followed these steps for same issue:

1) Open your access database,

2) Click windows icon in the top ribbon,

3) Click Access options,

4) Click trust center settings,

5) Click Show the Message Bar in all applications when content has been blocked

6) Close database and reopen it again,

Access will show you a warning "Certain content in the database has been disabled"

7) Click options,

8) Click enable this content.

Your database is ready to be manipulated...

answered Aug 27, 2013 at 15:58

Mr.X

31.7k27 gold badges150 silver badges231 bronze badges

Collectives™ on Stack Overflow

delete query on access database c#

3 Answers 3

4 Comments

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related