C# Discussion Boards - CodeProject

Deepak.Prahlad12-Mar-10 0:25

Deepak.Prahlad

12-Mar-10 0:25

My data is 30 to 60 byte long
My question is

Will the code return with first few byte immediately when it recevies the first event for DataRecieved? (because of slight inter-byte delays?)

Or it will go for reading and if found (it should... because event was generated) something in Hardware Buffer wait for the entire stream till there is no more bytes?

In both case there is no chance for timeouts Confused | :confused:

Is there any thing like "De register the event once it is served" ?

PS: I can not say when the data will be pushed from the other side so I need to be continuously monitoring the port. Is there any other method to do this than dataReceived event?

OriginalGriff12-Mar-10 1:46

OriginalGriff

12-Mar-10 1:46

Deepak.Prahlad wrote:
Is there any thing like "De register the event once it is served" ?

Yes - you can remove the handler in the same way you add them, but using -= instead of +=.
If for example it was a Timer event you would add with:

tim.Tick += new EventHandler(tim_Tick);

and remove it with:

tim.Tick -= tim_Tick;

You should never use standby on an elephant. It always crashes when you lift the ears. - Mark Wallace

C/C++ (I dont see a huge difference between them, and the 'benefits' of C++ are questionable, who needs inheritance when you have copy and paste) - fat_boy

DotNetCoderJunior12-Mar-10 2:08

DotNetCoderJunior

12-Mar-10 2:08

Here is a nice Com Class that you can use.

using System;
using System.IO.Ports; 
using System.Runtime.Remoting.Messaging; 
using System.Drawing;
using System.Windows.Forms;
using System.Threading;
namespace ModemAPP
{    
    /// <summary>
    /// Routines for finding and accessing COM ports.
    /// </summary>

    public class ComPorts  
    {  
        private const string ModuleName = "ComPorts"; 
        
        //  Shared members - do not belong to a specific instance of the class.
        
        internal static bool comPortExists; 
        internal static string[] myPortNames; 
        internal static string noComPortsMessage = "No COM ports found. Please attach a COM-port device."; 
        
        internal delegate void UserInterfaceDataEventHandler( string action, string formText, Color textColor ); 
        internal static event UserInterfaceDataEventHandler UserInterfaceData;

        internal delegate void UserInterfaceResultEventHandler(string strResult);
        internal static event UserInterfaceResultEventHandler NumberCrunchInterface; 
        
        //  Non-shared members - belong to a specific instance of the class.
        
        internal delegate void SerialDataReceivedEventHandlerDelegate( object sender, SerialDataReceivedEventArgs e );
        internal delegate void SerialErrorReceivedEventHandlerDelegate( object sender, SerialErrorReceivedEventArgs e );
        internal delegate bool WriteToComPortDelegate( string textToWrite );
        internal delegate bool ReadComPortDelegate();
        delegate void SetTextDeleg(string text);      
        internal WriteToComPortDelegate WriteToComPortDelegate1;
        internal ReadComPortDelegate ReadComPortDelegate1;
        
        //  Local variables available as Properties.

        private bool m_ParameterChanged;
        private bool m_PortChanged;
        private bool m_PortOpen;
        private SerialPort m_PreviousPort = new SerialPort();
        private int m_ReceivedDataLength;
        private int m_SavedBitRate = 9600;
        private Handshake m_SavedHandshake = Handshake.None ;
        private string m_SavedPortName = "";
        private SerialPort m_SelectedPort = new SerialPort();
        
               
        internal bool ParameterChanged 
        { 
            get 
            { 
                return m_ParameterChanged; 
            } 
            set 
            { 
                m_ParameterChanged = value; 
            } 
        }
        
        
        internal bool PortChanged 
        { 
            get 
            { 
                return m_PortChanged; 
            } 
            set 
            { 
                m_PortChanged = value; 
            } 
        }         
      
        internal bool PortOpen 
        { 
            get 
            { 
                return m_PortOpen; 
            } 
            set 
            { 
                m_PortOpen = value; 
            } 
        }         
       
        internal SerialPort PreviousPort 
        { 
            get 
            { 
                return m_PreviousPort; 
            } 
            set 
            { 
                m_PreviousPort = value; 
            } 
        }         
       
