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

[@rahimmughal4552]

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]

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

[@rahimmughal4552]

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

[@SwiftLearn]

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

[@rahimmughal4552]

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

[@rahimmughal4552]

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

[@zerosandones7547]

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.

[@selvarani9386]

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

[@globalinvest9275]

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]

Thanks for your comment. Please share to help others

[@jedzernaofficial3942]

How did you fix it please😭

[@zainuddin9484]

How did you fix it brother

[@wahibomer1176]

Can you helo me

[@WinManRus]

Hello@@wahibomer1176

[@carltechviews605]

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

[@SwiftLearn]

You are most welcome🌹🌹

[@aminaali5905]

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]

Thanks mohad. feeling proud to see your comment.

[@taimoorshehzad2477]

Mam Can you help me ?

[@sardorbektalatov3078]

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

[@umairrehman2703]

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

[@zerosandones7547]

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?

[@tunpeter7564]

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

[@SwiftLearn]

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

[@frankbauer2727]

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]

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

[@vicky-q3v]

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]

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.

[@ahmed_raaphat]

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

[@SwiftLearn]

Glad I could help! please keep in touch.

[@cmcotrading]

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

[@SwiftLearn]

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

[@suryak7602]

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

[@SwiftLearn]

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.

[@muhammadrasul1581]

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]

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

[@محمدسعيد-ش5ك8س]

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

[@letuslearn8433]

Nice video bro.just keep it up

[@SwiftLearn]

Thanks for your comment. You are very kind.

[@mybox6177]

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]

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

[@manojbhatt9350]

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

[@SwiftLearn]

It means can not connect with the SQL server. Add prerequisites. follow this tutorial kzbin.info/www/bejne/raiqZ5mZa9KpfNE

[@hitendusseja6615]

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

[@codeisnull6777]

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

[@SwiftLearn]

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

[@thanhvan3528]

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

[@SwiftLearn]

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

[@narwinmerluza9906]

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]

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]

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

[@oriannaakali1622]

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]

Thanks for your comment. i will check.

[@souravroy5751]

Has Swift Learn or anyone found the solution to this ?

[@hardysingh198]

@@souravroy5751 you just need to create backup for database

[@jersondomalaon1505]

Thank you so much more blessings to come

[@SwiftLearn]

Pleased to see your comment. Thanks

[@zerosandones7547]

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

[@SwiftLearn]

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

[@atanki5682]

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)

[@jkdev396]

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

[@SwiftLearn]

I will make such tutorial as soon as possible. thanks

[@jkdev396]

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

[@zainuddin9484]

There'sno option of .netframework 4 client profile in my prerequisite please help.

[@SwiftLearn]

Scroll down and check. thanks

[@zainuddin9484]

@@SwiftLearn i didn't expect that stupid reply, obviously i had checked everything by scrolling before i came here to ask you.

[@SwiftLearn]

@@zainuddin9484 do you use VS 2010. If its upper or lower it may change .net framework version. i will try with upper version of visual studio and let you know. thanks.

[@rameshpudi4817]

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

[@christiansanchez8656]

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

[@SwiftLearn]

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]

@@SwiftLearn pls am waiting also, thanks

[@leonroutzounis383]

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

[@mahmoodalgoul3717]

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

[@SwiftLearn]

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

[@valchalas]

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

[@malgoul]

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

[@SwiftLearn]

No need to install sql server manually. Just add SQL in Prerequisites. To add Prerequisites watch this tutorial kzbin.info/www/bejne/fmGUhaKhaM-jqdk thanks

[@malgoul]

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

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

[@aneeqmurtaza8122]

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

[@joshuareyes2939]

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

[@SwiftLearn]

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

[@talharaza1246]

It will support Backup and Restore?

[@SwiftLearn]

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

[@aimanmalkawi8831]

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]

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

[@mrceejay7086]

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

[@abdelillahbenali9718]

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]

May be the problem of prerequisites. to add prerequisites accurately see this tutorial too kzbin.info/www/bejne/fmGUhaKhaM-jqdk

[@PRONOOBSPAK]

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.

[@fujiahermawan8]

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]

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]

@@SwiftLearn what version should i install?

[@zerosandones7547]

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

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

[@fujiahermawan8]

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]

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

[@mahdealjamil3796]

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]

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]

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

[@kaushikdayalan924]

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]

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

[@kaushikdayalan924]

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

[@boujaoudkamal3727]

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

[@McLovin__]

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

[@SwiftLearn]

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

[@tusharsaini6802]

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

[@adhityaprimandhika]

I have problem with my own project that after i install it there is a problem that mention |Data Directory| please somebody helpp

