Passing a node value as an SQL parameter

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

vpman - 09 Dec 2005 00:44 GMT

I would like the value of a text box to be used as part of the SQ
SELECT statement along the lines of SELECT * FROM TABLE WHERE FIELD
"Text Box Value".
I have tried using "/my:myFields/my:TextBox" however I am obviousl
doing something wrong.
Could someone please help

Reply to this Message

Franck Dauché - 09 Dec 2005 02:26 GMT

Hi,

what about:
IXMLDOMNode oNode =
thisXDocument.DOM.selectSingleNode("/my:myFields/my:TextBox");
string sSQL = "Select * from tblTest where Test = '" + oNode.text + "'";

Regards,

Franck Dauché

> I would like the value of a text box to be used as part of the SQL
> SELECT statement along the lines of SELECT * FROM TABLE WHERE FIELD =
> "Text Box Value".
> I have tried using "/my:myFields/my:TextBox" however I am obviously
> doing something wrong.
> Could someone please help?

Reply to this Message