Is it possible to write an SQL script (open + close connection, create statements, execute queries) and display the information on the screen instead of writing it to an excel report?
Need guidance on this matter.
Here is an example of what I'm doing.
SqlCeConnection conn = null;
try
{
conn = new SqlCeConnection("Data Source = Database.sdf; Password = ''");
conn.Open();
SqlCeCommand cmd = conn.CreateCommand();
cmd.CommandText = "INSERT INTO DataLogger1(Source_Address, SPN, FMI, Comments) values ('CDL', '23', '23', 'David');";
cmd.ExecuteNonQuery();
}
finally
{
conn.Close();
}
Thanks.
SqlServerCe
Re: SqlServerCe
Attached is an example project that connects to the internal database
This project was created in 2.40 SP3
This project was created in 2.40 SP3
- Attachments
-
- Date and Time Custom DataBase Viewer.zip
- (28.85 KiB) Downloaded 690 times
Best regards,
Russ
(801) 708-6690
Technical Support
Contact Us
Beijer Electronics AB
http://www.beijerelectronics.us
Russ
(801) 708-6690
Technical Support
Contact Us
Beijer Electronics AB
http://www.beijerelectronics.us