When i am doing it like that it gives error cannot convert System.Int32 to System.String Actually both are Primary key IDs in individual master tables....but the value coming here is string...If i am not using AND clause this is working fine with individual listbox filtering it is auto converting those strings...Its only then when i want to filter by values from both columns its creating prob...I am not facing any prob with combo box in the same situation.......Its the only list box thats irritating

I have to list boxes...and i have a datagrid with binded to complete table..and i am using DataGridCombocolumn with displaystyle as nothing to display the values from master tables in relation instead of their IDs... On selection change event of second list box i put this filter...values in both list boxes are selected...it shows correct values in debug mode........ MyBindingSource.Filter = "Column1="+cbCol1.SelectedValue+" AND Column2= "+cbCol2.SelectedValue; it gives following error Syntax error: Missing operand before 'And' operator.

Hi there, Trim() i used ...... Its the first time...........like a form with a binding navigator directly picking db values. we use trim when we are sending the records to db........ Using binding navigator it calls a Fill() function on tableadapter..and retrieves records from dataset Is there a way to edit default fill query in C#....I think if i can edit the default query i can add DB Trim function and my problem will be solved........Can anybody know how to edit Fill query of a binding navigator or dataset pls help

Hi Folks, I made a test app with sql server 2008 and vc# 2008. Used dataset, bindingsource, table adapter, bindingnaviagator When i am displaying data on the form in textbox, combobox, text area i found that the data is added with extra whitespace upto the width of the column in table. if my db column size is char(30), and it actually has a value of 10 chars...when i retrieve record it displays 10chars +20whitespace on text box and the text goes hidden to left side in textbox etc.... Is there a way to fix this????????? Coz i am using bindingsource and tableadapter i cant handle it at db level trimming....pls help.....These whitespaces are really irritating....... regards shafi

Hi Folks, I want to insert 6 rows of data of Six week days into SQL Server 2008 database from a single C# windows form. I want to use a data grid view....... Please suggest how to logically achieve it....on single click of "Save" button in bindingnavigator i want to insert all 6 records in Database. I am using Visual Studio 2008 SP1.... pls help regards shafi

Hi Folks, I have a string.."Desktop Development Web Development Multimedia Development". Now i want a 20 character string "Desk Dev Web Dev" like this...pls help

I have two data grids on a windows form......... On double-clicking a row on first datagrid i want that row grid should get copied onto the second data grid under new auto incremented row number........ can any one help please regards :)