1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
| //connexion
connStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filename + ";Mode=ReadWrite";
oConn = new OleDbConnection(this.connStr);
oConn.Open();
//test si table existe
DataTable dt;
string table = "2004";
dt = oConn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables,new Object[] {null,null,null,"TABLE"});
bool bTableExist = true;
foreach(DataRow row in dt.Rows)
{
if (row.ItemArray[2].ToString() != table)
{
bTableExist = false;
}
}
bool ToReturn = true;
if (!bTableExist)
{
try
{
DataTable Source = new DataTable("ref");
DataTable cloneTable = new DataTable(table);
cloneTable = Source.Clone();
}
catch
{
ToReturn = false;
}
}
return ToReturn; |
Partager