Ozeki不会返回其他记录

Question

我正在使用C#做一个Ozeki Messenger项目。我想从表中检索多条记录。它只返回给我第一条记录...

这是我的代码。知道我做错了什么吗伙计们？

protected void Page_Load(object sender, EventArgs e)
{
    try
    {
        String x;
        String y;
        String z;
        String SenderNumber, receiverNumber, message;
        SenderNumber = Request.QueryString.Get("sender");
        receiverNumber = Request.QueryString.Get("receiver");
        message = Request.QueryString.Get("msg");

        SqlConnection connection = new SqlConnection();
        SqlCommand command = new SqlCommand();
        SqlDataReader reader;

        connection.ConnectionString = Constring;
        command.Connection = connection;

        command.CommandText = "SELECT P_Name, P_Parking FROM tblPharmacy Where Code = '" + message + "'" ;

        connection.Open();

        reader = command.ExecuteReader();            
        String data = "";
        while (reader.Read())
        {
            x = reader["P_Name"].ToString();
            y = reader["P_Parking"].ToString();
            data += x + "  " + y + " - ";

            Response.Redirect("http://localhost:9333/ozeki?login=admin&password=xxxxxx&action=sendMessage&messagetype=SMS:TEXT&recepient=" + SenderNumber + " &messageData= " + data);
        }

        reader.Close();
        connection.Close();
    }
    catch (Exception)
    {
    }
}

Answer 1

protected void Page_Load(对象发送者，消息e) { EventArgs { String x；String y；String z；String SenderNumber，receiverNumber，message；SenderNumber =Request.QueryString.Get(“发送者”)；receiverNumber =Request.QueryString.Get(“接收者”)；message = Request.QueryString.Get("msg")；

    SqlConnection connection = new SqlConnection();
    SqlCommand command = new SqlCommand();
    SqlDataReader reader;

    connection.ConnectionString = Constring;
    command.Connection = connection;

    command.CommandText = "SELECT P_Name, P_Parking FROM tblPharmacy Where Code = '" + message + "'" ;

    connection.Open();

    reader = command.ExecuteReader();            
    String data = "";
    while (reader.Read())
    {
        x = reader["P_Name"].ToString();
        y = reader["P_Parking"].ToString();
        data += x + "  " + y + " - ";

    }

Response.Redirect("http://localhost:9333/ozeki?login=admin&password=xxxxxx&action=sendMessage&messagetype=SMS:TEXT&recepient=“+ SenderNumber +”&messageData=“+ data)；reader.Close()；connection.Close()；} catch (Exception) {}}

我自己找到了答案..LOL。Response.Redirect应该在While循环之外。它工作得很好：