public void Update(DataTable dt)
{
if (!DBExist(databaseName))
{
CreateDatabase(databaseName);
}
ArrayList columns = new ArrayList();
foreach (DataColumn c in dt.Columns)
{
columns.Add(c.ColumnName);
}
string sql;
if (!TableExist(dt.TableName))
{
sql = GenerateSQL.CreateSqlTableScheamFromDataTable(dt.TableName, dt);
try
{
sqlConn.Open();
sqlCmd.CommandText = sql;
sqlCmd.CommandType = CommandType.Text;
sqlCmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally {
if (sqlConn.State == ConnectionState.Open)
{
sqlConn.Close();
}
}
}
sql = GenerateSQL.GenerateSqlInserts(columns, dt, dt.TableName);
try
{
sqlConn.Open();
sqlCmd.CommandText = sql;
sqlCmd.CommandType = CommandType.Text;
sqlCmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (sqlConn.State == ConnectionState.Open)
{
sqlConn.Close();
}
}
}
public int CreateTableSchema(string tableName, DataTable table)
{
string sql = GenerateSQL.CreateSqlTableScheamFromDataTable(tableName, table);
using (SqlCeConnection conn = new SqlCeConnection(_connecitonString))
{
conn.Open();
IDbCommand cmd = conn.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = sql;
//Console.WriteLine(sql);
return(cmd.ExecuteNonQuery());
}
}