        internal int ReceivedDataLength 
        { 
            get 
            { 
                return m_ReceivedDataLength; 
            } 
            set 
            { 
                m_ReceivedDataLength = value; 
            } 
        }         
       
        internal int SavedBitRate 
        { 
            get 
            { 
                return m_SavedBitRate; 
            } 
            set 
            { 
                m_SavedBitRate = value; 
            } 
        }         
        
        internal Handshake SavedHandshake 
        { 
            get 
            { 
                return m_SavedHandshake; 
            } 
            set 
            { 
                m_SavedHandshake = value; 
            } 
        }         
       
        internal string SavedPortName 
        { 
            get 
            { 
                return m_SavedPortName; 
            } 
            set 
            { 
                m_SavedPortName = value; 
            } 
        }         
       
        internal SerialPort SelectedPort 
        { 
            get 
            { 
                return m_SelectedPort; 
            } 
            set 
            { 
                m_SelectedPort = value; 
            } 
        } 
        
        private SerialDataReceivedEventHandler SerialDataReceivedEventHandler1;        
        private SerialErrorReceivedEventHandler SerialErrorReceivedEventHandler1; 
        
        /// <summary>
        /// If the COM port is open, close it.
        /// </summary>
        /// 
        /// <param name="portToClose"> the SerialPort object to close </param>  

        internal void CloseComPort( SerialPort portToClose ) 
        { 
            try 
            { 
                if ( null != UserInterfaceData ) UserInterfaceData( "DisplayStatus", "", Color.Black ); 
                
                object transTemp0 = portToClose; 
                if (  !(  transTemp0 == null ) ) 
                {                     
                    if ( portToClose.IsOpen ) 
                    {                         
                        portToClose.Close(); 
                        if ( null != UserInterfaceData ) UserInterfaceData( "DisplayCurrentSettings", "", Color.Black );                         
                    } 
                }                
           }
                                      
            catch ( InvalidOperationException ex ) 
            {                 
                ParameterChanged = true; 
                PortChanged = true; 
                DisplayException( ModuleName, ex );                 
            } 
            catch ( UnauthorizedAccessException ex ) 
            {                 
                ParameterChanged = true; 
                PortChanged = true; 
                DisplayException( ModuleName, ex );                 
            } 
            catch ( System.IO.IOException ex ) 
            {                 
                ParameterChanged = true; 
                PortChanged = true; 
                DisplayException( ModuleName, ex ); 
            }             
        } 

        /// <summary>
        /// Called when data is received on the COM port.
        /// Reads and displays the data.
        /// See FindPorts for the AddHandler statement for this routine.
        /// </summary>
                
        internal void DataReceived( object sender, SerialDataReceivedEventArgs e ) 
        {
            
            string newReceivedData = null;
            try
            {
                //  Get data from the COM port.
                Thread.Sleep(200);
                newReceivedData = SelectedPort.ReadExisting();
                Thread.Sleep(100);

                if (null != UserInterfaceData) UserInterfaceData("Dialing","",Color.Black);


                if (newReceivedData.Length > 6)
                {
                    if (null != UserInterfaceData) UserInterfaceData("RetrievingResults", "", Color.Black);
                    NumberCrunchInterface(newReceivedData);
                }
                    

            }
            catch (Exception ex)
            {
                DisplayException(ModuleName, ex);
            }  
        }
        

        /// <summary>
        /// Provide a central mechanism for displaying exception information.
        /// Display a message that describes the exception.
        /// </summary>
        /// 
        /// <param name="ex"> The exception </param> 
        /// <param name="moduleName" > the module where the exception was raised. </param>
        
        private void DisplayException( string moduleName, Exception ex ) 
        {
            string errorMessage = null; 
            
            errorMessage = "Exception: " + ex.Message + " Module: " + moduleName + ". Method: " + ex.TargetSite.Name; 
            
            if ( null != UserInterfaceData ) UserInterfaceData( "DisplayStatus", errorMessage, Color.Red ); 
            
            //  To display errors in a message box, uncomment this line:
            //  MessageBox.Show(errorMessage)
        }        

        /// <summary>
        /// Respond to error events.
        /// </summary>
        
