1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
| //Connection DataBase
String dataBasePath = Path.GetDirectoryName(Assembly.GetExecutingAssembly().GetName().CodeBase);
String conn = "Data Source=" + dataBasePath + "\\AppDatabase1.sdf";
SqlCeConnection connection = new SqlCeConnection(conn);
try
{
connection.Open();
String queryString = "INSERT INTO WorkoutType VALUES (1, 'test')";
SqlCeCommand command = new SqlCeCommand(queryString, connection);
command.ExecuteNonQuery();
}
catch (SqlException exception)
{
System.Console.WriteLine("Problem database connection");
}
finally
{
if (connection.State != ConnectionState.Closed)
{
connection.Close();
}
} |
Partager