62,046
社区成员
发帖
与我相关
我的任务
分享
//DBHlper类的方法
public static DataSet GetDataSet(string sql)
{
DataSet ds = new DataSet();
try
{
OpenConn();
SqlCommand cmd = CreateCmd(sql);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
return ds;
}
catch (Exception ex)
{
throw ex;
}
finally {
CloseConn();
}
}
//----------------------------------------------------------
/// <summary>
/// 所有服务器信息
/// </summary>
/// <returns></returns>
public static List<ServerInfo> GetAllServers()
{
ServerInfo server = null;
string sql = "select ServerName,OtherInfo,About,Feature,Url from ServerInfo";
List<ServerInfo> listServer = new List<ServerInfo>();
DataTable dt = DBHeler.GetDataSet(sql).Tables[0];
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dt.Rows[i];
server = new ServerInfo();
server.SID = Convert.ToInt32(dr["SID"]);
server.ServerName = (string)dr["ServerName"];
server.OtherInfo = (string)dr["OtherInfo"];
server.Feature = (string)dr["Feature"];
server.Url=(string)dr["Url"];
server.About = (string)dr["About"];
listServer.Add(server);
}
}
return listServer;
}
//用这个测试下,删除数据!
if (DBHeler.GetDataSet(sql).Tables[0] != null)
{
DBHeler.GetDataSet(sql).Tables[0].Clear();
}
DataTable dt = DBHeler.GetDataSet(sql).Tables[0];//重新获取
//另外,检查下你的实体类是否包含[BeginTime这个字段属性]
//再则,如果你页面不想要其余的列,你可以用模板列绑定需要的列<%# Eval("BeginTime")%>
protected void btnShow_OnClick(object o,EventArgs e)
{
if (Cache.Count > 0)
{
lblShow.Text = "Cache Is Full!";
}
else
{
lblShow.Text = "Cache Is 0";
}
}
//结果没有缓存,我早已经想到这步了
this.gv1.DataSourseID=null;//一定要清空下数据源
this.gv1.DataSourse=listServer///这个是你查询的数据源
this.gv1.DataBind();//绑定
//楼上的这个方法没用!