        private void ErrorReceived( object sender, SerialErrorReceivedEventArgs e ) 
        { 
            SerialError SerialErrorReceived1 = 0; 
            
            SerialErrorReceived1 = e.EventType; 
            
            switch ( SerialErrorReceived1 ) 
            {
                case SerialError.Frame:
                    Console.WriteLine( "Framing error." ); 
                    
                    break;
                case SerialError.Overrun:
                    Console.WriteLine( "Character buffer overrun." ); 
                    
                    break;
                case SerialError.RXOver:
                    Console.WriteLine( "Input buffer overflow." ); 
                    
                    break;
                case SerialError.RXParity:
                    Console.WriteLine( "Parity error." ); 
                    
                    break;
                case SerialError.TXFull:
                    Console.WriteLine( "Output buffer full." ); 
                    break;
            }            
        }         

        /// <summary>
        /// Find the PC's COM ports and store parameters for each port.
        /// Use saved parameters if possible, otherwise use default values.  
        /// </summary>
        /// 
        /// <remarks> 
        /// The ports can change if a USB/COM-port converter is attached or removed,
        /// so this routine may need to run multiple times.
        /// </remarks>
        
       internal static void FindComPorts() 
        { 
            myPortNames = SerialPort.GetPortNames(); 
            
            //  Is there at least one COM port?
            
            if ( myPortNames.Length > 0 ) 
            {                 
                comPortExists = true; 
                Array.Sort( myPortNames );                 
            } 
            else 
            { 
                //  No COM ports found.
                
                comPortExists = false; 
            }             
        } 

        /// <summary>
        /// Open the SerialPort object selectedPort.
        /// If open, close the SerialPort object previousPort.
        /// </summary>
                
        internal bool OpenComPort() 
        { 
            bool success = false;
            SerialDataReceivedEventHandler1 = new SerialDataReceivedEventHandler(DataReceived);
            SerialErrorReceivedEventHandler1 = new SerialErrorReceivedEventHandler(ErrorReceived); 

            try 
            { 
                if ( comPortExists ) 
                {                     
                    //  The system has at least one COM port.
                    //  If the previously selected port is still open, close it.
                    
                    if ( PreviousPort.IsOpen ) 
                    { 
                        CloseComPort( PreviousPort ); 
                    } 
                    
                    if ( ( !( ( SelectedPort.IsOpen ) ) | PortChanged ) ) 
                    {                         
                        SelectedPort.Open(); 
                        
                        if ( SelectedPort.IsOpen ) 
                        {                             
                            //  The port is open. Set additional parameters.
                            //  Timeouts are in milliseconds.
                            
                            SelectedPort.ReadTimeout = 20000; 
                            SelectedPort.WriteTimeout = 20000; 
                            
                            //  Specify the routines that run when a DataReceived or ErrorReceived event occurs.
                           
                            SelectedPort.DataReceived += SerialDataReceivedEventHandler1; 
                            SelectedPort.ErrorReceived += SerialErrorReceivedEventHandler1; 
                           
                            //  Send data to other modules.
                            
                            if ( null != UserInterfaceData ) UserInterfaceData( "DisplayCurrentSettings", "", Color.Black ); 
                            if ( null != UserInterfaceData ) UserInterfaceData( "DisplayStatus", "", Color.Black ); 
                            
                            success = true; 
                            
                            //  The port is open with the current parameters.
                            
                            PortChanged = false;                             
                        } 
                    }                    
                }                 
            }
            
            catch ( InvalidOperationException ex ) 
            {                 
                ParameterChanged = true; 
                PortChanged = true; 
                DisplayException( ModuleName, ex );                 
            } 
            catch ( UnauthorizedAccessException ex ) 
            {                 
                ParameterChanged = true; 
                PortChanged = true; 
                DisplayException( ModuleName, ex );                 
            } 
            catch ( System.IO.IOException ex ) 
            {                 
                ParameterChanged = true; 
                PortChanged = true; 
                DisplayException( ModuleName, ex ); 
            } 
            
            return success;             
        } 

        /// <summary>
        ///  Executes when WriteToComPortDelegate1 completes.
        /// </summary>
        /// <param name="ar"> the value returned by the delegate's BeginInvoke method </param> 
                
