Question

asp.net datalist控件数据绑定能用嵌套查询吗？

void bindgrid2()
{
string sqlconnstr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
DataSet ds = new DataSet();
using (SqlConnection sqlconn = new SqlConnection(sqlconnstr))
{
SqlDataAdapter sqld = new SqlDataAdapter("select * from Dynamic where focus in(select focus from Focus where id='" + s + "')order by time desc", sqlconn);
sqld.Fill(ds, "tabSpeech");
}
DataList2.DataSource = ds.Tables["tabDynamic"].DefaultView;
DataList2.DataBind();
}
编译没错误,但在datalist里面绑定数据的控件显示不出数据.

Answer 1

where id='" + s + "',你定义的字段id是int还是nvarchar,如果是int where id=1;如果是nvarchar where id='1';可以去数据库建个查询看一个，把sql语句复制进去，看看数据是否显示出来了