Microsoft .net and SqlServer

Quartz.NET

2025-02-13T09:21:00.000+05:30

Quartz.NET is a widely used and popular open-source scheduling framework. It allows you to schedule thousands of complex jobs with ease.

Typically, when developing scheduling-based applications in .NET, the Timer feature is used. However, Timer has limitations—it does not support scheduling jobs based on a specific month, day, or year. Additionally, it lacks a persistence mechanism and does not utilize the thread pool.

With Quartz.NET, each job can be assigned to a specific thread, providing greater flexibility and efficiency. The following example demonstrates how to use Quartz.NET in a .NET application. For this demonstration, I am using Visual Studio 2010.

Steps:

1. Download the Quartz.NET dll of Quartz.NET 2.0 beta 1 from the following link http://sourceforge.net/projects/quartznet/files/quartznet/

2. Created a Console application.

3. Add the refernce of Common.Logging.dll and Quartz.dll to the application from the downloaded folder Quartz.NET-2.0-beta1\bin\4.0\release\Quartz.

4. Add the app.config file and add the following configuration.

</configSections>

</startup>

</configuration>

5. Add the following code in the Main() function.

static void Main(string[] args)

{

ISchedulerFactory obSchedulerFactory = new StdSchedulerFactory();

IScheduler obIScheduler = obSchedulerFactory.GetScheduler();

DateTimeOffset runTime = DateBuilder.EvenSecondDateAfterNow();

IJobDetail job = JobBuilder.Create<MYJob>()

.WithIdentity("job1", "group1")

.Build();

ITrigger trigger = TriggerBuilder.Create()

.WithIdentity("trigger1", "group1")

.StartAt(runTime)

.EndAt(runTime.AddMinutes(1))

.WithCronSchedule("0/5 * * * * ?")

.Build();

obIScheduler.ScheduleJob(job, trigger);

obIScheduler.Start();

}

6. Creat a MyJob class.

public class MYJob : IJob

{

public MYJob()

{

}

public virtual void Execute(IJobExecutionContext context)

{

Console.WriteLine(string.Format("My Job! - {0}", System.DateTime.Now.ToString("r")));

}

7. Open the property of the application and select the Target Framework to .NET Framework 4 from .NET Framework 4 Client Profile.

8. Run the application. The output will be as follow

My Job! - Mon, 02 Apr 2012 12:16:10 GMT

My Job! - Mon, 02 Apr 2012 12:16:15 GMT

My Job! - Mon, 02 Apr 2012 12:16:20 GMT

My Job! - Mon, 02 Apr 2012 12:16:25 GMT

The Execute() function of the MyJob class will run in each 5 second, since we had set the shedular for 5 second.

There are 3 main component of the Quartz.NET : Trigger, Scheduler and Jobs.

Jobs: Job is an executable task, which is sheduled and trigger in a regular interval. To specify the executable task, you have to inherit the IJob Interface and implement the Execute() function. This Execute() method will be called in each interval. In this example, I have used MYJob class and inherited the IJob interface. In the Main() function I have created the instance of IJobDetail instance with the identity name "job1" and group name "group1" and specified the MyJob class to be called.

Trigger: Trigger refers the start, end and sheduler interval for the job. Here I have created the instance of ITrigger instance with the identity name "trigger1" and group name "group1". The group name for both the job and trigger should be same, so that it can identify that which job is used for which shedule when there are more than one job and trigger. Here I have set the StartAt() to the current datetime and EndAt() after the one minute of current time. The expression "0/5 * * * * ?" specifies the Crone experession, which is used to tell the sheduling time. Here I 0/5 specify that this job will be executing in each 5 second.

Cron Expressions Allowed Fields and Values

Name	Required	Allowed Values	Allowed Special Characters
Seconds	Y	0-59	, - * /
Minutes	Y	0-59	, - * /
Hours	Y	0-23	, - * /
Day of month	Y	1-31	, - * ? / L W C
Month	Y	0-11 or JAN-DEC	, - * /
Day of week	Y	1-7 or SUN-SAT	, - * ? / L C #
Year	N	empty or 1970-2099	, - * /

Cron Expressions

Cron expressions can be as simple as * * * * ? * or as complex as 0 0/5 14,18,3-39,52 ? JAN,MAR,SEP MON-FRI 2002-2010.

Here are some more examples:

Expression	Means
0 0 12 * * ?	Fire at 12:00 PM (noon) every day
0 15 10 ? * *	Fire at 10:15 AM every day
0 15 10 * * ?	Fire at 10:15 AM every day
0 15 10 * * ? *	Fire at 10:15 AM every day
0 15 10 * * ? 2005	Fire at 10:15 AM every day during the year 2005
0 * 14 * * ?	Fire every minute starting at 2:00 PM and ending at 2:59 PM, every day
0 0/5 14 * * ?	Fire every 5 minutes starting at 2:00 PM and ending at 2:55 PM, every day
0 0/5 14,18 * * ?	Fire every 5 minutes starting at 2:00 PM and ending at 2:55 PM, AND fire every 5 minutes starting at 6:00 PM and ending at 6:55 PM, every day
0 0-5 14 * * ?	Fire every minute starting at 2:00 PM and ending at 2:05 PM, every day
0 10,44 14 ? 3 WED	Fire at 2:10 PM and at 2:44 PM every Wednesday in the month of March
0 15 10 ? * MON-FRI	Fire at 10:15 AM every Monday, Tuesday, Wednesday, Thursday and Friday
0 15 10 15 * ?	Fire at 10:15 AM on the 15th day of every month
0 15 10 L * ?	Fire at 10:15 AM on the last day of every month
0 15 10 ? * 6L	Fire at 10:15 AM on the last Friday of every month
0 15 10 ? * 6L	Fire at 10:15 AM on the last Friday of every month
0 15 10 ? * 6L 2002-2005	Fire at 10:15 AM on every last friday of every month during the years 2002, 2003, 2004, and 2005
0 15 10 ? * 6#3	Fire at 10:15 AM on the third Friday of every month
0 0 12 1/5 * ?	Fire at 12 PM (noon) every 5 days every month, starting on the first day of the month
0 11 11 11 11 ?	Fire every November 11 at 11:11 AM

Sheduler: Sheduler is used to grouped the job and trigger both in a group and start and end the sheduling. Here I have created the instance of ISheduler and grouped both the job and trigger and then started the sheduler.
Download:

Part 2 : How to use log4net in .net

2012-03-22T12:58:00.011+05:30

In Part 1 : How to use log4net in .net you have learnt the basic of log4net. Here I am going to tell you some more details about it.

Create Date based log file

Yes, you can also create your log files date vise. If you want to create a separate file for every day then you can also do that in the log4net. You need to set the <staticLogFileName value="false">

in the appender.

The appender section will be

</layout>

</appender>

Here the value of the file section specify the path of the log file. I have specify the "D:\ "then the file will be created in the "D" drive. If you specify the "d:\log_" then the log file will be "log_2012-03-22.log".

Create separate log file for specified log level

Here I would like to let you know how you can log the information according to their log level (Debug, Info, Warning, Error, Fatal) in different files. For example, if you want to log Debug log into a file and Error log to another file, you can achieve this through the log4net. For that you just have to add the two appender according to their log level. Each appender will have different log file.

 <appender name="ErrorLogFileAppender" type="log4net.Appender.FileAppender">
  <param name="File"value="D:\ErrorLogFile.txt"/>
  <param name="AppendToFile" value="true"/>
  <layout type="log4net.Layout.PatternLayout">
    <param name="ConversionPattern" value="%d [%t] %-5p %c %m%n"/>
  </layout>
  <filter type="log4net.Filter.LevelMatchFilter">
    <levelToMatch value="ERROR"/>
  </filter> 
  <filter type="log4net.Filter.DenyAllFilter" />
</appender>

   
<appender name="DebugLogFileAppender" type="log4net.Appender.FileAppender">
  <param name="File" value="D:\DebugLogFile.txt"/>
  <param name="AppendToFile" value="true"/>
  <layout type="log4net.Layout.PatternLayout">
    <param name="ConversionPattern" value="%d [%t] %-5p %c %m%n"/>
  </layout>
  <filter type="log4net.Filter.LevelMatchFilter">
    <levelToMatch value="DEBUG"/>
  </filter>
  <filter type="log4net.Filter.DenyAllFilter" />
</appender>
<root>
  <level value="ALL"/>
  <appender-ref ref="DebugLogFileAppender" />
  <appender-ref ref="ErrorLogFileAppender" />
</root>

Here I have created two appender ErrorLogFileAppender and DebugLogFileAppender. ErrorLogFileAppender logs the Error level log and store the log information into the ErrorLogFile.txt and DebugLogFileAppender logs the Debug log and store the log information into the DebugLogFile.txt.

Appenders

We can log the information into differenct destination output through the Appender. In Previous examples we have seen the FileAppender which is used to log the information into a file. However, log4net provides numbers of Appenders to log the information, you can customized as per your need.

FileAppender

See the previous examples.

SmtpAppender

SmtpAppender is used when you want to get the specified event log through the email. The following example will show how to use the SmtpAppender.

</layout>

</appender>

Here to specifies the address where log event should be send. The from is the address from which account email should be send. The subject specifies the subject of the email. You can also customise this subject. The bufferSize specifies the size of the email. As soon as log event information reached that size, it sends the email.

Here I have customised the subject. The HostName and appdomain represents the your host name and application domain of your application.

In the above appender all the log events will be sent to the specified email address, however you can also mentioned which log event you want in email. For that you have to use the following configuration.

  <appender name="SmtpAppender" type="log4net.Appender.SmtpAppender">     
    <to value="to@domain.com" />     
    <from value="from@domain.com" />     
    <subject value="my logging message" />     
    <smtpHost value="SMTPServer.domain.com" />     
    <bufferSize value="512"/>     
    <lossy value="true" />     
    <evaluator type="log4net.Core.LevelEvaluator">       
      <threshold value="ERROR"/>     
    </evaluator>      
    <layout type="log4net.Layout.PatternLayout">       
    <conversionPattern value="%newline%date [%thread] %-5level %logger [%property{NDC}] - %message%newline%newline%newline" />     
    </layout> 
  </appender>

Here you will get only Errro log event through the email. For that you have to set the lossy to "true" and evaluator to "ERROR".

ConsoleAppender

Basically ConsoleAppender is used to show the log event information into the console output. The following configuration is used for the ConsoleAppender.

 <appender name="ConsoleAppender" type="log4net.Appender.ConsoleAppender"/&agt;     
    <layout type="log4net.Layout.PatternLayout"/&gt       
       <conversionPattern value="%date [%thread] %-5level %logger [%property{NDC}] - %message%newline" />     
    </layout>
   </appender>

Insert multipal rows into database

2012-02-27T16:31:00.002+05:30

Sometimes we need to insert or update multipal records in a single call using c# code . Here I am going to tell how you can achive this throw the new features of SQL Server 2008. In Sql Server 2008, we can pass table type variable in the parameters of the stored procedrue. So, we can create a table type object in the .net code and pass that object in parameter. Let me give you an example step by step.

Steps:

1. 1. Create a table named Employee.

   CREATE TABLE [dbo].[Employee](
      [EmpId] [nvarchar](20) NULL,
      [Name] [nvarchar](50) NULL,
      [Salary] [decimal](18, 0) NULL
     ) ON [PRIMARY]
     GO

3. 2. Create a table type variable named EmployeeTable

