How to create an exist database [modified]

[yueru]

If I has database but in sqlite command can't write into exists dataase

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

how to command that write whatever database is exist !!! I 've already use command but it's not work

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();

modified on Thursday, May 14, 2009 11:03 PM