Sign in to follow this  
Followers 0
rhishi20

how to concatenate

3 posts in this topic

I am working with vb.net and want to upload file. i am using stringbuilder for building sql query.

but not able to properly concatenate following sql statement in vb.net.

 

path = ConfigurationManager.AppSettings.Get("resDeptCommentPath")

 

.Append("actionDescFileName='" & fuActDescFile.FileName & "',actionfilepath='" & path & " " & '" & ViewState("DepartmentName") &"' & "ActionDescription" "',")

 

& represented with green color is the error spot and it gives expresssion expected error.

 

I guess, i am not concatenating things properly.

 

help will be appreciated.

 

note:don't consider .append for second line i have written this code in single line while coding.

Share this post


Link to post
Share on other sites

I don't think a single quote is a string delimiter in VB.NET. I believe a single quote begins a comment.

1 person likes this

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0