    CREATE TYPE EmployeeTable AS TABLE
      (     
        [EmpId][nvarchar](20) NULL,
        [Name][nvarchar](50) NULL,
        [Salary][decimal](18, 0) NULL
      )
      GO

3. Create a stored procedure to insert/update the data.

ALTER PROCEDURE SaveEmployee
      @EmployeeTable as EmployeeTable READONLY
AS
BEGIN
      SET NOCOUNT ON;

    DECLARE @InsertEmployeeTable as EmployeeTable,
            @UpdateEmployeeTable as EmployeeTable 
        
    /* Insert those records which are not exist in the Employee table  */
    INSERT INTO @InsertEmployeeTable 
    SELECT * FROM @EmployeeTable 
      WHERE [@EmployeeTable].[EmpId] NOT IN (SELECT EmpId FROM Employee)
    
    /* Insert those records which are exist in the Employee table  */
    INSERT INTO @UpdateEmployeeTable 
    SELECT * FROM @EmployeeTable
          WHERE [@EmployeeTable].[EmpId] IN (SELECT EmpId FROM Employee)
    
    /* Insert the new records in the Employee table */
    INSERT INTO Employee 
    SELECT * FROM @InsertEmployeeTable
    
    /* update the existing records in the Employee table */
    UPDATE Employee
    SET  Name = [@UpdateEmployeeTable].[Name]
        Salary = [@UpdateEmployeeTable].[Salary]    
   FROM Employee INNER JOIN @UpdateEmployeeTable ON Employee.EmpId = [@UpdateEmployeeTable].[EmpId]
       
END
GO

Here I am passing EmployeeTable type variable @EmployeeTable in the parameter. Created two EmployeTable variable @InsertEmployeeTable and @UpdateEmployeeTable. @InsertEmployeeTable is used to stored those records which are going to be insert and @UpdateEmployeeTable to update records.

4. Create a console application and add an app.cofig file and add the connection string.

5. Add a class Employee.cs.Here I have created the Save() method which takes the collectios of Employee object. This function basically convert the IList collection to the datatable and pass that datable into the parameter of the stored procedure. Here you have to very careful when converting the Employee collection to the DataTable. The datatable should have the same same as EmployeeTable type in the Sql Server.


     public void Save(IList<Employee>obEmployees)
        {
            SqlConnection connection =new SqlConnection(ConfigurationManager.AppSettings["Emp.Connection"].ToString());
            
            SqlCommand obCommand = new SqlCommand();
            obCommand.Connection = connection;
            obCommand.Connection.Open();
            obCommand.CommandText = "SaveEmployee";
            obCommand.CommandType =System.Data.CommandType.StoredProcedure;
            //Convert collection to data table
            DataTable dtEmployee = GetEmployeeTable(obEmployees);
            obCommand.Parameters.Add("@EmployeeTable", dtEmployee);
            obCommand.ExecuteNonQuery();
            obCommand.Connection.Close();
        }

        private DataTable GetEmployeeTable(IList<Employee> obEmployeeList)
        {
            var dtEmployee = new DataTable("dtEmployee");
            dtEmployee.Columns.Add(new DataColumn("EmpId"));
            dtEmployee.Columns.Add(new DataColumn("Name"));
            dtEmployee.Columns.Add(new DataColumn("Salary"));
            DataRow dataRow;
            //Assing each object to Data Row and add to Datatable
            foreach (var obEmployee in obEmployeeList)
            {
                dataRow = dtEmployee.NewRow();
               
                dtEmployee.Rows.Add(GetEmployeeDataRow(dataRow, obEmployee));
            }
            return dtEmployee;
        }

        private static DataRow GetEmployeeDataRow(DataRow dataRow, Employee obEmployee)
        {
            dataRow["EmpId"] = obEmployee.EmpId;
            dataRow["Name"] = obEmployee.Name;
            dataRow["Salary"] = obEmployee.Salary;
            return dataRow;
        }

6. Add the following code in the Program.cs file.

     static void Main(string[] args)
        {
            Employee obEmployee = new Employee();
            Console.WriteLine("*********** SAVE EMP *********");
            List<Employee> obEmployees = new List<Employee>();
            obEmployees.Add(new Employee {EmpId = "EMP01", Name = "A", Salary = 6000});
            obEmployees.Add(new Employee { EmpId = "EMP02", Name = "B", Salary = 7000 });
            obEmployees.Add(new Employee { EmpId = "EMP03", Name = "C", Salary = 8000 });
            obEmployee.Save(obEmployees);
            Console.WriteLine("************************");
            Console.ReadLine();
        }

If you run this code first time then application will add those value into the table. And if you run the same code with differenct Name and Salary but same EmpId then it will update all the records.

Download :

New features of SQL Server 2008

2012-02-21T15:51:00.018+05:30

Here I am going to tell you some new transact-SQL enhancement.

1. Now you can declare and assigne the variables in a single stagtement. In the old version if you want to declare the variable and assigne the variable then you have to write in the following manner

DECLARE @A BIGINT

,@B NVARCHAR(10)

SET @A = 10

SET @B = 'test'

Now you can use the following manner

DECLARE @A BIGINT = 10

,@B NVARCHAR(10) = 'test'

If you are using the reference of a variable in the declaration then it will show the error

DECLARE

@A BIGINT = 10

,@B BIGINT = @A + 1

SELECT @B

You have to change the above statements in the following manner

DECLARE

@A BIGINT = 10

,@B BIGINT

SET @B = @A + 1

You can also assingne the multipal statements in the single line

DECLARE

@A BIGINT = 10

,@B BIGINT

SELECT @B = @A + 1, @B +=2

SELECT @B

The output will be 13

Here you have to use the SELECT statement in the SELECT @B = @A + 1, @B +=2

You can not use SET statement here.

2. Insert multipal statement

If want want to insert multipal records then what have to use the following queries

INSERT INTO Employee (EmpId, Name, Salary)

VALUES ('Emp01' , 'A', 20000)

INSERT INTO Employee (EmpId, Name, Salary)

VALUES ('Emp02' , 'B', 30000)

INSERT INTO Employee (EmpId, Name, Salary)

VALUES ('Emp03' , 'C', 40000)

INSERT INTO Employee (EmpId, Name, Salary)

SELECT 'Emp01' , 'A', 20000

UNION ALL

SELECT 'Emp02' , 'B', 30000

UNION ALL

SELECT 'Emp03' , 'C', 40000

But now we can insert multipal records in a single query

INSERT INTO Employee (EmpId, Name, Salary)

VALUES

('Emp01' , 'A', 20000),

('Emp02' , 'B', 30000),

('Emp03' , 'C', 40000)

If you want apply some conditions or joins on some default values of collection then you have to insert those values into a temp table and apply those joins or conditions. We can achieve this through the new features of SQL Server 2008. Here I am using the CTE (Common Table Expression ) to insert default values instead of the temp table and applying the conditions on that

WITH ConditionalDataCTE(EmpId, Name, Salary)

(

SELECT * FROM

(VALUES

('Emp01' , 'A', 20000),

('Emp02' , 'B', 30000),

('Emp03' , 'C', 40000)

) AS EMP (EmpId, Name, Salary)

)

SELECT * FROM ConditionalDataCTE

Now we can apply different conditions or JOINS on the ConditionalDataCTE.

SELECT Employee.* FROM ConditionalDataCTE

INNER JOIN Employee ON Employee.EmpId = ConditionalDataCTE.EmpId

3. New Merge statement

If we have a collection of records and want to update or insert through a single query then we can achieve this through the Merge statement. The syntax of the Merge statement is

MERGE [INTO] <target table>

USING table or table expression>

ON merge predicate> (semantics similar to outer join)

WHEN MATCHED <statement to run when match found in target>

WHEN [TARGET] NOT MATCHED <statement to run when no match found in target>

Here I am using an Employee table and I have to update and insert the multipal records in the Employee table then I will use the following query

WITH NewEmployee(EmpId, Name, Salary)

(

SELECT * FROM

(VALUES

('Emp01' , 'A', 20000),

('Emp02' , 'B', 70000),

('Emp03' , 'C', 80000),

('Emp04' , 'D', 80000)

) AS EMP (EmpId, Name, Salary)

)

MERGE INTO EMPLOYEE

USING NewEmployee

ON EMPLOYEE.EmpId = NewEmployee.EmpId

WHEN NOT MATCHED THEN

INSERT (EmpId, Name, Salary)

VALUES (NewEmployee.EmpId, NewEmployee.Name, NewEmployee.Salary)

WHEN MATCHED THEN

UPDATE SET

Name = NewEmployee.Name

,Salary = NewEmployee.Salary;

Here I have NewEmployee table and appling the Merge statement with Employee table. If the NewEmployee's EmpId are exist in the Employee table then those records will be updated otherwise those will be inserted.

4. Use Table type paramenter in stored procedure.

Now we can also pass the table type parameter in the SQL Server Stored Procedure. I am using the following commend to create the table type variable

CREATE TYPE EmployeeTable AS TABLE

(

[EmpId] [nvarchar](20) NULL,

[Name] [nvarchar](50) NULL,

[Salary] [decimal](18, 0) NULL

)

Now need passing this table type variable in the parameter of the stored procedure

CREATE PROCEDURE useTableType

@NewEmployee AS EmployeeTable READONLY

BEGIN

SET NOCOUNT ON;

MERGE INTO EMPLOYEE

USING @NewEmployee

ON EMPLOYEE.EmpId = [@NewEmployee].[EmpId]

WHEN NOT MATCHED THEN

INSERT (EmpId, Name, Salary)

VALUES ([@NewEmployee].[EmpId], [@NewEmployee].[Name], [@NewEmployee].[Salary])

WHEN MATCHED THEN

UPDATE SET

Name = [@NewEmployee].[Name]

,Salary = [@NewEmployee].[Salary];

END

Giving anonymous access to a page and folder using form authentication

2012-02-18T16:39:00.002+05:30

One of my friend has the problem using for accessing the page and folder using the form authentication. I thought I should put this solution in the blog. Whenever we use the Form Authentication for the authentication we use the following configuration in the web.cofig file

here <authorization> section restrictes all the anonomous user to access the other pages of the site. Now the problem is that I need to access some pages i.e. faq.aspx, contact.aspx, career.aspx which are in the root of the site or css and javascript files then I can not go directectly to those pages. To overcome this problem you just need to add the following section in the web.config file

Now the Default.aspx page will be accessable by the anonomous users withoug login. If you want to access more pages then add that section with the differenct path.

If you have to access a folder or all the pages of a particula folder then you can specify the folder path here.

Part 1 : How to use log4net in .net

2012-02-18T14:30:00.039+05:30

Introduction

This article describes how to use the log4net for the .net application. Log4net is the open source library used to log the application event message in the different sources. You can log the info into the file, console output, event log or can be send in the email. The main advantage to use this, it's flexibility and extendenbility. You can control the log though the configuration file without change the code. Here I am going to give you the overview how to use the log4net for the asp.net web application.

You just have to create an asp.net website, changed in the web.config file and call the log method.

Steps:

1. Download the latest dll file of log4net from the link here

2. Create the asp.net website, and add the reference of log4net.dll to this application.

3. Add the following section in the <configSections> section of the web.config file

4. Then add the following section in the the <configSections> section

</layout>

</appender>

<root>

<appender-ref ref="LogFileAppender"/>

</root>

</log4net>

Here <log4net> contains to more sub sections <appender> and <root> Appender specify what type of log to be logged, where it should be logged, how you need to log and what type of information you want to log. Here I have used file appender. The Name of the appender can be anything. The type for the file logger should be log4net.Appender.FileAppender. You can also extend the class as per your need. The "D:\LogFile.tx" specify the file path where it should be logged. specify the log information format. You can also customized this format. The section is used to specify the appender reference and define what level of log you want to logged.

5.Add the namespace in the default.aspx.cs page

using log4net;

using log4net.Config;

6. Add the following code in the Page_Load method

private static readonly ILog logger = LogManager.GetLogger(typeof(_Default));

private static readonly ILog logger = LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType)

