Comments by Blue Ocean

Blue Ocean 23-Mar-22 19:48pm View

Because it seems to make working with the reporting side of things a little less difficult, but seeing as there doesn't seem to be a solution, I will likely work through the coding.

Blue Ocean 23-Mar-22 15:38pm View

I didn't realize that was a negative thing, my apologies.

Blue Ocean 23-Mar-22 15:12pm View

Mike thanks for the link, but I am looking specifically for how to add SQLite to the data source list in Visual Studio 2022, Data Source Configuration Wizard.

Blue Ocean 23-Mar-22 13:43pm View

Mike see my note below to Maciej.

Blue Ocean 23-Mar-22 10:21am View

Maciej, I think I am asking this question wrong. I understand how to use SQLite in my C# project code (connection strings, commands, data adapters, data readers, command builder, etc) What I am trying to do is figure out how to include the SQLite in the list that is in the Visual Studio 2022 Data Source Configuration Wizard. In Visual Studio\Add New Data Source...\ the Data Source Configuration Wizard opens and asks for
SOURCE TYPE: Database
...then it asks for
SOURCE MODEL: Dataset
...then it asks for
DATA CONNECTION: I select NEW CONNECTION and the CHOOSE DATA SOURCE form opens with a list of sources:
Microsoft Access Database File
Microsoft ODBC Data Source
Microsoft SQL Server
Microsoft SQL Server Database File
<other>

Here is where I need to have SQLite to select from. How do I add SQLite in this list?

Blue Ocean 22-Mar-22 16:00pm View

Maciej this article doesn't give any instructions on sqlite, what am I missing?

Blue Ocean 14-Feb-22 15:19pm View

Thanks Maciej, I really appreciate the extra direction!

Blue Ocean 14-Feb-22 13:07pm View

I should have caught the quotes issue, you are right it doesnt return the records but it doesnt generate the error.

Blue Ocean 11-Feb-22 20:13pm View

Thank You Imran, this was part of the problem. Please see my comment to PIEBALDconsult, there are apparently quite a few more issues. There seems to be a problem with the WHERE part of statement, the Parameters, and also the mile_Date format of my sqlite table below:
auto_ID INTEGER PRIMARY KEY AUTOINCREMENT
UNIQUE
NOT NULL,
mile_Date DATE NOT NULL,
begin_Miles INTEGER NOT NULL,
end_Miles INTEGER NOT NULL,
car_ID INTEGER REFERENCES Car (car_ID)

Also, is SelectedIndex correct? or should it be something else. If I select a value in the combobx and it populates the datagridview then go back to combobx and select another value it does nothing.

Blue Ocean 11-Feb-22 20:01pm View

I think the parameter is a problem, yes. If I
//WHERE car_ID=@car_ID";
//sqlite_cmd.Parameters.Add("@car_ID", System.Data.DbType.Int16).Value = //autoidcomboBx.SelectedIndex;
and the if () solution below with the autoidcombobx.SelectIndex change from below, I can get data to populate the datagrid, but only if dont include the mile_Date in the query. If I include it, another error is thrown: System.FormatException
HResult=0x80131537
Message=String was not recognized as a valid DateTime.

Comments by Blue Ocean (Top 10 by date)