I am using too lengthy connection string, when brek the connection string it show error : "Newline In constant "
qs = "INSERT INTO EMPLOYEE (Name_1,Org_2,Nat_Bus3,Year_4,Plevel_5,Gross_7,B_8,A_8,B_9,A_9,B_10 ,A_10 ,B_11 ,A_11
,B_12 ,A_12 ,B_13 ,A_13 VALUES (‘ “+TB2_NAO.SelectedValue+” ‘ ,‘
“+DDQ3NoB.SelectedValue+” ‘ ,‘ “+DDQ4HMY.SelectedValue+” ‘ ,
‘ “+DDQ5POL.SelectedValue+” ‘ ,‘ “+DDQ6REM.SelectedValue+” ‘ , ‘
“+DDQ7AGS.SelectedValue+” ‘ );
How to break it?
|
| Author: Vasudevan Deepak Kumar 21 Jun 2007 | Member Level: Diamond | Rating:  Points: 2 |
You can use your Visual Studio's Word Wrap option to see soft break instead.
Also, you can build the string using StringBuilder instead of costly string concatenation.
Also, you are meaning a 'query' and not a 'connection string'. Both are different.
|
| Author: Rajaraman 21 Jun 2007 | Member Level: Diamond | Rating: Points: 2 |
Yeah. vasudevan is pointed out correcly..
|