7. Add the following code in the Page_Load method

protected void Page_Load(object sender, EventArgs e)

{

DOMConfigurator.Configure();

try

{

int a = 0, b = 1;

logger.Debug("Log Debug");

logger.Info("Log info");

logger.Warn("Log Warn");

logger.Fatal("Log Fatal");

float c = b/a;

}

catch (Exception ex)

{

logger.Error("some errro in the application ",ex);

}

7. Run the application.

8. Now open the LogFile.txt. The output will be

2012-02-18 13:58:01,197 [2348] DEBUG _Default Log Debug

2012-02-18 13:58:01,203 [2348] INFO _Default Log info

2012-02-18 13:58:01,203 [2348] WARN _Default Log Warn

2012-02-18 13:58:01,203 [2348] FATAL _Default Log Fatal

2012-02-18 13:58:01,219 [2348] ERROR _Default some errro in the application

System.DivideByZeroException: Attempted to divide by zero.

at _Default.Page_Load(Object sender, EventArgs e) in d:\Log4NetWeb\Default.aspx.cs:line 31

Disable log4net

The big benefit of using the log4net is, you can configure it without changing the code. Once you have completed your code and published the application, then you can change the configuration through the configuration section of the .config file. If you want to disable the log4net then you just need to add the <threshold> section in the appender section.

</layout>

</appender>

Specify log level

You can use 7 type of levels in the logging. These levels specify what kind of log you want to add into your application.

1. ALL

2. Debug

3. Information

4. Warning

5. Error

6. Fatal

7. OFF

The sequence is very important here. ALL specify that all kind of logs will be loged. If you specify Debug then all types of log can be logged. If you specify Information then all the log will be logged except Debug and if you specify Fatal then only Fatal log. OFF type of level will not log any kind of log. These level are specify in the >

<root>

<appender-ref ref="LogFileAppender"/>

</root>

Filters

Filter is the another kind of criteria which tell what kind of level you want to log. Filter is specified in the appender. You can use multipal appender in the same logger and each appender can contain different Filters. As per the name, Filter filters the log information or log the information as per the filter criteria. There are different types of Filters:

StringMatchFilter

This Filter check if the matching string is exist in the log or not. If exist then log the information otherwise does not log.

Here I have used the Filter section and used the StringMatchFilter filter. It will log only those information which has string "Pankaj". You also have to add the section <filter type="log4net.Filter.DenyAllFilter" /> . Now I have changed the above code.

protected void Page_Load(object sender, EventArgs e)

{

DOMConfigurator.Configure();

try

{

int a = 0, b = 1;

logger.Debug("Log Debug");

logger.Info("Log info");

logger.Warn("Log Warn");

logger.Fatal("Pankaj Log Fatal");

float c = b/a;

}

catch (Exception ex)

{

logger.Error("some errro in the application ",ex);

}

If you don’t include the DenyAllFilter section then it will log all the log (DEBUG, INFO, WARN, FATAL, ERROR). DenyAllFilter section will deny all the log and stringToMatch log only those information who has the string "Pankaj".

LevelMatchFilter

When you need to log only specified level of log then you can use LevelMatchFilter. For example, if you want to log only ERROR level then the syntax will be

LevelRangeFilter

This type of logging is basically used when you need to log a specified range of log. For example, if you want to log only those information which are between the WARNING and FATAL, then the systax will be

Now if you run the Page_Load function then only WARN, ERROR and FATAL will be logged, not DEBUG and INFO.

Factory Pattern

2010-08-10T11:28:00.005+05:30

In the object oriented programming there are numbers of patterns, one type of pattern is Factory Patterns. When we have several classes and returning an instance of a single class depending on the type of the data is called Factory Pattern. Generally all the classes have a single parent class and each derived class contain same methods. Depending on the data, we fetch a single class object.

In this figure, you can see there is a single Parent class which is derived by 3 Derived Class. Here we have created a Factory Class, which contains a Factory Method (may contain parameter or not), which returns the parent class’s instance.

To see this figure we can say, the Factory class basically used to decide which derived class object should be initiate. It does not depend on the programmer.

Let me give you an example that will make it simple.

 public abstract class NumberClas
 { 
   public abstract void Show();
 }

Here NumberClass is a parent class, which contains a abstract method Show();

public class EvenNumber : NumberClass

{

public EvenNumber()

{}

public override void Show()

{

Console.WriteLine("Even number.");

}


  public class OddNumber : NumberClass
        {
      public OddNumber ()
      {}
  
     public override void Show()
               {

       Console.WriteLine("Odd number.");
               }
  }

The EvenNumber and OddNumber are two derived classes, both have the same parent NumberClass and overriding the Show() method. To know the runtime which derived class’s object should be initialize I have created the FactoryClass. This class contains the GetObject(int number) method, which returns the correct object at the run time.

public class FactoryClass
 { 
     public NumberClass GetObject(int number)
     {
       
       if(number % 2 == 0)
         return new  EvenNumber();

       else
         return new  OddNumber();
     }
}

Now

 static void Main(string[] args)
  {
    //initialice the factory class object
   FactoryClass obFctoryClass = new FactoryClass();
  
   //initilize the base class object through the factory method
    NumberClass obNumberClass = obFactoryClass.GetObject(2);

   
   //call the derived class method
   obNumberClass.Show();


   Console.WriteLine("\n******************");
   //initilize the base class object through the factory method
   obNumberClass = obFactoryClass.GetObject(3);


   //call the derived class method
   obNumberClass.Show();

      Console.ReadLine();
  }
}

Output is

Even number.
******************
Odd number.

Delegate

2010-08-05T16:53:00.006+05:30

What is a Delegate

A delegate is a class that can hold a reference of a method. The type of a delegate is the type or signature of the method rather than the class. A delegate is thus equivalent to a type safe function pointer or a callback. A delegate declaration is sufficient to define a delegate class.

There are three steps in defining and using delegates:
1. Declaration
2. Instantiation
3. Invocation

1. Declaration
The syntax to declare of the delete is

delegate   return-type  identifier([parameters])

example :

public delegate void DelegateSample();

here return-type is void, identifier is the delegate name (DelegateSample) and this delegate does not have any parameter.

2. Instantiation
Every delegate can contain only those functions pointer, which has the same signature. Here DelegateSample can only contain refereces of those function which has return-type void and does not have any parameters.

DelegateSample obDelegateSample = new DelegateSample(ShowMessage);

private void ShowMessage()
{
Response.Write("Function called");
}

Here ShowMessage() is a private function which has return type void and this function does not contain any parameter. Now I have created an object of DelegateSample obDelegateSample and this object contain the refrence of ShowMessage(). Here function and delegate signature is same.

3. Invocation
To invoke the delegate you just need to call the obDelegateSample.

obDelegateSample();

Here I am using a web application.

Example1: Void return-type with no parameter delegate example

public delegate void DelegateSample();

protected void Page_Load(object sender, EventArgs e)
{
DelegateSample obDelegateSample = new      DelegateSample(ShowMessage);

obDelegateSample();
}

private void ShowMessage()
{
Response.Write("Function called");
}

Example2: string return-type with parameter delegate example

public delegate string DelegateSampleReturn(string message);

protected void Page_Load(object sender, EventArgs e)
{

DelegateSampleReturn obDelegateSampleReturn = new   DelegateSampleReturn(ShowMessageReturn);

string returnValue =  obDelegateSampleReturn("hello");

Response.Write(returnValue);
}

private string  ShowMessageReturn(string message)
{
return message;
}

Example3: calling static function

public delegate string DelegateSampleReturn(string message);

protected void Page_Load(object sender, EventArgs e)
{

DelegateSampleReturn obDelegateSampleReturn = new   DelegateSampleReturn(ShowMessageReturn);

string returnValue =  obDelegateSampleReturn("hello");

Response.Write(returnValue);
}

static string  ShowMessageReturn(string message)
{
return message;
}

Example4: Calling different class member functions

public class ClassAdd
{
public static int Add(int a, int b)
{
return a + b;
}

}

public class ClassSub
{
public static int Subtract(int a, int b)
{
return a - b;
}

}
public delegate int DelegateSampleReturnInt(int a, int b);

protected void Page_Load(object sender, EventArgs e)
{
DelegateSampleReturnInt obDelegateSampleReturnInt = new  DelegateSampleReturnInt(ClassAdd.Add);

int returnValue = obDelegateSampleReturnInt(2, 3);
Response.Write("Add :" + returnValue);

obDelegateSampleReturnInt = new DelegateSampleReturnInt(ClassSub.Subtract);

returnValue = obDelegateSampleReturnInt(2, 3);

Response.Write("  Subtract : " + returnValue);

}

Multicast Delegate

A delegate can point to one or more than one function. When delegate point to more than one function, then it is called Multicast Delegate.

In the example4, I have created a single object of DelegateSampleReturnInt obDelegateSampleReturnInt, and obDelegateSampleReturnInt is pointing two different functions. First time it is initializing to the ClassAdd.Add and then invoke the Add() method. Second time it is initializing to the ClassSub.Subtract() method and then invoking that method. The limitation is here, If I do not invoke the Add() method, then It will only invoke Subtract(). To overcome this scenario, we can use Multicast Delegates.

In Multicast Delegate you can call more than one function in a single invocation.
You can use the overloaded += operator to assign an additional funtion to the delegate object. If you want to remove any function reference from the delegate object then you have to use overloaded -= operator.

Multicast delegates must contain only methods that return void; else there is a run-time exception.

//declaration of the delegate
public delegate void DelegateSampleReturn(int a, int b);

protected void Page_Load(object sender, EventArgs e)
{
//initilization 
DelegateSampleReturn obDelegateSampleReturn = new DelegateSampleReturn(Add);

obDelegateSampleReturn += new DelegateSampleReturn(Substract);

//invoke   
obDelegateSampleReturn(2, 3);


}
public void Add(int a, int b)
{
Response.Write("Add :" + a + b);
}
public void Substract(int a, int b)
{
Response.Write("Sub : " + a - b);
}

Logon failed. (rsLogonFailed) Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)

2010-04-12T15:44:00.003+05:30

Hi All,

I have created the reports in SQL Service Services. When I upload the reports in the Reporting Server, its show the following error

Logon failed. (rsLogonFailed)

Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)

To solve this problem, do the following steps

1.Open the SQL Server Reporting Service Configuration

2.Go to the Execution Account

3.Uncheck the Specify an execution account

Custom Error Handling in ASP.NET

2010-03-24T11:26:00.008+05:30

.Net provides number of ways to manage and handle errors. Generally we use try..catch block to handle the error and show the error message in a label. Instead of showing the error in that page, we can show the error in another page with the customized manner, so that it can be seem more professional.

Steps:

1.Create an ASP.NET web site.
2.Add a class ErrorPage.cs in the App_Code folder.
3.Add the following variable in the ErrorPage.cs file

//Declare the private HttpApplication variable
private HttpApplication _application;

