views:

195

answers:

1
 MyTable.Update(long.Parse(id), txtLocation.Text, txtCode.Text, locale, 
                           chkAvailable.Checked, DateTime.Now);

Neither chkAvailable.Checked or DateTime.Now cause an update but changing the other fields do...

What's going on?

I'm using SQL Server 2005. .NET 3.5 SP1

Rob

+1  A: 

Hi Rob....Did you try another way ?? like

Object obj = new Object(); obj.field = xxx; obj.field = xxxx;

obj.Save();

Other question ? What the database do you using ??? I´m asking because not all the databases have the type boolean and you set in the line "chkAvailable.Checked"

Valmir
No i did not but I will.
Rob Stevenson-Leggett
It's SQL2005 and it uses the bit type, this works fine for insert so I don't see why it wouldn't work in this case.
Rob Stevenson-Leggett
I never use the bit type because my projects have to run in SqlServer oracle and mySql . But I agree with you, should be work.....
Valmir