I have been programming in vb6 for few time ago and i used open SQL Server connection and command objects to make database traansactions. I have been searching for similar approaches in vb.net too but not finding any starting point.
How can we work similarly in vb.net application?
I think you're looking for SqlConnection
and SqlCommand
.
The MSDN page for SqlCommand
shows a sample for how they can be used:
http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.aspx