private void Page_Load(object sender, System.EventArgs e) { listpic4.Text = show("select top 7 id,a_title,right(convert(varchar(10),a_datetime,120),5)as times from c_article order by a_datetime desc", "listpic4", "a_title"); listpic1.Text = show("select top 7 id,p_title,right(convert(varchar(10),p_datetime,120),5)as times from c_pic order by p_datetime desc", "listpic1", "p_title"); listpic2.Text = show("select top 7 id,a_title,right(convert(varchar(10),a_datetime,120),5)as times from c_article order by a_datetime desc", "listpic2", "a_title"); listpic3.Text = show("select top 7 id,p_title,right(convert(varchar(10),p_datetime,120),5)as times from c_pic order by p_datetime desc", "listpic3", "p_title"); } protected static SqlDataReader reDatareader(string Sql) { SqlConnection conns = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnStr"]); conns.Open(); SqlCommand cmd = new SqlCommand(Sql, conns); SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); return dr; }public string show(string Sql,string labelname,string colnumname) { SqlDataReader huadong = reDatareader(Sql);
Dictionary<string, string> dic = new Dictionary<string, string>();
foreach(var item in dic)
{
Literal ltl = this.FindControl(item.Key) as Literal;
if (ltl != null)
{
ltl.Text = //这里写用item.Value进行SQL操作对ltl赋值
}
}
是列出前7条数据不是一条,我是想通过传参,把不同的sql传递进去取数据
这样就不用重复写代码
private void Page_Load(object sender, System.EventArgs e)
{
listpic4.Text = show("select top 7 id,a_title,right(convert(varchar(10),a_datetime,120),5)as times from c_article order by a_datetime desc", "listpic4", "a_title");
listpic1.Text = show("select top 7 id,p_title,right(convert(varchar(10),p_datetime,120),5)as times from c_pic order by p_datetime desc", "listpic1", "p_title");
listpic2.Text = show("select top 7 id,a_title,right(convert(varchar(10),a_datetime,120),5)as times from c_article order by a_datetime desc", "listpic2", "a_title");
listpic3.Text = show("select top 7 id,p_title,right(convert(varchar(10),p_datetime,120),5)as times from c_pic order by p_datetime desc", "listpic3", "p_title");
}
protected static SqlDataReader reDatareader(string Sql)
{
SqlConnection conns = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnStr"]);
conns.Open();
SqlCommand cmd = new SqlCommand(Sql, conns);
SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
return dr;
}public string show(string Sql,string labelname,string colnumname)
{
SqlDataReader huadong = reDatareader(Sql);
while (huadong.Read())
{
labelname = "<li><div class='text002'><div class='span_left'><a href='#'>" + huadong[colnumname] + "</a></div><div class='span_right'>" + huadong["times"] + "</div></div></li>";
}
return labelname;
}我这样做只能返回第一条数据,不能读取到7条各位大哥帮忙看看啊
{
while(dr.Read)
{
................
}
}