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

Рет қаралды 92,623

5 жыл бұрын

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

Пікірлер: 281

@rahimmughal4552 5 жыл бұрын

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

@SwiftLearn 5 жыл бұрын

Watch video once again and put @ for example @"Data Source=(..... and let me know. please like subscribe and share.

@rahimmughal4552 5 жыл бұрын

@@SwiftLearn Sir Thanks For Your love, & for Pinning My Comment :*

@SwiftLearn 5 жыл бұрын

@@rahimmughal4552 Try with [User] or dbo.user. if still not solve connect with me in facebook.com/rowshanp

@rahimmughal4552 5 жыл бұрын

@@SwiftLearn Let Me try With dbo.user / Others names Sir

@rahimmughal4552 5 жыл бұрын

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

@selvarani9386 3 жыл бұрын

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

@sardorbektalatov3078 2 жыл бұрын

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

@hitendusseja6615 3 жыл бұрын

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

@cmcotrading 2 ай бұрын

I love your energy! This is what i was looking for

@SwiftLearn 2 күн бұрын

So glad! Thanks for your comment. Please keep connected.

@carltechviews605 3 жыл бұрын

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

@SwiftLearn 3 жыл бұрын

You are most welcome🌹🌹

@ahmed_raaphat 3 жыл бұрын

That is exactly what iam looking for! thanks a lot .

@SwiftLearn 3 жыл бұрын

Glad I could help! please keep in touch.

@globalinvest9275 5 жыл бұрын

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.

@SwiftLearn 5 жыл бұрын

Thanks for your comment. Please share to help others

@jedzernaofficial3942 4 жыл бұрын

How did you fix it please😭

@zainuddin9484 4 жыл бұрын

How did you fix it brother

@wahibomer1176 2 жыл бұрын

Can you helo me

@WinManRus 4 ай бұрын

Hello@@wahibomer1176

@frankbauer2727 4 жыл бұрын

Thank you so much, you've just saved me. I wouldn't mind donating something to you, in the meantime, CHEERS from Kenya, Africa!

@SwiftLearn 4 жыл бұрын

Thanks for your comment. Please keep connected. your comment inspired enough to make new tutorial.

@letuslearn8433 2 жыл бұрын

Nice video bro.just keep it up

@SwiftLearn 2 жыл бұрын

Thanks for your comment. You are very kind.

@codeisnull6777 4 жыл бұрын

bro very good tutorial so useful keep creating vids like this thanks for sharing . bro i love your yes saying way

@SwiftLearn 3 жыл бұрын

Glad you liked it and also glad to support programmers. thanks

@zerosandones7547 3 жыл бұрын

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.

@jersondomalaon1505 3 жыл бұрын

Thank you so much more blessings to come

@SwiftLearn 3 жыл бұрын

Pleased to see your comment. Thanks

@aminaali5905 5 жыл бұрын

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.

@SwiftLearn 5 жыл бұрын

Thanks mohad. feeling proud to see your comment.

@taimoorshehzad2477 2 жыл бұрын

Mam Can you help me ?

@zerosandones7547 3 жыл бұрын

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?

@kylevargas7530 Жыл бұрын

Worth to watch and subscribe

@niranjangoswami1417 4 жыл бұрын

Thank you so much sir

@crow4209 5 жыл бұрын

Hello sir , I am developing a software with C# where I have used Oracle 10g. will this process work in my case ?

@isaqpasha394 4 жыл бұрын

Thank you so much, sir.

@SwiftLearn 4 жыл бұрын

You are most welcome

@jaysolanki593 4 жыл бұрын

Yes !!!!!! 😅👌🏻

@zerosandones7547 3 жыл бұрын

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

@leonroutzounis383 Жыл бұрын

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

@GiorgiGogenia 5 жыл бұрын

100th Liker xD nice video

@SwiftLearn 4 жыл бұрын

Thanks.

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

@tomail1167 3 жыл бұрын

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

@azmathayat1304 5 жыл бұрын

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

@muhammadshahzaib3814 5 жыл бұрын

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.

@narwinmerluza9906 4 жыл бұрын

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?

@SwiftLearn 4 жыл бұрын

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.

@hanssss13 4 жыл бұрын

@@SwiftLearn database will be stored automatically in the program file ?? even though on another computer sql server is not installed ??

