Using SQL Server database with vb

[awweather]

Hello,

I created an application that serves as an inventory manager for the printer toner cartridges that we have in the company. Due to the restraints of not being able to set triggers with access, I went through the process of migrating my database over to SQL server 2012.

I have found that the code for setting up the SQL database within visual studio is a lot more complicated (or so it seems) than it was for access. I have successfully added the database as a new data connection. However, I am unsure how to actually load the database into the application. I have searched online for tutorials but everything I find is different than what the last person is saying.

Basically, what I want from this program is to activate a trigger whenever a certain model of toner reaches 0 and send out a notification to our rep. I have already configured the email part and that works fine. But, I am having to re-program the database functions to access the new SQL database instead of access.

For example, the code to load a table from the access database was something like Me.TblTonerTableAdapter.Fill(Me.PrinterinventoryDataSet.tblToner). But it seems exponentially more difficult to do this with SQL. Maybe I am not looking in the right places?

Any guidance or work through would be appreciated!

Anthony

[Niya]

Read this post.