how to add image and display in crystal report dynamically in c#. part 5

hello guys in this video I'll show how to add is and display me from the local Drive to Crystal reported the situation is for application [Music] when the service forward this is the data will be first DB explained the table folder my included this table column Carano me speak the data division worker 150 ok show the table data there are many better in this table and this is the pixel name in the database column the peaks are exist in the z-type folder name is a files fixer exists in the GJ folder name is file and 1 to 7 feet already available now I'm going to show you how to display the image from the local tribe to distill report and see our application just such thing and I'm sure showing these are the in use for application and I am going to expand it to Crystal Putin and when a year add a new record IDs John at is 8 named John address Canada is 33 I just choose a fixer this fixer I will add see that it's already added say that in the jitta that location also the fixer is added now just a replace the record see that the 8 John can add a load he added he says also first of all to stop debugging he says the form you can also add in the different form but we still to put in the deep and form people to you I am just showing in same form instantly these are the critical to be here I just take it from the toolbox group routine on because I don't need group tonight now you know if I will add in there this childhood that's way okay go to the solution Explorer I'll have new item right click on add new item crystal report see the lab site reporting select reporting and then select crystal report name by Crystal report I just named it as display info I was asking the head button okay now I explained the connection I have connected it first the trip okay expand the table my info tab just because arrow next next finish okay Mike reboot already created now I'm going to add column by drag and drop on the field Explorer if the filters were not available in the in the lab said go to the view and at the field Explorer okay drag the ID column and name and address and ace [Music] okay insert a text object text object the to define the column name first of all what I added first this is the bedroom now it is the name of this column ID name address age okay bolt reset the text display excellently okay I just designed to not show far fit all that history put Tudor from the beginner to an expert level and they're in these playlists okay I'm going to add a picture I right click on the picture for a format object click on the picture menu then click graphic location just click on the picture menu graphic location our graphic location I mean pixels location is G files I just coffee G well master probably use a single petition okay then right there location G files okay now close the single quotation and expand double click my input a fig already added just click on the ok button ok save then now go to the click even button click even hi and I click on the button control it will display the report in there this is the existing code this code will display in there is no application now I will write the code to display in the crystal report viewer I just perfected releasing time this is the this is the my connection string I just copied pasted my crystal report name is display info I have created and I have displayed you first they display info crystal report is report name is displaying through and my connection listing is would they have to be going to equal to see the connection my condition is thing is my forte is cutting my instinct - okay just paste it here okay I stood it and I'm gonna write the code string first you coffee and faced SQL select a star for my row higher ID in decided I wonder texture which ID I would put in the text box one dot text that I did speak sir will display in their report and in stamp land in my window small creation now declare a data set and that adapter and field that field the data set in that adapter okay see the data set BS dead adapter SQL is MySQL query corn is connection okay and I have filled it in adapter filled es mi info and data source I have declared my info tab this is my table name now history put dua what I what I took from the toolbox history would be our honor to purchase equal to CL you said we wonder replace okay this is the discipline from the report name what I already mentioned report name now just debug okay ID one sirs oh sorry it it's an error maybe it will be the location problem location error I have to mention it perfectly the location see right click format object click on the fixer go to the graphic location oh yes there I forget to put backslash okay because after backslash it will perfect now seven close okay save and debug again okay now I think it will display perfectly Wow super excellent now it's okay see that six six images displayed the images that would be the trades not so perfectly the seven picture is be sure okay and I again show you the graphic location G files backslash rotation and person and my improve technique this is the database column [Music]

Channel: Swift Learn

Views: 67,687

Keywords: how to add image in crystal report in c#, add image in crystal report, add image in crystal report c#, how to add image in crystal report from database, display image in crystal report from database in c#, display image in crystal report from database, crystal report, crystal report dynamically, swift learn, crystal report in c# windows application, crystal report image from database, crystal report images, crystal report image from path, visual studio code

Id: LXCzSqck1Pw

Length: 8min 13sec (493 seconds)

Published: Sun Mar 04 2018