好家伙,
我已经在我的ASP.NET网页的下拉控件,我从数据库中检索数据填充下拉控件,每个页面加载事件后的数据重新绑定一次,从而增加在下拉控制,这是没有什么ListItem的我想,我只是希望它绑定一次。
这里是代码?
问题是,,在lblError.Text的文本不显示时,读者返回false。
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;
}
}
}
谢谢你们