Asp net RDLC Report | Create RDLC Report in Asp net C# With SQL Step By Step

create rdlg report and aspirated c sharp with sql [Music] okay start visual studio click on file menu new website and visual c sharp select asp.net web form site browse the directory where now create this web application select rdlc tutorial folder click on open yes this is the rdlc report tutorial sorry backslash and name the web application create rdlc underscore tutorial yes now application is created these are the default tag and text value attributes i'm just removing all the text and i designed newly to load data from sql database to rdlc report and finally display the report in asp.net website so this highly equal to fading fading is 15 pixel yes let's check yes padding is added now go to the chores and add another deep control in this first tip in this deep tag this deep deck i will use as title of this workpiece so user info report style is font size font size large 30 pixel okay and align center okay [Music] now let's see design yes now this is looking nice now add another dig yes in this deep deck i will add a button control from the toolbox just drag the button control yes go to the design resize and design this button control the text of this button control is load report i will use this button control to load rdlc reporting asp.net pace onboard true font size is large okay now for color yes this is for color now add back color back color yes okay now this is looking nice now i'm going to add a rdlg report be your microsoft report viewer so go to the reporting expand the reporting and just drag the report viewer and drop it in asp.net webpage research that you report viewer yes now this deep tag go to the chores and make it align go to center okay design yes now this is looking nice this is revealed to you are one report with your id is devoted to your one go to the button click event and in this button click event i will write code to load a dlc report in this report viewer okay so now i'll check the exclusive data so this is server name login essay password just claudication password connect yes it's connected and database database name is programming db and table expand the table table name is user info underscore tab let's check the records these are the records scissors username addresses action data part the records in the database table okay now create a new rdls report right click click on add new item select report yes this is the report named rdlc report then i just named it user in full report click on add yes let's edit now go to the report data if you don't have default data go to the view menu and just click on report data or press ctrl alt d okay that is it i don't have any data set so first of all i'm going to create a data set new data set so go to the solution explorer right click on the solution project and click on add new item select dataset yes dataset.xsd i just named it dataset1.xsd click on yes yes the set is created yes okay now in the server explorer add sql connection server name authentication username and sql server password database name programmingdb click on ok yes it's connected expand the table just drag the user info tab and drop it in there that is it want to access the file yes user info descriptor this is data table and tabulator you can keep or you can remove table adapter okay now save and go to the rip rdlc report and now select new dataset yes the dataset name and datasource is dataset1 and data set whereas it is user info underscore tab okay it's added now design the report with the data set this is page header i just added the face header and footer you can add or you can ignore this phase header and footer now i'm just adding a header to add header add text box and that is user info report okay reset this text box make it align with center and font size font size is 16 fit okay pt and font family arial round empty bold okay now this is looking nice now i'm gonna add a table to load all the records from sql server database to rdlc report it will load from data set so user id user name address add new column to the right took two more columns yes address ace then sex data part okay it's added now design the header of this table this is back color and change the font to it onto it is bold and color i mean for color for color is for color yes requires white okay it's done now i'm gonna add a footer right click insert text box like works in footer all right some text in the in the footer text box okay text is report developed by programming geek select and make it with italic and [Music] upon bold okay it's done now save and go to the cs file first of all i'm gonna connect uh connect with sql so to connect with sql first of all add sql connection new sql connection okay now for double quotation and in this double quotation you should put the connection string add namespace is in system.data.sqlclient yes to use sql connection you should add namespace okay this is that table user info underscore tab and the column now to get connections right click on the database click on property and select the connection string coffee and paste it in the double quotation okay user id is essay first of all uh there is a error to solve this error add at the rate before connection string okay now sql command sql command c equal to new sql command mysql command is to select record all the records from sql server to be stable to rdlc report okay user info underscore tab is the table name and initializing connections think on current sql connection okay now sql data adapter sql data adapter s equal to new sql data adapter c c is sql command okay now data table data table delta will dt equal to new data table to use data table you should add new spaces in system.data just start using system.click on using system.data okay it's done now fill the s minuscule director to dt s dot field dt this position i just used to load data from specific database to uh data table now i'm gonna fill this dt to rdlc report i'm gonna load this dt to rdlt report okay it will be on localreport.cli clear initially uh datasource.clear i just cleared this report viewer initially then default data source report that is yours rds equal to new report data source resources data set 1 my data set data set 1 and dt okay now add new space using microsoft recording dot web form it's done now default viewer one dot local report dot report path report path is server dot map path copy the report name rdlc report name and faster in the map path okay my report name is user in 4e4.rdlc coffee coffee this name and paste with the double quotation yes it's done now report viewer one dot local report dot data choose dot add rds rds is report data source okay finally it would be our own dot local report dot refresh okay it's done now save and go to the default.spx right click on the page and click on view in browser load or login field for user asset this is uh check sql server connection string connection string is there a dsa password password you should put sql server password okay now right click and view in browser yes it's loading load report yes the report is loaded successfully you can see there it is the name addresses section data bars is also displaying all the records and the table are in rdls report okay now i'm gonna adding higher in sql command so higher is greater than 25 it will display that those record whose age is 25 greater than 25 yes you can see is 29 30 26 okay if you your closes in is greater than 27 then it will display only those records was uh is greater than 27 okay now i'm gonna add a text box to to load data based on the edges dynamically okay listen for edges i will put address in this text box and the records will display based on address but address i will put in this text box okay now and just end up with declaring a variable listing address equal to tablespoon.txt and then higher address equal to put single quotation then double quotation then plus sign then variable address okay it's done now save and reload this page yes put manchester lord reported as you can see the danny and catwoman slept in manchester if you put london there is only one person john in london and then oxford christina and oxford ok thanks for watching this tutorial [Music] you

Channel: ProgrammingGeek

Views: 22,121

Keywords: rdlc report in asp.net c# with sql step by step, rdlc report in c# with sql step by step, rdlc report in asp.net c#, create rdlc report in asp.net c# with sql, rdlc report in asp.net core, rdlc report in c# asp.net core, how to create rdlc report in visual studio step by step

Id: SwUt69hh3PQ

Length: 15min 3sec (903 seconds)

Published: Mon Jun 13 2022