Index your tables with appropriate key(s). Avoid to use Not In. You can use something like this select a.* from table1 a, table2 b where a.column1<>b.column1 Configure your connection string's timeout parameter... :cool: Be an Eagle, Sky is Yours.

In many cases, "NOT IN" takes a lot of time. If the table has key column, I suggest following steps. 1. Insert key value, to be filtered, into temporary table. 2. Query with "NOT EXISTS" like "select .. from table where not exists ( select ... temporary_table where table.key = temporary_table.key )" ToshiyaTSURU turutosiya@gmail.com http://www.google.com/profiles/turutosiya

>>> HOMEWORK ALERT <<<

my page is like this where should i call onload ? thank you

write the following on Body tag Regards, Jegastar.

People here usually don't do homework for others.

An hourglass is not a solution. You may want to find out why your postbacks are taking so long.

Do you really want to override it, or just create a new event handler? The Design View can be used to add an event handler to a control, or you can do it like this: myDataGrid.OnDataBinding += new System.EventHandler(this.myEventHandler); The OnDataBinding method itself doesn't really do anything but call the event handlers that are defined to respond to that event, and handles some issues that arise when databinding occurs (which happens when you call the DataBind() method). Did you want to change that behavior? If you override it, you will have to explicitly call the base class function in your override, or you will lose the default behaviors that keep the DataGrid functioning properly when new data is bound to it. Since you are aware of the times that you call DataBind(), you can handle any extra processing at that point, or you can create an event handler that does your extra stuff. I don't think you ever need to override the events themselves. "Quality Software since 1983!" http://www.smoothjazzy.com/ - see the "Programming" section for (freeware) JazzySiteMaps, a simple application to generate .Net and Google-style sitemaps!

i think u can cutomize existing controls by designing ur self and adding the cutomized functionality to it through user control in same project with out adding additional componet to tool bar. rahul

Although the question is very vague on what you want to do let see if this helps. You can create a custom collection by implementing IList, IEnumerable etc interfaces or extending a CollectionBase class to store whatever object you want to specialize to. In order to sent a Custom Collection to a DataGrid it should be one of the following A DataTable A DataView A DataSet A DataViewManager Any component that implements the IListSource interface Any component that implements the IList interface CustomCollection implements IList interface so it will work as a DataSource to DataGrid. Hope this helps.