Database

<br />
<br />
SELECT Contacts.CompanyName<br />
FROM MarkSandpit.dbo.Contacts<br />
INNER JOIN<br />
MarkSandpit.dbo.Associations_Companies_to_Contacts<br />
ON Contacts.mxContactID = Associations_Companies_to_Contacts.mxContactID<br />
INNER JOIN mxContact.dbo.Companies<br />
ON Associations_Companies_to_Contacts.mxCompanyID = Companies.mxCompanyID<br />
<br />

sql_con = new SQLiteConnection("Data Source=database.db;Version=3;New=True;Compress=True;");

if (File.Exists("" + info + ".db"))
           {
               sql_con = new SQLiteConnection("Data Source= " + info + ".db;Version=3;New=False;Compress=True;");
               sql_con.Open();
               sql_cmd = sql_con.CreateCommand();
               sql_cmd.CommandText = "drop table par ;";
               sql_cmd.ExecuteNonQuery();
           }
           else
           {
               sql_con = new SQLiteConnection("Data Source= " + info + ".db;Version=3;New=True;Compress=True;");

           }

          //  FileStream fileStream = new FileStream(@" " + info + ".db", FileMode.Create);


           sql_con.Open();
           sql_cmd = sql_con.CreateCommand();
           sql_cmd.CommandText = "create table par (Date nvarchar(20), Time nvarchar(10), Linein NVARCHAR(20), Lineout NVARCHAR(20), Number NVARCHAR(20), Status nvarchar(10),Duration int(20), Cost nvarchar(20), Detail nvarchar(10), Network nvarchar(10));";
           sql_cmd.ExecuteNonQuery();