how can i deploy windows application with its local database SQL Server R2 Express

how can i deploy windows application developed using Vb.net and Sqlserver R2 Express as local database?..how can i make it in setup format(including sqlserver) to deliver to clients?is it compulsory the client should install SQL Server R2 Express in his system apart from the installation of this windows application?

Are you using VB Express or VS? If it's the former then only ClickOnce support is built in, so you'd have to use a third-party tool to use Windows Installer. If it's the latter then you can create a Setup project or, in some editions, you can use Installshield LE. I've never used Installshield LE but you can select bootstrapper packages in the Prerequisites dialogue when using either ClickOnce or a Setup project. VS 2010 only provides packages for SQL Server 2005 Express and 2008 Express. For 2008 R2 Express you can either create your own or use one that someone else has already created, like this:

http://blogs.msdn.com/b/sqlexpress/a...2-express.aspx

thanks for your reply...i am using Visual studio 2010

Then you'll probably want to add a Setup project to your solution.

this is my first window application,so i am not that much familiar with deployment procedure,it would be appreciable if you could explain the steps to deploy my application including the database

So, because you haven't done it before you just assume that there's no way you can possibly work it out, or even part of it, for yourself? How about you look first, make an effort and then post back here if you have specific questions about things that pose a problem? Have you added a Setup project? Have you explored it to see what's there? Have you used the F1 key to get help on specific items? Have you searched Google and MSDN for information? There's plenty that you can do for yourself. You don't just have to sit back and wait for others to do it all for you. If you have issues then I and many others will be happy to help but I'm not really going to put myself out to help if you're not prepared to help yourself. You can wait for someone else to spell it out for you if you like, or you can do what you can for yourself. You might even surprise yourself with how much you can do, and that is always satisfying. Don't deprive yourself of that opportunity.