Click here to Skip to main content
15,920,383 members
Home / Discussions / Database
   

Database

 
GeneralRe: Updating Related Tables Pin
Wjousts3-Oct-03 5:20
Wjousts3-Oct-03 5:20 
Generalwhere close Pin
sardinka30-Sep-03 5:05
sardinka30-Sep-03 5:05 
GeneralRe: where close Pin
Edbert P16-Oct-03 20:45
Edbert P16-Oct-03 20:45 
Generaladd record to a database Pin
ranjjj30-Sep-03 4:33
ranjjj30-Sep-03 4:33 
GeneralGetting the SQL commands from OleDbDataAdapter.Update Pin
Wjousts29-Sep-03 10:38
Wjousts29-Sep-03 10:38 
GeneralRe: Getting the SQL commands from OleDbDataAdapter.Update Pin
Guillermo Rivero29-Sep-03 11:53
Guillermo Rivero29-Sep-03 11:53 
GeneralRe: Getting the SQL commands from OleDbDataAdapter.Update Pin
Wjousts29-Sep-03 12:18
Wjousts29-Sep-03 12:18 
GeneralRe: Getting the SQL commands from OleDbDataAdapter.Update Pin
Wjousts30-Sep-03 4:57
Wjousts30-Sep-03 4:57 
Okay, I tracked down the problem by systematically removing fields from my Update statement. The problem is caused by a date field. I have something like this (but with a lot more fields):
<br />
SQLUpdate = "UPDATE myTable SET Field1 = @Field1, Date = @Date, WHERE Key = @Key";<br />


Then I have this:

<br />
OleDbCommand myCmd = new OleDbCommand(SQLUpdate,myConnection);<br />
myCmd.Parameters.Add("@Field1", OleDbType.VarWChar, 20, "Field1");<br />
myCmd.Parameters.Add("@Date", OleDbType.Date, 0, "Date");<br />
<br />
myApt.UpdateCommand = myCmd;<br />


What's the right way to handle the date field in an Access database. Even the command builder seems to fail at this!! BTW, the Date field is bound to a DatePicker control on my form, perhaps something is getting lost in the translation?
GeneralRedistribute MS DataGrid Control Pin
pallattila29-Sep-03 7:57
pallattila29-Sep-03 7:57 
GeneralRe: Redistribute MS DataGrid Control Pin
Steve S30-Sep-03 5:21
Steve S30-Sep-03 5:21 
GeneralSQLServer and XML RAW Pin
Guillermo Rivero29-Sep-03 7:45
Guillermo Rivero29-Sep-03 7:45 
GeneralRe: SQLServer and XML RAW Pin
Mike Dimmick1-Oct-03 12:43
Mike Dimmick1-Oct-03 12:43 
GeneralRe: SQLServer and XML RAW Pin
Guillermo Rivero3-Oct-03 2:37
Guillermo Rivero3-Oct-03 2:37 
GeneralPrimary Key as a Foreign Key Pin
DotNet_Newbie29-Sep-03 6:44
DotNet_Newbie29-Sep-03 6:44 
GeneralRe: Primary Key as a Foreign Key Pin
STW2-Oct-03 22:40
STW2-Oct-03 22:40 
Generalado.net Pin
Member 23171029-Sep-03 0:37
Member 23171029-Sep-03 0:37 
GeneralRe: ado.net Pin
Roger Wright29-Sep-03 5:17
professionalRoger Wright29-Sep-03 5:17 
GeneralWinforms - Menu Generation from SQL Database at runtime Pin
sunny12328-Sep-03 22:47
sunny12328-Sep-03 22:47 
GeneralRe: Winforms - Menu Generation from SQL Database at runtime Pin
Guillermo Rivero29-Sep-03 8:09
Guillermo Rivero29-Sep-03 8:09 
GeneralRe: Winforms - Menu Generation from SQL Database at runtime Pin
sunny12329-Sep-03 20:47
sunny12329-Sep-03 20:47 
GeneralConcurrency violation: the UpdateCommand affected 0 records. Pin
falbala27-Sep-03 3:32
falbala27-Sep-03 3:32 
GeneralRe: Concurrency violation: the UpdateCommand affected 0 records. Pin
Mike Dimmick27-Sep-03 11:56
Mike Dimmick27-Sep-03 11:56 
GeneralRe: Concurrency violation: the UpdateCommand affected 0 records. Pin
falbala12-Oct-03 0:27
falbala12-Oct-03 0:27 
GeneralRe: Concurrency violation: the UpdateCommand affected 0 records. Pin
Wjousts30-Sep-03 9:05
Wjousts30-Sep-03 9:05 
GeneralRe: Concurrency violation: the UpdateCommand affected 0 records. Pin
falbala12-Oct-03 0:29
falbala12-Oct-03 0:29 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.