Simple selecting records from access table
Posted on 2009-04-16
Visual Studio 2008
I am having a very hard time understanding .net vs VB6 or vbscript in terms of selecting records from an access database.
Normally all I need to do is this:
ConStringLoginSQL = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\mydatabase.mdb"
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = ConStringLoginSQL
Set objRS = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT * FROM TableName"
Set objRS= objConn.execute(strSQL)
While not objRS.eof
MyVariable = objRS("MyField")
That allows me to manipulate, store or do whatever with the data individually as I am looping through the records.
With .Net all I can find examples of are loading data in to "datashapes" and "grids" all at once.
I dont understand.. how am I supposed to manipulate data this way?
I do not need to show the data only compare and make calculations and such.
what am I missing here?
Can someone show me how to do it the "old way" with .net
(note, it's Visual studio 2008, not 2003 or 2005)