@valchalas 4 жыл бұрын

it says a signing certificate is needed. It aborts the publishing after that.

@shawndarians 5 жыл бұрын

done too. thank u

@SwiftLearn 5 жыл бұрын

great job dear.

@devni1565 3 жыл бұрын

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?

@oriannaakali1622 5 жыл бұрын

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.

@SwiftLearn 5 жыл бұрын

Thanks for your comment. i will check.

@souravroy5751 5 жыл бұрын

Has Swift Learn or anyone found the solution to this ?

@hardysingh198 2 жыл бұрын

@@souravroy5751 you just need to create backup for database

@fiverrdesigns3780 5 жыл бұрын

thnak you so mutch.

@SwiftLearn 5 жыл бұрын

Most welcome. please subscribe.

@tusharsaini6802 4 жыл бұрын

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

@rameshpudi4817 3 жыл бұрын

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

@gulshanchauhan6875 2 жыл бұрын

Thanks

@SwiftLearn 2 жыл бұрын

Welcome.

@vicky-q3v 3 жыл бұрын

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

@SwiftLearn 3 жыл бұрын

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.

@aneeqmurtaza8122 3 жыл бұрын

Sir in prerequesties I have no option client profile and windows installer?? What should I do

@louureghz 8 ай бұрын

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

@umairrehman2703 3 жыл бұрын

10:48 in my prereqsuites .netframe work for client profile is not available

@boujaoudkamal3727 3 жыл бұрын

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

@MuhammadIbrahim-uc1nc Жыл бұрын

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

@mybox6177 3 жыл бұрын

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

@SwiftLearn 3 жыл бұрын

these data can be read modify and delete using application. thanks

@thanhvan3528 3 жыл бұрын

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

@SwiftLearn 3 жыл бұрын

Yes. In that case you should select sql in prerequisites during the creation of setup file. Thanks 👍👍

@achamzdevsstudio3236 4 жыл бұрын

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

@manojbhatt9350 4 жыл бұрын

a network related instance specific error occurred while establishing a connection to sql server, i m facing kinda this error in host computer

@SwiftLearn 4 жыл бұрын

It means can not connect with the SQL server. Add prerequisites. follow this tutorial kzfaq.info/get/bejne/rd13acmUm9PadqM.html

@muhammadrasul1581 3 жыл бұрын

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

@SwiftLearn 3 жыл бұрын

Restart the PC and try again. hope you will do.

@user-by7bq3id9t 3 жыл бұрын

If it didn't work, you should use ssms to see list of databases and detach the one you are going to use

@abdelillahbenali9718 4 жыл бұрын

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

@SwiftLearn 4 жыл бұрын

May be the problem of prerequisites. to add prerequisites accurately see this tutorial too kzfaq.info/get/bejne/fpZhh9KcmNDUo6s.html

@tunpeter7564 2 жыл бұрын

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

@SwiftLearn 2 жыл бұрын

Yes. You can install .net framework separately. But It should be compatible with visual studio version. Thanks.

@sajiths5268 5 жыл бұрын

Hi swift, nice video. Is it possible to protect the database with password

@aimanmalkawi8831 5 жыл бұрын

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

@SwiftLearn 5 жыл бұрын

Thanks for your comment. i have to be more practical about it.

@mrceejay7086 4 жыл бұрын

@@SwiftLearn great tutorial, pls can you make a video for setting up the application and its environment on client machine. thank you

@hafizmluqman 4 жыл бұрын

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.

@SwiftLearn 4 жыл бұрын

when you install this aplication in defferent client PC than it will save in database. to ge proof kzfaq.info/get/bejne/fpZhh9KcmNDUo6s.html

4 жыл бұрын

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.

@sagarutwani4739 3 жыл бұрын

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

@kaushikdayalan924 3 жыл бұрын

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.

@SwiftLearn 3 жыл бұрын

You are working good. Set full control in installed folder instead of .mdf file. thanks

@kaushikdayalan924 3 жыл бұрын

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

@Xtrade-tricks Жыл бұрын

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

@PawanKumar-hj8sn 3 жыл бұрын

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

@Mycotta01 4 жыл бұрын

Can you make tutorial for postgresql too?

@mahmoodalgoul3717 3 жыл бұрын

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

