Generate Sql Script with Data

Generate Sql Script with Data

In this Article we learn how to generate sql Database script with Data.

Step1:

Open Sql Server and right click on the Specific database(for which you want to creat script)

Database -------> Right click --------> Task‑‑‑‑‑‑‑>Generate Scripts

Step2:

Now Click on Next Button

Step3:

Click on Next button

Step4:

Now Click on Advanced .

Step 5:

Select Schema and data‑‑‑‑‑‑‑>Click on OK

Step 6:

Give the Script Name and location where you want to save it ------->Click on Next

Step 7:

Click on Finish.

Comments

Working With a Binding Navigator Control in Windows Forms

Definition : BindingNavigator control Provide user interface with a simple data navigation and manipulation on the form . it is used for Binding the Database Tables values to the control (Datagridview,Text Box, label etc.). BindingNavigator with the BindingSource enable users to move through data records on a form and interact with the records. There are few buttons in binding Navigator listed below: 1. Move First--------------- à Go first record of the table 2. Move Next--------------- à Go Next record of the table with respect to current record. 3. Move Previous---------- à Go previous record of the table. 4. Move Last---------------- à Go Last record of the table. 5. Delete---------------------- à Delete selected row (record). 6. Add New-------------------- à Add New Row. 7. ...

Autocomplete TextBox in Windows Form Application using SQL Server

Autocomplete TextBox in Windows Form Application using SQL Server. In this article we Lear how to create autocompelete textbox on the basis of sql server data. Step 1: First open visual Studio ---->File---->New---->Project----->Windows From Application---->Ok Drag and Drop label and TextBox. Step 2: Now Double Click on Windows Form and write the following Code : SqlConnection con = new SqlConnection ( @"Data Source=IS9;Initial Catalog=practice;User ID=sa;Password=abc" ); public void loadData() { con.Open(); AutoCompleteStringCollection namesCollection = new AutoCompleteStringCollection (); ...

Login Form Using LINQ in Windows Forms Application

Step 1: First we create a database and then Table in SQL Server. Here we create a table named “logintb”. Now insert a name and Password into the logintb table. Step 2: Open Visual Studio then select "File" -> "New" -> "Project..." then select "Windows Forms". Drag and drop a Label for ID and a Label for password. Drag and drop a TextBox for txtuser and a TextBox for txtPassword. Drag and drop a Button for Login. Step 3: Go to the project then right-click and seelct "Add" -> "New Item..." then select "Windows Form" -> "LINQ to SQL Classes" then click on "Add". Now go to the Server Explorer, drag and drop the logintb table as in the following: Open Server Explorer and select the database and then the table. Step 4 : Now double-click on the button Login in the form and write the following code: CS Code: using System; using System.Collections.Generic; using System.Comp...

ShamsiTech

Search This Blog