dear all
actually , m a new to .net,
i want to know how to use database connection in .net in sql way using dsn, without using provider like what i m write in vb is
dim con as new adodb.connection
dim sql as string
con.open("dsn=test")
dim rs as new adodb.recordset
sql="select * from emp order by emp_code"
rs.open sql,con,adlockoptimistic,adlockdynamic
same code how i convert into vb.net