@SwiftLearn 3 жыл бұрын

Yes it will work. But you must add SQL in prerequisites. thanks

@zerosandones7547 5 жыл бұрын

In creating desktop apps(.exe) which is much better, java or c#?

@SwiftLearn 5 жыл бұрын

I am c# programmer. started to study in java. i can not evaluate this time. thanks.

@atanki5682 5 жыл бұрын

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)

@xbxb 11 ай бұрын

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

@zerosandones7547 5 жыл бұрын

Is the database part of the application? like, I dont have to install sql server on client pc?

@SwiftLearn 4 жыл бұрын

Try your experiment. thanks.

@romeljohnviloria8581 4 жыл бұрын

Sir, can you still run the application whenever you lost your network connection?

@SwiftLearn 4 жыл бұрын

No need to network to run this application.

@louureghz 7 ай бұрын

can you make an updated version for this . and how do you install sql express

@Code_with_Iphie Жыл бұрын

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

@ishanchauhan5016 3 жыл бұрын

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

@SwiftLearn 3 жыл бұрын

Add prerequisites. Follow this tutorial and see how to add Prerequisites kzfaq.info/get/bejne/rd13acmUm9PadqM.html

@fujiahermawan8 3 жыл бұрын

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

@SwiftLearn 3 жыл бұрын

I have no idea right now. i will back after getting solution. thanks

@zerosandones7547 5 жыл бұрын

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

@SwiftLearn 5 жыл бұрын

of course you can. Thanks for your comment and support me. all the programming concept and tutorial available in this channel. keep connected.

@zerosandones7547 5 жыл бұрын

@@SwiftLearn when i double click the form, i can code the close button there? thanks for the response :D

@SwiftLearn 5 жыл бұрын

@@zerosandones7547 great bro

@kkspandiceo 5 жыл бұрын

Video error sir. Can't excute procesz

@mahdealjamil3796 4 жыл бұрын

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

@SwiftLearn 4 жыл бұрын

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.

@pavithrayogarajah1666 3 жыл бұрын

@@SwiftLearn How to find install location? This is my problem, can you please explain little more clearly??

@aryanbhaskar7872 4 жыл бұрын

How to do it with a image type data in db. I mean add a field for image in that??

@SwiftLearn 4 жыл бұрын

This is very easy. just see this tutorial kzfaq.info/get/bejne/ic-Dq82cubq2mKs.html THANKS.

@talharaza1246 4 жыл бұрын

It will support Backup and Restore?

@SwiftLearn 4 жыл бұрын

Go to the installed directory and take the .mdf and .ldf file. all data available in this files. thanks,

@McLovin__ 4 жыл бұрын

My data is not saving to the database. It is always gone after I relaunch my program. Need help!

@SwiftLearn 4 жыл бұрын

Copy the .mdf file and replace it in system directory installed folder. thanks.

@bhavyagarg1633 5 жыл бұрын

i have already made the database but when i m clicking on user control(WPF) it is not showing any mdf file. plz help

@SwiftLearn 5 жыл бұрын

So i have to check it in WPF. this tutorial is windows form application.

@aryanbhaskar7872 4 жыл бұрын

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

@SwiftLearn 4 жыл бұрын

If your image stored as binary image than it will be ok. if image in drive maintain the same directory in both PC. thanks.

@aryanbhaskar7872 4 жыл бұрын

How to get setup project in vs 2012 exp. Version

@krishnaraovasudevan8520 4 жыл бұрын

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

@SwiftLearn 4 жыл бұрын

Very simple. Just follow this tutorial kzfaq.info/get/bejne/fpZhh9KcmNDUo6s.html thanks.

@Shubham_848Vlog 2 жыл бұрын

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

@amktechnologies9313 4 жыл бұрын

How can i save database from installed computer if i am doing windows installation????

@SwiftLearn 4 жыл бұрын

Try then let me know. but windows authentication mentioned server name in connectionstring. so .....

@Code_with_Iphie Жыл бұрын

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

@rizwanyousaf4667 4 жыл бұрын

sir in this case SQL need to be installed ?

@SwiftLearn 4 жыл бұрын

.net framework is enough to run this application.

@akshaychougule7170 4 жыл бұрын

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

@samaccount4645 4 жыл бұрын

