Nov 01, 2018 01:27 PM|Justair07|LINK
PatriceSc and Nan Yu,
Thank you both for the reply. As you can probably tell from my question, I'm embarking on a new journey by making by first non-access db.
Patrice, you are correct, from my research (which I can now see was outdated) I planned to use typed datasets in my project.
You link was awesome. I'm going to do some research/training on Entity Framework Designer before I begin. I'll start with the video in the link :)
So correct me if I'm wrong, by using EFD in my project I won't need stuff like:
Module MyFirstProject Public str As String Public con As New SqlConnection(str) Public cmd As SqlCommand Public da As SqlDataAdapter Public ds As DataSet Public bs As BindingSource Public qry As String Public Function GetConString() As String Return "Data Source=MyFirstProject\SQLEXPRESS;" & "Initial Catalog=Projects;" & "Integrated Security=True;" & "MultipleActiveResultSets=True" End Function
Also, what about moving my DB location? I plan to develop my DB in SQL Express on my personal PC but then I need to move it to a LAN Server after testing and project completion.