![]() ![]() NET platform such as SCM, and HR based applications. He and the team have developed many projects using. He has been using Visual Studio (.NET) since the Beta back in year 2000. With 25 years of experience in the IT field, he has developed system using Clipper, COBOL, VB5, VB6, VB.NET, Java and C #. He is a software development manager for a multinational company. Ming Man is Microsoft MVP since year 2006. The blog is never meant to give people consulting services or silver bullet solutions. The blog also uses as a help to keep my memory. The blog also has a lot of guidance teaching you how to get stated certain Microsoft technologies. This blog is about more than 50% telling you how to resolve error messages, especial for Microsoft products. Since March 2011 Microsoft Live Spaces migrated to Wordpress () till now, I have is over 1 million viewers. String strSql = “INSERT INTO (,) VALUES (1, ‘Ming’)” Using ( SQLiteCommand cmd = new SQLiteCommand ()) Using ( SQLiteConnection conn = new SQLiteConnection ( “data source=mydb.db” )) To insert the record into SQLite, the code as below Type SQLite in the Search box then you will see the SQLite package appear. Click on “Manage NuGet Packages for Solution… (menu item)”.Ģ. You can see now there is a Customer table created.ġ. Click the Green Play (Run) button to create the table. After put in all the information you need then click on “Script! (text)” in “Build Table”.ġ0. Right click Table then click on “Build Table (beta)… “.ĩ. Click on “mydb.db (SQLite) (tree view item)” to expand the database.Ĩ. Click on “Test Connection (text)” in “Add SQLite Connection” then click OK.ħ. Type in the database name and click Save.Ħ. Click on “Create… (button)” in “Add SQLite Connection”ĥ. Click on “SQL Server Compact/SQLite Toolbox (menu item)”.ģ. Run the SqlCeToolbox.4.5.0.3.vsix then you will get the tool in your Visual Studio.Ģ. You can use an open source tool to create the SQLite database db file and see the records. It is quite confusing when you have Compare SQL and SQLite. This short article show you how to use SQLite with Visual Studio Project. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |