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 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
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.
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.
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
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.
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?
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.?
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...
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.
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???
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.
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.
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 :)
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
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.
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?
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.
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
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)
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
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.
when you install this aplication in defferent client PC than it will save in database. to ge proof th-cam.com/video/H01Tok3jpsw/w-d-xo.html
5 ปีที่แล้ว
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.
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.
No need to install sql server manually. Just add SQL in Prerequisites. To add Prerequisites watch this tutorial th-cam.com/video/H01Tok3jpsw/w-d-xo.html thanks
@@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?
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
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.
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.
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.
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
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.
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.
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...
@@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.
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?
@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.)
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
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
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
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 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?
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 th-cam.com/video/H01Tok3jpsw/w-d-xo.html
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
@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.)
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. 🙏
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
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.
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 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.)."
@@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
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?
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 .
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
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
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.
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
Watch video once again and put @ for example @"Data Source=(..... and let me know. please like subscribe and share.
@@SwiftLearn Sir Thanks For Your love, & for Pinning My Comment :*
@@rahimmughal4552 Try with [User] or dbo.user. if still not solve connect with me in facebook.com/rowshanp
@@SwiftLearn Let Me try With dbo.user / Others names Sir
@@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
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.
Thanks for your comment. Please share to help others
How did you fix it please😭
How did you fix it brother
Can you helo me
Hello@@wahibomer1176
Iam trying a lot without installing sqlserver. But your video is best and good. It's working nicely 😊😊
Wow, this is what I've search for. Now i know it. Thanks to u sir.
You are most welcome🌹🌹
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.
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
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.
Thanks mohad. feeling proud to see your comment.
Mam Can you help me ?
That is exactly what iam looking for! thanks a lot .
Glad I could help! please keep in touch.
Thank you so much, you've just saved me. I wouldn't mind donating something to you, in the meantime, CHEERS from Kenya, Africa!
Thanks for your comment. Please keep connected. your comment inspired enough to make new tutorial.
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?
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.?
these data can be read modify and delete using application. thanks
bro very good tutorial so useful keep creating vids like this thanks for sharing . bro i love your yes saying way
Glad you liked it and also glad to support programmers. thanks
10:48 in my prereqsuites .netframe work for client profile is not available
Hello Sir, may i ask that the prerequisite for the Microsoft .net framework must use client profile?
Yes. You can install .net framework separately. But It should be compatible with visual studio version. Thanks.
I love your energy! This is what i was looking for
So glad! Thanks for your comment. Please keep connected.
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...
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.
Nice video bro.just keep it up
Thanks for your comment. You are very kind.
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???
Restart the PC and try again. hope you will do.
If it didn't work, you should use ssms to see list of databases and detach the one you are going to use
Thank you so much more blessings to come
Pleased to see your comment. Thanks
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.
Thanks for your comment. i will check.
Has Swift Learn or anyone found the solution to this ?
@@souravroy5751 you just need to create backup for database
a network related instance specific error occurred while establishing a connection to sql server, i m facing kinda this error in host computer
It means can not connect with the SQL server. Add prerequisites. follow this tutorial th-cam.com/video/wwG6fc6mvFo/w-d-xo.html
Very nice, One question. How does one backup and restore the database in the created file?
Thank you very much sir, was looking for this since a very long time
At 3:49 ,I'm unable to create table, there's is no option for add new table.how to add it?
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.
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 :)
Thanks for your comment. i have to be more practical about it.
@@SwiftLearn great tutorial, pls can you make a video for setting up the application and its environment on client machine. thank you
Hi Sir,have
If my client PC dont have a SQL engine installed yet, the setup will automatically install SQL engine for it?
Yes. In that case you should select sql in prerequisites during the creation of setup file. Thanks 👍👍
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
I have no idea right now. i will back after getting solution. thanks
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.
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?
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.
@@SwiftLearn database will be stored automatically in the program file ?? even though on another computer sql server is not installed ??
it says a signing certificate is needed. It aborts the publishing after that.
what if there is crystal report involved? How can i connect it with already designed crystal reports?
I will make such tutorial as soon as possible. thanks
@@SwiftLearn Thanks Looking forward to it. Please make it priority as i am sure alot of people want to know.
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
Very simple. Just follow this tutorial th-cam.com/video/H01Tok3jpsw/w-d-xo.html
thanks.
100th Liker xD nice video
Thanks.
In creating desktop apps(.exe) which is much better, java or c#?
I am c# programmer. started to study in java. i can not evaluate this time. thanks.
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)
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
+1
Go to the installed folder C:\Program Files\ your installed folder. just take the .mdf and .ldf . Try and let me know. thanks.
How to do it with a image type data in db. I mean add a field for image in that??
This is very easy. just see this tutorial th-cam.com/video/SiSxjkTTRhw/w-d-xo.html THANKS.
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.
when you install this aplication in defferent client PC than it will save in database. to ge proof th-cam.com/video/H01Tok3jpsw/w-d-xo.html
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.
Hi, well it will work even without SQL Server installed in any other machine?
Yes it will work. But you must add SQL in prerequisites. thanks
hello sir,
do we still need lan server or internet to make it work?
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.
@@SwiftLearn pls am waiting also, thanks
Sir you can deploy the project without install sql server express?
No need to install sql server manually. Just add SQL in Prerequisites. To add Prerequisites watch this tutorial th-cam.com/video/H01Tok3jpsw/w-d-xo.html thanks
@@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?
@@malgoul If manually than you should install sql server and .netframework. thanks
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
May be the problem of prerequisites. to add prerequisites accurately see this tutorial too th-cam.com/video/H01Tok3jpsw/w-d-xo.html
Sir in prerequesties I have no option client profile and windows installer?? What should I do
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.
You are working good. Set full control in installed folder instead of .mdf file. thanks
@@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.
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.
in visual studio 2015 it is possible .i am not getting that version dataset
on another pc its say "cannot be opened because it is version 852 this server supports version 706 and earlier" how to fix it ?
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.
@@SwiftLearn what version should i install?
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
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.
@@SwiftLearn How to find install location? This is my problem, can you please explain little more clearly??
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.
Select SQL server in prerequisites.
How do you add icons when installing/publishing this way? I cant see icons when going to the control panel or desktop icon.
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...
Do you know how to install Update of window form application with also update in database sql server without deleting perivious database?
There'sno option of .netframework 4 client profile in my prerequisite please help.
Scroll down and check. thanks
@@SwiftLearn i didn't expect that stupid reply, obviously i had checked everything by scrolling before i came here to ask you.
@@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.
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?
sir, how to convert the full path of the connection string to the data directory.
copy the connection string in txt file. use text reader and read the connection string from the directory.
@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.)
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
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
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
How can i save database from installed computer if i am doing windows installation????
Try then let me know. but windows authentication mentioned server name in connectionstring. so .....
Is there such solution to mysql database on phpmyadmin server ?
Thanks for your comment. i have to study PHP MySql
My data is not saving to the database. It is always gone after I relaunch my program. Need help!
Copy the .mdf file and replace it in system directory installed folder. thanks.
It will support Backup and Restore?
Go to the installed directory and take the .mdf and .ldf file. all data available in this files. thanks,
Where did you get the contents of the application files from??
Installed location. C - Program Files -
Worth to watch and subscribe
Hi Sir, I install it to another pc the setup I made but always shows error 26. please help me 🙏 Thank you sir
Select SQL server in prerequisites during creating setup file. then try to install once again. Thanks
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
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
Almighty bless you to achieve goal. keep trying. thanks.
I have problem with my own project that after i install it there is a problem that mention |Data Directory| please somebody helpp
Create full permission(Read Write) in the installed directory. Thanks.
@@SwiftLearn Thank you sir, the problem has solved
@@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?
i have created database with tables, procedure and all, so how to bring that database complete file in project
Hello sir ,
I am developing a software with C# where I have used Oracle 10g. will this process work in my case ?
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
I have sent you a request on FB as well. Or please contact me over mail at: arpit.agrawal.0226@gmail.com
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 th-cam.com/video/H01Tok3jpsw/w-d-xo.html
hello dear my database doesn't publish with the setup file please help me?
Add SQL as prerequisites. to add prerequisites just follow this tutorial. th-cam.com/video/H01Tok3jpsw/w-d-xo.html
Database readonly error after setup installation how solve it
??
Go to the installed location and apply full permission. read and write. full control.
@@SwiftLearn Where? C:\User\user-name\AppData\043249\42390423\Data?
@@onee0.01 Right click on shortcut in the desktop - Click on Open File Location. you can get the file location. Thanks
Hello, the database is deleted when the update is made. How do we set it.
Thanks for your comment. you may get more information from this tutorial. th-cam.com/video/H01Tok3jpsw/w-d-xo.html thanks.
sir how to create same for SQL Server Compact Edition Database File (.sdf) this type of file
I have to create report viewing application wit this type of data base
Sir, can you still run the application whenever you lost your network connection?
No need to network to run this application.
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
@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.)
Add prerequisites. Follow this tutorial and see how to add Prerequisites th-cam.com/video/wwG6fc6mvFo/w-d-xo.html
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. 🙏
If your image stored as binary image than it will be ok. if image in drive maintain the same directory in both PC. thanks.
in the .config.deploy. The connection string is still the sqlserver
Is the database part of the application?
like, I dont have to install sql server on client pc?
Try your experiment. thanks.
Video error sir. Can't excute procesz
Thank you so much, sir.
You are most welcome
Sir, when I added the database it did not connect to the database
Can you make tutorial for postgresql too?
I'm having an error saying dat;
An error occured while signing: SignTool.exe not found
@Swift learn
I am still getting the error - Server was not found or was not accessible. Plz Help me out sir
Create setup file with prerequisites with SQL Server. Thanks
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
see the tutorial again and check the query whether its working in development project or not.
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.
Thanks for your suggession. In this tutorial i have focused on creating setup file. i will focuse on everything in upcoming tutorial.
i have already made the database but when i m clicking on user control(WPF) it is not showing any mdf file. plz help
So i have to check it in WPF. this tutorial is windows form application.
Sir i'm facing a problem,
In my appconfig I can't see the connection sting.
What should i do?
i'm using visual studio 2019
i will install VS 19 and inform you later. thanks.
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"
Watch video once again and put @ for example @"Data Source=(..... and let me know. please like subscribe and share.
@@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.)."
plz install sql server on your pc first on which you are installing setup.
sir, how to add auto increment and unique features to columns manually?
Select max id and insert next record with max+1;
@@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
@@drusttaib607 Write wpdate statement based on primary key column. put this statement in for loop.
@@SwiftLearn i had the same idea, but, isn't there anyway better
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?
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 .
Thanks for your comment. I didn't tried with WPF. I will try.
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
I will check.
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
of course you can. Thanks for your comment and support me. all the programming concept and tutorial available in this channel. keep connected.
@@SwiftLearn when i double click the form, i can code the close button there? thanks for the response :D
@@zerosandones7547 great bro
How to dump csv file into ce data base and view ce data base from viewer.
How should I include Icon in App ?
th-cam.com/video/yLhTrmWfpHk/w-d-xo.html it may help you.
my app config is not showing connection string
Add a DataSet and add table from server explorer by drag. thanks
@@SwiftLearn thanks, bro but in the prerequisite there is no option of .Net Framework 4 client profile. Please help :(
i am using vs 2017.
Thank you so much sir
.\ when you wrote this ... if it means it ll work in all computers so why mine is not working :((
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.
I did in same way...but when I'm installing it on another computer...it shows SQL server error ..pls help...
you should add prerequisits(SQL Server). to add prerequisits see this tutorial. thanks.
Is it temporary? I cant see the rows i added in the database.. Plz provide me the solution for permanent save..