[2005] Asp.net 2.0 Classes...Please help

[jnaneswari]

Hello all

I have 3 pages in my application
all 3 pages have gridview with same id, i want to bind data from 3 different tables to each 3 gridviews.
i want to create universal databind procedure to bind data to gridview in a class
i am using this line of code in my class

Public sub bind(byval sql as string)
  sda = New SqlDataAdapter(sql, strConn)
   sda.Fill(ds, "mytable")
  GridView1.DataSource = ds.Tables("mytable").DefaultView
  GridView1.DataBind()
end sub

i am passing sql string in page1 pageload
i am calling this class procedure in page load of page1 by creating object instance of the class

obj.bind(Select * from CustomerDetails)

But it is giving an error
object reference not set to an instance of object

how can i take referene of the gridview control present in page1 to the class


Kindly help me to solve this

Thanks in advance

[mendhak]

The class has no idea what GridView1 is. You should place the binding code on the page itself. Data retrieval should occur in the function itself, which can return a dataset to the page, but the binding should occur on the page. Keep the UI and logic separate.