void IHttpModule.Init (HttpApplication application)
{
_application = application;

//check whether the ErrorHandling values is Application type set in the web.config
//file or not. If yes then declare an EventHandler 
if (GetValue("ErrorHandling") == "Application")
_application.Error += new EventHandler(ErrorPageHandler);

}


private void ErrorPageHandler(Object sender, EventArgs e)
{
//fetch the error
ProcessException(_application.Server.GetLastError());
}

//store the error in the Cache
private void ProcessException(Exception exception)
{
HttpContext.Current.Cache["Error"] = HttpContext.Current.Request.Url.ToString();
HttpContext.Current.Cache["ErrorMsg"] = exception.Message;
HttpContext.Current.Cache["StackTrace"] = exception.StackTrace;

HttpContext.Current.Response.Redirect(GetValue("SiteUrl") + "/Error.aspx");
}


//fetch the value from the web.config file
public string GetValue(string Key)
{
string ret = System.Web.Configuration.WebConfigurationManager.AppSettings[Key];

return ret;
}
public void Dispose()
{
}

4.Create an Error.aspx page and add the following html code

<asp:table width="100%" align="center" >

<asp:tr>
<asp:td style="text-align: left; font-weight: bold">
Error In
<asp:/td>
<asp:/tr>
<asp:tr>
<asp:td  style="text-align: left; font-weight: bold">
<asp:asp:Label ID="lblError" runat="server" CssClass="x-panel-mc-font"><asp:/asp:Label>
<asp:/td>
<asp:/tr>
<asp:tr>
<asp:td  style="text-align: left; font-weight: bold">
  
<asp:/td>
<asp:/tr>
<asp:tr>
<asp:td style="text-align: left; font-weight: bold">
Error Message
<asp:/td>
<asp:/tr>
<asp:tr>
<asp:td  style="text-align: left;">
<asp:asp:Label ID="lblErrorMsg" runat="server" CssClass="x-panel-mc-font"><asp:/asp:Label>
<asp:/td>
<asp:/tr>
<asp:tr>
<asp:td  style="text-align: left;">
  
<asp:/td>
<asp:/tr>
<asp:tr>
<asp:td style="text-align: left; font-weight: bold">
Stack Track
<asp:/td>
<asp:/tr>
<asp:tr>
<asp:td  style="text-align: left;">
<asp:asp:Label ID="lblStackTrace" runat="server" CssClass="x-panel-mc-font"><asp:/asp:Label>
<asp:/td>
<asp:/tr>
<asp:tr>
<asp:td  style="text-align: left;">
  
<asp:/td>
<asp:/tr>
<asp:/table>

Here I have used 3 lables to show the page name (from where error is generated), Error Message and Stack Track.

5.Add the following code in the Error.aspx.cs page

protected void Page_Load(object sender, EventArgs e)
{
if (Cache["Error"] != null)
lblError.Text = Cache["Error"].ToString();
if (Cache["ErrorMsg"] != null)
lblErrorMsg.Text = Cache["ErrorMsg"].ToString();
if (Cache["StackTrace"] != null)
lblStackTrace.Text = Cache["StackTrace"].ToString();

}

Fetched the errors from the Cache and showing in the labels.

6.In the default.aspx page add a button control, and add the following code in the button click event.

int a = 1, b = 0;
int c = a / b;

Generating the error.

7.Add the following setting in the web.config file

<asp:appSettings>
<asp:add key="SiteUrl" value="http://localhost:1371/CustomeErrorHandling"/>
<asp:add key="ErrorHandling" value="Application"/>
<asp:/appSettings>

And add in the <httpModules> section

<asp:add type="ErrorPage" name="ErrorPageHandler">

8.Now run the application

9.Click on the Show Error button, then the error will be show in the following manner.

Note: Do not use try..catch block in the code behind page, If you use then custome error will not work. i.e. If I write the code in the following manner

try
{
int a = 1, b = 0;
int c = a / b;
}
catch
{ }

Then the error page will not show.

Download :

Use header checkbox in GridView in ASP.NET

2009-08-27T23:07:00.009+05:30

Here I am going to give you a very easy steps to use the checkbox in the header of the Gridview in ASP.NET.

Steps:
1. I have created a class “Customer” and fill the gridview with the collection of customers.

public class Customer

{



    int id;

    string name;

    string city;



    public string City

    {

        get { return city; }

        set { city = value; }

    }



    public string Name

    {

        get { return name; }

        set { name = value; }

    }



    public int Id

    {

        get { return id; }

        set { id = value; }

    }



    public Customer(int customerID, string customerName, string customerCity)

    {



        id = customerID;

        name = customerName;

        city = customerCity;

    }



}

2.Created a gridview in the default.aspx page


 <asp:GridView ID="dgridCustomer" runat="server" AutoGenerateColumns="false" Width="592px">

 <Columns>

   <asp:TemplateField>

    <HeaderTemplate>

       

      <input type="checkbox" class="chkHeader" id="HeaderCheckBox"  onclick="javascript:Check(this)"                                        name="ItemCheckBox" runat="Server" />

    </HeaderTemplate>

       <ItemTemplate>

         <input type="checkbox" value='<%# DataBinder.Eval(Container.DataItem, "Id") %>' class="chkItem"

         id="ItemCheckBox" name="ItemCheckBox" runat="Server" />

       </ItemTemplate>

    </asp:TemplateField>

    <asp:TemplateField HeaderText="Name">

        <ItemTemplate>

           <%# DataBinder.Eval(Container.DataItem, "Name") %>

        </ItemTemplate>

    </asp:TemplateField>

    <asp:TemplateField HeaderText="City">

        <ItemTemplate>

          <%# DataBinder.Eval(Container.DataItem, "City") %>

        </ItemTemplate>

    </asp:TemplateField>

  </Columns>

</asp:GridView>

3.To fill the gridview following functions has been used in default.aspx.cs file

protected void Page_Load(object sender, EventArgs e)

    {



        lblMsg.Visible = false;



        if (IsPostBack) return;



        FillCustomer();



    }



    private void FillCustomer()

    {

        List obCustomers = new List();



        obCustomers = GetAllCustomers();



        Session["Customers"] = obCustomers;



        dgridCustomer.DataSource = obCustomers;

        dgridCustomer.DataBind();

    }



    private List GetAllCustomers()

    {

        List obCustomers = new List();



        Customer obCustomer = new Customer(1, "name1", "city1");

        obCustomers.Add(obCustomer);



        obCustomer = new Customer(2, "name2", "city2");

        obCustomers.Add(obCustomer);



        obCustomer = new Customer(3, "name3", "city3");

        obCustomers.Add(obCustomer);



        obCustomer = new Customer(4, "name4", "city4");

        obCustomers.Add(obCustomer);



        obCustomer = new Customer(5, "name5", "city5");

        obCustomers.Add(obCustomer);



        return obCustomers;



    }

