asp.net - Data rows from database are not displayed in rdlc report -


this code`

  protected void btncreatebill_click(object sender, eventargs e) {     displayreport();  } private datatable totalinfodata() {     try     {         // open sql connection           sqlconnection sqlcon = new sqlconnection(@"data source=pratikpc;initial catalog=dbbilling2.0;integrated security=true");         sqlcon.open();          // create command           sqlcommand sqlcomm = new sqlcommand();         sqlcomm.connection = sqlcon;         sqlcomm.commandtype = commandtype.text;         sqlcomm.commandtext = "select * tbltotalfee class='" + classdropdownlist.selecteditem.value + "'and studentid='" + studentnamedropdownlist.selecteditem.value+"'";          // create instance of northwind datasetxsd           dataset1.tbltotalfeedatatable totalinfodata = new dataset1.tbltotalfeedatatable();          // set data commands           sqldataadapter sqlda = new sqldataadapter(sqlcomm);         sqlda.fill(totalinfodata); // fill data in northwinddataset object.            return totalinfodata;      }      catch (exception ex)     {         throw new exception(ex.message);     } } private void displayreport() {     try     {         // clear data source            reportingforprintingreportviewer.localreport.datasources.clear();          // set datasource report            // first parameter - report dataset name           // second parameter - datasource object i.e datatable           reportingforprintingreportviewer.localreport.datasources.add(new reportdatasource("dataset1", totalinfodata()));          // or set report path           reportingforprintingreportviewer.localreport.reportpath = httpcontext.current.server.mappath("~/report.rdlc");          // refresh , display report           reportingforprintingreportviewer.localreport.refresh();     }     catch (exception ex)     {         throw new exception(ex.message);     } }

why isn't output coming in report?? there rows in database has not been returned. report looks after operation. why aren't rows being displayed?? enter image description here

this datasetenter image description here

try adding schema name before dataset name. like- schemaname_dataset1.

reportingforprintingreportviewer.localreport.datasources.add(new reportdatasource("schemaname_dataset1", totalinfodata()));

Comments

Post a Comment

Popular posts from this blog

Why does Ruby on Rails generate add a blank line to the end of a file? -

running rails generate controller foo home results in: class foocontroller < application controller def home end end (there's nothing on line in actual file, blank line) is there purpose blank line? it's common use newline indicate end of line, last line. many editors (like vi, use) add in newline silently. consensus text files (especially in unix world) should end in newline, , there have been problems historically if wasn't present. why should text files end newline? the tool used count lines in file "wc" counts newlines in file, without trailing newline show 3 instead of 4. it improves readability of templates used in generator. consider: https://github.com/rails/rails/blob/master/railties/lib/rails/generators/rails/controller/templates/controller.rb to remove trailing newline, template have last line of: end<% end -%> instead of: end <% end -%> that seems less readable me. the discussion below refers ...
Read more

keyboard - Smiles and long press feature in Android -

i've created android keyboard. how add features inserting smilies, , using long keypresses display symbols? to create long-press behavior allows select several options pop-up menu, follow guide (specifically pop-up menu section): http://developer.android.com/guide/topics/ui/menus.html smileys (also known emoticons) combination of keys, understood programs , parsed same way. have do, when clicks smiley face on keyboard, simulate pressing of key combination matching emoticon. example, when clicks smiley, should simulate key presses ':' , ')' :). here's list of emoticons: http://en.wikipedia.org/wiki/list_of_emoticons
Read more

node.js - Bad Request - node js ajax post -

i'm using express 3.0 , node v0.11.0. have button submits form , i'm using ajax post data json object node server. client code is: $('#contact').submit(function(e) { console.log('submit called'); var formdata = json.stringify($('form').serializeobject()); console.log(formdata); $.ajax({ url: "http://localhost:3000/savedata/", type: "post", datatype: 'json', data: {objectdata: formdata}, contenttype: "application/json", complete: function() { console.log('process complete'); }, success: function(data) { console.log('process sucess'); }, error: function() { console.log('process error'); }, }); return false; }); then on server: var express = require('express'); var app = express(); app.set('views', __dirname + '/views'); app.set('view engine', 'jade'); app.use(express.bodyparser());...
Read more