[RESOLVED] Deployment with SQL Server 2005 Express, 3.5 Framework and MSChart control

[enex]

Hi, I am at the stage of deploying my application that has been coded in VB.NET Visual Studio 2008 Standard

My application connects to my database that sits on the local directory of /SQLEXPRESS I then connect via the connection string in my app.

My question is, how do I deploy my application with the SQL Server Database? I would also like to check if the user has SQL Server installed and if they dont prompt them to install sql server first. My app also needs MSChart controls that use the 3.5 framework, the user needs to install MSChart.exe to run my application, how can I install the MSChart.exe on my setup?

I have read I can use Setup and Deployment Projects in Visual Studio but I have never used these before, I have also read about a free installer called INNO Installer. But unsure of the best way to go.

If someone could provide some advice I would be highly grateful.

Thanks in advance

edit: I decided to use setup and deployment type projects as i have vb2008 standard it comes with this,
as for sql and mschart I just added the prequisites i needed
job done

enex