What kind of object is _bindingSource? My guess would be that it likely iterates through the data when DataSource is assigned to. You could create a var that holds the _context.VAllClients reference and only assign to _bindingSource when you're ready. They Call me Mister James

PIEBALDconsult wrote: and therefore it can't be done. Well, not *technically*... "Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997 ----- "...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001

As I said in the first post, the scenarios are not the same. In your first example you fill the dataset. So it seems that you don't have a datatable in the dataset, but it's created during fill. In the second example, you already have a datatable and you're filling it. So it makes me wonder if you have existing event handlers, binding etc. attached to the datatable. If so, they can be the cause to the slow fill. Especially if binding is involved since existing binded objects must be refreshed when binding is done. This wouldn't be the case in example 1. Without seeing the actual situation, it's merely guessing. However, the filling speed should be equal in both cases if the query is the same and the 'surroundings' are the same (eventhandlers etc) The need to optimize rises from a bad design. My articles[^]

This[^] might be a good place to start looking. El'Cachubrey wrote: derive my custom type from AN INTERFACE IDatatSource[^] perhaps? But fortunately we have the nanny-state politicians who can step in to protect us poor stupid consumers, most of whom would not know a JVM from a frozen chicken. Bruce Pierson Because programming is an art, not a science. Marc Clifton I gave up when I couldn't spell "egg". Justine Allen

you can invoke them as a process . Best Regards ----------------- Abhijit Jana Check Out My Latest Article Java.NET : Integration of Java and .NET[^] "Success is Journey it's not a destination"

ORM Wiki[^] Basically you will be working on an object that is mapped to your data, instead of working on datatable, datarow, datacolumn, etc. You may want to look at whether you can write your own DataBinding for binding to the columns of datarow, good luck. ;)

Well you might be interested in the Model-View-Controller Software Design Pattern [^] or the more recent variation Model-View-Presenter. There is a reference (and link) to MVP on the MVC page I linked to. led mike

if you have a constructor in your derived class then inherit the base class constructor, like: MyTextBox(): base() { } i think you should use ControlAdded Event TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L %^]*IRXD#@GKCQ`R\^SF_WcHbORY87??6?N8?BcRAV\Z^&SU~%CSWQ@#2 W_AD`EPABIKRDFVS)EVLQK)JKSQXUFYK[M`UKs*$GwU#(QDXBER@CBN% Rs0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-i?TV.C\y -------------------------------------------------------- 128 bit encrypted signature, crack if you can

Hi Guys I think 30 sec is enough time. but not desired. So i think if we are put a thread to do the file operatoion and give high leve thread.may be this help to you reduce the time consume. thanks Cheers RRave MCTS,MCPD

El'Cachubrey wrote: And how connection string can affect speed of data retriving???? Different database providers perform differently in certain situations. Also, the connection string can contain settings that may affect the performance of a provider. Have you examined the network traffic when the application runs the query? This could tell you if it's connecting to the database or transfering the data that takes time. It could also tell you if the amount of data looks reasonable, or if there is a lot of overhead. Experience is the sum of all the mistakes you have done.

I have never seen either happen but it seems likely that Exceptions would be thrown in both cases

For scalar UDFs (which return a single value) use: select dbo.MyUdfName() For table-valued UDFs (that return a resultset) use: select * from dbo.MyUdfName() Regards Andy

THNAK ALL

Dear Friend, Hi. ;P string strFileName = "fileName.xls"; System.Data.OleDb.OleDbConnection excelConn = new System.Data.OleDb.OleDbConnection("provider=microsoft.jet.oledb.4.0;data source= '" + strFileName + "'; " + " extended properties=excel 8.0;"); string strsql = "Select * from [Sheet1$]"; System.Data.OleDb.OleDbDataAdapter excelDataAdap = new System.Data.OleDb.OleDbDataAdapter(strsql, excelConn); dsExcel = new DataSet(); if (excelConn.State == ConnectionState.Closed) { excelConn.Open(); } //Select the values from Excel excelDataAdap.Fill(dsExcel); GridView1.DataSource = dsExcel; GridView1.DataBind(); System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand(strsql, excelConn); System.Data.OleDb.OleDbDataReader dr = cmd.ExecuteReader(); string sqlConnectionString = "Data Source=srvr;Initial Catalog=db;User Id=usr;Password=pwd"; // Bulk Copy to SQL Server System.Data.SqlClient.SqlBulkCopy bulkCopy = new System.Data.SqlClient.SqlBulkCopy(sqlConnectionString); bulkCopy.DestinationTableName = "ExcelData"; bulkCopy.WriteToServer(dr); I hope this will helps u..... "Good Thing Goes With Good People..."

In SQL there are INT & BINT data types currently you are using INT instead user BIGINT Regards KP

Extend base datatable creating a new event on datarow remove Visit my blog at http://dotnetforeveryone.blogspot.com

Unfortunately, none of the two suggestion above will do what DATEDIFF does... You need to separate the DATE part of your time value. You didn't say what data type you use for your date/time variables. The easiest way, I think, is to convert both dates to COleDateTime (which wraps double representation of date/time), truncate the fractional part and simply subtract one value from another. ----------------------------- Get trial copy of FeinViewer - an integrated GDI objects viewer for Microsoft Visual Studio .NET 2005 (8.0) Visual C++ Debugger, and other convenience and productivity tools for Microsoft Visual Studio .NET at at www.FeinSoftware.com