        internal void WriteCompleted( IAsyncResult ar ) 
        {   
            WriteToComPortDelegate deleg = null; 
            string msg = null; 
            bool success = false; 
            
            //  Extract the value returned by BeginInvoke (optional).
            
            msg = System.Convert.ToString( ar.AsyncState ); 
            
            //  Get the value returned by the delegate.
            
            deleg = ( ( WriteToComPortDelegate )( ( ( AsyncResult )( ar ) ).AsyncDelegate ) ); 
            
            success = deleg.EndInvoke( ar );
            if ( success ) 
            { 
                if ( null != UserInterfaceData ) UserInterfaceData( "UpdateStatusLabel", "", Color.Black ); 
            } 
           
        }
        internal void ReadComplete(IAsyncResult ar)
        {
            ReadComPortDelegate deleg = null;
            string msg = null;
            bool success = false;

            //  Extract the value returned by BeginInvoke (optional).

            msg = System.Convert.ToString(ar.AsyncState);

            //  Get the value returned by the delegate.

            deleg = ((ReadComPortDelegate)(((AsyncResult)(ar)).AsyncDelegate));

            success = deleg.EndInvoke(ar);

            if (success)
            {
                if (null != UserInterfaceData) UserInterfaceData("UpdateStatusLabel", "", Color.Black);
            }

            //  Add any actions that need to be performed after a write to the COM port completes.
            //  This example displays the value passed to the BeginInvoke method
            //  and the value returned by EndInvoke.

            Console.WriteLine("Write operation began: " + msg);
            Console.WriteLine("Write operation succeeded: " + success);
        }

        /// <summary>
        /// Write a string to the SerialPort object selectedPort.
        /// </summary>
        /// 
        /// <param name="textToWrite"> A string to write </param>
                
        internal bool WriteToComPort( string textToWrite ) 
        { 
            bool success = false;
           
            try 
            { 
                //  Open the COM port if necessary.
                
                if ( ( !( ( SelectedPort == null ) ) ) ) 
                { 
                    if ( ( ( !( SelectedPort.IsOpen ) ) | PortChanged ) ) 
                    {                         
                        //  Close the port if needed and open the selected port.
                        
                        PortOpen = OpenComPort();                         
                    } 
                } 
                
                if ( SelectedPort.IsOpen ) 
                { 
                    SelectedPort.Write( textToWrite ); 
                    success = true;

                }                 
            }           
            catch ( TimeoutException ex ) 
            { 
                DisplayException( ModuleName, ex ); 
                
            } 
            catch ( InvalidOperationException ex ) 
            { 
                DisplayException( ModuleName, ex ); 
                ParameterChanged = true; 
                if ( null != UserInterfaceData ) UserInterfaceData( "DisplayCurrentSettings", "", Color.Black );                 
            } 
            catch ( UnauthorizedAccessException ex ) 
            { 
                DisplayException( ModuleName, ex ); 
                
                //  This exception can occur if the port was removed. 
                //  If the port was open, close it.
                
                CloseComPort( SelectedPort ); 
                ParameterChanged = true; 
                if ( null != UserInterfaceData ) UserInterfaceData( "DisplayCurrentSettings", "", Color.Black );                 
            }             
            return success;             
        }
        internal string ReadComPort()
        {
            bool success = false;
            string dataReadToDisplay = null;
            try
            {
                //  Open the COM port if necessary.

                if ((!((SelectedPort == null))))
                {
                    if (((!(SelectedPort.IsOpen)) | PortChanged))
                    {
                        //  Close the port if needed and open the selected port.

                        PortOpen = OpenComPort();
                    }
                }

                if (SelectedPort.IsOpen)
                {
                    //int iRead = SelectedPort.BytesToRead;
                    //byte[] a_byteArray = new byte[iRead];
                    //int iNread = 0;
                    //iNread = SelectedPort.Read(a_byteArray, 0, iRead);
                    //dataReadToDisplay = "";
                    //foreach (byte b in a_byteArray)
                    //{

                    //    dataReadToDisplay += b.ToString() + " ";

                    //}
                    dataReadToDisplay = SelectedPort.ReadLine();
                    success = true;
                }
            }
            catch (TimeoutException ex)
            {
                DisplayException(ModuleName, ex);

            }
            catch (InvalidOperationException ex)
            {
                DisplayException(ModuleName, ex);
                ParameterChanged = true;
                if (null != UserInterfaceData) UserInterfaceData("DisplayCurrentSettings", "", Color.Black);
            }
            catch (UnauthorizedAccessException ex)
            {
                DisplayException(ModuleName, ex);

                //  This exception can occur if the port was removed. 
                //  If the port was open, close it.

                CloseComPort(SelectedPort);
                ParameterChanged = true;
                if (null != UserInterfaceData) UserInterfaceData("DisplayCurrentSettings", "", Color.Black);
            }
            return dataReadToDisplay;
        }           
    }     
}

