Convert Dataset to Recordset in C#

[Marathoner]

I am trying to convert a dataset to an ADODB.Recordset . I create the sxl
file and open it in VB.NET by using:
Dim rs as ADODB.Recordset
rs.Open("C:\fil es\xslfile.xsl" )

I want to do this same thing in C#. The open method in C# takes several
additional parameters in addition to the xsl file:
rs.Open("C:\fil es\xslfile.xsl" , object ActiveConnectio n,
ADODB.CursorTyp eEnum, ADODB.LockTypeE num, int Options)

While it may seem very obvious to everyone, I am having trouble providing
valid arguments to make this method work.

Any help is greatly appreciated.

Robert
--
Robert Hill
Senior Programmer/Analyst
Wake Forest Univ Baptist Med Ctr

[Jeff Gaines]

On 30/12/2004 Marathoner wrote:

I am trying to convert a dataset to an ADODB.Recordset . I create the
sxl file and open it in VB.NET by using:
Dim rs as ADODB.Recordset
rs.Open("C:\fil es\xslfile.xsl" )

I want to do this same thing in C#. The open method in C# takes
several additional parameters in addition to the xsl file:
rs.Open("C:\fil es\xslfile.xsl" , object ActiveConnectio n,
ADODB.CursorTyp eEnum, ADODB.LockTypeE num, int Options)

While it may seem very obvious to everyone, I am having trouble
providing valid arguments to make this method work.

Any help is greatly appreciated.

Robert

Hi Robert.

This is how I use an Access database:

string strConnection;
string strQuery;

strConnection = "Provider=Micro soft.Jet.OLEDB. 4.0;";
strConnection += " Data Source=";
strConnection += this.m_strDBNam e;
strConnection += ";";

strQuery = "SELECT * FROM " + this.m_strTable Name + " WHERE blnCompany
= True";

adCON.Open(strC onnection, "", "", 0);
adRS.Open(strQu ery, adCON, ADODB.CursorTyp eEnum.adOpenKey set,
ADODB.LockTypeE num.adLockOptim istic ,0);

Can you pick the bones from that?

--
Jeff Gaines
Posted with XanaNews 1.17.1.2 http://www.wilsonc.demon.co.uk/delphi.htm

[Marathoner]

Thanks for the reply.

I am opening a recordset from a xsl file, not a database. How would you do
that in C#?

Robert

"Jeff Gaines" wrote:

On 30/12/2004 Marathoner wrote:

I am trying to convert a dataset to an ADODB.Recordset . I create the
sxl file and open it in VB.NET by using:
Dim rs as ADODB.Recordset
rs.Open("C:\fil es\xslfile.xsl" )

I want to do this same thing in C#. The open method in C# takes
several additional parameters in addition to the xsl file:
rs.Open("C:\fil es\xslfile.xsl" , object ActiveConnectio n,
ADODB.CursorTyp eEnum, ADODB.LockTypeE num, int Options)

While it may seem very obvious to everyone, I am having trouble
providing valid arguments to make this method work.

Any help is greatly appreciated.

Robert

Hi Robert.

This is how I use an Access database:

string strConnection;
string strQuery;

strConnection = "Provider=Micro soft.Jet.OLEDB. 4.0;";
strConnection += " Data Source=";
strConnection += this.m_strDBNam e;
strConnection += ";";

strQuery = "SELECT * FROM " + this.m_strTable Name + " WHERE blnCompany
= True";

adCON.Open(strC onnection, "", "", 0);
adRS.Open(strQu ery, adCON, ADODB.CursorTyp eEnum.adOpenKey set,
ADODB.LockTypeE num.adLockOptim istic ,0);

Can you pick the bones from that?

--
Jeff Gaines
Posted with XanaNews 1.17.1.2 http://www.wilsonc.demon.co.uk/delphi.htm

[Lasse Vågsæther Karlsen]

Marathoner wrote:

Thanks for the reply.

I am opening a recordset from a xsl file, not a database. How would you do
that in C#?

<snip>

Why not use the OleDb .net classes ?

You can use the same provider as you would for ADODB.Connectio n.

--
Lasse Vågsæther Karlsen
http://www.vkarlsen.no/
mailto:la***@vk arlsen.no
PGP KeyID: 0x0270466B

[Robert]

Thanks.
I must not understand recorsets and xml. In VB.NET I can open a recordset by:
rs.Open("C:\Fil es\MyXsl.xsl")
I have written this applicaton in C# and the addional arguments are
required. I do not need a connection. I have a xsl file created from a
dataset. I just need to populate the recordset with this data.
If I can't get this resolved, I may have to rewrite this in VB.NET even
though I want to continue my learning exprience in C#.

Robert
"Lasse Vågsæther Karlsen" wrote:

Marathoner wrote:

