Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rtutus
Aged Yak Warrior
522 Posts |
 Posted - 2006-02-23 : 23:51:29
|
| Hi, I populate my dataset, that has more than one table, the first time using dataadapter and a view like this: cm.CommandText = "SELECT * FROM vwFeat where SubNmbr=5142062279" da.SelectCommand = SqlSelectCommand1da.Fill(ds, "TblFeat")Then, I update my dataset "ds" with an internal process by adding, deleting and updating rows (for now i m interested in updating rows)Please how do I update that first table "TblFeat" in my SQL server database from my modified dataset "ds"P.S: the view vwFeat is constructed from table : TblFeatI can replace my view with the table TblFeatThanks a lot, |
|
|
shallu1_gupta
Constraint Violating Yak Guru
394 Posts |
Posted - 2006-02-24 : 00:12:18
|
| Hi,Go thru this link...http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatacommondbdataadapterclassupdatetopic5.asp |
 |
|
|
rtutus
Aged Yak Warrior
522 Posts |
Posted - 2006-02-24 : 10:13:08
|
| Thanks a lot, that helped a lot. |
|
|
|
|
|
|
updating a table in my SQL database from a dataset