Generic class which takes command string and returns datareader?

[=?Utf-8?B?UGV0ZXI=?=]

I'm trying to create a generic class which will take a command string and I
can issue statement like this:

Dim rdrCustomers As New Generic_Reader( "select * from customers")

However, I have not found anyway to do that. It seems that I may need to
create some functions instead of class and issue statement like this:

Dim rdrCustomers As SqlDataReader = GetDataReader(" select * from customers")

[rowe_newsgroups]

On Aug 28, 12:30 am, Peter <Pe...@discussi ons.microsoft.c omwrote:

I'm trying to create a generic class which will take a command string and I
can issue statement like this:

Dim rdrCustomers As New Generic_Reader( "select * from customers")

However, I have not found anyway to do that. It seems that I may need to
create some functions instead of class and issue statement like this:

Dim rdrCustomers As SqlDataReader = GetDataReader(" select * from customers")

Huh?

You want to pass a connection string into a class constructor for a
datareader right?

How about:

Public Class MyDataReader
Inherits SqlDataReader

Public Sub New(queryString as String)
Dim conn As New SqlConnection(c onnString)
Dim com As SqlCommand = conn.CreateComm and()
com.CommandType = CommandType.Tex t
com.CommandText = queryString
Me = com.ExecuteRead er()
End Sub
End Class

I just typed that in the message, so it might not work properly, but
it should give you a start. Also I 100% recommend you have this class
implement IDisposable and manually dispose of the Connection and
Command objects from within the classes Dispose method.

Thanks,

Seth Rowe

[Jack Jackson]

On Tue, 28 Aug 2007 03:30:47 -0700, rowe_newsgroups
<ro********@yah oo.comwrote:

>On Aug 28, 12:30 am, Peter <Pe...@discussi ons.microsoft.c omwrote:

>I'm trying to create a generic class which will take a command string and I
can issue statement like this:

Dim rdrCustomers As New Generic_Reader( "select * from customers")

However, I have not found anyway to do that. It seems that I may need to
create some functions instead of class and issue statement like this:

Dim rdrCustomers As SqlDataReader = GetDataReader(" select * from customers")

Huh?

You want to pass a connection string into a class constructor for a
datareader right?

How about:

Public Class MyDataReader
Inherits SqlDataReader

Public Sub New(queryString as String)
Dim conn As New SqlConnection(c onnString)
Dim com As SqlCommand = conn.CreateComm and()
com.CommandType = CommandType.Tex t
com.CommandText = queryString
Me = com.ExecuteRead er()
End Sub
End Class

I just typed that in the message, so it might not work properly, but
it should give you a start. Also I 100% recommend you have this class
implement IDisposable and manually dispose of the Connection and
Command objects from within the classes Dispose method.

Thanks,

Seth Rowe

You can't inherit from SqlDataReader. You could probably put the code
above in New() in a Shared function and return the DataReader.

[rowe_newsgroups]

On Aug 28, 10:04 am, Jack Jackson <jacknos...@peb bleridge.comwro te:

On Tue, 28 Aug 2007 03:30:47 -0700, rowe_newsgroups

<rowe_em...@yah oo.comwrote:

On Aug 28, 12:30 am, Peter <Pe...@discussi ons.microsoft.c omwrote:

I'm trying to create a generic class which will take a command string and I
can issue statement like this:

Dim rdrCustomers As New Generic_Reader( "select * from customers")

However, I have not found anyway to do that. It seems that I may need to
create some functions instead of class and issue statement like this:

Dim rdrCustomers As SqlDataReader = GetDataReader(" select * from customers")

Huh?

You want to pass a connection string into a class constructor for a
datareader right?

How about:

Public Class MyDataReader
Inherits SqlDataReader

Public Sub New(queryString as String)
Dim conn As New SqlConnection(c onnString)
Dim com As SqlCommand = conn.CreateComm and()
com.CommandType = CommandType.Tex t
com.CommandText = queryString
Me = com.ExecuteRead er()
End Sub
End Class

I just typed that in the message, so it might not work properly, but
it should give you a start. Also I 100% recommend you have this class
implement IDisposable and manually dispose of the Connection and
Command objects from within the classes Dispose method.

Thanks,

Seth Rowe

You can't inherit from SqlDataReader. You could probably put the code
above in New() in a Shared function and return the DataReader.

Darn, I was hoping when I typed the message that SqlDataReader wasn't
a sealed class.

Thanks,

Seth Rowe

[Jack Jackson]

On Tue, 28 Aug 2007 07:16:04 -0700, rowe_newsgroups
<ro********@yah oo.comwrote:

>On Aug 28, 10:04 am, Jack Jackson <jacknos...@peb bleridge.comwro te:

>On Tue, 28 Aug 2007 03:30:47 -0700, rowe_newsgroups

<rowe_em...@ya hoo.comwrote:

>On Aug 28, 12:30 am, Peter <Pe...@discussi ons.microsoft.c omwrote:
I'm trying to create a generic class which will take a command string and I
can issue statement like this:

>Dim rdrCustomers As New Generic_Reader( "select * from customers")

>However, I have not found anyway to do that. It seems that I may need to
create some functions instead of class and issue statement like this:

>Dim rdrCustomers As SqlDataReader = GetDataReader(" select * from customers")

>Huh?

>You want to pass a connection string into a class constructor for a
datareader right?

>How about:

>Public Class MyDataReader
Inherits SqlDataReader

Public Sub New(queryString as String)
Dim conn As New SqlConnection(c onnString)
Dim com As SqlCommand = conn.CreateComm and()
com.CommandType = CommandType.Tex t
com.CommandText = queryString
Me = com.ExecuteRead er()
End Sub
End Class

>I just typed that in the message, so it might not work properly, but
it should give you a start. Also I 100% recommend you have this class
implement IDisposable and manually dispose of the Connection and
Command objects from within the classes Dispose method.

>Thanks,

>Seth Rowe

You can't inherit from SqlDataReader. You could probably put the code
above in New() in a Shared function and return the DataReader.

Darn, I was hoping when I typed the message that SqlDataReader wasn't
a sealed class.

Thanks,

Seth Rowe

It's not sealed, but it doesn't have a public constructor, so as far
as I know it can't be inherited.

[=?Utf-8?B?UGV0ZXI=?=]

Thanks Seth. I wish that SqlDataReader is not a sealed class too.

"rowe_newsgroup s" wrote:

On Aug 28, 10:04 am, Jack Jackson <jacknos...@peb bleridge.comwro te:

On Tue, 28 Aug 2007 03:30:47 -0700, rowe_newsgroups

<rowe_em...@yah oo.comwrote:

>On Aug 28, 12:30 am, Peter <Pe...@discussi ons.microsoft.c omwrote:
>I'm trying to create a generic class which will take a command string and I
>can issue statement like this:

>Dim rdrCustomers As New Generic_Reader( "select * from customers")

>However, I have not found anyway to do that. It seems that I may need to
>create some functions instead of class and issue statement like this:

>Dim rdrCustomers As SqlDataReader = GetDataReader(" select * from customers")

>Huh?

>You want to pass a connection string into a class constructor for a
>datareader right?

>How about:

>Public Class MyDataReader
Inherits SqlDataReader

Public Sub New(queryString as String)
Dim conn As New SqlConnection(c onnString)
Dim com As SqlCommand = conn.CreateComm and()
com.CommandType = CommandType.Tex t
com.CommandText = queryString
Me = com.ExecuteRead er()
End Sub
>End Class

>I just typed that in the message, so it might not work properly, but
>it should give you a start. Also I 100% recommend you have this class
>implement IDisposable and manually dispose of the Connection and
>Command objects from within the classes Dispose method.

>Thanks,

>Seth Rowe

You can't inherit from SqlDataReader. You could probably put the code
above in New() in a Shared function and return the DataReader.

Darn, I was hoping when I typed the message that SqlDataReader wasn't
a sealed class.

Thanks,

Seth Rowe

[=?Utf-8?B?UGV0ZXI=?=]

"Jack Jackson" wrote:

On Tue, 28 Aug 2007 03:30:47 -0700, rowe_newsgroups
<ro********@yah oo.comwrote:

On Aug 28, 12:30 am, Peter <Pe...@discussi ons.microsoft.c omwrote:

I'm trying to create a generic class which will take a command string and I
can issue statement like this:

Dim rdrCustomers As New Generic_Reader( "select * from customers")

However, I have not found anyway to do that. It seems that I may need to
create some functions instead of class and issue statement like this:

Dim rdrCustomers As SqlDataReader = GetDataReader(" select * from customers")

Huh?

You want to pass a connection string into a class constructor for a
datareader right?

How about:

Public Class MyDataReader
Inherits SqlDataReader

Public Sub New(queryString as String)
Dim conn As New SqlConnection(c onnString)
Dim com As SqlCommand = conn.CreateComm and()
com.CommandType = CommandType.Tex t
com.CommandText = queryString
Me = com.ExecuteRead er()
End Sub
End Class

I just typed that in the message, so it might not work properly, but
it should give you a start. Also I 100% recommend you have this class
implement IDisposable and manually dispose of the Connection and
Command objects from within the classes Dispose method.

Thanks,

Seth Rowe

You can't inherit from SqlDataReader. You could probably put the code
above in New() in a Shared function and return the DataReader.

[=?Utf-8?B?UGV0ZXI=?=]

Hi Jack,

I think the ExecuteReader method in Data Access Application Block of
Enterprise Library is similar (actually much more) to what I'm trying to do.
Peter

"Jack Jackson" wrote:

On Tue, 28 Aug 2007 07:16:04 -0700, rowe_newsgroups
<ro********@yah oo.comwrote:

On Aug 28, 10:04 am, Jack Jackson <jacknos...@peb bleridge.comwro te:

On Tue, 28 Aug 2007 03:30:47 -0700, rowe_newsgroups

<rowe_em...@yah oo.comwrote:
On Aug 28, 12:30 am, Peter <Pe...@discussi ons.microsoft.c omwrote:
I'm trying to create a generic class which will take a command string and I
can issue statement like this:

Dim rdrCustomers As New Generic_Reader( "select * from customers")

However, I have not found anyway to do that. It seems that I may need to
create some functions instead of class and issue statement like this:

Dim rdrCustomers As SqlDataReader = GetDataReader(" select * from customers")

Huh?

You want to pass a connection string into a class constructor for a
datareader right?

How about:

Public Class MyDataReader
Inherits SqlDataReader

Public Sub New(queryString as String)
Dim conn As New SqlConnection(c onnString)
Dim com As SqlCommand = conn.CreateComm and()
com.CommandType = CommandType.Tex t
com.CommandText = queryString
Me = com.ExecuteRead er()
End Sub
End Class

I just typed that in the message, so it might not work properly, but
it should give you a start. Also I 100% recommend you have this class
implement IDisposable and manually dispose of the Connection and
Command objects from within the classes Dispose method.

Thanks,

Seth Rowe

You can't inherit from SqlDataReader. You could probably put the code
above in New() in a Shared function and return the DataReader.

Darn, I was hoping when I typed the message that SqlDataReader wasn't
a sealed class.

Thanks,

Seth Rowe

It's not sealed, but it doesn't have a public constructor, so as far
as I know it can't be inherited.