4.When header checkbox of the gridview is clicked then all the item checkboxes should be checked and if header checkbox is unchecked then all the item checkboxes should be unchecked. To do this I have created a javascript function and added in the default.aspx page.

 function Check(varchk)

            {



               var objInputs = document.getElementsByTagName('input')

               for(i=0;i               {

                  if(varchk.checked)

                    {

                        if(objInputs[i].className==='chkItem')

                        {

                            objInputs[i].checked=true;

                        }

                    }

                    else

                    {

                        if(objInputs[i].className==='chkItem')

                        {

                            objInputs[i].checked=false;

                        }

                    }

               }

            }

5.Remove all the checked record from the gridview, the following method has been used
in the Remove button.

 protected void btnRemove_Click(object sender, EventArgs e)

    {

        List obCollection = (List)Session["Customers"];



        foreach (GridViewRow row in dgridCustomer.Rows)

        {

            System.Web.UI.HtmlControls.HtmlInputCheckBox chk = (System.Web.UI.HtmlControls.HtmlInputCheckBox)dgridCustomer.Rows[row.RowIndex].FindControl("ItemCheckBox");



            if (chk.Checked)

            {

                Customer obCustomer = obCollection.Find(delegate(Customer obj) { return obj.Id == Convert.ToInt32(chk.Value); });



                obCollection.Remove(obCustomer);



                lblMsg.Visible = true;



                lblMsg.Text = "Customer information deleted successfully.";

            }

        }



        dgridCustomer.DataSource = obCollection;

        dgridCustomer.DataBind();



    }

Below method is used to find the checked item from the collection.

Customer obCustomer = obCollection.Find(delegate(Customer obj) { return obj.Id == Convert.ToInt32(chk.Value); });

Download :

Decorator Pattern

2009-08-01T17:07:00.007+05:30

There are numbers of way we used in the designing software application. These ways are called Patterns, and in the object-oriented programming, we use so many patterns. Decorator Pattern is a design pattern in the object-oriented programming that allows us to add the new functionality in the existing class dynamically. To understand let me give you a simple example. Suppose you have an application in ASP.NET and SQL Server.
In your business logic, you have written all you logics. i.e.

1. Insert()
2. Update()
3. Delete
4. Get()

In these logics, you have written the code according to your SQL Server fetching technique. You have used System.Data.SqlClient and open/close the connection with SQL Server and done all the insert/update/delete opertaions with SQL Server. You have also called this business logic objects into your UI layer. Now your application is fully dependent in SQL Server. The problem start now, you have a single application where you have done your all effort with the SQL Server and the new requirement is you have to also provide the support of the Microsoft Access with the same database and UI. Then what will you do? You have to create the another business logic with the Microsoft Access as well as have to change all the logic of UI layer because it is accessing the SQL Server business layer logic right now. It will force you rethink again in your design pattern. In such type of situation Decorator Pattern help you to get up. Let me make it simpler. Suppose, I have an asp.net .aspx page where I have to show all products information. Remember we have two databases one is in SQL Server, another is in Microsoft Access, and we have to write the code in a single UI. At the run time, we can decide which database we have to use. First, I will create an interface IProduct. (Here I am using a console application.)

public interface IProduct
{
bool Insert(int id, string name);
bool Update(int id, string name);
bool Delete(int id);
string GetRecords();
}

Then I have to create a Product class which will contains all the operations with SQL Server database. This Product class will inherits the IProduct interface.

public class ProductSQLServer : IProduct 
{
int id = 10;
string name = "SQL Server";

#region IProduct Members

public bool Insert(int id, string name)
{

//insert logic

return true;

}

public bool Update(int id, string name)
{
//upate logic
return true;
}

public bool Delete(int id)
{
//delete login
return true;
}

public string GetRecords()
{
return "sql server : id=" + id + " name=" + name ;
}

#endregion

}

public class ProductMicrosoftAccess : IProduct
{
int id = 10;
string name = "MicrosoftAccess";

#region IProduct Members

public bool Insert(int id, string name)
{
//insert into the microsoft access
return true;
}

public bool Update(int id, string name)
{
//update in the microsoft access
return true;
}

public bool Delete(int id)
{
//delete from the microsoft access
return true;
}

public string GetRecords()
{
return "MicrosoftAccess : id=" + id + " name=" + name ;
}

#endregion
}

Now in the UI layer we can decide in the run time what type of object (SQL Server/Access) need to be accessed.

In the view product.aspx page I can decide whether I want to create the object of ProductMicrosoftAccess class or ProductSQLServer class.
For that you have to use the IProduct interface

static void Main(string[] args)
{
IProduct  obOperation = new ProductMicrosoftAccess();

Console.WriteLine(obOperation.GetRecords());

obOperation = new ProductSQLServer();

Console.WriteLine(obOperation.GetRecords());


Console.ReadLine();
}

You can choose the type of database by setting the key in your web.config file or any configuration file.

Download :

ADO.NET Entity Framework

2009-07-20T16:04:00.003+05:30

Introducing the ADO.NET Entity Framework

During the development with the database and ADO.NET, we use some traditional way. First we create the database tables and their relationships and then create the classes in the code for business layer. We write our business logic in these classes and performs different operations on the database though these classes. Most of the developers have to do the complex code to move the data between the application and the database. However, to write such type of the code develops must have the database knowledge. In this type of development we generally do not care about the database concepts in our code. Now the Microsoft has introduced the concept of Entity Framework Model where it deals with the database tables as en entity and allows us to write and maintain the code according to the database concepts. Using the entity relationship modeling, developers create the conceptual model of the data and write their code against this model. So we can say “ADO.NET Entity Framework Model allows you to deal with database concepts in your code."
ADO.NET Entity framework intended to make the development easier and more effective for object-oriented application to work with data.

The Entity Framework architecture

The ADO.NET Entity Framework is a layered framework which abstracts the relational schema of a database and presents a conceptual model.

Data Source: The bottom layer is the data which can be stored in one or many databases.

Data Providers: The data will be accessed by a ADO.NET data provider. At this moment only SQL Server is supported but in the near future there will be data providers for Oracle, MySQL, DB2, Firebird, Sybase, VistaDB, SQLite.

Entity Data Model (EDM): The Entity Data Model consists of 3 parts :
• Conceptual schema definition language (CSDL) : Declare and define entities, associations, inheritance, ... Entity classes are generated from this schema.
• Store schema definition language (SSDL) : Metadata describing the storage container (=database) that persists data.
• Mapping specification language (MSL) : Maps the entities in the CSDL file to tables described in the SSDL file.

Entity Client: EntityClient is an ADO.NET managed provider that supports accessing data described in an Entity Data Model. It is similar to SQLClient, OracleClient and others. It provides several components like EntityCommand, EntityConnection and EntityTransaction.

Object Services: This component enables you to query, insert, update, and delete data, expressed as strongly-typed CLR objects that are instances of entity types. Object Services supports both Entity SQL and LINQ to Entities queries.

Entity SQL (ESQL): Entity SQL is a derivative of Transact-SQL, designed to query and manipulate entities defined in the Entity Data Model. It supports inheritance and associations. Both Object Services components and Entity Client components can execute Entity SQL statements.

LINQ to Entities: This is a strong-typed query language for querying against entities defined in the Entity Data Model.

DATABASE MODELING LAYERS

Common design pattern for data modeling is the division of the data model into three parts: a conceptual model, a logical model, and a physical model

1.Physical Data Model: This model describes how data are represented in the physical resources such as memory, wire or disk. The vocabulary of concepts discussed at this layer includes record formats, file partitions and groups, heaps, and indexes. The physical model is typically invisible to the application –applications

2.Logical/Relational Data Model: The concepts discussed at the logical level include tables, rows, and primary key-foreign key constraints, and normalization.

3.Conceptual Model: The conceptual model captures the core information entities from the problem domain and their relationships. conceptual model is the Entity-Relationship Model. UML is a more recent example of a conceptual model

Why Entity Framework is used/ADO.NET Entity Data Model

Entity Framework maps relational tables, columns, and foreign key constraints in logical models to entities and relationships in conceptual models. The Entity Data Model tools generate extensible data classes based on the conceptual model. These classes are partial classes that can be extended with additional members that the developer adds. The classes that are generated for a particular conceptual model derive from base classes that provide Object Services for materializing entities as objects and for tracking and saving changes. Developers can use these classes to work with the entities and relationships as objects related by navigation properties.

Object Services: Object Services is a component of the Entity Framework that enables you to query, insert, update, and delete data, expressed as strongly typed CLR objects that are instances of entity types. Object Services supports both Language-Integrated Query (LINQ) and Entity SQL queries against types that are defined in an Entity Data Model (EDM).
Entity framework enables application to access and change the data that is represented as entities and relationship in the conceptual model. Object Services uses the EDM to translate object queries against entity types that are represented in the conceptual model into data source-specific queries. Query results are materialized into objects that Object Services manages. The Entity Framework provides the following ways to query an EDM and return objects:

• LINQ to Entities - provides Language-Integrated Query (LINQ) support for querying entity types that are defined in a conceptual model.

• Entity SQL - a storage-independent dialect of SQL that works directly with entities in the conceptual model and that supports EDM features such as inheritance and relationships. Entity SQL is used both with object queries and queries that are executed by using the EntityClient provider. For more information, see Entity SQL Overview.

• Query builder methods - enables you to construct Entity SQL queries using LINQ-style query methods. For more information, see Query Builder Methods (Entity Framework).

The Entity Framework includes the EntityClient(The EntityClient provider is a data provider used by Entity Framework applications to access data described in an Entity Data Model (EDM)) data provider. This provider manages connections, translates entity queries into data source-specific queries, and returns a data reader that Object Services uses to materialize entity data into objects. When object materialization is not required, the EntityClient provider can also be used like a standard ADO.NET data provider by enabling applications to execute Entity SQL queries and consume the returned read-only data reader.
The following mythology is used generally

If you use the Entity Framework concept then the result would be

Thus we can say the ADO.NET Entity Framework provide the abstraction layer between the logical data model and application domain. When you will generate the logical tables to entity data diagram, it combines multiple data tables to one entity.

NET 3.5 SP1 includes the new ADO.NET Entity Framework, which allows developers to define a higher-level Entity Data Model over their relational data, and then program in terms of this model. Concepts like inheritance, complex types and relationships can be modeled using it.

Scheme file (EDMX)

If can also see the EDMS file as XML. To see the xml file open the solution explorer, right click on .EDMS file, select Open With XML Editor.

Now you can see here 3 sections
1. Conceptual Model (CSDL)
2. Storage Model (SSDL)
3. Mapping (MSL)

<?xml version="1.0" encoding="utf-8"?>

<edmx:Edmx Version="1.0" xmlns:edmx="http://schemas.microsoft.com/ado/2007/06/edmx">

  <edmx:Runtime>

    <!-- CSDL content -->

    <edmx:ConceptualModels>

      <Schema Namespace="NorthwindModel" Alias="Self" xmlns="http://schemas.microsoft.com/ado/2006/04/edm">

        <EntityContainer Name="NorthwindEntities">

          <EntitySet Name="Employees" EntityType="NorthwindModel.Employee" />

          <AssociationSet Name="FK_Orders_Employees" Association="NorthwindModel.FK_Orders_Employees">

            <End Role="Employees" EntitySet="Employees" />

            <End Role="Orders" EntitySet="Orders" />

          </AssociationSet>

        </EntityContainer>

        <EntityType Name="Employee">

          <Documentation><Summary>Employee entity which corresponds with the Northwind.Employees table</Summary></Documentation>

          <Key>

            <PropertyRef Name="EmployeeID" />

          </Key>

          <Property Name="EmployeeID" Type="Int32" Nullable="false" />

          <Property Name="LastName" Type="String" Nullable="false" MaxLength="20" />

          <Property Name="FirstName" Type="String" Nullable="false" MaxLength="10" />

          <NavigationProperty Name="Orders" Relationship="NorthwindModel.FK_Orders_Employees" FromRole="Employees" ToRole="Orders" />

        </EntityType>

      </Schema>

    </edmx:ConceptualModels>

 

    <!-- SSDL content -->

    <edmx:StorageModels>

      <Schema Namespace="NorthwindModel.Store" Alias="Self" ProviderManifestToken="09.00.1399" 

        xmlns="http://schemas.microsoft.com/ado/2006/04/edm/ssdl">

        <EntityContainer Name="dbo">

          <EntitySet Name="Employees" EntityType="NorthwindModel.Store.Employees" />

          <AssociationSet Name="FK_Orders_Employees" Association="NorthwindModel.Store.FK_Orders_Employees">

            <End Role="Employees" EntitySet="Employees" />

            <End Role="Orders" EntitySet="Orders" />

          </AssociationSet>

      </Schema>

    </edmx:StorageModels>

 

    <!-- C-S mapping content -->

    <edmx:Mappings>

      <Mapping Space="C-S" xmlns="urn:schemas-microsoft-com:windows:storage:mapping:CS">

        <EntityContainerMapping StorageEntityContainer="dbo" CdmEntityContainer="NorthwindEntities">

          <EntitySetMapping Name="Employees">

            <EntityTypeMapping TypeName="IsTypeOf(NorthwindModel.Employee)">

              <MappingFragment StoreEntitySet="Employees">

                <ScalarProperty Name="EmployeeID" ColumnName="EmployeeID" />

                <ScalarProperty Name="LastName" ColumnName="LastName" />

                <ScalarProperty Name="FirstName" ColumnName="FirstName" />

              </MappingFragment>

            </EntityTypeMapping>

          </EntitySetMapping>

          <AssociationSetMapping Name="FK_Orders_Employees" TypeName="NorthwindModel.FK_Orders_Employees" StoreEntitySet="Orders">

            <EndProperty Name="Employees">

              <ScalarProperty Name="EmployeeID" ColumnName="EmployeeID" />

            </EndProperty>

            <EndProperty Name="Orders">

              <ScalarProperty Name="OrderID" ColumnName="OrderID" />

            </EndProperty>

            <Condition ColumnName="EmployeeID" IsNull="false" />

          </AssociationSetMapping>

        </EntityContainerMapping>

      </Mapping>

    </edmx:Mappings>

  </edmx:Runtime>

</edmx:Edmx>

When you build your project, MSBuild will extract the CSDL/SSDL/MSL content from the EDMX file and places these 3 seperate XML files in your project output directory.

Model View

The Model Browser window can be used to visualize the conceptual model and storage model in a well-organized tree hierarchy.

• Conceptual Model
o Entity Types : Employee
o Associations : FK_Orders_Employees
o Entity Container
1. Entity Sets : Employees
2. Association Sets
3. Function Imports

• Storage Model
o Tables / Views : Employees
o Stored Procedures
o Constraints

Generating an Entity Data Model in Your Visual Studio Project

The very first step you have to generate the Entity Data Model for your database. Here I am using the asp.net web application to create the sample of the Entity Data Mode.
Right click on sample project -> Add -> New Item -> ADO.NET Entity Data Model

Changed the model name to EntityDataModel.edmx

Select the Generate from database and click on Next

Select your database connection or create New Connection. And click on Next button

You can select objects (Tables, Vies, Stored Procedures) from this window. Then click on the Finish button. Blow is the graphical representation of the Entity Data Mode (EDM) that is generated by the wizard.

Here I have created a .aspx page to fetch all the categories from the database with the Entity Framework Model and showing the products in the gridview by the selected category.
The .aspx page is

 <table width="100%">

            <tr>

                <td align="right" >

                    Category :

                </td>

                <td>

                    <asp:DropDownList ID="drpCategory" runat=server AutoPostBack=true

                        onselectedindexchanged="drpCategory_SelectedIndexChanged" ></asp:DropDownList>

                </td>

            </tr>

            <tr>

                <td colspan="2" align="center" style="padding-top:10px" >

                    <asp:GridView ID="dgridProducs" Width="90%" runat=server ></asp:GridView>

                </td>

            </tr>

   </table>

Code:

NORTHWNDEntities obNORTHWNDEntities = new NORTHWNDEntities();



        protected void Page_Load(object sender, EventArgs e)

        {

            if (IsPostBack) return;

            FillCategories();

        }



        private void FillCategories()

        {

            try

            {

                drpCategory.DataSource = obNORTHWNDEntities.Categories;

                drpCategory.DataTextField = "CategoryName";

                drpCategory.DataValueField = "CategoryID";

                drpCategory.DataBind();

            }

            catch

            {

                throw;

            }

        }



   

        protected void drpCategory_SelectedIndexChanged(object sender, EventArgs e)

        {

            int categoryID =Convert.ToInt32(drpCategory.SelectedValue);



            IQueryable<Products> products = from c in obNORTHWNDEntities.Products 

                                                where c.Categories.CategoryID ==  categoryID 

                                                select c;





            dgridProducs.DataSource = products;

            dgridProducs.DataBind();

        }

    }

