Can if loop statement written in string builder . append method ?

Question

0.00/5 (No votes)

See more:

Below is my statement in string builder but do not give me any confirmation box can any one help me?

MySql = " Select PR_EMPLOYEE_MASTER.ID from PR_EMPLOYEE_MASTER, PR_DESIG_MASTER " & _
" where PR_EMPLOYEE_MASTER.PR_DESIG_MASTER_ID = PR_DESIG_MASTER.RPT_DESIG_MASTER_ID And " & _
" PR_DESIG_MASTER.ID =" & Trim(e.Item.Cells(1).Text) & _
" And PR_EMPLOYEE_MASTER.Emp_Location_Master_Id =" & Trim(new_location_id)

tTempEmp = RSmartUtl.GetSqlColVal(MySql, 1)

aryEmp = Split(tTempEmp, ",", "-1")

strBuilder.Append("If ( Confirm('Do You want to change the Reporting Manager To ')== true )" & aryEmp(0) & vbCrLf)
strBuilder.Append("End If" & vbCrLf)

Posted 25-Feb-14 23:14pm

Member 9410081

Add a Solution

3 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abhinav S · Answer 1 · 2014-02-25T23:27:00

Solution 1

An if loop cannot be written inside the string build with quotes.
Try without the quotes as follows -

If ( Confirm('Do You want to change the Reporting Manager To ')== true) strBuild.Append(aryEmp(0);
Ebd If

Also, explore the quick If.
E.g.

If(ApplyValue IsNot Nothing AndAlso ApplyValue IsNot...) & _

Permalink

Posted 25-Feb-14 23:27pm

Abhinav S

Comments

Member 9410081 26-Feb-14 4:34am

This is giving error in vb.net

OriginalGriff · Answer 2 · 2014-02-25T23:28:00

Solution 2

Well no, it won't.
It's a string: not a command.
If you want it executed, then you have to do something with it.
That just creates a string in a StringBuilder and does nothing with it.
If you want it executed, then you probably want to convert it to a string using the ToString Method, surround it with the appropriate HTML and pass it up to the client...

Permalink

Posted 25-Feb-14 23:28pm

OriginalGriff

Comments

Member 9410081 26-Feb-14 4:36am

I want to show a confirmation window and if it is true then want to execute another statement so can u help?

Member 9410081 · Answer 3 · 2014-02-26T00:07:00

Solution 3

If (confirm('Do You want to change the Reporting Manager To ')== true)

Permalink

Posted 26-Feb-14 0:07am

Member 9410081

Can if loop statement written in string builder . append method ?

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Can if loop statement written in string builder . append method ?

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us