How to run a sql script file on Sql server Express edition 2005 using C# code

[EDN Admin]

Hi all,
            I have to run a group of sql commands which are stored in a file (sqlscript.sql) on Sql Server Expression Edition 2005 using my C# code. 

That sql script contains the creation of Logins to the Sql Server and creating the Users for those logins to the specific database.

How can I do this. Please help me out.

Here is the sql script that I want to run on Sql Server Express Editon 2005

<font size=2>
--delete the User [SmartCarLocalSqlServer] from UpLink_Helo
USE [Master]
GO
IF EXISTS (SELECT * FROM sys.database_principals WHERE name = NSmartCarLocalSqlServer)
DROP USER [SmartCarLocalSqlServer]
GO
--delete the user [SmartCarUser] from UpLink_Helo
USE [Master]
GO
IF EXISTS (SELECT * FROM sys.database_principals WHERE name = NSmartCarUser)
DROP USER [SmartCarUser]
--delete the Login [SmartCarLocalSqlServer]
IF EXISTS (SELECT * FROM sys.server_principals WHERE name = NSmartCarLocalSqlServer)
DROP LOGIN [SmartCarLocalSqlServer]
--delete the Login [SmartCarUser]
IF EXISTS (SELECT * FROM sys.server_principals WHERE name = NSmartCarUser)
DROP LOGIN [SmartCarUser]
--create the Login [SmartCarLocalSqlServer]
CREATE LOGIN [SmartCarLocalSqlServer] WITH PASSWORD=NClubCar2008, DEFAULT_DATABASE=[Master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=ON,
CHECK_POLICY=ON
GO
--create the Login [SmartCarUser]
CREATE LOGIN [SmartCarUser] WITH PASSWORD=NClubCar2008, DEFAULT_DATABASE=[Master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=ON
GO
--Create the User [SmartCarLocalSqlServer] for login [SmartCarLocalSqlServer]
-- for Master database
USE [Master]
GO
CREATE USER [SmartCarLocalSqlServer] FOR LOGIN [SmartCarLocalSqlServer] WITH DEFAULT_SCHEMA=[dbo]
Go
--create the User [SmartCarUser] for Login [SmartCarUser]
--for Master database
USE [Master]
GO
CREATE USER [SmartCarUser] FOR LOGIN [SmartCarUser] WITH DEFAULT_SCHEMA=[dbo]
GO </font> 

View the full article