Bill & Steve Thanks guys I am trying to learn and make some progress with the information you both provided.
On Mon, Apr 27, 2015 at 9:57 AM, Steven M. McNeese < steven.mcneese at freedomparkdfw.com> wrote: > 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-bounces at 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 > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
