how to delete mdb file data using c# code not fix file

Question

2.20/5 (3 votes)

See more:

i have one mdb file select with data suppose sa14.mdb i want same mdb file with rename sa15.mdb but only tabale structure i dint want data in sa15 how it is posibale using c# windowformapplication code is not fixed type in sa14.mdb i select any mdb

Posted 8-May-14 2:18am

sandipthummar

Updated 8-May-14 2:46am

v2

Add a Solution

Comments

José Amílcar Casimiro 8-May-14 8:20am

What?

[no name] 8-May-14 8:21am

If you think that is an understandable question, then you are mistaken. Have you tried File.Delete?

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Volynsky Alex · Accepted Answer · 2014-05-08T02:47:00

Solution 1

Hi sandipthummar313
Try use following code:

C#

string pathToFile = Server.MapPath("~/path_to_your_file/your_file.mdb");
if (System.IO.File.Exists(pathToFile))
{
  System.IO.File.Delete(pathToFile);
}

Posted 8-May-14 2:47am

Volynsky Alex

Comments

[no name] 8-May-14 9:23am

this is nice solution. But user asking about window application where Server.MapPath will not work. For this you to use System.Environment.

OriginalGriff · Accepted Answer · 2014-05-08T02:54:00

Solution 3

Get all the non-system table names:

SQL

SELECT MSysObjects.Name AS table_name FROM MSysObjects

Then loop through each table, removing all the rows:

SQL

DELETE * FROM MyTable

will do it.
The file will probably benefit from compacting afterwards.

Posted 8-May-14 2:54am

OriginalGriff

sandipthummar · Accepted Answer · 2014-05-08T02:51:00

Solution 2

i din't want file delete sir i want database table data delete any data i select

Posted 8-May-14 2:51am

sandipthummar