tjstewart

Hi folks. I'm trying to figure out how I can use a function to return a user control. Here's what I'm trying to do: I've got a custom user control that displays a datagrid, and I want to set up a web service which uses a proxy class. I want to be able to copy the proxy class file to the bin directory of a website, slap a <%WriteGrid%> or some such onto any of the pages, and it'll display the grid. I'm pretty sure I can handle the making of the actual web service (although I've never done it before and it's completely new to me), I just need to know how to make the function that returns the user control. I'm trying to do this where it takes as little effort and knowledge as possible to install this onto a page, and it seems sensible enough. Am I taking the right approach?

Hi guys. Thanks a lot for the ideas, I'll probably put something together based on what you've suggested. Many thanks, Tj

Hi. I'm trying to write my own paging functions because the DataGrid built-in paging isn't customizable enough. I want it to look a certain way, and I can't accomplish that the "easy" way. My question is how can I retrieve just records, say, 5-10 from pdf.mdb? Currently I'm using this to pull db records: Sub BindDataGrid() Dim DSet As DataSet = New DataSet() Dim DBConnection as OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source=" & server.mappath(DBPath)) Dim DAdapter As OleDbDataAdapter = New OleDbDataAdapter("Select * From PDF Order By ID ASC", DBConnection) DAdapter.Fill(DSet, "PDF") PDFList.DataSource = DSet PDFList.DataBind() End Sub Can I just use a different SQL command to retrieve rows 1-5, then 5-10, 10-15 etc? Thanks Tj