Friday, 6 September 2013

How to deploy and attach SQL Server Management Studio 2012 Database with Winform Application ?

How to deploy and attach SQL Server Management Studio 2012 Database with
Winform Application ?

I am using Visual Studio 2012 with SQL Server Management Studio 2012, At
very first I created a database named salesystem in SQL Server Management
Studio 2012, I created views and tables also in SQL Server Management
Studio 2012 ... Then
I created a new Winform Project,
Then I created a new Data connection in Server Explorer (Visually > Not by
Coding) in Visual Studio 2012. Server Explorer > Add Connection > (In
Server Name I gave . and selected my database from the combo box given
there , I clicked TEST CONNECTION (It gave me Connection Successful !)
then I clicked OK ).
Then I created a NEW DATA SET by clicking on Solution Explorer > Add > New
Item > Dataset.
Then In Data Set I Dragged Tables from my Database. And started working
with my Database.
Now the problem is that when i wish to publish my project, my database is
not attached with it! What to Do Now???
How can I publish this Application with my Database created in SQL Server
Management Studio 2012??
How can i reference my Database to my Winform Application?
Do i have to reference it before publishing? If YES, then HOW????
IF ... someone in one of you helped and solved my problem, then when I
install this Application with database on my client PC, and install SQL
Server 2008 Express OR SQL Server Management Studio 2012, will I have to
give server name. In his PC?? After installing and running SQL Server
Management Studio 2012???? If yes then, how can I configure database
reference settings after my application is published?
I know this is a very long question but I am stuck very badly!!! Please I
need a MASTER to sort out this GIANT Problem for me.... Any Help Will Be
Appreciated.... Please help me Step by Step..... Thanks...
NOTE : I don't know any other method on how to make a database app in
winforms in visual studio 2012 , so please try to help me in my way , Not
by telling me to use SQL Compact or LOCAL Database in my app !!! I know
it's a tricky question! But a MASTER IS THE ONE WHO SOLVES TRICKIEST
QUESTION!!!

No comments:

Post a Comment