Cor Ligthert [MVP]
5/8/2008 4:09:00 PM
Look at your transact SQL and the parameters that are used.
However for that it is very depending how you did create that as there are
probably more than 100 possibilities for that, and I can assure you, I
don't know them all.
Cor
"Morris Neuman" <Morris@online.nospam> schreef in bericht
news:D2EE5D4E-F97D-4BE2-8DE3-0F657075C897@microsoft.com...
> OK what can I do to resolve it?
> --
> Thanks
> Morris
>
>
> "Cor Ligthert[MVP]" wrote:
>
>> Morris,
>>
>> There is defintly something wrong by the by you supplied parameters and
>> the
>> parameters the SQL procedure expects.
>>
>> That you get no errors when there are no changes is obviously as there
>> will
>> be nothing done as there are no changes.
>>
>> The Adapter skips before the non changed rows on their rowstate.
>>
>> Cor
>>
>> "Morris Neuman" <Morris@online.nospam> schreef in bericht
>> news:7F0FE369-C5CF-4EF5-9841-C37E22B2DAB9@microsoft.com...
>> > I'm working in VS2005, C#. I have a form with a details view of
>> > records.
>> > The Fill statement takes 1 parameter a BOXNUMBER so I fetch only one
>> > record
>> > from the database table. Fill(MBDataSet.MBDetailsDataTable dataTable,
>> > string
>> > BoxNumber)
>> >
>> > After editing the fields I issue a tableadapter.update(dataset)
>> > command.
>> > That update throws an exception and the message is :
>> >
>> > "Parameterized Query '(@BoxNumber nvarchar(10),@LastName
>> > nvarchar(25),@PhoneNumber nva' expects parameter @IsNull_BoxNumber,
>> > which
>> > was
>> > not supplied."
>> >
>> > If no changes were made to any field the update does not throw an
>> > excpetion.
>> >
>> > I have made no code changes to any of the Designer generated code and
>> > have
>> > only added event handlers to the Form.cs file to issue the update.
>> > What is going wrong? A data view of the data set shows the changes
>> > made
>> > to
>> > the fields OK.
>> > How can I send the update back to the database using the table adapter?
>> >
>> > --
>> > Thanks
>> > Morris
>>