How to Create Setup File With attaching SQL Database .mdf with proof in c# windows application

How to Create Setup File With attaching SQL Database .mdf with proof in c# windows application

Swift Learn

5 лет назад

92,389 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

@rahimmughal4552
@rahimmughal4552 - 16.02.2019 23:35

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

Ответить
@louureghz
@louureghz - 01.12.2023 03:51

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

Ответить
@xbxb
@xbxb - 05.09.2023 05:01

in the .config.deploy. The connection string is still the sqlserver

Ответить
@MuhammadIbrahim-uc1nc
@MuhammadIbrahim-uc1nc - 09.08.2023 22:09

Do you know how to install Update of window form application with also update in database sql server without deleting perivious database?

Ответить
@edsonferraz1
@edsonferraz1 - 06.08.2023 17:02

Hi Sir, In the step "Application Files" when attempt is I include the files not display the database files.
Please, do you can help me.
My connection string is:
@"Data Source=EDSON_FERRAZ\SQLEXPRESS; Integrated Security=false; Initial Catalog=VendasDB; User ID=sa; password=278012";

Ответить
@edsonferraz1
@edsonferraz1 - 06.08.2023 17:01

Hi Sir, In the step "Application Files" when attempt is I include the files not display the database files.
Please, do you can help me.
My connection string is:
@"Data Source=EDSON_FERRAZ\SQLEXPRESS; Integrated Security=false; Initial Catalog=VendasDB; User ID=sa; password=278012";

Ответить
@edsonferraz1
@edsonferraz1 - 06.08.2023 16:59

Hi Sir, In the step "Application Files" when attempt is I include the files not display the database files.
Please, do you can help me.
My connection string is:
@"Data Source=EDSON_FERRAZ\SQLEXPRESS; Integrated Security=false; Initial Catalog=VendasDB; User ID=sa; password=278012";

Ответить
@shamlanpro
@shamlanpro - 25.05.2023 17:30

Yes Yes it will not work at ohter computer out of your local network. Yes Yes 😒🙄😬Nooooooooo

Ответить
@StatuswalaHarsh
@StatuswalaHarsh - 20.05.2023 11:50

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.

Ответить
@leonroutzounis383
@leonroutzounis383 - 14.01.2023 09:37

Very nice, One question. How does one backup and restore the database in the created file?

Ответить
@Code_with_Iphie
@Code_with_Iphie - 13.01.2023 04:02

My data deletes after I put in records and close my system

Ответить
@Code_with_Iphie
@Code_with_Iphie - 07.01.2023 04:25

Sir, when I added the database it did not connect to the database

Ответить
@kylevargas7530
@kylevargas7530 - 29.10.2022 09:24

Worth to watch and subscribe

Ответить
@AbdulMajid-le9yz
@AbdulMajid-le9yz - 15.09.2022 14:40

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

Ответить
@joshuaayomide1547
@joshuaayomide1547 - 23.08.2022 22:00

I'm having an error saying dat;


An error occured while signing: SignTool.exe not found

Ответить
@letuslearn8433
@letuslearn8433 - 25.07.2022 08:06

Nice video bro.just keep it up

Ответить
@Shubham_848Vlog
@Shubham_848Vlog - 01.07.2022 04:23

How to dump csv file into ce data base and view ce data base from viewer.

Ответить
@Shubham_848Vlog
@Shubham_848Vlog - 30.06.2022 04:53

sir how to create same for SQL Server Compact Edition Database File (.sdf) this type of file

Ответить
@tunpeter7564
@tunpeter7564 - 19.05.2022 08:50

Hello Sir, may i ask that the prerequisite for the Microsoft .net framework must use client profile?

Ответить
@taimoorshehzad2477
@taimoorshehzad2477 - 06.03.2022 09:43

Bro how can I contact you ?

Ответить
@gulshanchauhan6875
@gulshanchauhan6875 - 19.02.2022 14:45

Thanks

Ответить
@sardorbektalatov3078
@sardorbektalatov3078 - 30.11.2021 18:33

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

