Looking for CSharp equivalent of SQLBindCol

[Faheem Khan]

I'm trying to get some XML data stored as binary data in a MS SQL server
database's table using C#

I have code which used to extract this data in C++
Pasting the functions used in C++ to get the same data...
sr = SQLExecDirect(h stmt1, (SQLCHAR *)szSQLQuery, SQL_NTS);
sr = SQLBindCol(hstm t1, (UWORD)1, SQL_C_BINARY, prgbReq, *pcbReq, (long
*)pcbReq);
sr = SQLBindCol(hstm t1, (UWORD)2, SQL_C_BINARY, prgbRsp, *pcbRsp, (long
*)pcbRsp);

thnx a lot for your help. Appreciate it.

_Faheem

[Faheem Khan]

Re: Looking for CSharp equivalent of SQLBindCol

FYI:
Got this figured out. The Encoding, Decoder name classes are helpful to get
details.

_Faheem


"Faheem Khan" <fak_4u@hotmail .com> wrote in message
news:%23lggsoeX FHA.2080@TK2MSF TNGP15.phx.gbl. ..[color=blue]
> I'm trying to get some XML data stored as binary data in a MS SQL server
> database's table using C#
>
> I have code which used to extract this data in C++
> Pasting the functions used in C++ to get the same data...
> sr = SQLExecDirect(h stmt1, (SQLCHAR *)szSQLQuery, SQL_NTS);
> sr = SQLBindCol(hstm t1, (UWORD)1, SQL_C_BINARY, prgbReq, *pcbReq, (long
> *)pcbReq);
> sr = SQLBindCol(hstm t1, (UWORD)2, SQL_C_BINARY, prgbRsp, *pcbRsp, (long
> *)pcbRsp);
>
> thnx a lot for your help. Appreciate it.
>
> _Faheem
>[/color]