Question

C#reportviewer如何显示sql语句查询的值

public DataTable queryToDatatable(string sqlCondition)
{
SqlDataAdapter sda;
DataSet ds = new DataSet();
sda = new SqlDataAdapter(sqlCondition, conne);
sda.Fill(ds);
DataTable dt = ds.Tables[0];
return dt;
}
private void Form1_Load(object sender, EventArgs e)
{
this.reportViewer1.LocalReport.DataSources.Clear();
conne.Open();
string sql = "select *from dbo.SL_lipei where xxx='" + no + "'";
this.reportViewer1.RefreshReport();
conne.Close();
}
到这里就不知道怎么写了
或者说我的写法根本就不对，一般绑定textboxx.Text = queryToDatatable(sql).Rows[0]["XXX"].ToString();就可以绑定，我连textboxx都没弹出来

Answer 1

this.reportViewer1.LocalReport.DataSources.Clear();
this.reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("DataSet1", ds.Tables[0]));
reportViewer1.RefreshReport();

Answer 2

能补充一下么 想用什么 做一个什么 还是只是想绑定 reportviewer1