ASP.net Create Table help Code Included

[TrAcER]

Sub CreateDatabase(ByVal dbName As String)

    Dim connectionString As String = "server='(local)'; trusted_connection=true; database='DNScards'"
    Dim dbConnection As System.Data.IDbConnection = New System.Data.SqlClient.SqlConnection(connectionString)

    Try
        dim cmdCreate as string = "CREATE DATABASE [" & dbName & "]"
        Dim dbCommand As System.Data.IDbCommand = New System.Data.SqlClient.SqlCommand
        dbCommand.CommandText = cmdCreate
        dbCommand.Connection = dbConnection

        dbConnection.Open
        dbCommand.ExecuteNonQuery
    Finally
        dbConnection.Close
    End Try
End Sub

any one see any problems with my code? dosent give me any errors, but also dosent work, tho i think it should, please help mr fix it

[crptcblade]

How could you know that it isn't giving you errors? You have a Try and a Finally, but no Catch portion to trap potential exceptions. Add a Catch to your Try block and see if an Exception is raised.

[TrAcER]

try and catch in asp.net? does that even work?

[crptcblade]

Yup, its just VB.NET after all. ASP is just the technology to render the output, but you are still running a VB.NET dll, with all the same syntax and everything available to a desktop app.

[TrAcER]

not sure how to debug in real time tho, do i have to take a look through the broweser? or can i do it in the ide?

[crptcblade]

You can set breakpoints in your code just like normal, and run it through the IDE. Execution should pause at the breakpoints like you would expect.

[TrAcER]

ok wicked i'll give it a try in about an hour

[mendhak]

Or in your Catch block, write to the console or even the page.

It should look something like this

Try
'All that code
Catch ex As Exception
   'write ex.Message.ToString
 
Catch sqlx As SqlException
    'sqlx.Message.ToString
 
Finally

etc, etc, etc.

[TrAcER]

right this is confusing the hell out of me now, opened what i originaly wrote in visual studio, but no code, i wrote it in web matrix coz that is the bomb for asp.net stuff, bloody code is gone arrrggg, can the try catch still be achived in web matrix, since there is still no one product that is visual studio, web matrix, dreamweaver combind, unless VWDE is that tool

[TrAcER]

ok ok, i messed up sorry, can you see the code, thats creting a new database, that works, can you see the title, i wanted to make a new table, dam im stupid sometimes, ok, now i captured that, any ideas on adding a new table to a database