How to Create Crystal Reports in Visual Studio 2015 in Asp.net c# with SQL | swift learn

welcome to my channel so from this tutorial I will show you how to create crystal report in Wizards 2015 with higher Claus using asp.net c-sharp if you don't subscribe my channel yet please subscribe and press the bell icon for upcoming videos the SQL Server database is my test levy and in the table and these are the records in the database table start with your the studio now click on file menu click on new website select the location where you wanna create this website the website name is crystal deep for tutorials 2015 click on yes now click OK the website is created this is the default text in the stream of this text and in this page I will display how to load a crystal report how to create this the report in visual is 2015 using a speed or not C sharp ok heading is crystal report tutorial in visualize 2015 add a deep tag in this deep Jack I will add a button ctrl + I add a bottom control from the toolbox just a drag and drop yes this is the button here the design yes now I change the text of this buttons button text is a load report in this button I will use to load crystal report in a speed on pace for color is white and font bold true yes now this looking nice now I'm gonna add a crystal report beaver from the toolbox yes this is the crystal report view are just a drag-and-drop yes now in the button click event I'll write code to load crystal report okay now add new item in the solution add new item select work form now select crystal report yes name this report this is the default name crystal report I just renamed it in the crystal report test yes using the report you just allowed to click OK and get new connection expand the validity Microsoft already provided for SQL Server next select the server my server name is catalog as Pierre he's already SNS word is this is my password would your password SQL Server password and the database is my task DB next finish yes now it's connected with my tasks to be and this is the table student info tab okay now this table is added ok the default text I just removed from the report and now I'm going to add a text object as heading heading is a student info report ok now change the making bold yes expand the database field and eyes from the student info tab drag the column student ID in a details section of the external report student name address age and contact now add line vertically to design this report so that it will look like a table to make this table I look like table just add a line and design with their line caja line yes these are the line objects now add line horizontally and coffee this line and paste in each column each like a student ID name address age and contact now go to the PPO yes now it's look like table ok now put the button click event in this bottle click event I will connect to the SQL Server database and I read code to display a crystal report in the hospital network form crystal report viewer ok SQL connection corn equal to new SQL connection add namespaces in system to dotted SQL client yes the name of space is added now SQL command has kill command CMD equal to new SQL command at double quotation and initiate the Conn yes now to connect SQL server go to the server Explorer first of all I have to add connection all right click add connection catalog as beer as possible indication is your name and password password is my password if you use Windows authentication you can use ok my test DVDs the database and the table is student info tab ok now select star from student info tab and to get the conditional sting right-click on the database and serve Explorer click on property this is the connection testing double click to coffee and fest in the SQL connection ok now it's connected in their SQL Server database SQL dated after SDA equal to new SQL data adapter called C MD okay now data data set that is it D is equal to new dead is it animal space using system dot data okay then I my space is added as using system dot data now as da dot fill D s I mean a spell data adapter filling the D s that is it finally report document CR P equal to new we put document at namespace this is a crystal report engine yes namespace is added now CR P dot load c @ p dot loads harbored or my path my path is my crystal report name my crystal good name is crystal report a star on dot r PT yes finally CLP dot said that yours my datasources D s dot tables table is table okay now finally crystal it would be your what I added in there I ask you does not work palm is still it would be your wand Autry put yours equal to CRP CRP dot export to HTTP response we should use expertise to be response in a message 2015 okay now that namespace crystal did my decisions not sheared okay now CF e dot export HTTP response export format type dot portable doc format response C in the suggestions' response false as a testament false and a dustman name comentary still report name is a student information ok now go to the view in browser yes load report system will turn on login field for user yes I have to check the connection string I go to the car CS file and check the connection string oh sorry I have to put my password here I just put in my password so let's reload this pace yes there's lordy Lord report yes in displaying all the records from the SQL Server database look this tilde for beaver adding higher clothes now I just displaying all the records but now I will display using higher clothes I mean specific clothes so first of all I'll add her plus to add her plus I will add text box to load data according to the text box text in that case is Ching chk equal to type of sound or text and her ir e address I will mention address and after after executing it will display that information those are external information which addresses as far the test box or does not exist I have to save the webform save save all yes now reload the space hmm address addresses us a loud report we display all the data which addresses USA now Canada load report displaying only that record which addresses Canada okay now I'm gonna just this uh address two E's I mean is greater than chk-chk is now extinct so ages integer so change is 200 a type you to integer and convert the text or is integer integer dot first of all so on door text okay now now I'll display those records which age is greater than 30 yes 35 40 35 55 okay now Jane is 35 yes now it's decreased 40 and 55 only you

Channel: Swift Learn

Views: 41,195

Keywords: swift learn, how to create crystal reports in visual studio 2015 asp.net c#, crystal report tutorial for beginners visual studio 2015, how to create crystal report in asp.net c# using sql server, how to create crystal report 2015 in c#.net, how to use crystal report in visual studio 2015 c#, create crystal report, crystal reports, visual studio code, how to, crystal report in visual studio 2015, crystal reports in asp.net c#, asp.net crystal report

Id: Ys2MfQHPQ88

Length: 10min 43sec (643 seconds)

Published: Mon Jul 20 2020