返回首页

好家伙,

我已经在我的ASP.NET网页的下拉控件,我从数据库中检索数据填充下拉控件,每个页面加载事件后的数据重新绑定一次,从而增加在下拉控制,这是没有什么ListItem的我想,我只是希望它绑定一次。

这里是代码?


 protected void GetSVNumber(string vNumber)

    {

        SqlDataReader vreader = null;

        string vString = "SELECT ResponseDateTime FROM GpsResponseData WHERE SendersPhone = @senderphone";

        using (SqlConnection vconnection = new SqlConnection(GetConnectionString()))

        {

            SqlCommand vcommand = new SqlCommand(vString, vconnection);

            SqlParameter vParam = new SqlParameter("@senderphone", vNumber);

            vcommand.Parameters.Add(vParam);

            vcommand.CommandType = CommandType.Text;

            try

            {

                if (vconnection.State == ConnectionState.Open)

                {

                    vconnection.Close();

                }

                else

                {

                    vconnection.Open();

                    vreader = vcommand.ExecuteReader();

                    while (vreader.Read())

                    {

                        if (vreader.HasRows)

                        {

                            DateTime vResult = vreader.GetDateTime(0);

                            ddVehicleGpsTime.Items.Add(vResult.ToString());

                        }

                        else

                        {

                        lblError.Text = "The selected vehicle does not have any GPS data retreived for today";

                        }

                    }

                }

            }

            catch (SqlException vsqlex)

            {

                lblError.Text = vsqlex.Message;

            }

        }

    }

问题是,,在lblError.Text的文本不显示时,读者返回false。

谢谢你们

回答

评论会员: 时间:2