How to Create Setup File With attaching SQL Database .mdf with proof in c# windows application
Vložit
- čas přidán 14. 02. 2019
- If you want to create setup file with attaching sql database this tutorial is for you. In this tutorial you can learn how to create setup file or publish project in c#.net with SQL database. create setup file with attaching SQL server database .mdf in visual studio 2010 c#. install the setup file in different computer. you can see 100% proof in this tutorial.
To create setup .exe file with SQL database full package follow these steps.
1. Create a windows application.
2. Add the database.mdf file in solution explorer.
3. Connect with .mdf file with your project through connection string - SqlConnection.
4. complete coding in the application
5. Right click on your project in solution explorer, Click on Property.
6. Click on publish in left pane.
7. Complete the task by following the tutorial.
- you can add setup description link etc.
8. INSTALL this setup file in different computer
Now if you install this .exe file it automatically added the database.mdf and database.ldf file in system folder where its installed.
First of all we develop a software according to client requirement in c# windows form application with connecting SQL server databse.
We usually have the options to submit the software to client through mail or other online server where client can not configure database and we don't have access to clients computer. we should give him a complete package so that he can just run the setup .exe file. in that case we need to create a setup file with attaching database in c# so that he can run and watch output data from SQL database.
~~~~~~~~~~~~~
Subscriber will be notified when I will upload new tutorials in future. Many more new tutorials coming soon, so stay tuned!
/ swiftlearn
~~~~~~~~~~~~~
You can also know all the programming techniques, and bug fixing, error solution in my channel Swift learn.
The main topics of this cnannel are c#.net, asp.net, WCF, sql server, crystal report, RDLC report, HTML, CSS, javascript, Android etc.
~~~~~~~~~~~~~
Share this video with anyone if you think as useful.
Please leave any suggestions for future tutorials in the comment section below.
~~~~~~~~~~~~~
Connect with me
/ swiftlearn
All playlists
c# tutorial for beginners Swift Learn
• c# tutorial for beginners
c# linq to sql tutorial Swift Learn
• c# linq to sql tutorial
asp.net tutorial for beginners full Swift Learn
• asp.net tutorial for b...
crystal report c# in sql Swift Learn
• crystal report c# in sql
RDLC Report tutorial
• rdlc report in asp.net c#
SQL Tutorial for beginners full Swift Learn
• sql tutorial for begin...
HTML tutorial full course
• how to add background ...
WCF Tutorial Step By Step with SQL
• WCF Tutorial Step by S...
For Details
#swiftlearn #setupfilewithdatabase.mdf #createsetupfilewithsql #createsetupwithdatabase #howtocreatesetupfilewithdatabase #createsetupfilewithdatabasewithproof
how to create a setup file in visual studio 2010 with database, create setup file with sql
setup file,create setup with database in c#,create setup exe file,c#, setup file with sql,create setup file with database proof,how to create setup file in c#.net windows application with database .mdf,create setup file with database .mdf,how to create setup file in c#, visual studio code - Věda a technologie
Hello Sir ,
Your Way Of Defining Is Just Awesome ,
sir i'm facing a issue
when i add new Database.mdf file then perform the other work that you shown in the video,
but when i run the project, it displays error in my query, but the query is same as the query you shown in the video,
i'm using MS Visual Studio 2012.
& this is the connection string which i'm getting from App.Config File
:
"Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True"
;
Please Sir Help me regarding to this
Watch video once again and put @ for example @"Data Source=(..... and let me know. please like subscribe and share.
@@SwiftLearn Sir Thanks For Your love, & for Pinning My Comment :*
@@rahimmughal4552 Try with [User] or dbo.user. if still not solve connect with me in facebook.com/rowshanp
@@SwiftLearn Let Me try With dbo.user / Others names Sir
@@SwiftLearn Actually Sir , there was problem with my table name name 'user' that is the constant of SQl language , later i created table with another name & it's worked for me :D Thanks You so much for your corporation & For your Precious Time Sir
I really liked the way you explained very interesting and good video you made the word "YES" is makes more attention keep it up and thanks for the video liked and subscribed
Thank you very much sir, was looking for this since a very long time
Iam trying a lot without installing sqlserver. But your video is best and good. It's working nicely 😊😊
That is exactly what iam looking for! thanks a lot .
Glad I could help! please keep in touch.
Wow, this is what I've search for. Now i know it. Thanks to u sir.
You are most welcome🌹🌹
Great job Swift Learn. Its working in different computer.I have created setup file with attaching database, but failed to run in different computer because of it can not connect with SQL. Now I just get my solution and its working fine in different computer with SQL database.
Thanks for your comment. Please share to help others
How did you fix it please😭
How did you fix it brother
Can you helo me
Hello@@wahibomer1176
Thank you so much, you've just saved me. I wouldn't mind donating something to you, in the meantime, CHEERS from Kenya, Africa!
Thanks for your comment. Please keep connected. your comment inspired enough to make new tutorial.
I love your energy! This is what i was looking for
bro very good tutorial so useful keep creating vids like this thanks for sharing . bro i love your yes saying way
Glad you liked it and also glad to support programmers. thanks
Great Solution. I have faced much problem in setup file with attached SQL database. what is not working in different PC. displaying error a network related instance specific error occurred. in my point of view this is the solution i am waiting for.
thanks Swift Learn for uploading this video.
Thanks mohad. feeling proud to see your comment.
Mam Can you help me ?
How do you add icons when installing/publishing this way? I cant see icons when going to the control panel or desktop icon.
Hello sir ,
I am developing a software with C# where I have used Oracle 10g. will this process work in my case ?
Thank you so much more blessings to come
Pleased to see your comment. Thanks
Why do you have a connection string here @5:00? If I go there I don't have my connection string and I need to manually input it.
and why is my connection string look like this: Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename="D:\Visual Studio\Basic CRUD\CRUD\CRUD\CRUDDatabase.mdf";Integrated Security=True?
I have an sql server express but I don't know how to bind it with my winforms app. please help.
Hey, what to do if my connection string looks like this: "Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=D:\Visual Studio\Project\Project\DB.mdf;Integrated Security=True"?
Does this affect the project?
sir thats ok but what if i have used entity framework and created model and tables of database in my program how to add it with my program setup and configure that. its not working in the other pc.
it says a signing certificate is needed. It aborts the publishing after that.
Thank you for making informative video.
We need your help for following scenario..
how to make exe file in following case
if the source code
Front end is developed in visual studio 8 and
backend API is developed in visual studio 2013.
thank you for this video, and i want ask: what is the maximum size for this database?
in visual studio 2015 it is possible .i am not getting that version dataset
Can anyone help with any link or so where multiple user (who are on same network) but different computers can use this application simultaneously and their data will be updated for all...
If we run different set up on different computers then their database will be different ,,so we should be able to share the database across different computers. So how can we do that...Thank You...
So create a setup file without attaching database. And the database must be installed and configured in local network PC. Use ConncetionString of that PC where SQL server exist. After that the application will be accessible from all PC simultaneously in local network. Thanks.
Nice video bro.just keep it up
Thanks for your comment. You are very kind.
Very nice, One question. How does one backup and restore the database in the created file?
I have already build project in visual studio 2013 using window form and already have database. Now i want to make its setup i have done the same steps following your videos. But when i test before it i got error ["Invalid value for key 'attachdbfilename'.]""
However i write the same connection string as
="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\HMS.mdf;Integrated Security=True;User Instance=True"
i have add existing item HMS.mdf from desktop which i have copied to desktop from C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\DATA.
Can you please tell me how i can fix it.
Thanks in advance
This video was what i was finding for but , when i create and database and rename the table it asks me a place to save the sql file . it does not get saved in the vs like in the tutorial! Can u Please give me a solution?
10:48 in my prereqsuites .netframe work for client profile is not available
Great tutorial, thank you a lot, but I have a question. I already have data in my database (and users should be abel to add to that data). So how can I make that the data in the database won't be lost when I install the program on a different computer?
I could really use your help.
Thanks for your comment. i will check.
Has Swift Learn or anyone found the solution to this ?
@@souravroy5751 you just need to create backup for database
Sir I make a project on java swing desktop application using netbeans and mysql ....how can i sir install the project on other machines with database please help sir...
Hi Sir, in your tutorial will the database will only be save on 1 computer (as server)? or every computer that runs the installer will have their own database?
Your second question is true. If you install this app in a computer, the database .mdf will be stored in program files in the installed computer. Its allowed to backup the .mdf file from that directory folder. thanks.
@@SwiftLearn database will be stored automatically in the program file ?? even though on another computer sql server is not installed ??
Worth to watch and subscribe
Thank you so much sir
Sir in prerequesties I have no option client profile and windows installer?? What should I do
Thank you so much, sir.
You are most welcome
Nice Tuts... btw i try this method but the data keeps disappearing from the database which was store.. like when you debug its adding but when i run it again there is no data(Previous data) ... how can i solve this....
thanks
When installing on another computer, an error appears.
"(A network related or instance specific error occurred while establishing a connection to sql server the server could not be found or cannot be accessed. check that the name of the instance is correct and that sql server is configured to allow connections (provider sql network interfaces error: 52 impossible to locate the installation of a local database runtime check that sql server express is installed and that local database runtime functionality is enabled)"
Please explain the matter as soon as possible
May be the problem of prerequisites. to add prerequisites accurately see this tutorial too czcams.com/video/H01Tok3jpsw/video.html
a network related instance specific error occurred while establishing a connection to sql server, i m facing kinda this error in host computer
It means can not connect with the SQL server. Add prerequisites. follow this tutorial czcams.com/video/wwG6fc6mvFo/video.html
hello SIR?
I dont have nothing in app config, i have my data base is located in my laptp and i add a manual connection but how can i have the same as you i have visual studio 2019 and i want my app work in all compture
Please help
i have created database with tables, procedure and all, so how to bring that database complete file in project
Will it work on CD cause we have a project to do we need to put our exe file into a CD.. help me sir
Do you know how to install Update of window form application with also update in database sql server without deleting perivious database?
HI thank you sir!
sir i have a problem how to connect Crystal report with local database in this method Crystal report not working how to print data
in the .config.deploy. The connection string is still the sqlserver
Hi, your implementation works really good thanks for the help. But I am facing one issue that is when I am trying to install my software on client computer. I keep encountering the problem "Cannot update database because database is read only" I had to go to installed folder in program files and set the mdf and ldf file permissions to full control for the user that is when write operations work. Is there any possible fix for this rather than always going and setting permissions to it.
You are working good. Set full control in installed folder instead of .mdf file. thanks
@@SwiftLearn Thank you so much for the reply. Can this be automated by the setup or anyway possible or is it only possible to be done manually.
Hello Sir, may i ask that the prerequisite for the Microsoft .net framework must use client profile?
Yes. You can install .net framework separately. But It should be compatible with visual studio version. Thanks.
Thanks for Valuable Tutorial.
I am facing some problem. When saving the data into DataBase though WindowForm load and insert data successfully but actually it is not saving the data into Database. However, the data save through Database it show on the windowform successfully.
when you install this aplication in defferent client PC than it will save in database. to ge proof czcams.com/video/H01Tok3jpsw/video.html
Don't trust what you see in the sever explorer, the mdf file is copied into the debug folder (every time you build your program a new one is made) so don't worry, the record is updated.
can you make an updated version for this . and how do you install sql express
Thanks this is very good teaching. However, this will not work on other computer unless you have the same environment as the original application machine, what are the requirements to install it on any computer client without bothering checking their environment?
An other question please; this works only on one project, but what if you have more than one project in your solution and they are all connected to gother?
Thanks in advance :)
Thanks for your comment. i have to be more practical about it.
@@SwiftLearn great tutorial, pls can you make a video for setting up the application and its environment on client machine. thank you
hey sir, what if i already have a database and created a table in sql server database, but in my debug* there is no extension for mdf and once i try to copy from Programming files to debug* file it says that the file is opened somewhere while everything is closed???
Restart the PC and try again. hope you will do.
If it didn't work, you should use ssms to see list of databases and detach the one you are going to use
Hello very nice . Is your application have build db and can store data for working.for example you store some data save close application and next time you open this app this data stored for reading.?
these data can be read modify and delete using application. thanks
Hi Sir,have
If my client PC dont have a SQL engine installed yet, the setup will automatically install SQL engine for it?
Yes. In that case you should select sql in prerequisites during the creation of setup file. Thanks 👍👍
Is the database part of the application?
like, I dont have to install sql server on client pc?
Try your experiment. thanks.
Is it temporary? I cant see the rows i added in the database.. Plz provide me the solution for permanent save..
Video error sir. Can't excute procesz
Can you make tutorial for postgresql too?
How to do it with a image type data in db. I mean add a field for image in that??
This is very easy. just see this tutorial czcams.com/video/SiSxjkTTRhw/video.html THANKS.
thanks for tutorial its work for my machine, but when try on client pc this error apprears "cannot be opened because it is version 852 this server supports version 655 and earlier" how to fix it
I have no idea right now. i will back after getting solution. thanks
Yes !!!!!! 😅👌🏻
Sir, can you still run the application whenever you lost your network connection?
No need to network to run this application.
i have already made the database but when i m clicking on user control(WPF) it is not showing any mdf file. plz help
So i have to check it in WPF. this tutorial is windows form application.
How to get setup project in vs 2012 exp. Version
Sir if i want to save any image setting so that when i run application again then it show me the last saved image
Hope you got my word... help me how to do it. For others pc. 🙏
If your image stored as binary image than it will be ok. if image in drive maintain the same directory in both PC. thanks.
How to dump csv file into ce data base and view ce data base from viewer.
My data is not saving to the database. It is always gone after I relaunch my program. Need help!
Copy the .mdf file and replace it in system directory installed folder. thanks.
Sir, when I added the database it did not connect to the database
In creating desktop apps(.exe) which is much better, java or c#?
I am c# programmer. started to study in java. i can not evaluate this time. thanks.
Both are good but java is mostly used for programming robots nowadays but it's still used for everything all I'm saying is c# is more practical for these type of things (.exe)
Hi, well it will work even without SQL Server installed in any other machine?
Yes it will work. But you must add SQL in prerequisites. thanks
thank you sir, but I am Getting an error
An Attempt to attach an auto named database for file (file.mdf) failed. a database with the same name exists, or specified file can't be opened, or it is located on UNC share.
how can i solve that
an error occured due to multiple reasons. try to solve one by one.
1. delete everything in installed location as well as .mdf and .ldf file(C Drive)
2. Create full permission in the installed location (C Drive).
than try. thanks.
@@SwiftLearn How to find install location? This is my problem, can you please explain little more clearly??
thnak you so mutch.
Most welcome. please subscribe.
How can i save database from installed computer if i am doing windows installation????
Try then let me know. but windows authentication mentioned server name in connectionstring. so .....
Sir, I have created a blank database using script (using Generate Script in the Sql Server, Server Explorer in Visual Studio 2015) I wish to make an exe to use a tool in vb. Thanks in advance
Very simple. Just follow this tutorial czcams.com/video/H01Tok3jpsw/video.html
thanks.
done too. thank u
great job dear.
100th Liker xD nice video
Thanks.
At 3:49 ,I'm unable to create table, there's is no option for add new table.how to add it?
You can add table using SQL Server than connect with the project. if you don't have Server Explorer go to view menu and click on Server Explorer. thanks.
Hi swift, nice video. Is it possible to protect the database with password
My data deletes after I put in records and close my system
what if there is crystal report involved? How can i connect it with already designed crystal reports?
I will make such tutorial as soon as possible. thanks
@@SwiftLearn Thanks Looking forward to it. Please make it priority as i am sure alot of people want to know.
It will support Backup and Restore?
Go to the installed directory and take the .mdf and .ldf file. all data available in this files. thanks,
.\ when you wrote this ... if it means it ll work in all computers so why mine is not working :((
Check connectionstring in web.confin as well as development file. because sometime its generate multiple connectionstring at using linq. connection string should be attachdb database.
@Swift Learn
Sir, you are awesome. you've helped me a lot.
I need one more help urgently.
"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\shopdb.mdf;Integrated Security=True"
Sir, this is my connection string. It works fine with my project solution. When I've tried to insert data it works fine till the project is in running mode but as soon as I stopped debugging it doesn't store in the Database.
The Actual problem is :
When I tried to install this project in client pc it shows a Database or Connection error while I'm trying to insert data But it works fine with the previous data (e.g. Login Page or fetching previously-stored record are working fine.)
Add prerequisites. Follow this tutorial and see how to add Prerequisites czcams.com/video/wwG6fc6mvFo/video.html
Hi sir this is good tutorial my setup is created successfully but when i run this application on other system i'm getting error :
a network relatedor instance .......provider : SQL network interface, error 26 error location server/ instance specified..
already install sql express 2012.
Select SQL server in prerequisites.
on another pc its say "cannot be opened because it is version 852 this server supports version 706 and earlier" how to fix it ?
May be its happened due to sql server version. do you have installed sql server in client PC? if yes, then your application database should be compatible with client database. thanks.
@@SwiftLearn what version should i install?
Hi Sir, I install it to another pc the setup I made but always shows error 26. please help me 🙏 Thank you sir
Select SQL server in prerequisites during creating setup file. then try to install once again. Thanks
hello dear my database doesn't publish with the setup file please help me?
Add SQL as prerequisites. to add prerequisites just follow this tutorial. czcams.com/video/H01Tok3jpsw/video.html
I'm having an error saying dat;
An error occured while signing: SignTool.exe not found
@Swift learn
hello, i am having a problem. in the database i set the datatype to be integer. when i query for the integer from the textbox, it says there is an error in the da.Fill(dt); line and says it only accepts integer. can you pls tell me how to fix it. thank you
i am very sorry, i forgot to parse the varchar to integer datatype. i watched the video once more to find it out. thank you making such an amazing tutorial
Almighty bless you to achieve goal. keep trying. thanks.
hello sir,
do we still need lan server or internet to make it work?
If already install VS, no need internet. ealse need internet during installation. i will make a tutorial which will allow to install withoiut interent. thanks.
@@SwiftLearn pls am waiting also, thanks
sir in this case SQL need to be installed ?
.net framework is enough to run this application.
Is there such solution to mysql database on phpmyadmin server ?
Thanks for your comment. i have to study PHP MySql
Nice video sir,
Sir how to take backup of database information after installation done. Suppose any problem occurs how to take backup and restore data on client machine? Plz replay
+1
Go to the installed folder C:\Program Files\ your installed folder. just take the .mdf and .ldf . Try and let me know. thanks.
I have problem with my own project that after i install it there is a problem that mention |Data Directory| please somebody helpp
Create full permission(Read Write) in the installed directory. Thanks.
@@SwiftLearn Thank you sir, the problem has solved
@@SwiftLearn I got error:
System.Data.SqlClient.SqlException (0x80131904): Directory lookup for the file "C:\Users\cuu99\AppData\Local\Apps\2.0\Data\O8XX813R.VG9\41Z8Q9LC.L1Y\ktxv..tion_0000000000000000_0001.0000_cc470ef13f032ec0\Data\ktxV3dot15.mdf" failed with the operating system error 5(Access is denied.).
Cannot attach the file 'C:\Users\cuu99\AppData\Local\Apps\2.0\Data\O8XX813R.VG9\41Z8Q9LC.L1Y\ktxv..tion_0000000000000000_0001.0000_cc470ef13f032ec0\Data\ktxV3dot15.mdf' as database 'ktxV3dot15'.
How to fix it bro?
Database readonly error after setup installation how solve it
??
Go to the installed location and apply full permission. read and write. full control.
@@SwiftLearn Where? C:\User\user-name\AppData\043249\42390423\Data?
@@drratioo Right click on shortcut in the desktop - Click on Open File Location. you can get the file location. Thanks
Where did you get the contents of the application files from??
Installed location. C - Program Files -
sir how to create same for SQL Server Compact Edition Database File (.sdf) this type of file
I have to create report viewing application wit this type of data base
Hello, the database is deleted when the update is made. How do we set it.
Thanks for your comment. you may get more information from this tutorial. czcams.com/video/H01Tok3jpsw/video.html thanks.
Can I add code on the (close) button on the form?
I want to redirect the user to another window when the close (x) button is clicked.
btw liked and subbed ;) keep up the good work
of course you can. Thanks for your comment and support me. all the programming concept and tutorial available in this channel. keep connected.
@@SwiftLearn when i double click the form, i can code the close button there? thanks for the response :D
@@zerosandones7547 great bro
There'sno option of .netframework 4 client profile in my prerequisite please help.
Scroll down and check. thanks
@@SwiftLearn i didn't expect that stupid reply, obviously i had checked everything by scrolling before i came here to ask you.
@@zainuddin9484 do you use VS 2010. If its upper or lower it may change .net framework version. i will try with upper version of visual studio and let you know. thanks.
Sir I followed the same procedure as mentioned above but I'm unable to connect to the database on my other PC.
Can you please help. Its a bit urgent
I have sent you a request on FB as well. Or please contact me over mail at: arpit.agrawal.0226@gmail.com
If you add .mdf database it will work. noted that you should use prerequisites sql server 2008 Express . Watch this tutorial from 16:15 minutes to 20:00 minutes czcams.com/video/H01Tok3jpsw/video.html
I am still getting the error - Server was not found or was not accessible. Plz Help me out sir
Create setup file with prerequisites with SQL Server. Thanks
i have error ===>>"an error occurred: A network-related or instance-specific error occurred while esablishing a connection to SQL Server. The Server was not found or was not accessible.Verify that instance name is correct and that SQL Server is configured to allow remote connection. (provider: SQL Network Interface, error 50: - Local Database Runtime error occurred. The specified LocalDB instance does not exist.)" when i setup in different computer and this is my connectionString ===>> connectionString="Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\dbdema.mdf;Integrated Security=True;Connect Timeout=30"
Watch video once again and put @ for example @"Data Source=(..... and let me know. please like subscribe and share.
@@SwiftLearn I have similar error even after following your steps completely... The error is "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The Server was not found or was not accessible.Verify that instance name is correct and that SQL Server is configured to allow remote connection. (provider: SQL Network Interface, error 52: - Unable to locate a Local Database Runtime Installation. Verify that SQL Server Express is properly installed and that Local Database Runtime feature is enabled.)."
plz install sql server on your pc first on which you are installing setup.