<pre>
//个人测试代码
conn.Open();
string sql = string.Format("select * from ta where username like '{0}%' ",getinput);
SqlDataAdapter adapter = new SqlDataAdapter(sql,conn);
DataSet ds = new DataSet();
adapter.Fill(ds);
foreach (DataRowView drv in ds.Tables[0].DefaultView)
{
data_label.Text = "UserName:" + drv["username"] +"</br>"+ "Password:" + drv["password"] + "</br>"+" Email:" + drv["mail"];
}
conn.Close();
</pre>
页面返回总是得到最后一条数据,要求查找出全部符合的数据.
//个人测试代码
conn.Open();
string sql = string.Format("select * from ta where username like '{0}%' ",getinput);
SqlDataAdapter adapter = new SqlDataAdapter(sql,conn);
DataSet ds = new DataSet();
adapter.Fill(ds);
foreach (DataRowView drv in ds.Tables[0].DefaultView)
{
data_label.Text = "UserName:" + drv["username"] +"</br>"+ "Password:" + drv["password"] + "</br>"+" Email:" + drv["mail"];
}
conn.Close();
</pre>
页面返回总是得到最后一条数据,要求查找出全部符合的数据.