VB.NET

Access database in a class Constructor

Please support our VB.NET advertiser: Intel Parallel Studio Home

•

Join Date: Aug 2008

Posts: 12

Reputation: Jostra is an unknown quantity at this point

Solved Threads: 0

Jostra

Offline

Newbie Poster

Access database in a class Constructor

Aug 14th, 2009

Hi! everyone can some one share a piece of light with me is it possible to manipulate database access inside a class constructor.Cause i can create a connection but don't know how i'm going to things like data adapter an data set since.Any link Any Help Is appreciated.thanks

•

Join Date: Apr 2008

Posts: 45

Reputation: bcasp is an unknown quantity at this point

Solved Threads: 10

bcasp

Offline

Light Poster

Re: Access database in a class Constructor

Aug 14th, 2009

It would probably be possible, but I would probably rethink why there are database calls inside of the constructor. I would rather split it out into a separate call.

Here's a link to a Microsoft Patterns and Practices article. If it can't answer questions about how to handle database connectivity then I don't know what will:

http://msdn.microsoft.com/en-us/library/ms978510.aspx

•

Join Date: Oct 2008

Posts: 2,721

Reputation: adatapost has much to be proud of

Solved Threads: 501

adatapost

Offline

Posting Maven

Re: Access database in a class Constructor

Aug 16th, 2009

 Help with Code Tags 
 vb.net Syntax (Toggle Plain Text) 
public class DBClass
     ... 
     public Function GetTable(Sql as String) as DataTable
         Dim Adp as new SqlDataAdapter(sql,CnStr)
         Dim  Dt as New DataTable
         Adp.Fill(Dt)
         Return Dt
     End Function
 
End Class
.....
....
Dim cs as new DBClass
Dim Ds as new DataSet("TestDS")
Ds.Tables.Add(cs.getTable("Select * from Table1"),"Table1")
...
public class DBClass
     ... 
     public Function GetTable(Sql as String) as DataTable
         Dim Adp as new SqlDataAdapter(sql,CnStr)
         Dim  Dt as New DataTable
         Adp.Fill(Dt)
         Return Dt
     End Function

End Class
.....
....
Dim cs as new DBClass
Dim Ds as new DataSet("TestDS")
Ds.Tables.Add(cs.getTable("Select * from Table1"),"Table1")
...

•

Join Date: Aug 2008

Posts: 12

Reputation: Jostra is an unknown quantity at this point

Solved Threads: 0

Jostra

Offline

Newbie Poster

Re: Access database in a class Constructor

Aug 17th, 2009

Thanks adapost i truly didnt know this like i said on my thread, can you please explain to me how do i define an adapter in a class. i appreciate thank