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

How to Pass Data from one Form to other Form in windows Form Application C#

Introduction: Hi Guys! In this tutorial we learn how to pass data from one form to other form in windows form application using c#. Let’s Follow the Step and create windows form application. Step1: Visual studio- à File- à New- à Project à windows Form Application- à Ok Step2: Click on ToolBox- à Drag and drop Label and TextBox. I creat a Form with 3 Labels and TextBox as shown in fig. Step 3: I have Name,Fname,Address Label on Form .so I take a three global variable .Write this code on the Form1.cs public static string SetValueForText1 = "" ; public static string SetValueForText2 = "" ; public static string SetValueForText3 = "" ; Step4: Project- à Add Windows Form- à Click on Add Step 5: After Creating Form Double Click on Submit button on windows Form1 and Write the Cod...

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 (); ...

ShamsiTech

Search This Blog