WPF 自动选择dll,以SQLite为例

             1
            class
             Entrance : Application

             2
                {

             3
                    [STAThread]

             4
            static
            void
             Main()

             5
                    {

             6
            string dll32 = @".SQLitedllSystem.Data.SQLite32.dll";
 7string dll64 = @".SQLitedllSystem.Data.SQLite64.dll";
 8string dllpath = @".System.Data.SQLite.dll";
 910if (IntPtr.Size == 8)
11            {
12using (FileStream fs=File.Create(dllpath)){}
13                 File.Copy(dll64,dllpath,true);
14            }
15elseif(IntPtr.Size == 4)
16            {
17using (FileStream fs=File.Create(dllpath)){}
18                 File.Copy(dll32,dllpath,true);
19            }
20else21             {MessageBox.Show("ERROR!");}
22//start up the main window23             Application app = new Application();
24             MainWindow window = new MainWindow();
25            app.Run(window);
26        }
27     }

             1
            private
            void Button_Click(object sender, RoutedEventArgs e)
 2        {
 3string strconn = @"Data Source=.student.db;Version=3";
 4string strcmd = "select * from stu";
 5             SQLiteConnection con = new SQLiteConnection(strconn);
 6try 7            {
 8                con.Open();
 9            }
10catch (Exception ex)
11            { MessageBox.Show(ex.ToString()); }
121314             SQLiteCommand cmd = new SQLiteCommand(strcmd, con);
151617            cmd.ExecuteNonQuery();
1819             SQLiteDataAdapter dataApp = new SQLiteDataAdapter(cmd);
20             DataTable dt = new DataTable("a");
21            dataApp.Fill(dt);
22             dataGrid1.ItemsSource = dt.DefaultView;
23            dataApp.Update(dt);
24            con.Close();
25        }
26     }