Ответить
@joshuareyes2939
@joshuareyes2939 - 20.08.2021 18:54

Hi Sir, I install it to another pc the setup I made but always shows error 26. please help me 🙏 Thank you sir

Ответить
@selvarani9386
@selvarani9386 - 20.07.2021 21:52

Iam trying a lot without installing sqlserver. But your video is best and good. It's working nicely 😊😊

Ответить
@thanhvan3528
@thanhvan3528 - 11.07.2021 19:19

Hi Sir,have
If my client PC dont have a SQL engine installed yet, the setup will automatically install SQL engine for it?

Ответить
@ShahVicky
@ShahVicky - 15.06.2021 05:46

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

Ответить
@tomail1167
@tomail1167 - 22.05.2021 09:57

thank you for this video, and i want ask: what is the maximum size for this database?

Ответить
@hitendusseja6615
@hitendusseja6615 - 09.04.2021 07:59

Thank you very much sir, was looking for this since a very long time

Ответить
@devni1565
@devni1565 - 18.03.2021 15:37

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?

Ответить
@jersondomalaon1505
@jersondomalaon1505 - 01.03.2021 05:10

Thank you so much more blessings to come

Ответить
@boujaoudkamal3727
@boujaoudkamal3727 - 22.02.2021 15:28

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

Ответить
@PawanKumar-hj8sn
@PawanKumar-hj8sn - 12.02.2021 17:19

Is it temporary? I cant see the rows i added in the database.. Plz provide me the solution for permanent save..

Ответить
@rameshpudi4817
@rameshpudi4817 - 09.02.2021 09:39

in visual studio 2015 it is possible .i am not getting that version dataset

Ответить
@umairrehman2703
@umairrehman2703 - 05.02.2021 09:50

I have created a desktop Application using wpf window form Application c# with MS SQL SERVER as database Mow i want to create exe file or setup , so that i can install it on client computer I tried all the ways , search through internet alot of times but unable to create exe .... I am looking for c# wpf expert who knew how to handle this .

Ответить
@sagarutwani4739
@sagarutwani4739 - 31.01.2021 22:19

i have created database with tables, procedure and all, so how to bring that database complete file in project

Ответить
@kaushikdayalan924
@kaushikdayalan924 - 18.01.2021 22:38

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.

Ответить
@cvtchannel9538
@cvtchannel9538 - 15.01.2021 13:27

where is app.config ??????????

Ответить
@carltechviews605
@carltechviews605 - 09.01.2021 18:33

Wow, this is what I've search for. Now i know it. Thanks to u sir.

Ответить
@shaficicabdi9553
@shaficicabdi9553 - 09.01.2021 09:33

hi Swift Learn
I have one more Query

Ответить
@mahmoodalgoul3717
@mahmoodalgoul3717 - 27.12.2020 22:37

Hi, well it will work even without SQL Server installed in any other machine?

Ответить
@malgoul
@malgoul - 27.12.2020 22:18

Sir you can deploy the project without install sql server express?

Ответить
@muhammadrasul1581
@muhammadrasul1581 - 26.12.2020 23:10

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

Ответить
@jagulgachig.p213
@jagulgachig.p213 - 23.12.2020 19:32

sir please share source code lonk

Ответить
@zerosandones7547
@zerosandones7547 - 18.12.2020 08:00

How do you add icons when installing/publishing this way? I cant see icons when going to the control panel or desktop icon.

Ответить
@zerosandones7547
@zerosandones7547 - 17.12.2020 14:50

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?

Ответить
@shwetapapdiwal5307
@shwetapapdiwal5307 - 22.11.2020 09:55

Hello sir
Plz how to solve error
Severity Code Description Project File Line Suppression State Error An error occurred while signing: SignTool.exe was not found at path C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\bin\signtool.exe. DEMO_Project

Ответить
@fujiahermawan8
@fujiahermawan8 - 18.11.2020 08:03

on another pc its say "cannot be opened because it is version 852 this server supports version 706 and earlier" how to fix it ?

Ответить