Here obNORTHWNDEntities represent the NORTHWNDEntities context. To fill all the categories into the DrowDownList the FillCategories() is used. To fetch all the product of the selected categories, called the SelectedIndexChanged of the dropdownlist.

How to: Add, Modify, and Delete Objects (Entity Framework)

Here I have created an Employee page where you can add, modify and delete a new employee from the database through the Entity Framework.

To show all the employees the FillEmployees() has been called on the page load event.

 private void FillEmployees()

        {

            dgridEmployee.DataSource = obNORTHWNDEntities.Employees;

            dgridEmployee.DataBind();

        }

To add the new employee AddNewEmployee() has been used.

 private void AddNewEmployee()

        {

            Employees obEmployee = new Employees();



            obEmployee.EmployeeID = -1;



            obEmployee.FirstName = txtFirstName.Text.Trim();



            obEmployee.LastName = txtLastName.Text.Trim();



            obEmployee.City = txtCity.Text.Trim();



            obEmployee.Country = txtCountry.Text.Trim();



            obNORTHWNDEntities.AddToEmployees(obEmployee);



            obNORTHWNDEntities.SaveChanges();



        }

Since this the new employee that’s why the employeeID has been assigned to -1. After assigning all the values to the new employee object it has to be added to the obNORTHWNDEntities context through the AddToEmployees() method. To save the employee to the database SaveChanges() is called.

For modifying the employee, the EditEmployee() functions has been called.

 private void EditEmployee()

        {



            Employees obEmployee = new Employees();



            int employeeId = Convert.ToInt32(hdnEmployeeId.Value);





            //IQueryable<Employees> employees = from c in obNORTHWNDEntities.Employees

            //                                  where c.EmployeeID == employeeId

            //                                  select c;



            //List<Employees> obCollection = employees.ToList<Employees>();



            //obEmployee = obCollection[0];



            //IQueryable<Employees> emp = obNORTHWNDEntities.Employees.Where("it.EmployeeID=" + employeeId);



            //obEmployee = emp.First();



            obEmployee = obNORTHWNDEntities.Employees.Where("it.EmployeeID=" + employeeId).First();



            obEmployee.FirstName = txtFirstName.Text.Trim();



            obEmployee.LastName = txtLastName.Text.Trim();



            obEmployee.City = txtCity.Text.Trim();



            obEmployee.Country = txtCountry.Text.Trim();



            hdnEmployeeId.Value = string.Empty;





            obNORTHWNDEntities.SaveChanges();

        }

First of all the modified employees information is fatched.

obEmployee = obNORTHWNDEntities.Employees.Where("it.EmployeeID=" + employeeId).First();

you can also use the following code to fetch the employee information

//IQueryable<Employees> employees = from c in obNORTHWNDEntities.Employees

   //                                  where c.EmployeeID == employeeId

   //                                  select c;



   //List<Employees> obCollection = employees.ToList<Employees>();



   //obEmployee = obCollection[0];



After assinging the modified values you need to call the obNORTHWNDEntities.SaveChanges().

Use stored procedure with ADO.NET Entity Framework

1. Create the stored procedure to fetch all the orders of a customer

Create PROCEDURE [dbo].[GetOrderByCustomer] 

@CustomerID nchar(5)

AS

SELECT *

FROM Orders

WHERE CustomerID = @CustomerID

ORDER BY OrderID

2. Now you have to import this stored procedure to your EDM. There are two ways: first you have to regenerate the EDM and import is via the designer, or in second way you can edit the xml file directly. Here we are using the first method.

a. Right click on the Entity Designer View and click on the Update Model from Database.

b. Choose the newly created stored procedure what you want to include.

3. Go to the Model Browser and search the newly imported stored procedure
4. Right click on that stored procedure and then click on Create Function Import.

5. A new Add Function Import window will be opened. Here select the Entities to Orders. Since this function returns the order list.

To fetch all the orders of a customer the above stored procedure is used in the c# code.


   private void FillOrder()

        {

            using (NORTHWNDEntities obNORTHWNDEntities = new NORTHWNDEntities())

            {

                ObjectResult<Orders> objectResultOrder = obNORTHWNDEntities.GetOrderByCustomer("ALFKI");



                dgridOrder.DataSource = objectResultOrder;

                dgridOrder.DataBind();



            }

        }

Mapping the stored procedure

1. Create the stored procedure to insert the new employee


CREATE PROCEDURE InsertEmployee



@FirstName nvarchar(20)

,@LastName nvarchar(20)





AS

BEGIN





INSERT INTO EMPLOYEES

(

 FirstName

 ,LastName



)

VALUES

(

 @FirstName

 ,@LastName

)





SELECT MAX(EmployeeID) as NewEmployeeID FROM Employees



 

END

GO

2. Right click on the Employee entity on the EDM and click on Stored Procedure Mapping.

Once you click on that, you will see the Mapping Details window

Here you can map your insert, update and delete stored procedure. Now you have insertEmployee stored procedure to map this procedure click on the <Select Insert Function> then select the InsertEmployee stored procedure from the dropdownlist box.

Difference between LINQ to SQL and Entity Framework

LINQ to SQL is an object-relational mapping (ORM) framework that allows the direct 1-1 mapping of a Microsoft SQL Server database to .NET classes, and query of the resulting objects using LINQ. More specifically, LINQ to SQL has been developed to target a rapid development scenario against Microsoft SQL Server where the database closely resembles the application object model and the primary concern is increased developer productivity. LINQ2SQL was first released with C# 3.0 and .Net Framework 3.5.

• LINQ to SQL supports a wide breadth of abstractions
• LINQ to SQL support domain Model
• Linq to SQL is only for SQL
• LINQ to SQL is simple to use
• LINQ to SQL is used for rapid development.
• LINQ to SQL class uses the mapping only for the single table
• LINQ to SQL generate only dbml file

LINQ to Entities (ADO.Net Entity Framework) is an ORM (Object Relational Mapper) API which allows for a broad definition of object domain models and their relationships to many different ADO.Net data providers. As such, you can mix and match a number of different database vendors, application servers or protocols to design an aggregated mash-up of objects which are constructed from a variety of tables, sources, services, etc. ADO.Net Framework was released with the .Net Framework 3.5 SP1.

• Entity framework supports a high level of abstraction.
• Entity framework support conceptual data mode.
• Entity Framework will have ability to target different database engines in addition to Microsoft SQL Server.
• Entity framework is complex to use.
• Entity framework is slower development but has more capabilities.
• Entity framework map a single class to multipal tables
• Entity framework generate the three xml files csdl, msl and ssdl.

Reference:
http://blogs.msdn.com/adonet/archive/2007/05/30/entitysql.aspx
http://msdn.microsoft.com/en-us/library/bb399567.aspx

Read and Write from the xml file with C# / ASP.NET

2009-05-12T23:28:00.009+05:30

In this article I have created different methods to read and write from the xml files.
Here are two applications one is class library where I have put all the methods to read and write the xml files and another is a web site.

Example-1: Read the xml file

Here is a Config.xml file in the XMLFile folder. The structure of the file is

<?xml version="1.0" encoding="utf-8" ?>
<root>
<!-- site url-->
<SiteUrl> http://www.site.com</SiteUrl>
<!-- file path-->
<FilePath> c:\\myfolder</FilePath>
<!-- domain name-->
<DomainName> mydoman.com</DomainName>
</root>

Here I have put some comments also. To read this file I have created a class Configure.cs in the class liberary.
To read the element of the xml file I have used the document.GetElementsByTagName() method.

public void GetValues()
{
  XmlDocument document = new XmlDocument();
  XmlNode node = null;
  try
  {
   if (String.IsNullOrEmpty(path))
   {
    return;
   }
  document.Load(path);
  node = document.GetElementsByTagName("SiteUrl").Item(0);
  this.siteUrl = node.InnerText;
  node = document.GetElementsByTagName("FilePath").Item(0);
  this.FilePath = node.InnerText;
  node = document.GetElementsByTagName("DomainName").Item(0);
  this.domainName = node.InnerText;
 }
 catch
 {
  throw;
 }
 finally
 {
  document = null;
  node = null;
 }
}

To write to this file I have created WriteToFile(string filePath, string fileStreamData), where you have to pass the xml file path and data (may be the xml data in string format). For example I have used this function to create the country1. xml file with node "Mydata" in the default.aspx.cs page.

private void WriteToFile()
{
  ReadWriteXMLClassLib.Configure obConfigure = new ReadWriteXMLClassLib.Configure();

  obConfigure.WriteToFile(Server.MapPath("XMLFiles/Country1.xml"), "Mydata");

}

Example-2: Read the xml file

In the previous example there was a no repetition of elements in the file but in this example the xml file structure is different. Here are number of sub nodes or elements (Employee) are more than one and also added the attribute “id” to each sub node.

< ?xml version="1.0" encoding="utf-8" ? >
<?xml version="1.0" encoding="utf-8" ?>
< Employees>
< Employee id="1" >
< Name>Pankaj Saha< /Name>
< Age>26< /Age>
< Address>
< City>Baroda< /City>
< State>Gujaraat< /State>
< /Address>
< /Employee>
< Employee id="2" >
< Name>Sanjay< /Name>
< Age>27< /Age>
< Address>
< City>Baroda< /City>
< State>Gujaraat< /State>
< /Address>
< /Employee>
< /Employees>

To read this xml file I have created a class FileOperataion.cs in the class library. If there is only one Employee node then you can read this node value only with ReadXmlSubNodeValue() method. Since there are multiple nodes that’s why I have used ReadXmlNodeList() method to read all the node list of Employees and then fetch each node of Employees and get the value of each node of Employee through the ReadXmlSubNodeValue() method.

Example-3: Read the xml file

In this example I have used an xml file with the following format

< ?xml version="1.0" encoding="utf-8" ?>
< Countries>
< Country id="1" >India< /Country>
< Country id="2" >US< /Country>
< Country id="3" >Uk< /Country>
< /Countries>

Here each node has an attribute id and each attribute has different values. Now I need to get the node value by their attribute value, for that I have used the ReadXmlNodeList(string fileName, string xmlPath) method to get the node list and then pass each node to ReadXmlSubNodeValue(XmlNode node, string xPath, string attributeName, string attributeValue) method to get values of specific node. For example if you need to get the country which has id=1 then you can use GetCountry(1) method.

private void GetCountry(int countryId)
{
  ReadWriteXMLClassLib.FileOperataion obFileOperataion = new ReadWriteXMLClassLib.FileOperataion();

  XmlNodeList obNodeList = obFileOperataion.ReadXmlNodeList(Server.MapPath("XMLFiles/Country.xml"), "//Countries");

  if (obNodeList != null)
  {
   foreach (XmlNode obNode in obNodeList)
  {
   tdContry.InnerHtml = obFileOperataion.ReadXmlSubNodeValue(obNode, "Country", "id", countryId.ToString());
  }
 }
}

