01 2010 档案

dataset 多表查询
摘要: string citysql = "select * from soncity;select * from partytype"; ds= DbHelperSQL.Query(citysql); s1.DataSource = ds.Tables[0].DefaultView; s1.DataTextField = "sonname"; s1.DataBind(); s2.DataSource =...阅读全文
posted @ 2010-01-11 11:30 liuwei0214 阅读(273) | 评论 (0) 编辑
dropdownlist绑定数据
摘要: （1） string SQL_Select = "select id, ItemName from DDLItem order by id desc"; //构造一个SqlDataAdapter SqlDataAdapter myAdapter = new SqlDataAdapter( SQL_Select, Conn); //开始读取数据 Conn.Open(); DataSet dataSe...阅读全文
posted @ 2010-01-11 11:14 liuwei0214 阅读(633) | 评论 (0) 编辑
后台控制输出table（有数据库）
摘要: pid = Session["pid"].ToString(); uid = Session.SessionID.ToString(); // uid = Session["userid"].ToString(); string sql1 = "userid='" + uid + "'"; DataSet ds=bll.GetList(sql1); test = "<table>&l...阅读全文
posted @ 2010-01-08 16:12 liuwei0214 阅读(62) | 评论 (2) 编辑