Welcome to FoxLearn In this tutorial, I'll show you how to create a setup file in visual studio 2019 with SQL local database using ClickOnce deployment To play the demo, you should create a new windows forms application, then add the service based database to your project Next, You need to connect to the local database from the visual studio, then add a simple customer table to the local database You need to add new data sources to your project, then enter the connection string name and select the table you want to add to your DataSet After you have defined a data type as a data source in a project, you can create forms that display model data by dragging items from the Data Sources window into your winform These items become controls on the form that are bound to the data source As you can see, the Binding Source component will automatically add to your form when dragging items from the data source window into your form The BindingSource component serves two purposes First, it provides a layer of indirection when binding the controls on a form to data This is accomplished by binding the BindingSource component to your data source, and then binding the controls on your form to the BindingSource component All further interaction with the data, including navigating, sorting, filtering, and updating, is accomplished with calls to the BindingSource component Second, the BindingSource component can act as a strongly typed data source You can easily modify your layout after dragging items from the data source window into your winform You can add CheckedChanged event handlers to the GenderCheckBox control allows you to change text to male or female based on gender value To fix the error, you need to open the DataSet Next, set the automatic increase value for the ID field You can find your local database in the debug folder, remember that each time you rebuild your project, all data in the debug folder will be deleted To create a ClickOnce deployment, you need to create a test certificate Signing the manifests ensures that no one can tamper with your deployment and download it to another computer in place of yours You need to select the folder you want to publish, or you can enter your ftp account to publish your application to the ftp server Next, Enter the URL that you will provide when you deploy the application. Select the the application should check for updates check box, and then click before the application starts radio button This will enable automatic updates You should enter the URL that you want to download your application update As you can see, our database automatically adds to the list of installed files You should install all prerequisites on your client machine When you actually deploy your application to a customer, you will have to select the appropriate version of the .NET Framework and Windows Installer, plus any other prerequisites you need The prerequisites are installed the first time the user runs the application setup program At a minimum, you must complete the Product name and Publisher name In the Product name text box, type the name of the application shortcut In the Publisher name text box, type the name of the folder that will be listed on the Windows Start menu In the Suite name text box, type the name of the subfolder that will appear under the Publisher name You can also specify a Support URL and an Error URL that users can go to if they experience installation problems Click the Manifests item, and then select the Create desktop shortcut check box When the user installs the application, it will create a desktop shortcut in addition to the shortcut on the Start menu You need to enter your ftp account to publish your application to the ftp server Right click on your project, then select open folder in file explorer from the menu, then you can find your setup file in the debug folder Thank you for watching this video and don't forget to subscribe to my channel
