SQLQUERY

Hi,

Here is my SQL Query.

SQL = "insert into mnetwork..tblContactCorr(CorrespondentID,Name,Phone,Fax,Email,UserName,rowguid,Status,ChgPassword,lastlogin,MailNotification,USerLevel,LocationID,msrepl_tran_version)"
SQL = SQL & " values( '" & drpCorr.SelectedValue & "', '" & txtName.Text & "', '" & txtphone.Text & "', '" & txtFax.Text & "', '" & txtEmail.Text & "', '" & txtUserName.Text & "', '" & mGuid & "', '" & drpstatus.SelectedValue & "', '" & "Null" & "', '" & getdate & "', '" & drpmn.SelectedValue & " ', '" & drpuserlevel.SelectedValue & "', '" & drplocation.SelectedValue & "', '" & "Null" & "')"
Dim dbcommand As New SqlCommand(SQL, ObjConn)
ObjConn.Open()
dbcommand.ExecuteNonQuery()------>here is the problem

dbcommand = New SqlCommand("select @@identity", ObjConn)
Dim NewUserID = dbcommand.ExecuteScalar



After executing i am getting error like this:Message "Syntax error converting from a character string to uniqueidentifier." String

I don't know how to convert mguid into uniqueidentifier.

here is my batabase fields:

ContactID-->this is auto increment
CorrespondentID--int
Name-varchar
Phone-varchar
Fax-varchar
EMail-varchar
UserName-varchar
rowguid--uniqueiduntifier
status-tiniint
chgpassword-snallint
lastlogin--datetime
mailnotification--smallint
locationid--int
msrepl_tran_version-uniqueiduntifier -(this is null)

let me know whats wrong in this?