Module

[aninda55]

This is my vb6 programme for creating recordset in a module. and call it in class
and form
module :ModMain
Public Function getRec(strQry As String) As ADODB.Recordset
Dim r As New ADODB.Recordset
On Error Resume Next
If r.State = adStateOpen Then r.Close
r.CursorLocation = adUseClient
r.Open strQry, Con, adOpenStatic, adLockReadOnly, adCmdText
Set getRec = r
End Function

class:clsOrganization
Public Function fillOrgName() As ADODB.Recordset
strQry = "select NAME,CODE FROM ORGANIZATION ORDER BY NAME"
Set fillOrgName = getRec(strQry)
End Function


is there any way to create dataset in a module and call it in a class????

[garyjohn_2000]

This is the wrong place to post your question, mate. This section is for VB.NET code issues. Asking a question about VB6 code wont get much response.


[Damn! I just realized its been years I've even seen VB6 IDE >.<]

[si_the_geek]

Are you actually asking for help with VB6, or are you asking how to re-create the same thing in VB2005?

[aninda55]

yes
I want this for vb.net 2005

[jmcilhinney]

yes
I want this for vb.net 2005

You should state that in the first post in future. Be clear. If we have to guess or assume then we may do so incorrectly.

If you want a DataSet in a module then you simply declare a DataSet variable in a module. You can then get or set the value of that variable anywhere in your project. That goes for String, Integers, DataSets or anything else.

If you're actually asking, without actually asking, how to get the data from the database, then I would suggest that you go to the Database Development forum and read the FAQ thread at the top. You can then follow the VB.NET links to some ADO.NET resources.