Writing SQL Code in C#

[NiteshR]

Hi,
Will someone please help me with this.
I am using Visual Studio 2005 (C#).
I would like to write SQL queries in my code and assign it a variable thereafter.
Would someone please help me with this urgently.
Thanx.

[gomzi]

Hi,
Will someone please help me with this.
I am using Visual Studio 2005 (C#).
I would like to write SQL queries in my code and assign it a variable thereafter.
Would someone please help me with this urgently.
Thanx.

Your query cant be more vague than that man!!

anyway....
dim str as string = "select * from blah";

is this legal??yup.

[Plater]

I find the best method is to use a string and break it into parts.

string StringVarriableForLastName="Plater";
string myq="";

myq="Select ";
myq+=" C.* ";
myq+=" FROM ";
myq+=" CustomersTable AS C ";
myq+=" WHERE ";
myq+=" C.LastName='"+StringVarriableForLastName+"' ";
myq+=" AND C.FirstName LIKE 'A' ";
myq+=";";

when you have a big querry, I like to seperate it out on lines so I can comment out or re-arrange them later.

[NiteshR]

I find the best method is to use a string and break it into parts.

string StringVarriableForLastName="Plater";
string myq="";

myq="Select ";
myq+=" C.* ";
myq+=" FROM ";
myq+=" CustomersTable AS C ";
myq+=" WHERE ";
myq+=" C.LastName='"+StringVarriableForLastName+"' ";
myq+=" AND C.FirstName LIKE 'A' ";
myq+=";";

when you have a big querry, I like to seperate it out on lines so I can comment out or re-arrange them later.

Hi, this doesnt seem to work.
when i output the value from the variable 'myq', it shows me the coding text
as typed.

[Plater]

Are you actually in the dev-enivironment or in some sort of SQL Query creation zone?

what I typed would be place in your C# code section, if you were in a query creation zone, just type it out.
The output of my string should look like this

Select C.* FROM CustomersTable AS C WHERE C.LastName='Plater' AND C.FirstName LIKE 'A' ;