rhishi20 2 Posted February 17, 2015 Report Share Posted February 17, 2015 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. Quote Link to post Share on other sites
Ingolme 1,021 Posted February 17, 2015 Report Share Posted February 17, 2015 I don't think a single quote is a string delimiter in VB.NET. I believe a single quote begins a comment. 1 Quote Link to post Share on other sites
rhishi20 2 Posted February 24, 2015 Author Report Share Posted February 24, 2015 Thanks ! this solves the problem Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.