Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> Visual Studio Express Editions >> Visual Basic 2005 Express Edition

backend

I have a project in vb.net 2003 that uses an access backend. I would like to covert the project to vb.net 2005 using sql 2005. I know I am able to convert the project but how do I convert the access data source to sql datasource? One more thing; I can not find crystal reporting for vb.net 2005. How can I create reports once my project is done?
[345 byte] By [slimjen1] at [2007-12-17]
«« datetime picker for pocketPC ?
»» A problem with ATL::CTime.GetLocalTm()
# 1
Hi,

Crystal is readily available in VS2005 standard edition upwards. Express does not contain Crystal Reports. If you are converting Access into Sql then all you have to do is change all of your OleDb (if your using OleDb) classes to its Sql Counterpart. Here's a minor list:

Imports System.Data.OleDb = Imports.System.SqlClient
OleDbConnection = SqlConnection
OleDbDataAdapter = SqlDataAdapter
OleDbCommand = SqlCommand
...
cheers,

Paul June A. Domag

PaulDomag at 2007-9-8 > top of Msdn Tech,Visual Studio Express Editions,Visual Basic 2005 Express Edition...
Visual Studio Express Editions
Visual Basic 2005 Express Edition

Visual Studio Express Editions Hot Topic

Visual Studio Express Editions New Topic

Visual Studio Express Editions

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified