Binding a public class function to a datagrid

[tbcmartinharvey]

I would really be grateful for some help.

 

I realize this is probably a very basic question but can someone tell me how

 

to do this. I have created a class function that uses a stored procedure to return a datareader. (I am using webmatrix)

 

I want to bind this datareader to a datagrid. I have been using dg.datasource=classfunctionnname" but I get a compile error saying the class function hasnt been declared.

 

I have included the the class function below:

Namespace System.Data.SqlClient

 

Public Class Catalog

Public Shared Function SP_GetBB() As SqlDataReader

Dim Connection as New SqlConnection(ConnectionString)

Dim command As New SqlCommand(CommandText,Connection)

Dim CommandText As String = "SP_GetBB"

Command.CommandType = CommandType.StoredProcedure

Connection.Open()

Return Command.ExecuteReader(CommandBehaviour.CloseConnection)

End Function

 

Private Shared ReadOnly Property connectionString() As String

Get

Return ConfigurationSettings.AppSettings("ConnectionString")

End Get

 

End Property

End Class

End Namespace

 

I have tried

 

Dim dr1 As SqlClient.SqlDataReader = Catalog.SP_GetBB

dg.datasource = dr1

 

But no combination I try seems to work.

 

I was wondering if this is a namespace problem

Scott Mitchell wrote that you cannot use the web.config Appsettings unless you include the relevant namespaces in the page.

http://aspnet.4guysfromrolla.com/articles/122403-1.aspx Maybe class functions are the same.

 

If anyone could hellp me i would be grateful

[PlausiblyDamp]

You would need to prefix Catalog with it's namespace, however you seem to be putting it into the already existing System.dat.sqlclient namespace - is there a reason for this, usually you would want to extend the system provided namespaces in this manor. Edited October 7, 2005 by PlausiblyDamp