Member Avatar for php_noob

I am using a data connection (i don't know what...) I just have a connection string in APP_CODE and some supporting codes to execute it. (That's not the question)

Well What is your recommended DB connection in ASP.NET,
Is the real world still using ADO?

is ADO for simple website (CMS) only?

Thanks for the replies in advance!!!!

  • 2 Contributors
  • 4 Replies
  • 81 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by php_noob
Member Avatar for php_noob

BTW - ROUGHLY these are the codes in the APP_CODE

Dim scnnFS As New SqlConnection(SQL_CONNECTION_STRING)
Dim scmd As New SqlCommand(strSQL, scnnFS)
Dim sda As New SqlDataAdapter(scmd)
Dim ds As New DataSet()
sda.Fill(ds)
Return ds

Member Avatar for sknake

This is more of a VB.NET question than MSSQL, but yes that is the recommended way of connecting to SQL Server. What is the issue?

Member Avatar for php_noob

Really but I am using it ASP.NET?! :icon_cry:

Member Avatar for php_noob

The real question is ADO.NET is still been used in the real world, I am not a ADO.NET fan.

Thanks

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.