hi all,
i had a problem with displaying the data in textbox.
My code is here
string note = "SELECT Notes,NDate FROM Ticket_Notes WHERE TicketNo ='" + tktno.Text + "' ";
SqlCommand cmd3 = new SqlCommand(note, con);
SqlDataReader id = cmd3.ExecuteReader();
while (id.Read())
{
dnotes = id.GetValue(0).ToString();
ndate = id.GetValue(1).ToString();
description.Text = ndate + Environment.NewLine + dnotes ;
}
If i have single row in database it works fine.But if i had multiple rows with same id then it should display one after another but it is over writing on it. How to display it one after the other..
Thank u.