I'm not sure how to do this, and at lost trying to figure it out.

Plz help.

I want to be able to do this:

    objConn = CreateConnStr() 'returns sqlconnection

    dataAdapter = New System.Data.SqlClient.SqlDataAdapter(strSql, objConn)
    dataSet = New DataSet

    If Page.IsPostBack() Then
      dataAdapter.Fill(dataSet)
      lblRecordCount.Text = CStr(dataSet.Tables(0).Rows.Count)
      dataSet = Nothing
      dataSet = New DataSet
    End If
      dataAdapter.Fill(dataSet, 1, 10, "TABLE01")
      datalist01.DataSource = dataSet.Tables("TABLE01").DefaultView

    datalist01.DataBind()

However, I have a sqlclass that returns a datatable.

When I instaniate dataadapter, I pass the connectionstring and sqlconnection.

(I don't want to re-create the sqlconnection).

Is there a way I can take advantage of my sqlclass that returns the datatable?

Again, thank you for all posts !

Disregard this question.

I found my solution by creating another method inside my sql class
and returns a DataAdapter.

Then in my code-behind I would point to that dataAdapter.

thanks

You can also have a function that returns a DataTable object.

Hi planoie,

Thanks for your post.

Earlier ..

I'm can return a datatable or dataset from my custom sql class, and since I'm not able to instantiate the dataAdapter w/o the sqlconnection, how can I use a dataAdapter?

I would appreciate it if you could show me how.

Thanks in advance !

I'm not entirely sure what you are asking, but...

When I build a data access class, I do ALL the data access steps within it. I create the data connection and all the other objects inside the methods of the class. If you have to provide the class with connection information you could provide it thru a string property or you could even pass in a connection object (or set a connection object property on the class).

Peter
-------------------------
Work smarter, not harder