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

Подписаться 18 тыс.

Просмотров 93 тыс.

50% 1

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

Наука

Опубликовано:

14 фев 2019

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 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 3 дня назад

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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-wwG6fc6mvFo.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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-H01Tok3jpsw.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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-H01Tok3jpsw.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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-wwG6fc6mvFo.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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-SiSxjkTTRhw.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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-H01Tok3jpsw.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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-H01Tok3jpsw.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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-H01Tok3jpsw.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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-H01Tok3jpsw.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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-H01Tok3jpsw.html