Populating, Restore and Backup SQL Database using C#

27. May 2009 15:01

C# 

You want to add a functionality in your C# application to allow user to select the database to restore and taking backups of the database. C# provides the classes to allow a programmer to achieve this in the application.

 

Before you go and implement this feature in your application, make sure you have added the references of the following namespaces:

1.) Microsoft.SqlServer.Smo

2.) Microsoft.SqlServer.ConnectionInfo

 

Click the below link to download the full application

 

Download: DBBackup.zip (290.99 kb)

 


Currently rated 4.0 by 1 person

Import CSV File Into SQL Server Using Bulk Insert

25. May 2009 15:51

T-SQL 

You have large data to import to SQL Server, and you have all the data in a CSV File (Comma Seperated Value file). Are you going to map the field one by one? 

OR just use a small function od SQL to import everything in the table. But before you proceed with this you need to map each column of CSV with the one with your table column. Look at the below quick example on how to use the BULK INSERT to import CSV file data into SQL Server.

Step 1: Create a CSV file.

Step 2: Create a table and map the fields accordingly: (Check below screenshot)

 

Here is the CODE:

BULK INSERT TestTable
FROM 'c:\TestData.csv'  -- Full path of the CSV file
WITH
(
FIELDTERMINATOR = ',', --CSV field delimiter
ROWTERMINATOR = '\n'   --Use to shift the control to next row
)

 

Currently rated 3.7 by 3 people

Convert Numbers to Words in C#

24. May 2009 13:18

C# Code Snippets 

Use the below code to convert numbers to words and currency to word programatically (Check the code below). Instead you can create a DLL and use it or whatever the way you likeWink

Download the full Code from the below Link:

Usage: 

 

Download Link:

Num2Wrd.cs (8.30 kb)

 

Currently rated 4.6 by 12 people