Hi all, I created a form in VB .Net called frmStart. If the user clicks Yes on the form, they are brought to another form called frmYes. On this form there are several fields for them to fill in. Then they click a submit button. The action associated with clicking the button is to call another function (Private Sub) and pass it the user data. btSUB_frmYes is the name of the button so: Private btSUB_frmYes_Click () . . . code that processes the form data Call updateThruputDB(strFileName, blResult,strComments) End Sub In Priave updateThruputDB( . . . ) I want to say: Dim cnThruputDB AS Connection but Connection is not an option, in the list that appears I only have ConnectionState. I have looked all over the web and can not figure this out. Can someone please explain why "Connection" is not available? I created this in Visual Studio .Net as a windows application that is compiled and the starting point is frmStart. Thanks!

well, first off you need to make certain that you are: using System.Data.OleDb; and/or using System.Data.Odbc; then you can make one of these: Dim OleDbConnection CN As new OleDbConnection and/or Dim OdbcConnection ODBCCN As new OdbcConnection Hope this sets you in the right direction. Chi They mostly come at night...mostly.

PS please forgive the semi-colons. I program in C# not vb.net so I "tried" to convert them...but forgot about the ; Chi :) They mostly come at night...mostly.

i can't find the data about connection method in dot net.Plz send the connection techenique in dot net. thanks