RE: Require suggestions for a tool to format sql strings to vb.net
Posted on 2008-10-16
I'm currently devloping vb.net asp controls and in many instances have to pass an sql string to SQL 2000/ 2005. So, for example, I'll be passing this string to an SQL database:
cSQL = "INSERT INTO aTable (f1, f2, f3,f4) VALUES ('" & cWRRNo & "','" & txtNotes.Text & "','" & "" & "','" & "1')"
I'm using Visual Web Developer to develop the code.
However, as anyone knows who has had to format many of these strings, it can be long and frustrating work to correctly format the string.
Is there a software tool I can use to ease this formatting? I also use Visual Studio 2005, but can't see any utilities in there.
Any help gratefully received.