[@SwiftLearn]

Create full permission(Read Write) in the installed directory. Thanks.

[@adhityaprimandhika]

@@SwiftLearn Thank you sir, the problem has solved

[@onee0.01]

@@SwiftLearn I got error: System.Data.SqlClient.SqlException (0x80131904): Directory lookup for the file "C:\Users\cuu99\AppData\Local\Apps\2.0\Data\O8XX813R.VG9\41Z8Q9LC.L1Y\ktxv..tion_0000000000000000_0001.0000_cc470ef13f032ec0\Data\ktxV3dot15.mdf" failed with the operating system error 5(Access is denied.). Cannot attach the file 'C:\Users\cuu99\AppData\Local\Apps\2.0\Data\O8XX813R.VG9\41Z8Q9LC.L1Y\ktxv..tion_0000000000000000_0001.0000_cc470ef13f032ec0\Data\ktxV3dot15.mdf' as database 'ktxV3dot15'. How to fix it bro?

[@DirilisErtugrulSS]

Database readonly error after setup installation how solve it ??

[@SwiftLearn]

Go to the installed location and apply full permission. read and write. full control.

[@onee0.01]

@@SwiftLearn Where? C:\User\user-name\AppData\043249\42390423\Data?

[@SwiftLearn]

@@onee0.01 Right click on shortcut in the desktop - Click on Open File Location. you can get the file location. Thanks

[@haja1963]

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]

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]

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

[@sujaysshenoy247]

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

[@SwiftLearn]

Installed location. C - Program Files -

[@haftomkahsay7902]

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

[@SwiftLearn]

Add SQL as prerequisites. to add prerequisites just follow this tutorial. kzbin.info/www/bejne/fmGUhaKhaM-jqdk

[@azmathayat1304]

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

[@aryanbhaskar7872]

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

[@SwiftLearn]

This is very easy. just see this tutorial kzbin.info/www/bejne/iZq2qZ2hibmFntk THANKS.

[@krishnaraovasudevan8520]

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]

Very simple. Just follow this tutorial kzbin.info/www/bejne/fmGUhaKhaM-jqdk thanks.

[@ishanchauhan5016]

sir, how to convert the full path of the connection string to the data directory.

[@SwiftLearn]

copy the connection string in txt file. use text reader and read the connection string from the directory.

[@ishanchauhan5016]

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

[@hamdiayadi9815]

Is there such solution to mysql database on phpmyadmin server ?

[@SwiftLearn]

Thanks for your comment. i have to study PHP MySql

[@kylevargas7530]

Worth to watch and subscribe

[@arpitagrawal3656]

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]

I have sent you a request on FB as well. Or please contact me over mail at: [e-mail]

[@SwiftLearn]

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 kzbin.info/www/bejne/fmGUhaKhaM-jqdk

[@MuhammadIbrahim-uc1nc]

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

[@devni1565]

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?

[@HarshadCodes]

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.

[@crow4209]

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

[@amktechnologies9313]

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

[@SwiftLearn]

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

[@akshaychougule7170]

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]

+1

[@SwiftLearn]

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

[@hafizmluqman]

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]

when you install this aplication in defferent client PC than it will save in database. to ge proof kzbin.info/www/bejne/fmGUhaKhaM-jqdk

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.

[@vikashpatel8947]

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]

Select SQL server in prerequisites.

[@Shubham_848Vlog]

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

[@Shubham_848Vlog]

I have to create report viewing application wit this type of data base

[@xbxb]

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

[@ishanchauhan5016]

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

Add prerequisites. Follow this tutorial and see how to add Prerequisites kzbin.info/www/bejne/raiqZ5mZa9KpfNE

[@anonnymous1411]

Sir i'm facing a problem, In my appconfig I can't see the connection sting. What should i do?

[@anonnymous1411]

i'm using visual studio 2019

[@SwiftLearn]

i will install VS 19 and inform you later. thanks.

[@romeljohnviloria8581]

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

[@SwiftLearn]

No need to network to run this application.

[@esersoft1830]

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

[@SwiftLearn]

Thanks for your comment. you may get more information from this tutorial. kzbin.info/www/bejne/fmGUhaKhaM-jqdk thanks.

[@aryanbhaskar7872]

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]

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

[@mohamadarieajharie9112]

i have error ===>>"an error occurred: A network-related or instance-specific error occurred while esablishing a connection to SQL Server. The Server was not found or was not accessible.Verify that instance name is correct and that SQL Server is configured to allow remote connection. (provider: SQL Network Interface, error 50: - Local Database Runtime error occurred. The specified LocalDB instance does not exist.)" when i setup in different computer and this is my connectionString ===>> connectionString="Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\dbdema.mdf;Integrated Security=True;Connect Timeout=30"

