我想把库里的数据都读出来,可它就只读一条数据SqlDataAdapter sdr=new SqlDataAdapter();
sdr.SelectCommand=new SqlCommand("select * from testweb order by id desc",conPubs);
DataSet ds= new DataSet();
sdr.Fill(ds,"emp"); for(int i=0;i<ds.Tables[0].Rows.Count;i++)
{
MsgList.Text = ""+ds.Tables["emp"].Rows[i]["title"].ToString()+"";
break;
}
sdr.SelectCommand=new SqlCommand("select * from testweb order by id desc",conPubs);
DataSet ds= new DataSet();
sdr.Fill(ds,"emp"); for(int i=0;i<ds.Tables[0].Rows.Count;i++)
{
MsgList.Text = ""+ds.Tables["emp"].Rows[i]["title"].ToString()+"";
break;
}
去掉,你break了还循环啊
{
MsgList.Text = MsgList.Text + ""+ds.Tables[0].Rows[i]["title"].ToString()+"";
}
改成
for(int i=0;i<ds.Tables["emp"].Rows.Count;i++)
不知道lz是不是想这意思...
MsgList.Text += ""+ds.Tables["emp"].Rows[i]["title"].ToString()+""+"<br>";