ASP.NET

private static void CreateDBAndTables(SqlConnection sqlCon)
        {
            string[] SqlLine;
            Regex regex = new Regex("^GO", RegexOptions.IgnoreCase | RegexOptions.Multiline);

            string txtSQL = GetScript("createDB.sql");
            SqlLine = regex.Split(txtSQL);
            ExecuteSql(sqlCon, SqlLine);
}


private static void ExecuteSql(SqlConnection sqlCon, string[] SqlLine)
		{
			SqlCommand cmd = sqlCon.CreateCommand();
			cmd.Connection = sqlCon;

			foreach(string line in SqlLine)
			{
				if(line.Length>0)
				{
					cmd.CommandText = line;
					cmd.CommandType = CommandType.Text;
					try
					{
						cmd.ExecuteNonQuery();
					}
					catch(SqlException)
					{
						break;
					}
				}
			}
		}