[@SwiftLearn]

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

[@magesvaranes2950]

@@SwiftLearn I have similar error even after following your steps completely... The error is "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The Server was not found or was not accessible.Verify that instance name is correct and that SQL Server is configured to allow remote connection. (provider: SQL Network Interface, error 52: - Unable to locate a Local Database Runtime Installation. Verify that SQL Server Express is properly installed and that Local Database Runtime feature is enabled.)."

[@PRONOOBSPAK]

plz install sql server on your pc first on which you are installing setup.

[@harkorsky]

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

[@harkorsky]

@Swift learn

[@zerosandones7547]

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

[@SwiftLearn]

Try your experiment. 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";

[@ShrikantJadhavPatil]

I am still getting the error - Server was not found or was not accessible. Plz Help me out sir

[@SwiftLearn]

Create setup file with prerequisites with SQL Server. Thanks

[@shwetapapdiwal5307]

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

[@SwiftLearn]

I will check.

[@sagarutwani4739]

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

[@kkspandiceo]

Video error sir. Can't excute procesz

[@rizwanyousaf4667]

sir in this case SQL need to be installed ?

[@SwiftLearn]

.net framework is enough to run this application.

[@umairrehman2703]

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]

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

[@AhmadAli-ii6jn]

Help Sir! When I some of database query is not working i mean sir at the time of logging in it does not proceed when the username and password is correct but when they are wrong then it gives me error

[@SwiftLearn]

see the tutorial again and check the query whether its working in development project or not.

[@PRONOOBSPAK]

bro you must have to use try catch put the code in try block to login when username and password is true and put the exception in catch block and show a message there. try and catch blocks are used for exception handling.

[@SwiftLearn]

Thanks for your suggession. In this tutorial i have focused on creating setup file. i will focuse on everything in upcoming tutorial.

[@bhavyagarg29]

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]

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

[@Code_with_Iphie]

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

[@drusttaib607]

sir, how to add auto increment and unique features to columns manually?

[@SwiftLearn]

Select max id and insert next record with max+1;

[@drusttaib607]

@@SwiftLearn thanks, one more question. I want to update the database with datagridview. As I insert to my datagridview, i want the database to be updated

[@SwiftLearn]

@@drusttaib607 Write wpdate statement based on primary key column. put this statement in for loop.

[@drusttaib607]

@@SwiftLearn i had the same idea, but, isn't there anyway better

[@drusttaib607]

sir, I know I asked a lot, I am looking for a solution from someone, I am from a middle eastern country. I try to use a language inside the database which is Kurdish language. The problem is this language is some letters of this language is not supported in database such as ۆ ە ێ. after a lot of research I kinda found a sollution which is changing collation of the column to utf8mb4_unicode_ci. but the database is not supporting this language. I have used kurdish before in server based database. what should I do?

[@zainuddin9484]

my app config is not showing connection string

[@SwiftLearn]

Add a DataSet and add table from server explorer by drag. thanks

[@zainuddin9484]

@@SwiftLearn thanks, bro but in the prerequisite there is no option of .Net Framework 4 client profile. Please help :( i am using vs 2017.

[@Shubham_848Vlog]

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

[@keshavm1693]

How should I include Icon in App ?

[@SwiftLearn]

kzbin.info/www/bejne/r33LhaWjjMujfs0 it may help you.

[@NA-dq4px]

I did in same way...but when I'm installing it on another computer...it shows SQL server error ..pls help...

[@SwiftLearn]

you should add prerequisits(SQL Server). to add prerequisits see this tutorial. thanks.

[@achamzdevsstudio3236]

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

[@Mycotta01]

Can you make tutorial for postgresql too?

[@leonskennedy1568]

How if the database is acces

[@SwiftLearn]

If the database is access you can do it easily by following this tutorial kzbin.info/www/bejne/raiqZ5mZa9KpfNE thanks. keep connected!

[@leonskennedy1568]

@@SwiftLearn now i have more question icreate shop i wan to input the code, name, price, image how make image to database, and doing ubdate

[@isaqpasha394]

Thank you so much, sir.

[@SwiftLearn]

You are most welcome

[@zerosandones7547]

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]

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

[@zerosandones7547]

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

[@SwiftLearn]

@@zerosandones7547 great bro

[@MuhammadIbrahim-uc1nc]

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. WindowsFormsApplication2 I FOUNT THIS ERROR

[@SwiftLearn]

It's not error of your project. Try with setting full permission in C:\Program Files (x86)\Microsoft SDKs\Windows directory. or take help from google. thanks