Connection String in ASP.net 2005 using VB.net

[soumitrabhatt]

Dear friend
i am new to asp.net & problem with asp.net connection. plz let me know what are the best technique for making connection

thanks
waiting of reply

[pratsadhu]

Hi,
This would do

Dim conString As String = " Your string "
Dim con As SqlConnection = New SqlConnection
con.Open
'Write your code here

con.close

[Burhaan]

Visit www.connectionstrings.com for a list of valid connection strings to use.

[iteamweb]

hi,
using following code:

imports system.data.oledb;

dim con as oledbconnection
dim cmd as oledbcommand
dim dr as oledbDataReader

con=new oledbconnection(connection string)
con.open()
cmd=new oledbcommand("select * from tablename",con)
dr=cmd.ExecuteReader()
dr.Read()
con.close()
dr.close()


http://www.tryangled.com
http://www.tryangled.net
http://www.iteamweb.com