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

welcome to my channel so I plan this tutorial I will show how to create certified we that has two Microsoft SQL Server database which can be installed in any computer with accessing the database without install SQL Server to 100% proof [Music] start Visual Studio okay now I'm going to create a new project and get new windows for application the name of this finish application form is just set up with SQL DB and I just edition in G my test project folder okay and now I am going to create this project without asking as filter it says design this prom to insert and just record from database ms SQL Server database after performing these tasks then I will create set a file with addressing ms SQL database dot MDF file and finally I will install it in different computer with 100% profile to 100% proof okay now I'm just adding three level control ID named ace and the title of this page is create setup file a set of project SQL with SQL database okay now just change the font size and deforested position center skin and the font font is the back color of this form is okay now add three text box the text box one for ID and tactics to for name integrals to for ease change the font size of this text box okay twelve is enough now ID name is okay now the button control to insert record and database button name is button font size 12 and the text of this build of the pattern is insert and just to design this burden at another button to record from SQL Server database in Windows Phone application load okay now add a data grid view control to display the data after insertion okay now add new item I'm gonna add MDF file you can take the same deputy if you already clear database and you can copy and paste this MDF file from C program file SQL Microsoft SQL Server data from that location timed a file store okay recheck there is no table yet I just quit database there is data set 1 ok now go to the server explorer and this is the database name is database 1 dot MDF okay still there is no terrible I'm going to add in a table the column is ID integer type data type is integer and name and worker 50 is float float will decimal will support decimal ID is primary key the name of this table is user tape click on ok ok now it's done go to the cupboard and click event yes yeah I will right go to insert operation go to the API config felt this the connection sting now first of all right call that guy first of all connect with your database database one to connect to database annuity project then write SQL connection conical to new SQL connection at nemesis in system to data data SQL client the enemy species added you can write the name a space in front of animist it's ok now just coffee their connection listing the connection history is a this is the connection listing i marked just coffee this connection is string this is a test database connection nesting see that SQL server address DB detected a division under MDF target cigarette and instance equal to true ok now just copy this connection string and paste it in the SQL connection brags yes now it's connected with your database database 1 dot MDF now I'm gonna guess there is shown in some error because of backs less single backslash to ever this error just add at the rate we are before that double collision okay now open the connection con dot open now I'm going to write SQL command to insert a record in database that it is one dot MDF in the table of user type okay now SQL command CMD equal to new SQL command my command is insert into user take my table name is user tip so I am going to insert a record in user tip values values are ID name is value add and call the connection connection at that ID at that of name it this is this variable you can write anything based on column table column okay now CM d dot parameters not add with value the ID ID higher the ID will take at the load variable this is from textbooks one tag looks one for ID words the heart I already added in the wind is complication and ID is integer type so it's must convert to integer in the case in the dot first tigress wand or test and seemed e dot parameter dot now second second text box is for name added of name this is inverter type so no need to convert it to an integer in that case just take those two dot text okay now third one CMD dot parameter dotted with value is AG's flowed so converted to double because it will support decimal okay now Tigris theta double dot first tigress three daughters finally CMD dot execute non query expiry used to insert update or delete operation you can see all the insert or delete tutorial on a channel okay close the connection Condor plus finally display the masses masses box dot so after submitting the record after inserting a record it will display the mass has successfully saved okay now insert operation is done now good the second button button to loading click event to load data what data you just inserted you didn't respect the debt I just coefficient reducing time now just saying the SQL go on my command is select a star from user tip what data are exist in the user tab table it will display in the data grid be in that case just I just right ask your command select restart movie the tip now SQL debt adapter di equal to new SQL data adapter and called the CMD yes okay now datatable DT equal to new data table I just declaring in data table and finally I will load the DA data adapter in debt a table dt d dot feel DT okay now finally I will display the record DT in data grid B in that case that I could be wondered at a choice equal to DT finally con close the connection con dot close okay just about its debugging yes yes now just a field text box ID is one thousand one and the one one name Swift is 25 just click on insert successful in charge just click on load yes - so it now - is Donald AG's 22 just insert yes Lord yes it's also inserted close now I'm not create setup file you that has the SQL database which can be in stir in any computer with accessing database okay go to the solution Explorer now right click in the application profile go to the property and click on publish in the Left fan first of all I am just creating a folder in the backstop where I will or rock create the setup file the name of this folder is my mind set up yes my set of 5 I just create this folder with the name is my set of file here I will create a certified with addressing SQL database in that case just browse publishing folder this browse desktop expand the desktop yes my Cetaphil folder is displaying just click on open yes it's opened a location yes see that yeah the database wonder dot MDF application file what file after publishing after creating set of well what file will exist click on prerequisites yeah if you just select Microsoft dotnet framework for client profile accident six standard 6 is 64 just download is higher you higher you just install this application it will download the prerequisites ok now click an option heads you can see description development manifest and Fair Association ok you can just click on create desktop share a shortcut after installation you can see add a shortcut in desktop ok the selected and add description publicity language you can select language publish your name name swift lon site name if you have any site name you can put adjust why this site name is a flower and product name product name is test setup only install you can see the app shortcut file as test setup name if you have you're looking for okay now just publish your click on publish wizard yes next and from cd/dvd room next the application will not check if you take update you can update done you can not not check for update okay now next just publish is ready just click finish to publish yes its publishing it takes some time just be patient and see see Han it's completing the publisher then you can see the publish file will display in this location my setup file extra my shadow file yes yes yes it's published and the set of file is created now I am going to give this application the set of setup file in the network drive my network just rightly and coffee yes now I'm going to taste this setup project in network then I will install it in other computer keep watching please okay this is my network and here are many computer in my network this is the big Network okay now the comm server and Abdul IT Ras folder I just faced this setup file in Irish folder okay once again confirmed calm the network um server Abdullah tea rush confirmed this location and I will now I'll go I will jump to other computer here I'll install from this location see yes yes computer just I just hide my computer address IP for security purposes okay now I am just taking this setup file from network drive in that case I am just entering location this is completely different patient and that PC name is a web server and calm server same the same PC and Irish form server or I folded yes ability Irish folder see depth confirm once again calm server ability Irish folder hi are I faced the set of file I am just coffee the set of fell from that location and paste it in the GJ of this PC first yes it's best now I'll install it in this computer but I will not install SQL Server see that what I have deployed the database 100 MDF LDF and the config file application txt file all are published all arts edit now just getting setup file yes click on install no need to install ask yourself in order to configure rescue suite automatically let's not yes test yet it now just insert a record ID yes ID ones using one swept names waived is twenty five successfully saved yes now at another record second record is Donald - yes the second record is added now I'm gonna create one more record 103 John 55 successfully saved yes now close this application what the shortcut created I am just around the shortcut just load yes what three records I just inserted it's displaying now I'm going to add one more record to to prove you that this is installed with database insert ok yes all the record are added has to see this video [Music]

Channel: Swift Learn

Views: 89,229

Keywords: how to create setup file in c#, create setup file with sql database, swift learn, setup file, create setup exe file, c#, create setup with database, create setup file with sql, setup file with sql, create setup file with database proof, c# tutorial, how to, create setup file in visual studio 2017, create setup file in c# windows application, setup file in visual studio, visual studio, windows, application, exe file, .mdf, visual studio code, create setup file in visual studio

Id: Olp5hQ_NaLQ

Length: 16min 0sec (960 seconds)

Published: Sat Feb 16 2019