这代码该怎么写？？？

sdudubing 2012-03-14 09:32:56

sql = "select userid,moterid,username from userprofile where line='" + strUser + "' order by userid "; //设置SQL语句
SqlConnection con = dataOperate.createCon();
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
sql = "select top 1 * from singlemoter where datetime>='" + startDate + " 00:00" + "'and datetime<='" + endDate + " 23:59" + "'and userid='" + rd["userid"].ToString() + "' and moterid='" + rd["moterid"].ToString() + "' order by datetime desc"; //设置SQL语句
MonthsElectricityNumber.DataSource = dataOperate.getDataset(sql, "singlemoter"); //获取数据
MonthsElectricityNumber.DataBind();
}
这代码有个问题，就是最后只能显示一个userid（第一句查出的条目中最后一条），我现在想将所有数据都显示出来，该怎么写？？？

...全文

85 11 打赏收藏转发到动态举报

写回复

用AI写文章

11 条回复

切换为时间正序

请发表友善的回复…

发表回复

army369168520 2012-03-14

打赏
举报

select * from table where 1==1

Venssi_楠楠 2012-03-14

打赏
举报

繁體字是牛逼·

船员 2012-03-14

打赏
举报

我上面寫的好像不對,不過意思對的,你按照我那個代碼改一改就可以.

船员 2012-03-14

打赏
举报

給你改一下:



 //取得區域列表

        public static DataSet QueryInfo()

        {

           string sql=" select top 1 b.* from (select userid,moterid from userprofile where line='" + strUser + "' order by userid)a,singlemoter b where b.datetime>='" + startDate + " 00:00" + "'and b.datetime<='" + endDate + " 23:59" + "'and a.userid=b.userid and a.moterid=b.moterid order by b.datetime desc";



            SqlConnection con = dataOperate.createCon();

            con.Open();

            SqlDataAdapter dad = new SqlDataAdapter(sql, con);



            DataSet dst = new DataSet();



            try

            {

                con.Open();



                dad.Fill(dst, "QueryInfo");

            }

            catch (SqlException e)

            {

                // Handle exception.

                throw new Exception(e.Message);

            }

            finally

            {

                con.Close();

            }



            return dst;

        }