Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #72.9K
1 Posted Topic
I am trying to update a sequence of records where the field WebSvc = No Here is the code [code] cn.Open() da = New SqlDataAdapter("SELECT * FROM dbo.DurexBOL", cn) cmdBuilder = New SqlCommandBuilder(da) da.Fill(ds, "DurexBOL") Do While ds.Tables("DurexBOL").Select("WebSvc = 'No'") ds.Tables("DurexBOL").Rows(0)("WebSvc") = "Yes" da.Update(ds, "DurexBOL") Loop Console.WriteLine("City updated successfully") cn.Close() …
The End.