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 |
|
foolios
Starting Member
5 Posts |
 Posted - 2007-06-16 : 19:51:54
|
| Ok, at this point I have the reader reading the tables data in a loop while it's not empty. During the gathering of each row of data, I was wondering if it was possible to do a next row once I've reached a certain column. The main users table has just the one user, but it's relationship table has a couple family members. I was hoping someone could show me how to make it so that the one user and all his related family members will print out to a label.while (reader.Read()){string usr = reader["UserName"].ToString();usr = usr.TrimEnd();string pss = reader["Password"].ToString();pss = pss.TrimEnd();if (usrNmeLbl.Text == usr){if (psswrdLbl.Text == pss){//read the column from the reader and cast it to String as some may contain null valuesusrNmeLbl.Text = reader["FirstName"].ToString() + " ";psswrdLbl.Text = reader["LastName"].ToString() + "<br />";psswrdLbl.Text += "Place of Birth: " + reader["BirthPlace"].ToString() + "<br />";psswrdLbl.Text += "<img src=" + reader["Photo"].ToString() + " />" + "<br />";Label4.Text = "Your relatives: " + "<br />";Label4.Text += reader["Relation"].ToString() + ": ";Label4.Text += reader["RelativeFN"].ToString() + reader["RelativeLN"].ToString();Label4.Text += reader["Relation"].ToString() + ": ";Label4.Text += reader["RelativeFN"].ToString() + reader["RelativeLN"].ToString();}If I grab the Relation table data again, it's not cycled to the next relative. I was hoping that it would, but it's not. So I'm wondering if there was something that could be added to the second set.Label4.Text += reader["Relation"].ToString() + ": ";Label4.Text += reader["RelativeFN"].ToString() + reader["RelativeLN"].ToString();Thank you in advance. |
|
|
foolios
Starting Member
5 Posts |
Posted - 2007-06-16 : 20:05:47
|
| I tried this:while (reader.Read()) { string usr = reader["UserName"].ToString(); usr = usr.TrimEnd(); string pss = reader["Password"].ToString(); pss = pss.TrimEnd(); //take the read data from the reader and display it for testing purposes if (usrNmeLbl.Text == usr) { if (psswrdLbl.Text == pss) { //read the column from the reader and cast it to String as some may contain null values usrNmeLbl.Text = reader["FirstName"].ToString() + " "; psswrdLbl.Text = reader["LastName"].ToString() + "<br />"; psswrdLbl.Text += "Place of Birth: " + reader["BirthPlace"].ToString() + "<br />"; psswrdLbl.Text += "<img src=" + reader["Photo"].ToString() + " />" + "<br />"; Label4.Text = "Your relatives: " + "<br />"; while (reader.Read()) { Label4.Text += reader["Relation"].ToString() + ": "; Label4.Text += reader["RelativeFN"].ToString() + reader["RelativeLN"].ToString() + "<br />"; } }But for some reason the relationships print out multiple times rather than just until there are no more relatives in the database. |
 |
|
|
foolios
Starting Member
5 Posts |
Posted - 2007-06-16 : 20:48:26
|
| Ok, this is where I am really confused. Why does the reading of data loop all over again from the beginning? I would think that when it read the last row that then it would just exit out of the loop. Just like what's happening with the first loop with while(reader.Read()). while (reader.Read()) { Label4.Text += reader["Relation"].ToString() + ": "; Label4.Text += reader["RelativeFN"].ToString() + reader["RelativeLN"].ToString() + "<br />"; } |
|
|
|
|
|
|
How can you stop and cycle through a column(s) of