Pete O'Hanlon wrote: If you have two stylesheets, then that's two things you have to maintain as the site changes and new functionality is added. Not true - those on the old style don't want new functionality, no need to include it for them! ;P

Luc Pattyn wrote: I can't tell what is wrong in your P/Invoke code as you aren't showing any of it. The code is same not a bit change from the article i mention i.e. Use PI invoke for serial communication. Updated code is in download link of article, on MSDN(article) page code is not updated. In case of not working modem ReceiveThread() of CommBase.cs is not behaving as its in working modem. eventMask = (uint)Marshal.ReadInt32(uMask); //some code //not able to get inside this block in not working modem and OnRxChar(buf[0]) event is not raised if ((eventMask & Win32Com.EV_RXCHAR) != 0) { do { gotbytes = 0; if (!Win32Com.ReadFile(hPort, buf, 1, out gotbytes, unmanagedOv)) { int x = Marshal.GetLastWin32Error(); throw new CommPortException("IO Error [004]"); } if (gotbytes == 1) OnRxChar(buf[0]); } while (gotbytes > 0); } //same for OnStatusChange event is not raised uint i = 0; if ((eventMask & Win32Com.EV_CTS) != 0) i |= Win32Com.MS_CTS_ON; if ((eventMask & Win32Com.EV_DSR) != 0) i |= Win32Com.MS_DSR_ON; if ((eventMask & Win32Com.EV_RLSD) != 0) i |= Win32Com.MS_RLSD_ON; if ((eventMask & Win32Com.EV_RING) != 0) i |= Win32Com.MS_RING_ON; if (i != 0) { uint f; if (!Win32Com.GetCommModemStatus(hPort, out f)) throw new CommPortException("IO Error [005]"); OnStatusChange(new ModemStatus(i), new ModemStatus(f)); } above are few lines of ReceiveThread for reference which are not executing as excepted. Luc Pattyn wrote: Your Win7 probably is 64-bit, Its 32 bit. Luc Pattyn wrote: (One way to circumvent this problem is by building for "x86" rather than "AnyCPU"). This i will try. But have doubt as same code is working in same window 7 but with different card. But not working card respond with .Net 2.0 serial port class under same window 7.

SilimSayo wrote: Most of our imports come from abroad! Imports become necessary when locals lack quality and become unaffordable! ;-)

You are actually giving it an output value in your SP aren't you? That one's caught me out before! C# has already designed away most of the tedium of C++.

hi, You can use a List collection to store the data whilst reading from the db. i don't know where you are getting the data from or how so i will assume its from the database and u are using TSQL /// Your sql reader SqlDataReader = reader.ExecuteQuery ( commandText ) ; /// Your list ArrayList aList = new ArrayList ( ) ; while ( reader.Read ( )) { if ( ! aList.Contains ( ( string )reader[ "rowname" ] ) ) { /// Add the row to table } /// else, oh snap! skip me already been added } Good luck

The problem is actually known as the subset sum problem as konduc pointed out, with a useful link. As your number of rows is limited, you should load them all in memory and go for a normal solution, not a database-centric SQL one. Now start studying the keywords and links given to you, and help yourself with Google and/or some books. No one is going to do your job for you. :) Luc Pattyn [My Articles] Nil Volentibus Arduum The quality and detail of your question reflects on the effectiveness of the help you are likely to get. Please use <PRE> tags for code snippets, they improve readability. CP Vanity has been updated to V2.4

Try putting headers in the first row of the spreadsheet and use HDR=Yes option.

It should help you: LINQ to Excel

Hmm, what happens if you try to execute the statement dynamically. Put it into a string and then use exec to run the statement. Unfortunately I don't have SQL Server 2000 to test this issue... The need to optimize rises from a bad design.My articles[^]

What I have done in the past is to periodically delete rows older than some threshold. If you like, you can use a trigger to also write them to some archive table.

Thanks - we've been looking into this over the weekend and should have it sorted out today. cheers, Chris Maunder The Code Project | Co-founder Microsoft C++ MVP

You could use LINQ to SQL[^] Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together. Digital man: "You are, in short, an idiot with the IQ of an ant and the intellectual capacity of a hose pipe."

Hum Dum wrote: SELECT @address = CONVERT(VARCHAR(150),[TEXT]) FROM OPENXML(@idoc,'/Name_Address/address', 0) where [text] is not null AFAIK the result is having two rows returning and At a time of converting SQL might picking up the second row and converting it accordingly, As It returns two rows having one column. But I can Provide you another solution for that. To first Retrieve the result and using COALESCE you can JOIN them together to produce expected result. Here's my work for you only. SELECT @address = COALESCE(@address+',' ,'') + [address] FROM ( SELECT * FROM OPENXML (@idoc, 'Name_Address/address',3) WITH ([address] varchar(1000) '.') ) P SELECT @address It's working all right. Regards, Hiren. Microsoft Dynamics CRM My Recent Article: - Way to know which control have raised PostBack[^]

Well there isn't much out there in print on networking for .NET. That link was the book I was thinking about. Mixed reviews, I guess you need to try and get your hands on the book and see what you think because some thought it was good. BTW I'm guess you know this but threading isn't networking. Maybe try and find some articles online regarding .NET and TCP/IP

Hum Dum wrote: for that i have to use cursor. I presume you select statement will not do the job for you Insert Tablename (columnames....) select columnnames... from #Temp_940 Never underestimate the power of human stupidity RAH

Without looking at your code but looking at your post, it is clear that the code for populating that printer drop down is written at server side. So it would NEVER show you the client's list of printers, it will show you the list of printers on the server. It is important that you understand this fundamental concept. To achieve what you need - you will have to write some client side scripting or ActiveX - though I am not sure that can be achieved since the browser may not be allowed to have access to the client's resources through script. Generally, it is the end user's responsibility (privilege?) to select the printer he wants to use. You can put out some advise for the user to select a correct printer. Hope this helps. Shreekar

Possibly this is due to the issue where, if you click on a message before the page has finished loading, the page does a full post-back. We're aware of this and will fix it as soon as possible cheers, Chris Maunder The Code Project | Co-founder Microsoft C++ MVP

This is a complete guess as I have never even heard of that product before but do you have the correct permissions to connect and run a stored procedure? Sorry if that is complete bollocks but worth a try. "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair. nils illegitimus carborundum me, me, me

Only if you, or the person who has to maintain your code, don't need to use the pliers later... A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008 But no longer in 2009...