Another way is to use AsQueryable method on the Nodes collection and the use Linq to search the nodes matching your criteria. The need to optimize rises from a bad design.My articles[^]

obalesu wrote: I put the "some.dll" file in the debug folder. What debug folder? Try putting it in the same folder as the .exe file using the dll is in. Mark Salsbery Microsoft MVP - Visual C++ :java:

Create a Page_INIT eventhandler for the Crystal Report In that handler you can recreate the Header

Please don't start a new thread for a follow-up comment to your original question[^]. Scott. —In just two days, tomorrow will be yesterday. —Hey, hey, hey. Don't be mean. We don't have to be mean because, remember, no matter where you go, there you are. - Buckaroo Banzai [Forum Guidelines] [Articles] [Blog]

thank you . this problem is solved by using stored procedure.thank you for giving idea regards hselabo. :)

obalesu wrote: sir i don't have idea about config files please send clearly Then you should be reading through a beginners book on the .NET Framework. It will explain much more clearly that I could do in the space of a forum post. obalesu wrote: please send solution for this problem.and i can i use my application in network system. I can only send suggestions for such a problem. It is up to you to find the solution. I am not paid to do your work. You are employed as a software developer, I would have said it was a prerequisit to know the basics around the technology in which you are developing. So, I repeat my advise to read a beginners book on the subject. I also don't know anything about your application. To suggest that I could send you some random piece of code that happens to work with your existing system betrays the depth of your lack of knowledge. Once you have read that beginners book you might be able to solve your problem yourself, or if not, you will have a better understanding of what the problem actually is. Upcoming FREE developer events: * Developer Day Scotland Recent blog posts: * Mixins in C#3.0 My website | Blog

obalesu wrote: i don't have any idea about config file In which case try the C# help. obalesu wrote: i wrote connectionstring as"datasource =C:\\cms\\cms.xls" This will only work if your excel file is on your C drive. You said its on the network, so it won't work will it. I suggest you try a bit of Google research Bob Ashfield Consultants Ltd

you could do something like the following in your clicked_handler. it goes through all mdi childforms....if the one you are trying to open is already opened, it activates the windows and returns. if it's not found, it creates a new mdi childform. foreach (Form f in this.MdiChildren) { if (f.Name.Equals("mySubForm")) { f.Activate(); return; } } mySubFormn f= new mySubForm(this); f.MdiParent = this; f.Show();

thank you jhon for your code .it is working.but cursor does not gone to next row first cell when the cursor is in last cell of the currentrow when we press enter key.and i am facing another problem is i was trying to check the data entered by us in datagridview to database table.means datagridview first column name "x".i want check the x values to database table values if the data is already exist in database table at that time i want to show an error msg in message box.after that the cursor must be in the error cell.but the cursor moves to next cell.if error occurs the cursor must be in the error cell only.if u have any idea send me. thank you sir. regards Obalesu.nagamalli

obalesu wrote: please solve my problem. No. And why are you using ODBC to access SQL Server in the first place?

Rocky is probably right - unless you've got a known, fixed start and end point and status updates along the way (which you don't have with SQL loads), a progress bar is probably not the right UI choice. Something that indicates a long-running process is probably better - a loading circle or an animated gif. There are some great loading circles here on Code Project. It has become appallingly obvious that our technology has exceeded our humanity. - Albert Einstein

thank you sending reply. how can i add these dependencies to set up project.

Don't give the option to enter the date by user. Give the option to select the date from the calender. Display a popup calender and select the date from it. Make the textfield for the date to be "readonly". dhans