Question Access or SQL

[nadertec]

Hi,

This is my 1'st thread here and would like to great all.

I've been using MS Access since version 2.0 for many applications like accounting and decided to give VB.NET a try for non db solutions with success.

Now, I would like to use it for my new db solutions and need to clear a couple of points first:

So here are my quesitions:

1. How do I report in VB.net. I need a a freeware to run my reports and let end-user to be able to change report design. (e.g. invoice design)

2. Since Access does all the patching-up in queries (and thus not familiar with SQL commands), in single and multiuser platforms should I use VB.NET's own file system, Access, or MSSQL.

3. what are the primary differences between visual studio 2008 express and pro.

Thanks in advance and rgrds

Nader

 

[Hack]

should I use VB.NET's own file system

I have no idea what you mean by this. VB.NET is a programming language. It doesn't have a "file system"

How do I report in VB.net.

You don't...there is no built in reporting tools. FOr this you would have to rely on third party apps like Crystal Reports or such...I actually run SQL queries against my SQL Server database and dump the results to Excel and use Excel as my report engine.

3. what are the primary differences between visual studio 2008 express and pro.

This goes into the differences
Microsoft Visual Studio - Wikipedia, the free encyclopedia