Thanks for the help. Project works fine. Please see link below which serves as my guidance. http://www.devarticles.com/c/a/C-Sharp/Socket-Programming-in-C-sharp-Part-II/1/[^] Dabsukol

One reason would be occurance of deadlock while executing the update query. deadlock occurs at that time you are trying to do multiple operation on the same table at the same time. e.g. select and update both operations are done on same table same time then deadlock will occurs. To avoid this situation use no lock in your select query and use update lock in your update query.

dabuskol wrote: What I need Who is saving the Excel files, what database? Sql Server? Oracle? Sqlite? Are they saved as a BLOB, or is it a real import? Do you want to "show" 10 excel-files (and their content) in a single grid? How? You'll have to formulate your question with a bit more detail to get a decent answer. And that's what we do, answer questions - that's a bit different from "providing codez". Like your question is standing now, I'm very inclined to explain how to add a button to the form. Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]

Thanks it works in .NET Dabsukol

Try this: SELECT tableIdentity, case when groupstatus = 1 or groupstatus = 0 then 'In Progress' else 'OK' end GroupDesc from tableOne where tabid = T1; You should also physically confirm that you have only a single row named T1.

Thanks for the information. I will check with our server log the real problem and at the same time try to see for other solutions. I will keep you posted. Dabsukol

I have a list like excel format in the list, Org Code Title Function 62,171,616 BAT To develop as per users request 62,171,616 BAT To Maintain existing systems under NO/NI I want to read the Org Code and display the function on every page of the site depending on the title that I will pass as parameter. FROM THIS SITE http://po.abv.com.sa/Lists/NO%20Organizational%20Functions/AllItems.aspx[^] TO THE FRONT PAGE OF THIS SITE http://po.abv.com.sa/PS/BAT/default.aspx[^] Regards Dabsukol

Checkout this link: http://technet.microsoft.com/en-us/windowsserver/sharepoint/dd560708.aspx[^] http://tech-motive.blogspot.com/2009/12/for-fresh-moss-administrator-like-me.html[^] There is no foolish question, there is no final answer...

Select top 1m records order by ID Get the last ID in the first set (you do have an ID field) Select the top 1m records where ID > last ID You can also look into Row_Number in SQL Server, this will eliminate the detect requirement but is more complex in the select. I would assume you are processing the 1m records and therefore detecting the last ID would be trivial. Never underestimate the power of human stupidity RAH

No problem Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP

Have a look at this[^] The example is in VB.Net but I hope you can easily convert it to C#. Manas Bhardwaj Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Your client is making stuff up. Real developers step in and tell people why they can't have anything they like. In this world, Outlook limits what it will display/allow because of all the viruses out there. I would not be surprised if what they want, won't work. Christian Graus Driven to the arms of OSX by Vista. "I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )

this.Close(); Usually works for me, at least this is the command I always put in the close buttons. Also, self is VB iirc, not C#. In C# you need to use this.

select substring(columnname, 1, charindex('@', columnname) - 1) from tablename Do good and have good.

There is no equivilent control in the Web Forms ToolBox. You just have to write the code manually using the classes in the System.DirectoryServices namespace. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008

Thanks for all the help. After so many trials and isolation, the only problem I believe that is missing why the data on the CACHE object is missing si the declaration of the namespace of CACHE. using System.Web.Caching --- After including it in my code. it works perfect. Dabsukol

foreach(Control control in this.Controls) { MessageBox.Show(control.Name); } :rose: Too many passwords to remember? Try KeePass Password Safe!

If you can't use an identity column, a common pattern is to have a sequence table that contains the next sequence number for your table. Then, your code creates a transaction, updates the table to add 1 to the sequence number and then select from the table. The trick here is that the transactional update will lock the sequence row and then you select the record to retrieve this value - the beauty here is that the update lock prevents anybody else getting to the record until you commit the transaction. Deja View - the feeling that you've seen this post before. My blog | My articles

Did you check your MailQueue folders on the server for any BadMail? Any messages in the eventlog? Vasudevan Deepak Kumar Personal Homepage Tech Gossips All the world's a stage, And all the men and women merely players. They have their exits and their entrances; And one man in his time plays many parts... --William Shakespeare