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#

ความคิดเห็น • 134

  • @sushilsinghal6387
    @sushilsinghal6387 4 ปีที่แล้ว +3

    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.

    • @foxlearn
      @foxlearn  3 ปีที่แล้ว +1

      You're welcome. Thank you so much !

    • @ashtonmalakai8674
      @ashtonmalakai8674 3 ปีที่แล้ว

      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!

  • @nelsonrivers8546
    @nelsonrivers8546 9 หลายเดือนก่อน +1

    Can you create a video to show "How to Create Setup.exe in Visual Studio 2022 with EF Core 7.0 or 8.0 ?

  • @mikeb6006
    @mikeb6006 ปีที่แล้ว +1

    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!

  • @temirkhanamanbaev42
    @temirkhanamanbaev42 4 ปีที่แล้ว

    The great channel about C#, thank you very much!!!

    • @foxlearn
      @foxlearn  3 ปีที่แล้ว

      Thank you so much !

  • @LoveAndFun-y5c
    @LoveAndFun-y5c 2 ปีที่แล้ว +1

    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

  • @gudgolfer
    @gudgolfer 2 ปีที่แล้ว +2

    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

  • @issamtoufella4760
    @issamtoufella4760 4 ปีที่แล้ว +1

    Many thanks to you; the content is well explained. Thank you so much

    • @foxlearn
      @foxlearn  3 ปีที่แล้ว

      You're welcome. Thank you !

  • @nekdan
    @nekdan 2 ปีที่แล้ว

    Thanks man. I fixed the error!

  • @hasanaslan9840
    @hasanaslan9840 3 ปีที่แล้ว

    Çok Teşekkür Ederim Türkiyeden selamlar olsun sizlere

    • @foxlearn
      @foxlearn  3 ปีที่แล้ว

      Thank you

  • @StatuswalaHarsh
    @StatuswalaHarsh ปีที่แล้ว

    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.

  • @mdziaulhaq2576
    @mdziaulhaq2576 4 ปีที่แล้ว

    Thank you sooooooooo much...... keep going on.

    • @foxlearn
      @foxlearn  4 ปีที่แล้ว

      Thank you !

  • @solutions4software
    @solutions4software 5 ปีที่แล้ว

    That's a great explanation appreciated

    • @foxlearn
      @foxlearn  5 ปีที่แล้ว +1

      Thank you !

  • @ashirafzal6771
    @ashirafzal6771 4 ปีที่แล้ว

    Thankyou soo much Fox Learn

    • @foxlearn
      @foxlearn  4 ปีที่แล้ว

      You're welcome. Thank you !

  • @bidawialsaedi7533
    @bidawialsaedi7533 2 ปีที่แล้ว

    Thanks a lot ❤️👏

  • @ahmedzubaca4755
    @ahmedzubaca4755 2 ปีที่แล้ว +1

    Is this procedure applicable to .Net CORE?

  • @Hxlip09xStickman
    @Hxlip09xStickman 4 ปีที่แล้ว

    Thanks i will us am using this for my new video

  • @kamelsoltani3935
    @kamelsoltani3935 ปีที่แล้ว +1

    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

  • @ejdelara2460
    @ejdelara2460 17 วันที่ผ่านมา

    will this also apply if I had made my database in xampp sql?

  • @jeffersoneener9071
    @jeffersoneener9071 3 ปีที่แล้ว +1

    Is the Setup Project used for building C++ win form apps?

  • @aleemosi
    @aleemosi 11 หลายเดือนก่อน

    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.

  • @ravindutharaka519
    @ravindutharaka519 3 ปีที่แล้ว

    Thank you ❤❤❤

  • @massmedialaser3399
    @massmedialaser3399 3 ปีที่แล้ว

    great!

  • @manjeetnandal1
    @manjeetnandal1 5 ปีที่แล้ว

    Many thanks!

    • @foxlearn
      @foxlearn  5 ปีที่แล้ว

      You're welcome. Thank you !

  • @petertharwat7352
    @petertharwat7352 5 ปีที่แล้ว

    Really many thanks

    • @foxlearn
      @foxlearn  5 ปีที่แล้ว

      Thank you !

  • @raniradcliff4718
    @raniradcliff4718 ปีที่แล้ว

    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."

  • @Mycotta01
    @Mycotta01 4 ปีที่แล้ว +2

    hi,
    I'm working with postgresql
    how to create .exe setup with postgresql?
    Thanks

    • @foxlearn
      @foxlearn  3 ปีที่แล้ว

      OK. Thank you for your suggestion. I'll make tutorial soon

  • @deveshvagal3238
    @deveshvagal3238 4 ปีที่แล้ว +2

    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 ?

    • @foxlearn
      @foxlearn  4 ปีที่แล้ว +3

      Yes, it will work if you modify your connection string is attached database. and your client computer should install sql express or local database

  • @xbxb
    @xbxb ปีที่แล้ว

    Failed to update database because the file is read only? How to fixed that?

  • @mdziaulhaq2576
    @mdziaulhaq2576 4 ปีที่แล้ว +1

    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.

    • @kamelsoltani3935
      @kamelsoltani3935 ปีที่แล้ว +1

      I get the same problem

    • @MuteebQ
      @MuteebQ 10 หลายเดือนก่อน

      I get the same error in 2023 😢. Did you find a solution?

  • @AyyashKLD
    @AyyashKLD 4 ปีที่แล้ว

    thank you so much

    • @foxlearn
      @foxlearn  4 ปีที่แล้ว +1

      Thank you !

  • @toilahoang7466
    @toilahoang7466 6 หลายเดือนก่อน

    can I run this setup.exe on another computer
    I tried but failed

  • @edgareldy
    @edgareldy 5 ปีที่แล้ว +1

    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

    • @foxlearn
      @foxlearn  5 ปีที่แล้ว

      OK. Thank you for your suggestion

  • @when_if_then_else
    @when_if_then_else 5 ปีที่แล้ว

    ขอบคุณครับ

    • @foxlearn
      @foxlearn  5 ปีที่แล้ว

      Thank you !

  • @edsonferraz1
    @edsonferraz1 ปีที่แล้ว

    Hi!! Please, do you have a vídeo to create a setup.exe of aplication with database SQL Server Express? not local.

  • @rv9570
    @rv9570 4 ปีที่แล้ว

    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 ?

  • @bojidarkamenski3432
    @bojidarkamenski3432 5 ปีที่แล้ว

    So nice video!!! Thank you! Have you ever tried to create setup exe with squirrel

    • @foxlearn
      @foxlearn  5 ปีที่แล้ว

      OK. Thank you for your suggestion.

  • @arambahram2967
    @arambahram2967 3 ปีที่แล้ว

    On this way, if i update my program to client, does the database will be reset ?

  • @boujaoudkamal3727
    @boujaoudkamal3727 3 ปีที่แล้ว

    Hello;
    I have an issue when i change the computer the data base are inknown
    Can you please help me

  • @jimuelmadlangsakay1870
    @jimuelmadlangsakay1870 2 ปีที่แล้ว

    why is my visual studio 2019 don't have setup? anyone can help me..

  • @alirezaabedi1885
    @alirezaabedi1885 5 ปีที่แล้ว

    good job

    • @foxlearn
      @foxlearn  5 ปีที่แล้ว

      Thank you !

  • @sonatteaa9818
    @sonatteaa9818 3 ปีที่แล้ว

    I canot insert any values....it shows read only database

  • @djamelboukhedir2000
    @djamelboukhedir2000 2 ปีที่แล้ว

    Please is this available for c++ in visual studio 2022?

  • @abdechafineji8782
    @abdechafineji8782 4 ปีที่แล้ว

    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 )?

  • @cybertree7571
    @cybertree7571 3 ปีที่แล้ว

    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

    • @foxlearn
      @foxlearn  3 ปีที่แล้ว

      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.

  • @feyyazaki1740
    @feyyazaki1740 4 ปีที่แล้ว

    thank you for video .. can we use Linq to Sql in project that we used sqllocaldb?

    • @foxlearn
      @foxlearn  4 ปีที่แล้ว

      OK, You can do that

    • @feyyazaki1740
      @feyyazaki1740 4 ปีที่แล้ว

      @@foxlearn thank you.. can u suggest any video including how to do it ?

  • @Nighthawk11791
    @Nighthawk11791 4 ปีที่แล้ว

    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?

    • @foxlearn
      @foxlearn  3 ปีที่แล้ว

      I think you should attach your database inside setup file

  • @bulentozben1603
    @bulentozben1603 2 ปีที่แล้ว

    How to Create Setup.exe in Visual Studio 2019 with MySQL Database? please help thanks.

  • @mprincehanad
    @mprincehanad 5 ปีที่แล้ว +1

    Will this be working on client's pc without any sql installation or changing the connection string???

    • @foxlearn
      @foxlearn  5 ปีที่แล้ว +4

      Yes, you don't need change the connection string, sql server will be installed when installing the setup

    • @dharmathedare
      @dharmathedare 3 ปีที่แล้ว

      @@foxlearn thanks , I like all videoes.

    • @cybertree7571
      @cybertree7571 3 ปีที่แล้ว

      @@foxlearn i used SQLSERVER2019 . can i need to install SQLSERVER2019 on client machine??

    • @zerosandones7547
      @zerosandones7547 3 ปีที่แล้ว

      @@foxlearn will this work even if you didn't include sqlexpress on the prerequisites?

    • @kamelsoltani3935
      @kamelsoltani3935 ปีที่แล้ว

      @@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

  • @thoejan8820
    @thoejan8820 5 ปีที่แล้ว

    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

    • @thoejan8820
      @thoejan8820 5 ปีที่แล้ว

      please this is so important for me . please contact me .

    • @foxlearn
      @foxlearn  5 ปีที่แล้ว

      Can you post error details at c-sharpcode.com .Thank you !

  • @axzuremc
    @axzuremc 4 ปีที่แล้ว +1

    i cant find Setup project in my VS 2019 Community. Where can i download it?

    • @foxlearn
      @foxlearn  4 ปีที่แล้ว +2

      Open your Visual Studio, then Extensions=>Online=> Search Microsoft Visual Studio Installer Projects

    • @axzuremc
      @axzuremc 4 ปีที่แล้ว

      Fox Learn thanks!

  • @shreyasj1596
    @shreyasj1596 4 ปีที่แล้ว

    Please provide background music links as well in the description

    • @foxlearn
      @foxlearn  3 ปีที่แล้ว +1

      OK. Thank you for your suggestion !

  • @kaushikdayalan924
    @kaushikdayalan924 3 ปีที่แล้ว

    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 ?

    • @kaushikdayalan924
      @kaushikdayalan924 3 ปีที่แล้ว

      @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.

  • @abdechafineji8782
    @abdechafineji8782 3 ปีที่แล้ว

    How can I do that with WPF application?

  • @pratiksinhmakwana6986
    @pratiksinhmakwana6986 3 ปีที่แล้ว

    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.

    • @foxlearn
      @foxlearn  3 ปีที่แล้ว +1

      I think you should include sql server express when installing your app

    • @pratiksinhmakwana6986
      @pratiksinhmakwana6986 3 ปีที่แล้ว

      @@foxlearn its still not working

  • @randomgaming2278
    @randomgaming2278 4 ปีที่แล้ว

    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?

    • @progalion4647
      @progalion4647 3 ปีที่แล้ว

      Don't Install your project in Program Files Folder

    • @NTKM-om9vn
      @NTKM-om9vn ปีที่แล้ว

      @@progalion4647 where should it be installed?

    • @progalion4647
      @progalion4647 ปีที่แล้ว

      @@NTKM-om9vn wow , it was 1 year ago , um I almost remember you have to install it anywhere else than Program Files

  • @hamdiayadi9815
    @hamdiayadi9815 4 ปีที่แล้ว

    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 ?

    • @foxlearn
      @foxlearn  4 ปีที่แล้ว

      You should attach your database to sql server, then client can connect via lan or internet

    • @hamdiayadi9815
      @hamdiayadi9815 4 ปีที่แล้ว

      @@foxlearn you mean attach the database to sql server on the client's computer ?

  • @ArunTr
    @ArunTr 4 ปีที่แล้ว

    hi how to fix database read only error in service based database ? it is not working in my pc and pc cliendt

    • @ArunTr
      @ArunTr 4 ปีที่แล้ว +1

      @@esat986 hocam cevabiniz icin tesekkurler. Kurulu dizin ve alt dizinlere izin verdim sorun kalmadi.

  • @haithamwehbi6552
    @haithamwehbi6552 3 ปีที่แล้ว

    not working when i install it on other computer, it says problem with sql server, any idea how to fix this?

    • @foxlearn
      @foxlearn  3 ปีที่แล้ว

      You should tick sql server at prerequisite dialog box

    • @haithamwehbi6552
      @haithamwehbi6552 3 ปีที่แล้ว

      @@foxlearn the whole folder or just the tables?

  • @cloud77hot40
    @cloud77hot40 3 ปีที่แล้ว

    How can I create the setup file?

  • @stalin2789
    @stalin2789 3 ปีที่แล้ว

    In this way you can perform automatic updates?

    • @foxlearn
      @foxlearn  3 ปีที่แล้ว

      If you want you make your software automatically update you can use click once setup

  • @hossienhassanhamow3489
    @hossienhassanhamow3489 3 ปีที่แล้ว

    I did exactly what you did, but when I installed the app on another computer doesn't work!!! Could you tell me why? Please

    • @foxlearn
      @foxlearn  3 ปีที่แล้ว

      What error are you getting? Have you attach your database inside setup file?

    • @hossienhassanhamow3489
      @hossienhassanhamow3489 3 ปีที่แล้ว

      @@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.

    • @hossienhassanhamow3489
      @hossienhassanhamow3489 3 ปีที่แล้ว

      @@foxlearn it works but my data that I have in database like customers name and address doesnt show. All deleted?!

    • @ChrisTian-sd5yq
      @ChrisTian-sd5yq 3 ปีที่แล้ว

      @@hossienhassanhamow3489 maybe the database change to read only

    • @hossienhassanhamow3489
      @hossienhassanhamow3489 3 ปีที่แล้ว

      @@ChrisTian-sd5yq I don't know, I have to check it

  • @sinthi315
    @sinthi315 4 ปีที่แล้ว

    how to create .exe file of windows form project with MySQL database in visual studio 2019?

    • @foxlearn
      @foxlearn  3 ปีที่แล้ว

      Thank you for your suggestion. I'll make tutorial soon

  • @mzansi_kleva
    @mzansi_kleva 5 ปีที่แล้ว

    Please can you do the same using a WIX toolset

    • @foxlearn
      @foxlearn  5 ปีที่แล้ว

      OK. Thank you for your suggestion !

  • @xfedelx
    @xfedelx 5 ปีที่แล้ว

    how about Microsoft Access database?

    • @foxlearn
      @foxlearn  5 ปีที่แล้ว

      OK. I'll upload soon !

  • @ahmadsaad8743
    @ahmadsaad8743 5 ปีที่แล้ว

    How to fix database read only error in service based database ?

    • @ABsazerNer
      @ABsazerNer 5 ปีที่แล้ว

      Set it readable and writable to everyone in their properties

    • @ahmadsaad8743
      @ahmadsaad8743 5 ปีที่แล้ว

      If You mean database file property .
      So I do it but its not working my PC and virtual machine.
      Any other suggestions ?

    • @ArunTr
      @ArunTr 4 ปีที่แล้ว

      @@ahmadsaad8743 hi bro i have the same problem. How do you fixed it?

  • @KeijiJohnLibadisos
    @KeijiJohnLibadisos 4 ปีที่แล้ว

    cant open the app after installing

    • @foxlearn
      @foxlearn  4 ปีที่แล้ว

      What error are you getting?

  • @sanjeevarora3735
    @sanjeevarora3735 4 ปีที่แล้ว

    THERE IS AN ERROR " DATABASE IS READ ONLY"

  • @jkeee1800
    @jkeee1800 3 ปีที่แล้ว

    Thank you very much

    • @foxlearn
      @foxlearn  3 ปีที่แล้ว

      Thank you !