It sounds silly!! but i can't figure out how to get the data to the report viewer from the dataset that i have created in c#. because my dataset is dynamic and the columns would vary every time when i load into the report viewer. i read thru most of the articles but was unable to figure houw to work this out.
the data set for eg i created is:-
private DataSet getDataSet()
string sql = "";
sql += "SELECT * FROM TABLE WHERE NAME='JOHN SMITH'";
OdbcDataAdapter adptr = new OdbcDataAdapter(sql, _connection);
DataSet ds = new DataSet();
and from this dataset i have to create the report viewer. this is created in cs page of the aspx page where the report viewer is. also i have a blank report.rdlc. please help me thru this...
thanks in advance..
View Complete Post