How to include char & in a string in VB.NET?

[david]

I do not how to include char & in a string. In C, use \&. But I do not know
how in VB.NET? any one give me hand?

I have the following error message.

David

......
Syntax error: Missing operand after ''&''prot='' operator.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.

Exception Details: System.Data.SyntaxErrorException: Syntax error: Missing
operand after ''&''prot='' operator.

Source Error:
Line 85:
Line 86:
'dsResource.Tables("Resource4Spec").Columns.Add("U RLQuery",
Type.GetType("System.String"), "MethodName +" & "'?pkey='" & "+ PatientKey")
Line 87:
dsResource.Tables("Resource4Spec").Columns.Add("UR LQuery",
Type.GetType("System.String"), "MethodName +" & "'?pkey='" & "+ PatientKey" &
"'&'" & "'prot='" & "+ Protocol")
Line 88:
Line 89: 'binding datagrid

[Kevin Spencer]

How about something like the following?

Dim s As String = "123&abc"

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
You can lead a fish to a bicycle,
but it takes a very long time,
and the bicycle has to *want* to change.

"david" <da***@discussions.microsoft.com> wrote in message
news:53**********************************@microsof t.com...

I do not how to include char & in a string. In C, use \&. But I do not
know
how in VB.NET? any one give me hand?

I have the following error message.

David

.....
Syntax error: Missing operand after ''&''prot='' operator.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about
the error and where it originated in the code.

Exception Details: System.Data.SyntaxErrorException: Syntax error: Missing
operand after ''&''prot='' operator.

Source Error:
Line 85:
Line 86:
'dsResource.Tables("Resource4Spec").Columns.Add("U RLQuery",
Type.GetType("System.String"), "MethodName +" & "'?pkey='" & "+
PatientKey")
Line 87:
dsResource.Tables("Resource4Spec").Columns.Add("UR LQuery",
Type.GetType("System.String"), "MethodName +" & "'?pkey='" & "+
PatientKey" &
"'&'" & "'prot='" & "+ Protocol")
Line 88:
Line 89: 'binding datagrid

[Karl Seguin]

I think you just got mixed up with your single quotes (you have '&''prot= ,
notice the double single quotes).

I _think_ this is what you want:
"MethodName +" & "'?pkey='" & "+ PatientKey" & " + '&prot='" & "+ Protocol"

I also don't understand why you are breaking up ur string..wouldn't:
"MethodName + '?pkey=' + PatientKey + '&prot='+ Protocol"

work just as well and be a way easier to read?

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/
http://openmymind.net/redirector.aspx?documentId=51 - Learn about AJAX!

"david" <da***@discussions.microsoft.com> wrote in message
news:53**********************************@microsof t.com...

I do not how to include char & in a string. In C, use \&. But I do not
know
how in VB.NET? any one give me hand?

I have the following error message.

David

.....
Syntax error: Missing operand after ''&''prot='' operator.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about
the error and where it originated in the code.

Exception Details: System.Data.SyntaxErrorException: Syntax error: Missing
operand after ''&''prot='' operator.

Source Error:
Line 85:
Line 86:
'dsResource.Tables("Resource4Spec").Columns.Add("U RLQuery",
Type.GetType("System.String"), "MethodName +" & "'?pkey='" & "+
PatientKey")
Line 87:
dsResource.Tables("Resource4Spec").Columns.Add("UR LQuery",
Type.GetType("System.String"), "MethodName +" & "'?pkey='" & "+
PatientKey" &
"'&'" & "'prot='" & "+ Protocol")
Line 88:
Line 89: 'binding datagrid

[david]

Thank you all.

I will try it tomorrow in workplace.
MethodName, PatientKey, Protocol are column names.

David

"Karl Seguin" wrote:

I think you just got mixed up with your single quotes (you have '&''prot= ,
notice the double single quotes).

I _think_ this is what you want:
"MethodName +" & "'?pkey='" & "+ PatientKey" & " + '&prot='" & "+ Protocol"

I also don't understand why you are breaking up ur string..wouldn't:
"MethodName + '?pkey=' + PatientKey + '&prot='+ Protocol"

work just as well and be a way easier to read?

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/
http://openmymind.net/redirector.aspx?documentId=51 - Learn about AJAX!

"david" <da***@discussions.microsoft.com> wrote in message
news:53**********************************@microsof t.com...

I do not how to include char & in a string. In C, use \&. But I do not
know
how in VB.NET? any one give me hand?

I have the following error message.

David

.....
Syntax error: Missing operand after ''&''prot='' operator.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about
the error and where it originated in the code.

Exception Details: System.Data.SyntaxErrorException: Syntax error: Missing
operand after ''&''prot='' operator.

Source Error:
Line 85:
Line 86:
'dsResource.Tables("Resource4Spec").Columns.Add("U RLQuery",
Type.GetType("System.String"), "MethodName +" & "'?pkey='" & "+
PatientKey")
Line 87:
dsResource.Tables("Resource4Spec").Columns.Add("UR LQuery",
Type.GetType("System.String"), "MethodName +" & "'?pkey='" & "+
PatientKey" &
"'&'" & "'prot='" & "+ Protocol")
Line 88:
Line 89: 'binding datagrid