SqlDataReader is only returning the first item of the returned results.

[G-Oker]

Hello,


I am trying to get a content of an order from an sql table. I am getting the 1st item that is being retunred (and then dislying it in a RTB), but it fails to get any of the other results.

Please can someone advise where I am going wrong ?

using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
using (SqlCommand cmd = new SqlCommand("SELECT * FROM analysis WHERE ( analysis.id = " + _order_id + " ) and ( isnull(analysis.cancelled,'0') = '0' )", connection))
{
using (SqlDataReader orderedItems = cmd.ExecuteReader())
{

foreach (var item in orderedItems)
{
_items_id = orderedItems[2].ToString().TrimEnd();
_qty = orderedItems[3].ToString().TrimEnd();
_qty = _qty.Split('.').First();
_price = orderedItems[4].ToString().TrimEnd();
_remarks = orderedItems[7].ToString().TrimEnd();
_measured = orderedItems[8].ToString().TrimEnd();

SetText1(_items_id + " " + _qty + " " + _price + " " + _remarks + " Measured: " + _measured + Environment.NewLine + Environment.NewLine);
}
}
}
connection.Close();
}
.
.
.
.
.
private void SetText1(string text)
{
if (this.richTextBox2.InvokeRequired)
{
SetTextCallback d = new SetTextCallback(SetText1);
this.Invoke(d, new object[] { text });
}
else
{
//this.textBox1.Text = text;
this.richTextBox2.AppendText(text);
}
}

delegate void SetTextCallback(string text);
}

Thank you

Continue reading...