Example-4: Fill gridview from xml file

In this example I have used the country.xml file. You can see in the Example4.aspx page where I have used to read the xml file to the dataset and assigned that dataset to the gridview. To read the xml file I have used the following function

public DataSet GenerateDataSet(string filePath)
{
  DataSet objDataSet = new DataSet();

  objDataSet.ReadXml(filePath);

  return objDataSet;
}

In this function you have to pass the xml file path. You can also pass the xml string, for this you have to use the following function

public DataSet GenerateDataSetWithString(string inputXmlString)
{
  DataSet objDataSet = new DataSet();

  StringReader sr = new StringReader(inputXmlString);

  objDataSet.ReadXml(sr);

  return objDataSet;
}

Example-5: Create and update the xml file

Here I have implemented a product xml file. The format of the xml file is

< ?xml version="1.0" encoding="utf-8"?>
< Items>
< Item>
< Code>101< /Code>
< Name>Product1< /Name>
< Price>100< /Price>
< Qty>12< /Qty>
< /Item>
< Item>
< Code>102< /Code>
< Name>Product2< /Name>
< Price>100< /Price>
< Qty>12< /Qty>
< /Item>
< /Items>

In this example you can add a new item, update the item and delete the items from the xml file.

Example-6: Delete node from xml file / Select Nodes Using XPath Navigation

Whenever you need to delete a node from the xml file, first of all you have to find the node with specified value then delete that node from the file. Here the xml format is

< ?xml version='1.0'?>
< bookstore xmlns="urn:newbooks-schema">
< book genre="novel" style="hardcover">
< title>Book1< /title>
< author>
< first-name>Pankaj< /first-name>
< last-name>Saha< /last-name>
< /author>
< price>19.95< /price>
< /book>
< book genre="novel" style="other">
< title>Book2< /title>
< author>
< first-name>Sanjay< /first-name>
< last-name>Singh< /last-name>
< /author>
< price>11.99< /price>
< /book>
< /bookstore>

public bool DeleteNode(string bookName)
{
  bool isValue = false;

  XmlDocument doc = new XmlDocument();

  try
  {

  string filePath = Server.MapPath("~/XMLFiles/Example6.xml");

  doc.Load(filePath);

  XmlNodeList nodeList;

  XmlNode root = doc.DocumentElement;

  nodeList = root.SelectNodes("descendant::book[title='" + bookName.ToLower() + "']");

  foreach (XmlNode obNode in nodeList)
  {
  root.RemoveChild(obNode);

  break;

  }

  doc.Save(filePath);
 }
 catch
 {
  throw;
 }
 finally
 {
 doc = null;
 }
 return isValue;
}

Example-6: Reading xml file with XmlTextReader

XmlTextReader is the best way when you need to read the xml file without loading the xml file in memory. When you have a very large xml file, which takes lots of time to load in the memory or document object and you need to find or read some values from the xml file then you can use the XmlTextReader class. This will help you to read the xml node value very fast.
Here I am using the Employee.xml file to read the xml file with the help of XmlTextReader class. You need to add the reference of using System.Xml.

 XmlTextReader reader = new XmlTextReader( Server.MapPath(@"~/XMLFiles/Employee.xml"));

 StringBuilder xmlString = new StringBuilder();

 while (reader.Read())
 {
 switch (reader.NodeType)
 {
  case XmlNodeType.Element: // when node is an element
  xmlString.AppendFormat("<" + reader.Name );

  //fetch all the attributes of the node
  while (reader.MoveToNextAttribute())
  {
   xmlString.AppendFormat(" " + reader.Name + "='" + reader.Value + "'");
  }

  xmlString.AppendFormat (">");
  break;
 case XmlNodeType.Text: //fetch the value of xml element
  xmlString.AppendFormat(reader.Value);
 break;
 case XmlNodeType.EndElement: //show the end of the element.
  xmlString.AppendFormat("");

 break;
 }
}

 Response.Write(xmlString.ToString());

Download:

Create row at run time in ASP.NET GridView

2009-04-30T23:52:00.005+05:30

Here I have created an ASP.NET GridView example where you can add, delete and update the row in the GridView at run time.

Steps:

1. Create a asp.net web application

2. Create a global DataTable globalDataTable

3. To create a DataTable first time I have created the following function

private DataTable CreateDataTable()
{
DataTable dtSample = new DataTable();

DataColumn myDataColumn;

myDataColumn = new DataColumn();
myDataColumn.DataType = Type.GetType("System.String");
myDataColumn.ColumnName = "Id";
dtSample.Columns.Add(myDataColumn);

myDataColumn = new DataColumn();
myDataColumn.DataType = Type.GetType("System.String");
myDataColumn.ColumnName = "FirstName";
dtSample.Columns.Add(myDataColumn);

myDataColumn = new DataColumn();
myDataColumn.DataType = Type.GetType("System.String");
myDataColumn.ColumnName = "LastName";
dtSample.Columns.Add(myDataColumn);

return dtSample;
}

First time when the page is loaded it call this function to create the gridview and then store the gridview into the Session["dtSample"]. You can also use viewstate here instead of session.

4. To create a new row in the gridview the following function has been created :

private void AddNewRow(string firstname, string lastname, DataTable myTable)

{

DataRow row;

row = myTable.NewRow();

row["Id"] = myTable.Rows.Count + 1;

row["FirstName"] = firstname;

row["LastName"] = lastname;

myTable.Rows.Add(row);

rowCount = myTable.Rows.Count;

}

6. To Edit and Delete from the gridview the following event has been added to the gridview

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)

{

DataTable userDataTable = (DataTable)Session["dtSample"];

userDataTable.Rows[e.RowIndex].Delete();

Session["dtSample"] = userDataTable;

this.GridView1.DataSource = ((DataTable)Session["dtSample"]).DefaultView;

this.GridView1.DataBind();

}

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)

