Hi,

When I first use .NET I get Started to Connect to my Databases and when I do, I finally found out that I need a Correction. So I hope to have a better answer in here. Thanks.

I use to Connect to my Database is

Dim Connect as Adodb.Connection
Set Connect = "Provider blah blah blah


I just need a question here...
When I query, I use this

dim rs as adodb.recordset
set rs = Connect.Execute("SELECT blah FROM Blah")

can I really use this in .NET? or it will only be available in Visual Basic? thanks in Advance..




Always,

Mark


____________________________
CLIPER

Hi clipper.

There are some parameters or syntax used in .NET that are not applicable in VB6 and vice versa. I used this sample code in connecting database using .NET.

' Create a connection string Dim ConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\\Northwind.mdb" Dim sql As String = "SELECT CustomerId, CompanyName, ContactName From Customers"

____________________________
Im JAMES  

.NET does not have a recordset object, at first I was like WTF but now that I have been working with .NET for a few months I don't miss it a bit. You can use old ASP code in a .NET project. but I recommend getting up to speed with how .NET ADO has changed (into ADO.NET......go figure...)

See  THIS LINK HERE

'Sample Data Access Using SQL Server '(for other DB use OleDB) 'Before your class make sure you have... Imports System.Data.SQLClient   'for SQL Server conn 'In your procedure/function... Dim objConn As SqlConnection 'your connection string will be pretty much the same as before... objConn = New SqlConnection(connection_string) objConn.Open Dim oCmd as New SqlCommand("SELECT id FROM tblTable", objConn) oCmd.CommandType = CommandType.Text Dim oReader as SqlDataReader oReader = oCmd.ExecuteReader While oReader.Read     'do something with data     myIDs = oReader.Item("id") End While oReader.Close objConn.Close

This example shows looping thru a data reader. Although slower than the data reader, you should also check out the Dataset object in Help or look for some examples on that because it is just so dang useful....(binding to a datagrid)

____________________________
Eggheads unite! You have nothing to lose but your yolks.

Hi,

regards
bhar



[Edited by Bharathi on 17-05-2013 at 12:46 PM GMT]