Luc Pattyn12-Mar-10 2:51

Luc Pattyn

12-Mar-10 2:51

Deepak.Prahlad wrote:
Timeout value (read timeout and write timeout) every time you read or write

No, timeout is a property just like all others. You can set it once, it will hold its value.

Deepak.Prahlad wrote:
Read timeout timer starts when the first characeter arrives at the hardware buffer

No, read timeout starts when a read operation starts. The behavior you are referring to exists in Windows but AFAIK is not exposed to the SerialPort class.

Deepak.Prahlad wrote:
thread locking in DataReceived event

DataReceived is an asynchronous event; as such it is handled by a ThreadPool thread, which is not allowed to touch the Winform Controls directly. See this[^] and this[^] article.

One can never be sure that all the serial data that belongs together (a "message") will be received in one go; there always could be a hick-up somewhere, causing the message to be split over two DataReceived events. One approach that often leads to success is by having some delay between the start of the DataReceived event and the actual reading of the data.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

I only read code that is properly formatted, adding PRE tags is the easiest way to obtain that.

PIEBALDconsult12-Mar-10 3:45

PIEBALDconsult

12-Mar-10 3:45

Here's a similar post[^]; maybe it could help.

MouseEnter and MouseLeave not working if Enabled=false

Deepak.Prahlad14-Mar-10 17:59

Deepak.Prahlad

14-Mar-10 17:59

Hi stancrm, OriginalGriff, DotNetCoderJunior, Luc Pattyn, PIEBALDconsult

I think I solved the issue by using a thread.sleep() at the bigining of the DataRecieved() as suggested by Luc Pattyn, Thumbs Up | :thumbsup:

Thanks for the help from every one! Blush | :O

Regards
Deepak

stancrm11-Mar-10 22:01

stancrm

11-Mar-10 22:01

modified 23-Nov-14 6:36am.

Re: MouseEnter and MouseLeave not working if Enabled=false

#realJSOP12-Mar-10 1:48

#realJSOP

12-Mar-10 1:48

You could try creating a class that inherits from the control and provide the functionality there.

.45 ACP - because shooting twice is just silly
-----
"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." - J. Jystad, 2001

Re: MouseEnter and MouseLeave not working if Enabled=false

Dave Kreskowiak12-Mar-10 3:42

Dave Kreskowiak

12-Mar-10 3:42

If the control is disabled, none of those events fire. Like John said, you'd have to implement your own button class to support this. You'd be creating a button that never really disables. You'd keep track of the Enabled state as in a normal button, and keep certain events running while "disabling" others, like Click DoubleClick, MouseDown, MouseUp, ..., if the control is disabled. You'd also have to custom paint the button to show that it is "disabled" or not.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

Re: MouseEnter and MouseLeave not working if Enabled=false [modified]

#realJSOP12-Mar-10 5:41

#realJSOP

12-Mar-10 5:41

bool EverythingYouSaid = PainInTheAss;
bool IsItWorthIt = false;

modified on Friday, March 12, 2010 11:48 AM

Re: MouseEnter and MouseLeave not working if Enabled=false

Dave Kreskowiak12-Mar-10 7:04

Dave Kreskowiak

12-Mar-10 7:04

Yep. I didn't say it was worth it, I just said it could be done. Frankly, I can find no value in knowing that the mouse is over a button that's disabled. Sounds like he's trying to use it for something not-so-well-thought-out.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

Re: MouseEnter and MouseLeave not working if Enabled=false

#realJSOP12-Mar-10 12:03

#realJSOP

12-Mar-10 12:03

Evidently, he 1-voted us both. I 5'd you to compensate.

I could almost understand wanting to show tooltips for a control that's disabled.

This particular problem (if done *right*) would require that he create a custom version of every control - a royal pain-in-the-ass. Smile | :)

