ADO/ADO.NET - how to solve the warning Ms Acess database already exit in ado.net

Asked By Bhanuprakash T.R on 20-Jun-12 03:10 AM
Earn up to 30 extra points for answering this tough question.
Hello sir , i placed one button(Write Db). if i click write db means what are the data in sdf file is transform to mdf file. if i run first time means i can able to do it. if i again run means it shows an error the database already created. if the database is already is there means it will delete and created new one . if database is not there means it will create new one..please how can i implement if else condition please tell me

i try this code
 Directory.CreateDirectory("C:/StockManagement");
       ADOX.CatalogClass cat = new ADOX.CatalogClass();
        cat.Create("Provider=Microsoft.Jet.OLEDB.4.0;" +
        "Data Source=C:/StockManagement/StockManagement.mdb;" +
        "Jet OLEDB:Engine Type=5");
        MessageBox.Show("database created successfully");
        cat = null;
        MessageBox.Show(pra);
        SqlCeConnection con = new SqlCeConnection("Data Source=" + textbox1.text.toString+ "");
        SqlCeDataAdapter da = new SqlCeDataAdapter("select * from purchaseOrder", con);
        DataTable dt = new DataTable();
        da.Fill(dt);
        OleDbConnection con1 = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/StockManagement/StockManagement.mdb");
        con1.Open();
        OleDbCommand cmd = con1.CreateCommand();
        cmd.CommandText = "create table purchaseOrder(barcode varchar(150),Actualqty varchar(150),LocationID varchar(100))";
        cmd.ExecuteNonQuery();


        for (int i = 0; i < dt.Rows.Count; i++)
        {
          cmd.CommandText = "insert into purchaseOrder (barcode,Actualqty,LocationID) values('" + dt.Rows[i]["barcode"].ToString() + "','" + dt.Rows[i]["Actualqty"].ToString() + "','" + dt.Rows[i]["LocationID"].ToString() + "')";


          cmd.ExecuteNonQuery();

        } 

thanks
Bhanuprakash
[)ia6l0 iii replied to Bhanuprakash T.R on 20-Jun-12 12:51 PM
This should be easy with System.IO giving us the File class.  There is an Exists method that returns a boolean after checking if the file exists. Just provide a path, and it will do wonders for you. 

The code would be on following lines:
If File.Exists("C:/StockManagement/StockManagement.mdb") Then
 'Database already exists
ELSE
'Database does not exist.
End If


Do not forget to add "Imports System.File.IO" at the top of your class.

Good one :-; Thank you.
help
insert data or else update new data into same mdb file. Directory.CreateDirectory("C: / StockManagement"); ADOX.CatalogClass cat = new ADOX.CatalogClass(); cat.Create("Provider = Microsoft.Jet.OLEDB.4.0;" + "Data Source = C: / StockManagement / StockManagement.mdb;" + "Jet OLEDB:Engine Type = 5"); MessageBox.Show("database created successfully"); cat = null; MessageBox.Show(pra); SqlCeConnection con = new SqlCeConnection("Data Source = " + textbox1.toString + ""); SqlCeDataAdapter da = new SqlCeDataAdapter("select * from purchaseOrder", con); DataTable dt = new DataTable(); da.Fill(dt); OleDbConnection con1 = new OleDbConnection
please tell me the solution i try this code / / button click Directory.CreateDirectory("C: / StockManagement"); ADOX.CatalogClass cat = new ADOX.CatalogClass(); cat.Create("Provider = Microsoft.Jet.OLEDB.4.0;" + "Data Source = C: / StockManagement / StockManagement.mdb;" + "Jet Type = 5"); MessageBox.Show("database created successfully"); cat = null; if(cat.ex) MessageBox.Show(pra); SqlCeConnection con = new SqlCeConnection("Data Source = " + textbox1.text.toString + ""); SqlCeDataAdapter da = new SqlCeDataAdapter("select * from purchaseOrder", con); DataTable dt = new DataTable(); da.Fill(dt); OleDbConnection con1 = new OleDbConnection
StockManagement / StockManagement.mdb")) { } else{ MessageBox.Show("file was trying to create"); Directory.CreateDirectory("C: / StockManagement"); ADOX.CatalogClass cat = new ADOX.CatalogClass(); string createStr = "Provider = Microsoft.ACE.OLEDB.12.0;Data Source = C: / StockManagement / StockManagement.mdb;"; cat Create(createStr); MessageBox.Show("database created successfully"); cat = null; MessageBox.Show(pra); SqlCeConnection con = new SqlCeConnection("Data Source = " + pra + ""); SqlCeDataAdapter da = new SqlCeDataAdapter("select * from purchaseOrder", con); DataTable dt = new DataTable(); da.Fill(dt); OleDbConnection con1 = new OleDbConnection
ADOX.CatalogClass odxc = new ADOX.CatalogClass() ; System.Data.OleDb.OleDbConnection Omaincon = new System.Data.OleDb.OleDbConnection(); Omaincon.ConnectionString = "Provider = Microsoft.Jet link http: / / support.microsoft.com / kb / 317881 / EN-US / keywords: OleDbConnection, Data Source description: Catalogclass ADOX.CatalogClass odxc = new ADOX.CatalogClass() ; System.Data.OleDb.OleDbConnection Omaincon = new System.Data.OleDb.OleDbCo
C# .NET 28-Oct-12 07:44 PM HelloSir, i try this code using ADOX; ADOX.CatalogClass cat = new ADOX.CatalogClass(); cat.Create("Provider = Microsoft.Jet.OLEDB.4.0;" + "Data Source = C: / writemdb27jul / StockManagement.mdb;" + "Jet one there. . . if (!System.IO.Directory.Exists( "C: / writemdb27jul" )) { System.IO.Directory.CreateDirectory( "C: / writemdb27jul" ); } ADOX.CatalogClass cat = new ADOX.CatalogClass(); cat.Create( "Provider = Microsoft.Jet.OLEDB.4.0;" + "Data Source = C: / writemdb27jul / StockManagement.mdb;" + "Jet
i want to get the different tables in database using c#.net i am using ADOX.CatalogClass odxc = new ADOX.CatalogClass() ; odxc.ActiveConnection = oMainConn1 ; foreach(ADOX.Table tblName in odxc.Tables ) i get the tables but i want to get the different tables in database using c#.net i am using ADOX.CatalogClass odxc = new ADOX.CatalogClass() ;