@SwiftLearn 4 жыл бұрын

Go to the installed folder C:\Program Files\ your installed folder. just take the .mdf and .ldf . Try and let me know. thanks.

@edsonferraz1 Жыл бұрын

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

@christiansanchez8656 4 жыл бұрын

hello sir, do we still need lan server or internet to make it work?

@SwiftLearn 4 жыл бұрын

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.

@mrceejay7086 4 жыл бұрын

@@SwiftLearn pls am waiting also, thanks

@vikashpatel8947 4 жыл бұрын

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.

@SwiftLearn 4 жыл бұрын

Select SQL server in prerequisites.

@fujiahermawan8 3 жыл бұрын

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

@SwiftLearn 3 жыл бұрын

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.

@fujiahermawan8 3 жыл бұрын

@@SwiftLearn what version should i install?

@joshuareyes2939 3 жыл бұрын

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

@SwiftLearn 3 жыл бұрын

Select SQL server in prerequisites during creating setup file. then try to install once again. Thanks

@suryak7602 4 жыл бұрын

At 3:49 ,I'm unable to create table, there's is no option for add new table.how to add it?

@SwiftLearn 4 жыл бұрын

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.

@jkdev396 3 жыл бұрын

what if there is crystal report involved? How can i connect it with already designed crystal reports?

@SwiftLearn 3 жыл бұрын

I will make such tutorial as soon as possible. thanks

@jkdev396 3 жыл бұрын

@@SwiftLearn Thanks Looking forward to it. Please make it priority as i am sure alot of people want to know.

@haja1963 4 жыл бұрын

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

@haja1963 4 жыл бұрын

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

@SwiftLearn 4 жыл бұрын

Almighty bless you to achieve goal. keep trying. thanks.

@internetgaming6441 4 жыл бұрын

YES YES YESSSSSSSSSSSS

@haftomkahsay7902 4 жыл бұрын

hello dear my database doesn't publish with the setup file please help me?

@SwiftLearn 4 жыл бұрын

Add SQL as prerequisites. to add prerequisites just follow this tutorial. kzfaq.info/get/bejne/fpZhh9KcmNDUo6s.html

@sujaysshenoy247 4 жыл бұрын

Where did you get the contents of the application files from??

@SwiftLearn 4 жыл бұрын

Installed location. C - Program Files -

@esersoft1830 4 жыл бұрын

Hello, the database is deleted when the update is made. How do we set it.

@SwiftLearn 4 жыл бұрын

Thanks for your comment. you may get more information from this tutorial. kzfaq.info/get/bejne/fpZhh9KcmNDUo6s.html thanks.

@challenger7540 4 жыл бұрын

.\ when you wrote this ... if it means it ll work in all computers so why mine is not working :((

@SwiftLearn 4 жыл бұрын

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.

@malgoul 3 жыл бұрын

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

@SwiftLearn 3 жыл бұрын

No need to install sql server manually. Just add SQL in Prerequisites. To add Prerequisites watch this tutorial kzfaq.info/get/bejne/fpZhh9KcmNDUo6s.html thanks

@malgoul 3 жыл бұрын

@@SwiftLearn Thanks for quick reply, unfortunately I'm using vs 2008 and the prerequisites is not getting installed do you suggest to add download link manually?

@SwiftLearn 3 жыл бұрын

@@malgoul If manually than you should install sql server and .netframework. thanks

@hamdiayadi9815 4 жыл бұрын

Is there such solution to mysql database on phpmyadmin server ?

@SwiftLearn 4 жыл бұрын

Thanks for your comment. i have to study PHP MySql

@harkorsky Жыл бұрын

I'm having an error saying dat; An error occured while signing: SignTool.exe not found

@harkorsky Жыл бұрын

@Swift learn

@umairrehman2703 3 жыл бұрын

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 .

@SwiftLearn 3 жыл бұрын

Thanks for your comment. I didn't tried with WPF. I will try.

@arpitagrawal3656 3 жыл бұрын

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

@arpitagrawal3656 3 жыл бұрын

I have sent you a request on FB as well. Or please contact me over mail at: arpit.agrawal.0226@gmail.com

@SwiftLearn 3 жыл бұрын

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 kzfaq.info/get/bejne/fpZhh9KcmNDUo6s.html