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
Rawan K
NA
3
1.6k
C# Windows Forms to SQL connection: error in reading table
Jan 25 2014 7:56 AM
Hey experts! I have a system consisting of a Java Android application that enters information in an SQL server database every certain count of seconds, and I have a C# Windows Form that is connected to the database and reads the entries perfectly fine. My problem is, I need to let the client know when information has STARTED to be entered inside the table, so I tried StartofSessionCheck() that checks whenever the datarow is NO LONGER null (has rows) and informs the client, but I keep getting the error: "there's no row at postition 0"
I don't know how to fix this, but maybe my whole methodlogy is wrong. please HELP!
NOTE: the marker1 and 2 check makes sure that the session only starts when my columns have ones in them
private void StartOfSessionCheck()
{
while (dRow != null ) // when datarow is no longer null, i.e. has a length >0 then proceed
{
if (stayinLoop == true)
{
dRow = ds.Tables[0].Rows[rowNum]; // reads the first row
Marker1 = dRow.ItemArray.GetValue(1).ToString();
Marker2 = dRow.ItemArray.GetValue(2).ToString();
if (Marker1 == "1" && Marker2 == "1") //make sure my first row has ones in it
{
stayinLoop = false; // leave the loop so we can execute the rest of the program
rowNum++;
}
}
}
}
Reply
Answers (
4
)
display images gallery scrolling
C# unknown project type