{

DataTable userDataTable = (DataTable)Session["dtSample"];

if (userDataTable != null)

{

lblMsg.Text = Convert.ToString(userDataTable.Rows[e.NewEditIndex]["Id"]);

txtFirstName.Text = Convert.ToString(userDataTable.Rows[e.NewEditIndex]["FirstName"]);

txtLastName.Text = Convert.ToString(userDataTable.Rows[e.NewEditIndex]["LastName"]);

}

7. We have saved the data on the Submit button click.

protected void btnSubmit_Click(object sender, EventArgs e)

{

if (txtFirstName.Text.Trim() == "")

{

this.lblMsg.Text = "You must fill a name.";

return;

}

else

{

if (lblMsg.Text != "")

{

DataTable dtSample = (DataTable)Session["dtSample"];

for (int iCount = 0; iCount < dtSample.Rows.Count; iCount++)
{
if (Convert.ToString(dtSample.Rows[iCount]["Id"]) == lblMsg.Text)
{
dtSample.Rows[iCount]["FirstName"] = txtFirstName.Text;
dtSample.Rows[iCount]["LastName"] = txtLastName.Text;
}
}
}
else
{
AddNewRow(this.txtFirstName.Text.Trim(), this.txtLastName.Text.Trim(), (DataTable)Session["dtSample"]);
}

this.GridView1.DataSource = ((DataTable)Session["dtSample"]).DefaultView; this.GridView1.DataBind();
this.txtFirstName.Text = "";
this.txtLastName.Text = "";
this.lblMsg.Text = "";
}
}

Download:

Use email template and send email with ASP.NET

2009-04-29T23:00:00.000+05:30

Sometimes you need to send the email with the formatted manner. Here I have created a sample application by which you can send mail with the html template.

Steps:

1. Created an Email Class library, where a SendMail has been created which contins the properties and functions to send the mail.

2. Created a Web Application “EmailApplication” and added the reference of Email Class library.

3. Create the Test.html page to send the formatted mail. With the $ sign you can set the values at the run time. For example if I need to set the title of the email then I used $Title in html page.

4. Set the following things in the web.config file

< key="SmtpServer" value="mail.mailserver.com">
< key="SiteUrl" value="www.mysite.com/default.aspx" />
< key="IsSend" value="Yes">
< key="SendMailBackground" value="Yes">
<system.net>
<mailSettings>
<smtp>
< host="mail.mailserver.com" port="25" username="" password="">
< / smtp >
< / mailSettings >
< / system.net >

Here SmptServer represent the SMTP Server name, SiteUrl represent the your site url , SendMailBackground specify whether the mail should be send by background or not and IsSend represent whether you want to send the mail or not. If you want to stop the mail send facility then you don’t need to change the code you just need to change the web.config file to set the value of IsSend to “No”.

5. To send the mail through the site I have created a UI as Default.aspx, where you have to specify the sender email address, subject, message and attached file.

Download:

Get user Permission from file or folder in asp.net

2009-04-27T20:05:00.000+05:30

Here I have upload the sample example to get the specific user permission on a specified file or folder. To get the permission I have created a function
public string GetDirectoryAccessControlInformation(string objectPath, string userName)
{
---------------------
}

Where we have to pass the file/folder path and the username.

Download:

implement impersonation in an ASP.NET application

2009-04-26T22:52:00.002+05:30

Impersonation in .Net allows you to run an application in a particular user account which is determined by you. Usually the account in which the application runs is ASPNET or NETWORK SERVICE depending on the version of IIS you are running in your machine. With IIS 5.0 the ASPNET account is used and it is not possible to override this account in the web.config file. In the IIS 6.0 you can configure this in the web.config file so that you can run the application on a different user account. With the help of impersonation, application can be run by a different user with different permission levels.
We can implement Impersonation in three ways:

1. Impersonate the Microsoft IIS Authenticated Account or User:

To impersonate the IIS authenticating user on every request for every page in an ASP.NET application, we must include an tag in the Web.config file of this application and set the impersonate attribute to true. By default impersonation is disabled and the anonymous user account is used by IIS.

< impersonate="'">

2. Impersonate a Specific User:
To impersonate a specific user for all the requests on all pages of an ASP.NET application, you can specify the userName and password attributes in the tag of the Web.config file for that application.

< impersonate="'" username="AccountName" password="password">

3. Impersonate through the code:
I have a machine A (Server) from where I have to use its resources. That machine is very secure and does not allow accessing its resources to everyone (Client). To accessing its resources I have to implement the Impersonation. Since there are numbers of users who will access those resources, that’s why I have to implement the Impersonation through the code.

Figure-1

As you can see in the Figrue-1, there is a Machine A and I have to read and write a Myfile.xml file, which is located in the file system of the Machine A. Since no any client can read/write that file, so that I have created a Web Service in ASP.NET and apply the impersonation into that web service, and all the clients can access that web service and easily read/write into that file. You can also implement the same scenario to create/delete the file or folders in the server.

Steps:

1. Create a new web service.

2. Change into the web.config file. Add the following tag in the tag.

< key="FilePath" value="D:\Projects\Impersonation\Myfile.xml">
< key="UserName" value="Pankaj">
< key="Pwd" value="password">
< key="DomainName" value="DomainName">

Change the appropriate values according to the authenticated user of that machine.

3. Include the AuthenticateUser class in the web service. This class is used to impersonate your code.

4. Add the following function to the Service.cs class

private void AuthenticateUser()
{
AuthenticateUser obAuthenticateUser = new AuthenticateUser();
try
{
obAuthenticateUser.Authenticate();
}
catch
{
throw;
}
finally
{
obAuthenticateUser = null;
}

4. Call the AuthenticateUser(); method into the every method of the web service. This method should be the called first in the each method, because this method will authenticate your code to run in the context. For example I have to get the Folder Path from the MyFile.xml, then I have created a function GetFolderPath in the service.asmx.cs file and write the code in the following manner

[WebMethod]
public string GetFolderPath()
{

//authenticate the user
AuthenticateUser();
string folderPath = string.Empty;
FileOperation.FileOperation obFileOperation = new FileOperation.FileOperation();
try
{
folderPath = obFileOperation.FolderPath;
}
catch
{
throw;
}
return folderPath;
}

5. Create a Web Application and add the reference of the web service. Now your web application can read and write the xml file which is located to another machine.

Why I have used Web Service: When we have a two or more then two machines (hosting server), and we need to read/write the file from a specified machine (hosting server) and each machine have different authentication, then web service is the best solution. I will create a web service and integrate each web service in each machine with their specified user authentication. Now each machine have same web service with their authentication to read/write file of that machine. Now any user to read/write that file of any machine then it does not need to be authenticated, since web service is already authenticated, it just need to call the web service of that specified machine. To call the specified web service of a machine, we can call by the setting of url of the web service object at run time. For example, suppose I am userA and I need to access the Machine-A web service to read/write the file of Machine-A. There is also another machine Machine-AA where my web application is hosted. Now I need to access the Machine-A file though the hosted web application of Machine-AA. Then I will pass the IP address of the Machine-A and set the url property of the Machine-A's web service object. i.e.

obMachine-AWebService.Url = "http://" + IPAddressOfmachine-A + "WebserviceName" ;

Now we can access the any machine's file/web service only just passing the IP address of that machine with the same web application.

Download:

Sorting in a Asp.net Gridview with custom data object

2009-04-21T23:32:00.002+05:30

This article explains about how to sort the gridview with the custom object. Here I have used viewstate and no need to any server call for the sorting.
Here I have filled the gridview with all the files or folder within a directory. To get the properties of the file/folder I have created a class FileObject class

public class FileObject
{
private string name;
private string path;
private int size;
private string type;
private string modified;

public string Modified
{
get { return modified; }
set { modified = value; }
}
public string Type
{
get { return type; }
set { type = value; }
}
public int Size
{
get { return size; }
set { size = value; }
}
public string Path
{
get { return path; }
set { path = value; }
}
public string Name
{
get { return name; }
set { name = value; }
}
}

To store all the object to a collection I have created a custom collection class.
public class DataCollection : IEnumerable
{
private List listData = new List();

public T GetData(int index)
{
return listData[index];
}
public void AddData(T c)
{
listData.Add(c);
}
public void ClearData()
{
listData.Clear();
}
public int Count
{
get { return listData.Count; }
}
// IEnumerable extends IEnumerable, therefore
// we need to implement both versions of GetEnumerator().
IEnumerator IEnumerable.GetEnumerator()
{
return listData.GetEnumerator();
}

System.Collections.IEnumerator System.Collections.IEnumerable.GetEnumerator()
{
return listData.GetEnumerator();
}
public void Add(T c)
{
listData.Add(c);
}

}

To sort the data in the collection I have created a GenericComparer class which is inherited from the IComparer.
public sealed class GenericComparer : IComparer
{

public enum SortOrder { Ascending, Descending };

#region member variables

private string sortColumn;

private SortOrder sortingOrder;

#endregion

#region constructor

public GenericComparer(string sortColumn, SortOrder sortingOrder)
{

this.sortColumn = sortColumn;

this.sortingOrder = sortingOrder;

}

#endregion

#region public property

///

/// Column Name(public property of the class) to be sorted.
///

public string SortColumn
{
get { return sortColumn; }
}

///

/// Sorting order.
///

public SortOrder SortingOrder
{
get { return sortingOrder; }
}

#endregion
#region public methods

///

/// Compare interface implementation
///

/// First Object
/// Second Object
/// Result of comparison
public int Compare(T x, T y)
{
PropertyInfo propertyInfo = typeof(T).GetProperty(sortColumn);
IComparable obj1 = (IComparable)propertyInfo.GetValue(x, null);
IComparable obj2 = (IComparable)propertyInfo.GetValue(y, null);
if (sortingOrder == SortOrder.Ascending)
{
return (obj1.CompareTo(obj2));
}
else
{
return (obj2.CompareTo(obj1));
}
}
#endregion
}

To Sort the gridview I have used the following gridview command

protected void dgrid_Sorting(object sender, GridViewSortEventArgs e)
{
if (ViewState["SortBy"] == null)
{
ViewState["SortBy"] = "DESC";
}

else if (ViewState["SortBy"].ToString().Equals("ASC"))
{
ViewState["SortBy"] = "DESC";
}
else
{
ViewState["SortBy"] = "ASC";
}

BindData(e.SortExpression);
}

Thanks for my colleague Poonam to help me for this.

Download:

Validation of XML with XSD in C#

2009-04-20T23:44:00.001+05:30

This article explains about how to validate an XML document with XSD schema. The validation is performed by checking whether the XML document is a well-formed one by programmatically using .NET classes in C#.

Xml Document

xml version="1.0" encoding="utf-8" ?>

<FirstName>PankajFirstName>

<LastName>SahaLastName>

<City>BarodaCity>

<Country>IndiaCountry>

Address>

Employee>

<FirstName>AnimeshFirstName>

<LastName>SingLastName>

<City>BarodaCity>

<Country>IndiaCountry>

Address>

Employee>

Employees >

Here I have created two xsd file, one is valid or another is invalid.

You can create the xsd file from a xml file with the visual studio.

Open the xml file in the visual studio.
Go to the xml menu
click on Create Schema

Figure-1

Figure-2

To created invalid xsd I have removed one tag LastName after the FirstName tag in the valid xsd.

Valid XSD schema

xml version="1.0" encoding="utf-8"?>

<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">

<xs:element name="Employees" >

<xs:complexType>

<xs:sequence maxOccurs ="unbounded" >

<xs:element maxOccurs="unbounded" name="Employee" >

<xs:complexType>

<xs:sequence>

<xs:element name="FirstName" type="xs:string" />

<xs:element name="LastName" type="xs:string" />

<xs:element name="Age" type="xs:unsignedByte" />

<xs:element name="Address">

<xs:complexType>

<xs:sequence>

<xs:element name="City" type="xs:string" />

<xs:element name="Country" type="xs:string" />

xs:sequence>

xs:complexType>

xs:element>

xs:sequence>

xs:complexType>

xs:element>

xs:sequence>

xs:complexType>

xs:element>

xs:schema>

Invalid XSD schema

xml version="1.0" encoding="utf-8"?>

<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">

<xs:element name="Employees">

<xs:complexType>

<xs:sequence>

<xs:element maxOccurs="unbounded" name="Employee">

<xs:complexType>

<xs:sequence>

<xs:element name="FirstName" type="xs:string" />

<xs:element name="Age" type="xs:unsignedByte" />

<xs:element name="Address">

<xs:complexType>

<xs:sequence>

<xs:element name="City" type="xs:string" />

<xs:element name="Country" type="xs:string" />

xs:sequence>

xs:complexType>

xs:element>

xs:sequence>

xs:complexType>

xs:element>

xs:sequence>

xs:complexType>

xs:element>

xs:schema>

To check whether the xml is valid or not I have done the following steps:

1. Created class XmlValidator

2. The ValidationCallBack event is used to define an event handler for receiving the notification about XSD schema validation errors. If any validation error occurs, an exception is thrown, and the XmlValidatingReader cannot be restarted

Conclusion

This article explained about the XML document, XSD schema, and how to validate XML document against XSD schema using Microsoft .NET framework classes.

Download:

Custom paging in asp.net with Jquery

2009-04-19T23:00:00.002+05:30

Here I have created a custom grid with Jquery in Asp.net. When we use web control (datagrid, GridView etc.) in asp.net to show the information then it takes time as the number of users increased. As well as if we have to go for the next page in the Gridview a postback happened and it increase the load on the server. I have used here a Jquery Ajax method to fetch and save the data without postback.

Steps:

Here I have used Link To SQL for the datalayer. I have created the procedures to insertUser (to insert the new user) , GetTotalUserCount (get the total number of users) and GetAllUsers (to fetch all the users).
Created a class user in the datalayer to fetch the users by pageSize, pageNo and SortColumn.
Created a BusinessLayer.
Created JSONHelper.JSON and added the reference to the BusinessLayer. JSONHelper.JSON is used to convert the object to the Json string.
Included the jquery-1.3.2.min.js in the default.aspx page. No need to write any server site code. You can also use any .html page instead of .aspx page.
Include CustomeUserGrid.js and Employee.js files where I fetch the data from the database and also save the new user information
To save/fetch the data from the database with Jquery Ajax method I have created a DataPage.aspx.
Restore the database EmployeeManagement.bak.
Set the default.aspx page Set as start page.

Technolgoes: asp.net 3.5, Linq to SQL, Jquery

Written By: Pankaj Saha

Download:

Thanks my friend Animesh Singh to help me out for this blog.

Copy database diagrams from one database to another database in sqlserver2005

2008-09-17T12:50:00.001+05:30

Generally we face a situation when we need to move the one Database diagram to another Database. Suppose you have created a database A which contains some database diagram and there is the same or different database B which does not contains any database diagram. Now you have to move only the database diagram of A to the B.

The entire diagram’s information is stored in the dbo.sysdiagrams.

If you wish to see the table dbo.sysdiagrams which is in System Table folder of A,then write the following statement

select * from A.dbo.sysdiagrams

It will list all the diagram information.

Now if you need to move or copy the all the diagrams of database A to the B then write the following sql statement and run:

insert into B.dbo.sysdiagrams
select [name], principal_id, version,definition from A.dbo.sysdiagrams

It will copy all the diagrams of database A to the database B

insert into B.dbo.sysdiagrams
select [name],diagram_id , version,definition from A.dbo.sysdiagrams
where diagram_id =13

Paging with Sqlserver2005

2008-09-16T16:33:00.001+05:30

Some time we need to implement the paging concept for our web and windows application. To achieve this we generally do very completed code or we have to do the paging with our controls such as Datagrid, Gridview etc. However this control s may affect the performance of our application. For example if there are 1000000 records and if we implement the paging then we have to do the server site code or if we fetch whole the record from database to the application then it will affect the performance, and if we use web application then we have to very much care about the performance of the application. But don’t worry friends there a very simple procedure to implement the paging through the database. We can filter the recodes in our procedure and then we can fetch only those records what we need.

1. Using the Employees table of northwind

2. Now create a procedure

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

-- =============================================

-- Author: Pankaj Saha

-- Create date:

-- Description: To fetch the records by paging

-- =============================================

CREATE PROCEDURE GetEmployees

@CurrentPageNo int

,@PageSize int

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from

-- interfering with SELECT statements.

SET NOCOUNT ON;

WITH EmployeeCTE

(

select *, ROW_NUMBER() OVER (ORDER BY EmployeeID) AS RowNumber FROM Employees

)

SELECT * FROM EmployeeCTE WHERE RowNumber between ((@CurrentPageNo-1)*@PageSize )+ 1and (@CurrentPageNo*@PageSize-1)

END

3. Execute the following statement

execute GetEmployees 1 ,10

The output would show the top 10 employees information, if you run

execute GetEmployees 2 ,10

The output would be the next 10 records.