Hi, if you need to send special byte values over SerialPort, forget about text, strings and encodings, and use SerialPort.Write, which works with byte arrays, no encoding, no translation. What you get is what you ordered. :) Luc Pattyn [Forum Guidelines] [My Articles] This month's tips: - before you ask a question here, search CodeProject, then Google; - the quality and detail of your question reflects on the effectiveness of the help you are likely to get; - use PRE tags to preserve formatting when showing multi-line code snippets.

The error can pop up under any WinSock circumstances, not just when you close a socket. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007

try this one. textbox1.text=listview1.selecteditems(0).subitems(0).text textbox2.text=listview1.selecteditems(0).subitems(1).text ........ Don't block the drive way of all the newbies in programming. :)

Hello Dave, I tried, it works fantastic. Thanks guru!!

Why are you using a data adapter? command.ExecuteNonQuery() is all you need (and an open connection) Upcoming events: * Glasgow: SQL Server 2005 - XML and XML Query Plans, Mock Objects, SQL Server Reporting Services... Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton My website

Your code is susceptable to SQL Injection Attack. Please read SQL Injection Attacks and Tips on How to Prevent Them[^]. You use ExecuteReader. But you don't get any information back. You should ExecuteNonQuery() when you don't expect a result set. You are allowing unvalidated and unsanitised user input directly into the SQL Statement. It is highly possible that this dirty information is causing problems for your SQL Statement. The advice given in SQL Injection Attacks and Tips on How to Prevent Them[^] will help you generate a safe SQL command that will be protected against that sort of error when caused by user input. Upcoming events: * Glasgow: SQL Server 2005 - XML and XML Query Plans, Mock Objects, SQL Server Reporting Services... Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton My website

Ok, i see. There is a lot to learn for me. Thanks for the reply.

Thanks. I will try that.

Well, I assume you knew what you've been told ( as it's the bare bones of what try/catch does ). What did you need to know ? Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

This is a question for the SQL Forum. The Babelfish translation is a bit rough, but, it would appear that you have a key constraint violation in your INNER JOIN. You shouldn't be allowing NULL's on the keys, primary or foreign, in either table. Also, is the data constistent? Do ALL of the FK values in the Agent_Group table actually exist in the PK's of the other two tables? Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007

The obvious way is to concatenate strings. The better way is to write a stored procedure. Either way, you need to be careful of SQL injection attacks. Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Hello Dave, Thanks for the info, it works.

Hello OldWarhorse, Thanks a lot for your tips. I will try the hashtable. Regards