Currently I have some Utilities created in VBA (Excel) that access and update a MS SQL database.
I am looking to update these to a Visual Basic 2015 Application. (Hopefully get rid of some Bugs and Speed things up)
I am currently using Visual Studio 2015 and SQL 2008 R2
My Questions are
What is the Best way to connect to the SQL database? (Needs to be able to update and run Procedures)
How do I get data from the SQL Database into Visual Basic Classes?
What is the Best/Fastest way to Search? - Load the Data (10,000 Records) into a Class in Memory, Or send a search Query to the database?
Note the database will be on the Local Network.
To get Started I want to make the Following App (If someone could enter the code in the sample it would probably answer most of these Questions)
User Enters a Code in the Search Code Box then Clicks the Search Button
If a Match is found in the Data then the Label below shows the Description of the Item and the Bincode Textbox Displays the Bincode for the Item
A New Bincode can be entered and the Database is updated when the Save button is Clicked
(I had a Sample Visual Basic Solution but EE won't let me upload the ZIP Folder)