Trim beginning and trailing spaces in Code Behind VB

Asked May 28 '19 at 16:34

Active May 28 '19 at 16:34

Viewed 38 times

I am trying to remove beginning and trailing spaces before my value is entered into the database. I tried the following but with no success and am struggling syntactically.

 SqlHelper.ExecuteNonQuery(SqlHelper.Command("dbo.spMYPROC_Insert", SqlHelper.Parameter("@myParameter", e.Values("myParameter"), Trim(Data.SqlDbType.VarChar))))

asked May 28 '19 at 16:34

Andy Williams

2

Your trimming the wrong thing: `Trim(e.Values("myParameter"))` – Alex K. May 28 '19 at 16:36
Than you that worked! – Andy Williams May 28 '19 at 16:46

Trim beginning and trailing spaces in Code Behind VB

0 Answers0