Jay, I don't do VB.Net development but it should be very similar to C#.Net in Visual Studio. Try to follow these steps:
1. Add a Dataset Item to your project. I think you have done this already. Once the Dataset is created you will get a blank dataset designer, create a connection to your Sqlite database on the server explorer panel. Drag the tables/views you want into the dataset designer. 2. Once you save that dataset, you will see the Dataset and corresponding Table Adapter in your project components list on the toolbox 3. Drag your dataset and table adapter onto your form that contains the control that you want to bind to 4. In the toolbox under data controls, drag a Binding Source to your form 5. Select the binding source and on the properties, set the DataSource to your dataset added in step 1; set the data member to the table or view added to your dataset in step 1 6. For each form control you want to bind to a column from your dataset, select the control on properties under databindings, click the attribute (like Text for a textbox) and drill into the Binding Source created in step 4, then the data table and finally the column you want. Like I said, this is how you do it in C#.net and it is probably very similar if not exactly the same way for VB.net. Steve -----Original Message----- From: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of Drago, William @ CSG - NARDA-MITEQ Sent: Monday, April 27, 2015 8:38 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] building SQLite DLL with Visual C++ I'm afraid I can't help you with that, Jay. I don't use data bindings and all that other built-in visual studio db stuff because performance is slow and it's hard to maintain. I just read from the db into a data table. From there you can do whatever you want with the data. Search on line for VB.NET examples and I'm sure you'll find some examples. Good luck, -- Bill Drago Senior Engineer L3 Narda-MITEQ 435 Moreland Road Hauppauge, NY 11788 631-272-5947 / William.Drago at L-3COM.com > -----Original Message----- > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite- > users-bounces at mailinglists.sqlite.org] On Behalf Of Jay Smith > Sent: Sunday, April 26, 2015 3:44 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] building SQLite DLL with Visual C++ > > Thanks Bill > > That worked.... > > BUT > > In my form when I go to "DataBindings" I get a Pop-up to "Add Project > Datasource" then the 2 screens to choose Datasource Type( I select > Database) then I choose DataSet. This is where it breaks down."Choose > Data Connection there are 4 choices "Access" and 3 server types, then > there is <Other> which I select. And that leaves me with a single > "Data provider" > Microsoft OLE DB simple provider This connection works, but is it > correct? > The connection is MSDAOSP > > Then I get to the screen "Choose your database objects" and an ERROR > > "Selecting Objects of type 'Table' is not supported. > > Then we get to the next part of the problem. I am in my late 70's and > have not done any SQL for over 15 years ( I was pretty good at one > time.) Where do I go from here. > > Jay > > On Sat, Apr 25, 2015 at 5:12 PM, Drago, William @ CSG - NARDA-MITEQ < > William.Drago at l-3com.com> wrote: > > > I don't know what error you're getting so I can't offer specific > help. > > > > This is what works for us: > > > > Open your project in Visual Studio. > > > > Click Tools > NuGet Package Manager > Manage NuGet Packages for > Solution... > > > > Select Online > nugget.org > > > > In the search box enter system.data.sqlite > > > > A list of packages should be displayed after a short wait. > > > > Select System.Data.SQLite Core (x86/x64) or, if you need LINQ and > > Entity Framework support, select System.Data.SQLite (x86/x64), then > > click Install (we use Core here) > > > > After installation you should see a little green checkmark next to > the > > package you selected. > > > > Click Close and you're done. Check on line for VB.NET code samples > > using SQLITE. > > > > Good luck, > > > > -- > > Bill Drago > > Senior Engineer > > L3 Narda-MITEQ > > 435 Moreland Road > > Hauppauge, NY 11788 > > 631-272-5947 / William.Drago at L-3COM.com > > > > > > > > > -----Original Message----- > > > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite- > > > users-bounces at mailinglists.sqlite.org] On Behalf Of Jay Smith > > > Sent: Saturday, April 25, 2015 3:50 PM > > > To: General Discussion of SQLite Database > > > Subject: Re: [sqlite] building SQLite DLL with Visual C++ > > > > > > Hi Bill > > > > > > I have been trying for 2 days and I am totally lost. > > > > > > I have NuGet Package Manager. I don't know how to use it. > > > > > > From the PM> System.Data.SQLite I get an error. > > > > > > Can you be a little more specific. > > > > > > Jay > > > > > > On Thu, Apr 23, 2015 at 4:08 PM, Drago, William @ CSG - > > > NARDA-MITEQ < William.Drago at l-3com.com> wrote: > > > > > > > > -----Original Message----- > > > > > From: sqlite-users-bounces at mailinglists.sqlite.org > > > > > [mailto:sqlite- users-bounces at mailinglists.sqlite.org] On > Behalf > > > > > Of Jay Smith > > > > > Sent: Thursday, April 23, 2015 3:47 PM > > > > > To: General Discussion of SQLite Database > > > > > Subject: Re: [sqlite] building SQLite DLL with Visual C++ > > > > > > > > > > Thank you Adam for responding to my post. I have the windows > > > > > binaries downloaded. > > > > > > > > > > At this point I am just following the instructions in the book. > > > > > And I really am not sure what I need the dll for. > > > > > > > > > > Here's the scenario. I have created a program in vb2012. The > > > program > > > > > stores less than 20 fields of data. I am currently saving the > > > > > data in a html format. I just recently discovered SQLite. I am > > > > > now in > > > the > > > > > process of changing over to a database to store data. I > > > > > studied SQL and Oracle > > > > > 10 years ago. I have almost completed the database for the > project. > > > > > My problem is how to integrate the SQL db into my VB program. > > > > > > > > Your subject line says C++, but the line above says VB, so is > your > > > > program written in C++ or VB? > > > > If it's VB just get SQLite with NuGet (Tools > NuGet Package > > > > Manager, then search for System.Data.SQLite Core). > > > > > > > > -Bill > > > > > > > > > > > > CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail > > > > and any attachments are solely for the use of the addressee and > > > > may contain information that is privileged or confidential. Any > > > > disclosure, use or distribution of the information contained > > > > herein > > > is > > > > prohibited. In the event this e-mail contains technical data > > > > within the definition of the International Traffic in Arms > > > > Regulations or Export Administration Regulations, it is subject > to > > > > the export > > > control > > > > laws of the U.S.Government. The recipient should check this e- > mail > > > and > > > > any attachments for the presence of viruses as L-3 does not > accept > > > any > > > > liability associated with the transmission of this e-mail. If > > > > you > > > have > > > > received this communication in error, please notify the sender > > > > by reply e-mail and immediately delete this message and any > attachments. > > > > _______________________________________________ > > > > sqlite-users mailing list > > > > sqlite-users at mailinglists.sqlite.org > > > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite- > use > > > > rs > > > > > > > _______________________________________________ > > > sqlite-users mailing list > > > sqlite-users at mailinglists.sqlite.org > > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite- > users > > CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and > > any attachments are solely for the use of the addressee and may > > contain information that is privileged or confidential. Any > > disclosure, use or distribution of the information contained herein > is > > prohibited. In the event this e-mail contains technical data within > > the definition of the International Traffic in Arms Regulations or > > Export Administration Regulations, it is subject to the export > control > > laws of the U.S.Government. The recipient should check this e-mail > and > > any attachments for the presence of viruses as L-3 does not accept > any > > liability associated with the transmission of this e-mail. If you > have > > received this communication in error, please notify the sender by > > reply e-mail and immediately delete this message and any attachments. > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users at mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any attachments are solely for the use of the addressee and may contain information that is privileged or confidential. Any disclosure, use or distribution of the information contained herein is prohibited. In the event this e-mail contains technical data within the definition of the International Traffic in Arms Regulations or Export Administration Regulations, it is subject to the export control laws of the U.S.Government. The recipient should check this e-mail and any attachments for the presence of viruses as L-3 does not accept any liability associated with the transmission of this e-mail. If you have received this communication in error, please notify the sender by reply e-mail and immediately delete this message and any attachments. _______________________________________________ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users --- This email has been checked for viruses by Avast antivirus software. http://www.avast.com
