VS 2013 Get detailsview with SQL light
-
I have a VS 2013 C# windows form application that binds a details view then a datagridview with an Access Database. I want to use SQL Light instead. There does not seem to be a simple procedure to click details view on the data source with SQL Light and drag the table onto the form as there is with Access. Can someone refer an article that explains how to accomplish this with C#?
-
I have a VS 2013 C# windows form application that binds a details view then a datagridview with an Access Database. I want to use SQL Light instead. There does not seem to be a simple procedure to click details view on the data source with SQL Light and drag the table onto the form as there is with Access. Can someone refer an article that explains how to accomplish this with C#?
-
Google: SQL Light C#[^].
Thank you for the links, Richard. I can't find what I am looking for. I have a windows form connected to an Access Database. Building the form was essentially drag and drop. I want to display a single record from a Sqlite database in an array of textboxes. VS will build all this when I select details view from the table, then drag the table onto the form. A data navigator is also installed. Then I drag a datagridview onto the form and the VS designer links everything together. So I don't really write any code. I installed the Sqlite toolbox, and I can add a datagridview easily. But not details. Since there seems to be nothing in VS to do this for Sqlite, can I simply change the connection string to the existing form that connects to Access?
-
Thank you for the links, Richard. I can't find what I am looking for. I have a windows form connected to an Access Database. Building the form was essentially drag and drop. I want to display a single record from a Sqlite database in an array of textboxes. VS will build all this when I select details view from the table, then drag the table onto the form. A data navigator is also installed. Then I drag a datagridview onto the form and the VS designer links everything together. So I don't really write any code. I installed the Sqlite toolbox, and I can add a datagridview easily. But not details. Since there seems to be nothing in VS to do this for Sqlite, can I simply change the connection string to the existing form that connects to Access?
-
BobbyStrain wrote:
can I simply change the connection string to the existing form that connects to Access?
No idea, why not try it and see?
That's all it took. Of course, the project needs to add the library for SQLite. Now I am working to populate a combobox with unique values from a column in the database table. Thanks.