Recent content by JanAntwerpen

  1. J

    Linq with Null values in the WHERE Clause

    I am using a datagridview which is normally bound to a datacontext, using Linq. var q = from table in dataContext.table1 select table; As I want to search for data in this table, I unbound the datagridview and have only one row. The user can put in filters. Afterwards, I want to fill...
  2. J

    Linq with Null values in the WHERE Clause

    Possible answer OK!! GOT IT! I know this is not the best way to do it, returning all records and then start the filtering, but it is the only way I could come up with. So if anyone knows a better way to handle this, let me know!!! What I have is this: var q = from table in dataContext.table1...
  3. J

    KeyUp in datagridview with EditOnEnter not working

    Works PERFECTLY!!!!:encouragement: THX!
  4. J

    Linq with Null values in the WHERE Clause

    Hello people! I have a table with a lot of columns. I want to be able te let the user search on every column. Afterwards I perform a linq query and this should show all the correct data. Problem is that all empty cells return a null value. Making the Linq query not working. I have following...
  5. J

    KeyUp in datagridview with EditOnEnter not working

    Hello People! I have a problem in my DataGridView: I like to have a cell Always be in editmode as I enter it. (DataGridView.EditMode = EditOnEnter) This works perfectly! I want to use the function-keys F7 and F8 for two different things: F7 adds a new record, F8 opens the selected...
  6. J

    Question Datagridview giving errors on adding a new row on the comboboxcell

    I tried it with other tables within my Database, and I keep getting the same errors. I noticed that I only get this error when the comboboxcell may not contain null values. Now, how can I prevent this error and let the user decide which value he wants to select from within the possible values in...
  7. J

    Question Datagridview giving errors on adding a new row on the comboboxcell

    Hello, I have problems with a comboboxcolumn in a datagridview: As I want to insert a new row, I get a "System.ArgumentException: The value of the DataGridViewComboBoxCell is invalid." I am using Linq to SQL to populate the data from different tables: - Table Customer (ID (key), Name,...) -...
Top Bottom