Execute Create Table Command From Asp.net

I have a little application that I have designed where I need to be able to execute create table and create function comands against the database.

It seems that it does not like my sql file. Does anyone know of a different method of doing this?

 

Error message

Line 2: Incorrect syntax near 'GO'.

Line 4: Incorrect syntax near 'GO'.

Line 8: Incorrect syntax near 'GO'.

'CREATE FUNCTION' must be the first statement in a query batch.

Must declare the variable '@usb'.

Must declare the variable '@usb'.

Must declare the variable '@i'.

A RETURN statement with a return value cannot be used in this context.

Line 89: Incorrect syntax near 'GO'.

Line 91: Incorrect syntax near 'GO'.

Line 94: Incorrect syntax near 'GO'.

 

Protected Sub Install()

   Dim err As String = ""

While err.Length < 1

'      Dim your StreamReader

      Dim TextFileStream As System.IO.TextReader

      'Load the textfile into the stream

      TextFileStream = System.IO.File.OpenText(Request.PhysicalApplicationPath & "Scripts.sql")

      'Read to the end of the file into a String variable.

      executesql(TextFileStream.ReadToEnd, err)

 

      err = "Susscessful"

End While

If err = "Susscessful" Then

      Response.Redirect("Default.aspx")

Else

      Me.lblError.Text = err

End If

End Sub

Private Function executesql(ByVal s As String, ByRef err As String) As Boolean

Try

      Dim conn As New Data.SqlClient.SqlConnection(GenConString())

      Dim cmd As New Data.SqlClient.SqlCommand(s, conn)

      conn.Open()

      cmd.ExecuteNonQuery()

      conn.Close()

      Return True

   Catch ex As Exception

      err = ex.Message.ToString

      Return False

   End Try

End Function





Example sql file

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_NULLS ON

GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MyFunc]') and xtype in (N'FN', N'IF', N'TF'))

drop function [dbo].[MyFunc]

GO

CREATE FUNCTION [dbo].[MyFunc]

(

-- Add the parameters for the function here



)

RETURNS varchar(1000)

AS

BEGIN

-- Declare the return variable here

DECLARE @Result varchar(1000)

-- Add the T-SQL statements to compute the return value here

-- Do something here

-- Return the result of the function

RETURN @Result

END

GO

SET QUOTED_IDENTIFIER OFF

GO

SET ANSI_NULLS ON

GO