Re: MouseEnter and MouseLeave not working if Enabled=false

Dave Kreskowiak12-Mar-10 12:15

Dave Kreskowiak

12-Mar-10 12:15

John Simmons / outlaw programmer wrote:
Evidently, he 1-voted us both. I 5'd you to compensate.

And the same for you!

John Simmons / outlaw programmer wrote:
I could almost understand wanting to show tooltips for a control that's disabled.

Yeah, I can see that too... almost. Still, when I see a greyed out control, I don't even bother testing it for some obscure functionality. it just gets skipped until it want's to respond.

John Simmons / outlaw programmer wrote:
This particular problem (if done *right*) would require that he create a custom version of every control - a royal pain-in-the-ass.

For some reason, I don't see him doing that. Wink | ;)

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

Re: MouseEnter and MouseLeave not working if Enabled=false

The Man from U.N.C.L.E.12-Mar-10 8:25

The Man from U.N.C.L.E.

12-Mar-10 8:25

It's possible that your application logic may be wrong. Why respond to events on a disabled button? Standard for windows is that disabled objects raise no events, so it has to be some really good reason to go against the flow. Also it will confuse your end users.
As has been said, you could write your own button, but why buck the trend?

If you have knowledge, let others light their candles at it.
Margaret Fuller (1810 - 1850)
[My Articles] [My Website]

multiple textbox text save in one field

mjawadkhatri11-Mar-10 19:41

11-Mar-10 19:41

hi..
I need 2 know How i am Insert multiple textbox text in one field
For Example
I have one Field name data
and i have 3 textbox
i want to insert 3 textbox data in one field.

hope u understand my problem
i am waiting your response.

Thanks In advance
Jawad khatri

Calla11-Mar-10 20:20

11-Mar-10 20:20

I don't get what the problem is?
Where do you fail in your attempt to copy the data from your textboxes?
You access the data in a textbox by using the Text property..

mjawadkhatri11-Mar-10 20:34

11-Mar-10 20:34

yes i want to access data to text property

let suppose
i have 3 textboxes
text1.text = I
text2.text = am
text3.text - jawad

now i want to save these 3 textboxes data in one field

Calla11-Mar-10 20:40

11-Mar-10 20:40

Just concatenate your textbox content to a string:

string theString = string.Empty;
text1.Text = "I";
text2.Text = "am";
text3.Text = "jawad";
theString = text1.Text + text2.Text + text3.Text;

Still not sure if this is what you're after though.. Confused | :confused:

mjawadkhatri11-Mar-10 20:46

11-Mar-10 20:46

thanks for response.
i have a table Data have one field name description.
and i have 3 textboxes Rate,Weight,Product
i want to save data of Rate,Weight,Product in description field

Now hope u understand

Calla11-Mar-10 20:55

11-Mar-10 20:55

Is "Data" a table in a database?
Could you post the code you're having trouble with and describe what goes wrong and what you want it to do?

mjawadkhatri11-Mar-10 23:16

Re: multiple textbox text save in one field [modified]

11-Mar-10 23:16

Yes Data Is table in database

SqlConnection conn = new SqlConnection(connString);
string query = "insert into Data(Product,discription) values('" + txtproduct.Text + "','" + txtrate.Text + "'&& '" + txtweight.Text + "')";
SqlCommand cmd = new SqlCommand(query, conn);
try
{
conn.Open();
cmd.ExecuteNonQuery();
MessageBox.Show("Record Inserted Sucessfully.");
}
finally
{
conn.Close();

}

Calla12-Mar-10 0:53

12-Mar-10 0:53

Okay, and what is the error your receiving?
Do you really want the concatenated string to look like this (if txtrate=theRating, txtweight=theWeight)?
theRating'&&'theWeight

Or do you want:
theRating&&theWeight

Check the part where you put your strings together.

If you want to use a ' in your concatenated string you have to use double '' like this:

string query = "insert into Data(Product,discription) values('" + textBox1.Text + "','" + textBox2.Text + "''&& ''" + textBox3.Text + "')";

modified on Friday, March 12, 2010 7:01 AM

mjawadkhatri12-Mar-10 1:01

12-Mar-10 1:01

I have Done Smile | :)

Thanks For Help Me Sir

Calla12-Mar-10 1:30