SQL string in C#

welshboy2005 · June 3rd, 2005, 05:32 AM

I'm trying to output an sql string in Visual C#.NET. What is giving me problems is that I want to reference an integer variable I have already assigned eg.

int FacilityPage = GetParentId;

string SqlTest = "SELECT * FROM content[Mode] WHERE parentId=FacilityPage and classId='new'";
rptTest.Sql = SqlTest;

It compiles ok but I keep getting errors stating that FacilityPage is not a valid column name.

Can someone help me on this?

Cheers

r_ganesh76 · June 4th, 2005, 12:28 AM

you need to put like this C# cannot interpret the contents of your string

Code:

string SqlTest = "SELECT * FROM content[Mode] WHERE parentId=" + FacilityPage.ToString() + " and classId='new'";

Regards
Ganesh