How to Create Setup.exe in Visual Studio 2019 with SQL Database | FoxLearn
ฝัง
- เผยแพร่เมื่อ 9 ก.ย. 2024
- How to Create Setup exe in Visual Studio 2019 with SQL Local Database C# Windows Forms Application.
Website: foxlearn.com
Through this video you will learn:
create setup.exe in visual studio 2019
visual studio 2019 installer project tutorial
microsoft visual studio 2019 installer projects
how to create msi package in visual studio 2019
how to create setup.exe in visual studio 2019
how to create setup file in visual studio 2019 for windows application step by step
microsoft visual studio 2019 installer projects tutorial
how to create an installation package in visual studio 2019
how to create setup file in visual studio 2019 with sql server database
how to create setup file in visual studio 2019 for windows application with database
how to create exe file in c# windows application with sql server database
how to create setup file(.exe) with database in visual studio 2019
how to create setup file with sql database in c#
create setup windows form application c#
Thank you so much for this. This is such a basic thing but no one tells about it. I hope I can someday contribute to people and TH-cam.
You're welcome. Thank you so much !
i know Im asking randomly but does anybody know a trick to get back into an Instagram account..?
I was dumb forgot my account password. I would love any tricks you can give me!
Can you create a video to show "How to Create Setup.exe in Visual Studio 2022 with EF Core 7.0 or 8.0 ?
a) Where the .mdf file will installed after setup is finished?
b) To run the appliction, it is necessary MSSQLServer Express is installed on the computer?
c) Do i need a license if i sell an application with included mdf database?
Thanks for your useful videos! Very often they helped!
The great channel about C#, thank you very much!!!
Thank you so much !
Hi fox,I built a little softaware in c# .I'm not so experienced.My question is: "Can yo do a tuto where you create an app with sqlite database an create setup for it with the intergrated sqlite database
Hi
Many thanks for a nice tutorial.
However, I have one question:
When I install the setup.exe in another computer or laptop, do I need to install sqlserver in that machine?
Kind regards
VENU
Many thanks to you; the content is well explained. Thank you so much
You're welcome. Thank you !
Thanks man. I fixed the error!
Çok Teşekkür Ederim Türkiyeden selamlar olsun sizlere
Thank you
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 sooooooooo much...... keep going on.
Thank you !
That's a great explanation appreciated
Thank you !
Thankyou soo much Fox Learn
You're welcome. Thank you !
Thanks a lot ❤️👏
Is this procedure applicable to .Net CORE?
Thanks i will us am using this for my new video
Thank you for the video every thing clear and easy to understand i installed in my laptop and everything work perfectly but when I installed to client pc he cant access to database
will this also apply if I had made my database in xampp sql?
Is the Setup Project used for building C++ win form apps?
Fox Learn, I have been following you for a while now. But, I have seen where people here are writing to you and the only thing is that you only reply to the positive content to you. Can you reply to those that I really asking for help? That would be greatly appreciated. Thank you.
Thank you ❤❤❤
great!
Many thanks!
You're welcome. Thank you !
Really many thanks
Thank you !
I followed this tutorial for my console application. When I deploy it to another computer, I receive an error when attempting to access the database: C:....\AppDatabase.mdf cannot be upgraded because it is read-only, has read-only files or the user does not have permissions to modify some of the files. Make the database or files writeable, and rerun recovery. An attempt to attach an auto-named database for file C:\Program Files (x86)|....\AppDatabase.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share."
hi,
I'm working with postgresql
how to create .exe setup with postgresql?
Thanks
OK. Thank you for your suggestion. I'll make tutorial soon
If we create a SQL server database & connect it to the windows forms application & then copy the ".mdf" file from the SQL server & paste it in the project folder & use that .mdf file while creating the setup will it work ?
Yes, it will work if you modify your connection string is attached database. and your client computer should install sql express or local database
Failed to update database because the file is read only? How to fixed that?
Hi your explanation is good....
I created desktop application with service basedatabase,when I try to install it is another system I am getting this error :- The database 'ProjectsV12' cannot be opened because it is version 782 This server supports version 706 and earler. A downgrade path is not supported.
I get the same problem
I get the same error in 2023 😢. Did you find a solution?
thank you so much
Thank you !
can I run this setup.exe on another computer
I tried but failed
Hello FoxLearn. Would you mind posting a video about creating a setup.exe video in visual studio with a C# windows application using entity framework/MySql database ? thanks
OK. Thank you for your suggestion
ขอบคุณครับ
Thank you !
Hi!! Please, do you have a vídeo to create a setup.exe of aplication with database SQL Server Express? not local.
But what the meaning of this all if can't save those data and recall it on form when I next time open it. It seems unusable thing. Is there a way to save this data ?
So nice video!!! Thank you! Have you ever tried to create setup exe with squirrel
OK. Thank you for your suggestion.
On this way, if i update my program to client, does the database will be reset ?
Hello;
I have an issue when i change the computer the data base are inknown
Can you please help me
why is my visual studio 2019 don't have setup? anyone can help me..
good job
Thank you !
I canot insert any values....it shows read only database
Please is this available for c++ in visual studio 2022?
How about SQL Server 2019? How can I create Setup.exe with Visual Studio 2019 and a Database created on SQL Server 2019 ( Sql server management studio )?
Yes, you can do that
Fox Learn how???
@@foxlearn How??
when i opened service based Database from existing item it shows error... DB.MDF can't open beacause it's version 904 and This server support version 852 and earlier....Help me please
i think you should create your database in old version, when creating the setup file you should add prerequires to new version or the same version of your sql database.
thank you for video .. can we use Linq to Sql in project that we used sqllocaldb?
OK, You can do that
@@foxlearn thank you.. can u suggest any video including how to do it ?
i have a .dbo sql server database connected to my application no ( .md ) there will be a problem when a transfer the .exe programm to other computer?
I think you should attach your database inside setup file
How to Create Setup.exe in Visual Studio 2019 with MySQL Database? please help thanks.
Will this be working on client's pc without any sql installation or changing the connection string???
Yes, you don't need change the connection string, sql server will be installed when installing the setup
@@foxlearn thanks , I like all videoes.
@@foxlearn i used SQLSERVER2019 . can i need to install SQLSERVER2019 on client machine??
@@foxlearn will this work even if you didn't include sqlexpress on the prerequisites?
@@foxlearn when i installed in my pc every thing work perfectly but when i installed in client pc i cant access to the local data base and show me error
Hello I made this but I'm getting an error. setup project features net framework and select sql 2012 localdb. I get sqlcmdnutils.msi error when installing. what is solution ? thanks
please this is so important for me . please contact me .
Can you post error details at c-sharpcode.com .Thank you !
i cant find Setup project in my VS 2019 Community. Where can i download it?
Open your Visual Studio, then Extensions=>Online=> Search Microsoft Visual Studio Installer Projects
Fox Learn thanks!
Please provide background music links as well in the description
OK. Thank you for your suggestion !
I tried this solution but every time I install I need to provide permissions for my mdf and ldf files for the user or else it doesn't allow me to write or update the database. Is there any possible fix ?
@Gosai Rajendra I have tried everything but it wont be possible any other way. We need to create the database files in the tmp folder that is when you can have full access and control over it.
How can I do that with WPF application?
it is not working on the other pc when I try to install it. it shows the database error. it works only on the pc from which we have created. can you help me out with this? I want to run on to another pc.
I think you should include sql server express when installing your app
@@foxlearn its still not working
I don't know why, but I followed the steps and yet whenever I make some changes in my data, it says my database is real-only. I tried to look at my database properties but can't locate the "Read-only" so I downloaded SQL server management. I found out that whenever I install the app on my laptop it gets converted into "Read-Only" can you show what to do? or do I really have to use SQL server management to fix it all the time when it gets installed?
Don't Install your project in Program Files Folder
@@progalion4647 where should it be installed?
@@NTKM-om9vn wow , it was 1 year ago , um I almost remember you have to install it anywhere else than Program Files
If the client wanted to access directly to the local database he open it from management studio ? And is there a way to access it online ?
You should attach your database to sql server, then client can connect via lan or internet
@@foxlearn you mean attach the database to sql server on the client's computer ?
hi how to fix database read only error in service based database ? it is not working in my pc and pc cliendt
@@esat986 hocam cevabiniz icin tesekkurler. Kurulu dizin ve alt dizinlere izin verdim sorun kalmadi.
not working when i install it on other computer, it says problem with sql server, any idea how to fix this?
You should tick sql server at prerequisite dialog box
@@foxlearn the whole folder or just the tables?
How can I create the setup file?
In this way you can perform automatic updates?
If you want you make your software automatically update you can use click once setup
I did exactly what you did, but when I installed the app on another computer doesn't work!!! Could you tell me why? Please
What error are you getting? Have you attach your database inside setup file?
@@foxlearn thank you for replay
My error is about database, because the form show and work, but without data.
I think I didn't attach.
@@foxlearn it works but my data that I have in database like customers name and address doesnt show. All deleted?!
@@hossienhassanhamow3489 maybe the database change to read only
@@ChrisTian-sd5yq I don't know, I have to check it
how to create .exe file of windows form project with MySQL database in visual studio 2019?
Thank you for your suggestion. I'll make tutorial soon
Please can you do the same using a WIX toolset
OK. Thank you for your suggestion !
how about Microsoft Access database?
OK. I'll upload soon !
How to fix database read only error in service based database ?
Set it readable and writable to everyone in their properties
If You mean database file property .
So I do it but its not working my PC and virtual machine.
Any other suggestions ?
@@ahmadsaad8743 hi bro i have the same problem. How do you fixed it?
cant open the app after installing
What error are you getting?
THERE IS AN ERROR " DATABASE IS READ ONLY"
Same error
Thank you very much
Thank you !