hiya,

I'm using the latest llblGenPro and binding an entityCollection to a winforms 2.0 datagidView.

The entityCollection datasource is an sqlServer nchar(15) field.

I'm having trouble because the item in the datagridView contains a trailing space.

 foreach (DataGridViewRow row in this.dgvDeliveryProducts.Rows)
                {
                    TblDeliveryProductsEntity product = new TblDeliveryProductsEntity();

                    product = (TblDeliveryProductsEntity)row.DataBoundItem; 

                    if (product != null)
                    {
                        string barCode;
                        barCode = txtBarcode.Text;

                        
                        if (product.BarCode == barCode)   
                        //can I "trim" the  product.BarCode?                        

Many thanks,

yogi

You could try something like this (copied from MSDN)

class stringTrim2 {
    public static void Main() {
        String str1 = "*;|@123***456@|;*";
    String delim = "*;|@";
    String str2 = str1.Trim(delim.ToCharArray());

    Console.WriteLine("Delimiters:      {0}", delim);
    Console.WriteLine("Original string: {0}", str1);
    Console.WriteLine("Trimmed string:  {0}", str2);
    }
}

cheers Sparmar,

i just asssigned the property of the entity to a string and compared it. I can't believe that VS2005 / sqlServer don't provide this functionality.

yogi

yogiberr wrote:

cheers Sparmar,

i just asssigned the property of the entity to a string and compared it. I can't believe that VS2005 / sqlServer don't provide this functionality.

yogi

Well that is one way of doing the job. but you never know. some else might come up with another method.