c#任何把数据库的多条消息一次性读取完呢？
////////连接数据库///////////
string ysip="192.168.0.4";
string yssjk="mdb";
string ysuid="gen";
string yspwd = "123012300";
String sql = @"Data Source='" + ysip + "';database='" + yssjk+ "';uid='" + ysuid + "';pwd='" + yspwd + "';";
SqlConnection conn = new SqlConnection(sql);
conn.Open();
string cx = "select top(50) * from chat where postpd='"+xxpd.Text+"' order by postsj desc";
SqlCommand cmd = new SqlCommand(cx, conn);
SqlDataReader sdr = cmd.ExecuteReader();
if (sdr.Read())
{
xs.Text += string.Format(sdr["postnc"].ToString().Trim() + "(" + sdr["postname"].ToString().Trim() + ")" + sdr["postsj"].ToString().Trim() + "\r" + sdr["postnr"].ToString().Trim())+"\r\n";
sdr.Close();
conn.Close();
}


xs.Text 的类型是 richtexibox

现在只能读取一条。。。

[解决办法]
修改如下

C# code

while(sdr.Read())  {  xs.Text += string.Format(sdr["postnc"].ToString().Trim() + "(" + sdr["postname"].ToString().Trim() + ")" + sdr["postsj"].ToString().Trim() + "\r" + sdr["postnr"].ToString().Trim())+"\r\n";    }sdr.Close();  conn.Close();