Generated UPDATE for TableAdapter error RRS feed

  • Question

  • Hi, I have this problem:
    I created new typed-dataset, dragged table from server explorer(using SQL 2005 express and  sample DB) and modified the update command in query builder. I remove filter from some columns in query builder. Now when I call Update method of that TableAdapter I get SqlException:

     Parameterized Query '(@Name nvarchar(100),@ProductNumber nvarchar(25),@MakeFlag bit,@' expects parameter @IsNull_Color, which was not supplied.

    So I try to find a bug and I find:
    All parameters for generated UPDATE command, which started with @IsNull_ColumnName are now: DbType is AnsiString( before my change of update was Int32)
                  SourceColumn is empty(was ColumnName)
                  SourceColumnNullMapping is False(was True)
                 AllowDbNull is false(was true)

    So my questions are:
    Is this behavior bug in Query builder?
    Why query builder change all @IsNull_ColumnName parameters for update command, when I remove filter in query builder in only one column?
    Thank you.

    Monday, February 13, 2006 5:15 PM