mukulmukul
Member
- Joined
- Jun 21, 2009
- Messages
- 10
- Programming Experience
- Beginner
hi.
i m using visual basic 2005
i am using a form to update a database created in ms access
i have created datasets, n also initialised all insert and upadate query`s using command builder
my statemens are
DataSet1.TRANSACTION.Rows.Add(New String() {DataSet1.TRANSACTION.Count + 1, bookcode, bookid, memberid, issuedate, duedate, duedate, 0})
TRANSACTIONTableAdapter.Update(DataSet1.TRANSACTION)
the update command generated by command builder is
UPDATE `TRANSACTION` SET `BOOK CODE` = ?, `BOOK_ID` = ?, `MEMBER_ID` = ?, `DATE OF ISSUE` = ?, `DUE DATE` = ?, `DATE OF RETURN` = ?, `FINE (IF ANY)` = ? WHERE (((? = 1 AND `SERIAL_NO` IS NULL) OR (`SERIAL_NO` = ?)) AND ((? = 1 AND `BOOK CODE` IS NULL) OR (`BOOK CODE` = ?)) AND (`BOOK_ID` = ?) AND ((? = 1 AND `MEMBER_ID` IS NULL) OR (`MEMBER_ID` = ?)) AND ((? = 1 AND `DATE OF ISSUE` IS NULL) OR (`DATE OF ISSUE` = ?)) AND ((? = 1 AND `DUE DATE` IS NULL) OR (`DUE DATE` = ?)) AND ((? = 1 AND `DATE OF RETURN` IS NULL) OR (`DATE OF RETURN` = ?)) AND ((? = 1 AND `FINE (IF ANY)` IS NULL) OR (`FINE (IF ANY)` = ?)))
with these statements.. i am having the dataset updated.. but my original database in access is not having the changes
any help how to get the changes reflected. please help.. m very new to vb.net
i m using visual basic 2005
i am using a form to update a database created in ms access
i have created datasets, n also initialised all insert and upadate query`s using command builder
my statemens are
DataSet1.TRANSACTION.Rows.Add(New String() {DataSet1.TRANSACTION.Count + 1, bookcode, bookid, memberid, issuedate, duedate, duedate, 0})
TRANSACTIONTableAdapter.Update(DataSet1.TRANSACTION)
the update command generated by command builder is
UPDATE `TRANSACTION` SET `BOOK CODE` = ?, `BOOK_ID` = ?, `MEMBER_ID` = ?, `DATE OF ISSUE` = ?, `DUE DATE` = ?, `DATE OF RETURN` = ?, `FINE (IF ANY)` = ? WHERE (((? = 1 AND `SERIAL_NO` IS NULL) OR (`SERIAL_NO` = ?)) AND ((? = 1 AND `BOOK CODE` IS NULL) OR (`BOOK CODE` = ?)) AND (`BOOK_ID` = ?) AND ((? = 1 AND `MEMBER_ID` IS NULL) OR (`MEMBER_ID` = ?)) AND ((? = 1 AND `DATE OF ISSUE` IS NULL) OR (`DATE OF ISSUE` = ?)) AND ((? = 1 AND `DUE DATE` IS NULL) OR (`DUE DATE` = ?)) AND ((? = 1 AND `DATE OF RETURN` IS NULL) OR (`DATE OF RETURN` = ?)) AND ((? = 1 AND `FINE (IF ANY)` IS NULL) OR (`FINE (IF ANY)` = ?)))
with these statements.. i am having the dataset updated.. but my original database in access is not having the changes
any help how to get the changes reflected. please help.. m very new to vb.net
