TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
rajesh kasani
NA
31
21.7k
how to update rows one after other
Mar 19 2011 4:56 PM
hi friends,
In Ado.net how to update rows one after the other in a particular table when there is a condition for limit let me say
if(ds.Tables[0].Rows.Count==0)
{
// Update the first row
//after that
// update second row.....so...on
// this happens in a asp.net page
can this be done like this
int rowpionter=0;
While(rowpionter<10)
{
update tbl_name set col_name=' ',col1_name=' ' where colPK='ds.Tables[0].Rows[rowpointer].ItemArray[0].Tostring();
rowpionter++;
}
}
this is when database is having 10 records the next record should not be inserted but updated and then next should be updated
Thanxs for u r help
Bye rajesh
Reply
Answers (
3
)
Simple Login Project
how to convert binary data to string