how to concatenate

[rhishi20 2]

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.

[Ingolme 1,001]

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

[rhishi20 2]

Thanks ! this solves the problem