Thanks for the reply.

I am opening a recordset from a xsl file, not a database. How would you do
that in C#?

<snip>

Why not use the OleDb .net classes ?

You can use the same provider as you would for ADODB.Connectio n.

--
Lasse Vågsæther Karlsen
http://www.vkarlsen.no/
mailto:la***@vk arlsen.no
PGP KeyID: 0x0270466B

[Jeff Gaines]

On 30/12/2004 Marathoner wrote:

Thanks for the reply.

I am opening a recordset from a xsl file, not a database. How would
you do that in C#?

Robert

I wouldn't, I would convert the Excel file into an Access database
since in my view it's a better way to keep data.

A quick look at help shows a subject 'Excel, Importing Data' which may
help, it seems quite similar with an additional step to select the
correct worksheet.

--
Jeff Gaines
Posted with XanaNews 1.17.1.2 http://www.wilsonc.demon.co.uk/delphi.htm

[Robert]

I agree if I were using Excel .xls files. This is a .xsl file which is an
ADO Recordset format for defining the schema.

Robert

"Jeff Gaines" wrote:

On 30/12/2004 Marathoner wrote:

Thanks for the reply.

I am opening a recordset from a xsl file, not a database. How would
you do that in C#?

Robert

I wouldn't, I would convert the Excel file into an Access database
since in my view it's a better way to keep data.

A quick look at help shows a subject 'Excel, Importing Data' which may
help, it seems quite similar with an additional step to select the
correct worksheet.

--
Jeff Gaines
Posted with XanaNews 1.17.1.2 http://www.wilsonc.demon.co.uk/delphi.htm

[Jeff Gaines]

On 30/12/2004 Robert wrote:

I agree if I were using Excel .xls files. This is a .xsl file which
is an ADO Recordset format for defining the schema.

Robert

Sorry, must have Excel on my mind :-)

The example I gave included the extra parameters, did you try them?

--
Jeff Gaines
Posted with XanaNews 1.17.1.2 http://www.wilsonc.demon.co.uk/delphi.htm

[Robert]

No. I have the data. I do not need to open a recordset and obtaion data
from a database. The data is coming form the dataset passed into the
procedure. I am creating a recordset from the data in the dataset. As part
of this process, I create a .xsl file which comtains both the schema and the
data. I need to open the recordset with this .xsl file. VB.NET is like this:

rs.Open("C"\Fil es\MyXslFile.xs l")

I want to do it in C# which is like this:

rs.Open("C:\fil es\xslfile.xsl" , object ActiveConnectio n,
ADODB.CursorTyp eEnum, ADODB.LockTypeE num, int Options)

Since I do not need a connection, cursor type, lock type, or any options,
how is this accomplished?


"Jeff Gaines" wrote:

On 30/12/2004 Robert wrote:

I agree if I were using Excel .xls files. This is a .xsl file which
is an ADO Recordset format for defining the schema.

Robert

Sorry, must have Excel on my mind :-)

The example I gave included the extra parameters, did you try them?

--
Jeff Gaines
Posted with XanaNews 1.17.1.2 http://www.wilsonc.demon.co.uk/delphi.htm

[BBFrost]

Robert,

One of the major differences between VB.Net and C#.Net that causes problems
with interop and things like you're trying to do is that there are no
optional parameters in C#.

As a result you must supply a value for all parameter values of a method or
class call.

With interop I've used oMissingValue as defined below for parameters that
don't require actual values.

object oMissingValue = Type.Missing; &
object oMissingValue = System.Reflecti on.Missing.Valu e;

Hope this helps.

Barry
in Oregon

"Robert" <rh******@hotma il.com> wrote in message
news:96******** *************** ***********@mic rosoft.com...

No. I have the data. I do not need to open a recordset and obtaion data
from a database. The data is coming form the dataset passed into the
procedure. I am creating a recordset from the data in the dataset. As part of this process, I create a .xsl file which comtains both the schema and the data. I need to open the recordset with this .xsl file. VB.NET is like this:
rs.Open("C"\Fil es\MyXslFile.xs l")

I want to do it in C# which is like this:

rs.Open("C:\fil es\xslfile.xsl" , object ActiveConnectio n,
ADODB.CursorTyp eEnum, ADODB.LockTypeE num, int Options)

Since I do not need a connection, cursor type, lock type, or any options,
how is this accomplished?


"Jeff Gaines" wrote:

On 30/12/2004 Robert wrote:

I agree if I were using Excel .xls files. This is a .xsl file which
is an ADO Recordset format for defining the schema.

Robert

Sorry, must have Excel on my mind :-)

The example I gave included the extra parameters, did you try them?

--
Jeff Gaines
Posted with XanaNews 1.17.1.2 http://www.wilsonc.demon.co.uk/delphi.htm