I have programmed a web application using classic ASP and MSSQL, but our company is upgrading to ASP.NET and for my next project I thought I would the application in pure VB.NET.
However, I am struggling to get my application to talk correctly to the MSSQL tables. I know my connection string is correct. But can anyone tell me how to do this?
1. Send SQL Query such as "select * from users where userid=<form field>"
2. Read the result of the query
I used to use ADODB and recordsets but ASP.NET appears to use something called datasets and I am really struggling to get my head around how this works.
Every example talks about displaying the data. I want to read the data not show it.
Any help appreciated or some clue as to how to resolve this issue