JIMcFadyen

If you don't need to store the previous data held within an object (eg you load it through code) then set the EnableViewState property to False, this will give some saving on performance, but I wouldn't imagine it would gain you a great deal on a simple textbox. John

If you need the object outside of a Session then use the Application variable. John

There is also a Find method on the DataView Private Sub FindValueInDataView(t As DataTable) Dim dv As DataView Dim i As Integer dv = New DataView(t) dv.Sort = "CusomerID" ' Find the customer named "DUMON" in the primary key column i = dv.Find("DUMON") Console.WriteLine(dv(i)) End Sub John

Worked for me aswell this time. Perhaps my connection was just a having a couple of days holiday... John

I would use the OnItemDataBind method to affect the template. Then you can write your code within a function. John

Every time I try and reply to Mischamel's thread it seems to error on me. http://www.xtremedotnettalk.com/t72615.html John

At what point do you want to filter the records? There is a property on the DataView called RowFilter that does just that. John

Try 4 Guys. http://aspnet.4guysfromrolla.com/articles/052803-1.aspx John

This article on MSDN will explain it all. As you can see .net makes it pretty simple. http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b323245 Any questions, feel free to ask. John

Do you need to similar queries to get the data? Wouldn't one simlpe DISTINCT query for "Categories" and a more detailed query for "Items" suffice? This would have slightly increases overhead, but not as much as 2 full selects. Maybe I've just lost the plot... John

DJVege, what are you trying? It would be easier if you gave us some code to work with. John

Do you want to load the image file into a database or just copy the file onto the server and put an entry into a list? John

So you want to load a Crystal Report from a DataSet, with some user defined sections. Crystal will do all this with no great problem. You need to look into passing parameters to a report, which is long winded but fairly simple. The VS.net help has a lot of information on it. John

You can load the file into a DataSet using the ReadXML method of the dataset, then just load it back to the db as normal. John

Systems Developer/Database Admin. Currently VB.net, ASP.net, SQL Server and a few legacy dBase systems from around the time of the Ark. John