Assalamualaykum wr br
I was working with migration of crystal reports to SSRS. There are much differences in these two reporting strategies which I am going to focus here.
1. Crystal report would have report header and report footer which displayed on whole report. In addition to it page header and footer does have.
2. SSRS would have only page header and footer which will be displayed on every page. SSRS page header and footer works like report header and footer.
3. To have page header in SSRS report we need to perform some actions which are as follows:
Select a column header, at below there is a columns table with drop down click it which shows advance view,click it which displays static headers next to it. Click the static and press f4 key which displays properties of tablix member there at last a property repeat on every page set it to true and select after option.
Assalamualaykum Wr Br…today we explore the asp.net’s powerful control to display data as in tabular format with built-in Edit, Update, Cancel and Insert options, named as GRIDVIEW. The general syntax of markup is as shown:
<asp:GridView ID=”gridview1″ runat=”server”>
This gridview will not display data because it has not datasource and databind method is called.
Assalamualikum wr br.
Today we discuss about one requirement where data needs to be displayed in GridView from table abc which has more than 2,66,000 records. This was coded to fetch data using DataAdapter on page_load event later it was done pagination from memory using GridView pagination. Later it was reported that memory leakage encountered and pagination is not responding.
Hence it was suggested to retrieve data on demand which means based on page index of gridview, no. of records needs to be fetched from data table.
Also most interesting point is Oracle 11g is being used which does not support Fetch and Limit keywords.
Fetch is used to limit the result set generated from the query. Since we use 11g we need to modify the existing query as below:
|Select * from
( Select p.record_type,
from abc) p
where rownum <= 50 <max_limit>)
where rm >= 10 <min_limit>;
With the help of above modifications I can able to retrieve the records in table data between max_limit and min_limit. Otherwise the rownum would return from records 1 to specified constraint.
That’s all for the day.
Jazakallah khair..Happy Programming..:)
Assalamualaykum wr br..:
Today we discuss what EF is..?
EF is ORM framework. ORM -> Object Relational Mapping. ORM automatically creates classes based on Database tables, and vice versa is also true. ie. it can also automatically generate SQL to create database tables based on classes.
Lets start a small project on it to understand better. To achieve it,
1. Create Department and Employee Classes.
2. Write ADO.Net code to retrieve data from the database.
3. Need to create objects of Department and classes to populate data.
Entity Framework can do all the above statements automatically , if we provide it with database shema.
Create the Database and tables as shown below:
Now add the Ado.net Entity Data Model and name it as EmployeeModel.edmx file and this results in wizard, supply the necessary values and finish.
compile the solution and add new webform in which add gridveiw and entity datasource control and then configure the Entity datasource with database and tables of employee and department and allow it to generate from database.
Thats it for the day..also please have a look on the versions of EF.
The following table lists all the important versions of Entity Framework.
||Basic O/RM support with Database First approach.
||POCO Support, Lazy loading, testability improvements, customizable code generation and the Model First approach.
||First to available in the NuGet, Simplified DBContext API over ObjectContext, Code First approach. EF 4.1.1 patch released with bug fixing of 4.1.
||Code First Migrations feature that allows a database created by Code First to be incrementally changed as your Code First model evolves. EF 4.3.1 patch released with bug fixing of EF 4.3.
||Announced EF as Open Source. Introduced Enum support, table-valued functions, spatial data types, multiple-diagrams per model, coloring of shapes on the design surface and batch import of stored procedures, EF Power Tools and various performance improvements.
|EF 6.0 – Current release
||EF 6.0/6.1 is the latest release of Entity Framework. It includes many new features related to Code First & EF designer like asynchronous query & save, connection Resiliency, dependency resolution etc.
Assalamualaykum wr br..:)
Today we are discuss about the code first approach of EF where code is designed based on which database is generated with tables and keys.
Lets quick start with web application. Create New Project -> WebSite -> <NameApp>.
Create the two classes in separate files Employee and Department also add two more classes with names as EmployeeDBContext.cs and EmployeeRepository.cs as shown
Code the Employee class as shown below. Every Employee is associated with Department hence it is defined using Department property whose return type is Department and as it is available in both tables(Classes) hence it is referenced as Navigation Properties and remaining properties like Id, Firstname, secondname etc are Static Properties.
Now code the Department class as below. Every Department have Id, Name which will be Static Properties and each department holds multiple employees for which list is considered with return type as employee which is navigation properties.
Now lets create EmployeeDBContext.cs class where we create datasets of tables to populate the data as applicable.
To fetch and operate on tables data we need to have one generic class which is referred to as EmployeeRepository.cs as shown below. It has one Get method which populates the department class data and returns.
Finally add new Webform.aspx and drag and drop grid view control and also datasource control as shown below. Before you add webform compile your project to let EF create dlls which is used to reference in datasource control. In above image of employeerepository class we see Include(“Employees”). This Include method used to display Navigation Properties where in Department table Employees is the Navigation Property.
Thats it for the Day..:) Jazakallah khair