Step towards Dot Net

How to open Visual studio 2012 solution in Visual studio 2010?

2014-07-11T00:01:00.001-07:00

As we know that if we have lower version solution then we can open it in upper version but in case of reverse it doesn't allow us to open. In this case we get incompatibility problem. We can make it position by doing some changes in solution file, config file and project file.

In this article, I will explain - How to open Visual studio 2012 solution in Visual studio 2010?

To make it position, Just follow the below steps-

Step 1 -

Open your solution file (.sln) and replace "Format Version 12.00" with "Format Version 11.00"

Step 2 -

Open App.config and replace sku=".NETFramework,Version=v4.5" with sku=".NETFramework,Version=v4.0"

Step 3 -

Open your project file and replace

<TargetFrameworkVersion>v4.5</TargetFrameworkVersion> with
<TargetFrameworkVersion>v4.0</TargetFrameworkVersion>

Finally save all the changes and close the files. Now just try to open your solution in Visual studio 2010. It will be opened.

Thanks

How to know SQL Server Version using backup file?

2014-03-06T02:13:00.003-08:00

Backup and restore these are common tasks while working with the database. But before restoring the database it is necessary that we should know about some information about backup file because it may be possible that we have created backup file in upper version of SQL Server and we are trying to restore it in lower version of SQL Server. In this is case database can not be restored.

So before facing this problem it is better to know about backup file means in which version it was created.

To get this information we can simply use RESTORE command with HEADERONLY. Check the bellow command -

RESTORE HEADERONLY
FROM DISK = N'd:\filename.bak'

By passing the path of backup file you can run this command, you will get result like this-

By seeing SoftwareVersionMajor and SoftwareVersionMinor you can identify the version of the software.

To know about each column help follow this link-

http://technet.microsoft.com/en-us/library/ms178536.aspx

Here you will get description for each column.

How to avoid ContextSwitchDeadlock exception?

2014-03-05T06:24:00.000-08:00

In some of the cases we face the problem regarding ContextSwitchDeadlock. Actually there are some causes for this exception.

You can check these causes by following this link-

http://msdn.microsoft.com/en-us/library/ms172233%28v=vs.110%29.aspx

In this article, I am explaining - "How can we avoid ContextSwitchDeadlock exception?"

To void the this exception, we need to set some setting in Visual Studio IDE, Check the below steps-

1. Click on "Debug" Menu.
2. After that Click on "Exceptions".
3. It will open one Exception window. Here expand the node- "Manage Debugging Assistants".
4. Here you will find "ContextSwitchDeadlock" CheckBox, just uncheck it.

Follow-

Debug-> Exceptions-> Manage Debugging Assistants -> ContextSwitchDeadlock

Check the below screen shot-

Just uncheck it and again run the application, This exception will be skipped while run-time.

How to Compare the Objects in .Net (Real story of Equals() method)

2014-02-28T00:49:00.000-08:00

Comparing objects is really a big story because we don’t have any direct method to compare the object (Except reference comparison). If we want to compare the object reference then we can use Object .Equals () but it is not useful when we want to compare the object properties.

Equals () method compares the references not the properties or values of the object. So it will not any help when we have requirement to compare the object properties or values.

Let me take the small example for this. Check the below code-

private void btnEquals_Click(object sender, EventArgs e)
        {
            try
            {
                ClsEmployee objEmp1 = new ClsEmployee();
                ClsEmployee objEmp2 = new ClsEmployee();
                ClsEmployee objEmp3 = new ClsEmployee();

                //Assigning value to objEmp1
                objEmp1.intEmpId = 1;
                objEmp1.intEmpName = "Jitendra";

                //Assigning value to objEmp2
                objEmp2.intEmpId = 1;
                objEmp2.intEmpName = "Jitendra";

                //Assigning objEmp3 with objEmp1 (Reference)
                objEmp3 = objEmp1;

                //Comparing objEmp1 and objEmp2
                if (objEmp1.Equals(objEmp2))
                {
                    MessageBox.Show("Object objEmp1 and objEmp2 are same");
                }
                else
                {
                    MessageBox.Show("Object objEmp1 and objEmp2 are not same");
                }

                //Comparing objEmp1 and objEmp3
                if (objEmp1.Equals(objEmp3))
                {
                    MessageBox.Show("Object objEmp1 and objEmp3 are same");
                }
                else
                {
                    MessageBox.Show("Object objEmp1 and objEmp3 not are not same");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

In above code, I have assigned the same value to objEmp1 and objEmp2 but
objEmp1.Equals(objEmp2) will return False because objEmp1 and objEmp2 represents different references.

objEmp1.Equals(objEmp3) will return True because before comparing the object I have assigned objEmp3 = objEmp1, so here both will represent the same reference.

So here is the question- What if we want to compare the object properties?

Solution-

Here we have solution for this- We can make use of Reflection. Using reflection we can compare thee the properties of object with the help of PropertyInfo class. This class provides the information about the property.

You can find the difference based on following points-

1.   If the type of objects are not same
2.   If number of properties in objects are not same
3.   If any property is missing in second object
4.   If value of properties are not same
5.   If any object is null

For this add the below namespace-

using System.Reflection;

Check the below example-

    //Employee Class
    public class ClsEmployee
    {
        public Int32 intEmpId { get; set; }
        public string intEmpName { get; set; }
        public ClsDept objClsDept { get; set; }
    }

    //Dept Class
    public class ClsDept
    {
        public Int32 intDeptId { get; set; }
        public string intDeptName { get; set; }
    }

//Code to compare object using PropertyInfo Class
        private void btnCompareProInfo_Click(object sender, EventArgs e)
        {
            try
            {
                ClsEmployee objEmp1 = new ClsEmployee();
                ClsEmployee objEmp2 = new ClsEmployee();
                ClsEmployee objEmp3 = new ClsEmployee();

                //Assigning value to objEmp1
                objEmp1.intEmpId = 1;
                objEmp1.intEmpName = "Jitendra";
                objEmp1.objClsDept = new ClsDept();
                objEmp1.objClsDept.intDeptId = 1;
                objEmp1.objClsDept.intDeptName = "AC";

                //Assigning value to objEmp2
                objEmp2.intEmpId = 1;
                objEmp2.intEmpName = "Jitendra";
                objEmp2.objClsDept = new ClsDept();
                objEmp2.objClsDept.intDeptId = 1;
                objEmp2.objClsDept.intDeptName = "AC";

                //Assigning value to objEmp3
                objEmp3.intEmpId = 1;
                objEmp3.intEmpName = "Jitendra";

                //Comparing objEmp1 and objEmp2
                if (CompareObjects(objEmp1, objEmp2))
                {
                    MessageBox.Show("Object objEmp1 and objEmp2 are same");
                }
                else
                {
                    MessageBox.Show("Object objEmp1 and objEmp2 are not same");
                }

                //Comparing objEmp1 and objEmp3
                if (CompareObjects(objEmp1, objEmp3))
                {
                    MessageBox.Show("Object objEmp1 and objEmp3 are same");
                }
                else
                {
                    MessageBox.Show("Object objEmp1 and objEmp3 are not same");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        //Method to compare Object
        private Boolean CompareObjects(object obj1, object obj2)
        {
            Boolean isEqual = true;
            try
            {
                //If any object is null then returning false
                if (obj1 == null || obj2 == null)
                {
                    return false;
                }
                //If object types are different then returning false
                if (obj1.GetType() != obj2.GetType())
                {
                    return false;
                }

                //Getting list of properties
                PropertyInfo[] obj1PInfo = obj1.GetType().GetProperties();
                PropertyInfo[] obj2PInfo = obj2.GetType().GetProperties();

                //If number of properties are not same then return false
                if (obj1PInfo.Count() != obj2PInfo.Count())
                {
                    return false;
                }

                //Looping each child property
                for (int index = 0; index < obj1PInfo.Count(); index++)
                {
                    //Getting child property
                    PropertyInfo objChild1PInfo = obj1PInfo[index];
                    Object propValue1 = objChild1PInfo.GetValue(obj1, null);

                    Object propValue2 = null;

                    //Checking same property is not present in second object then return false
                    if (obj2PInfo.Contains(objChild1PInfo) == false)
                    {
                        return false;
                    }
                    else
                    {
                        PropertyInfo objChild2PInfo = obj2PInfo[index];
                        propValue2 = objChild2PInfo.GetValue(obj2, null);
                    }

                    //If object contains any child property (as class type) then compare child properties also
                    if (Enum.IsDefined(typeof(System.TypeCode), objChild1PInfo.PropertyType.Name) == false)
                    {
                        isEqual = CompareObjects(propValue1, propValue2);
                    }
                    else
                    {
                        if (Convert.ToString(propValue1) != Convert.ToString(propValue2))
                        {
                            return false;
                        }
                    }
                }
                return isEqual;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
    }

In above code, I have written one method (CompareObjects()) to compare the object s.
Boolean CompareObjects(object obj1, object obj2)- In this method I have used PropertyInfo class get the information about each property in objects. This method will compare the object based on points as I have given above.

So the result of (CompareObjects(objEmp1, objEmp2)) will be True because both object have same values And result of (CompareObjects(objEmp1, objEmp3)) will be False because both object have different values.

Note- This code will also work if you have any child classes.

How to generate alphabet sequence A, B, C, ....., Z, AAA, AAB,....., ZZZ in C#

2014-02-24T04:15:00.002-08:00

In some of the cases we use alphabet for sequence. If we have options less then 27 then   we can direct use A-Z alphabet but if the options are more then we have to generate sequence.

Check the below logic to generate the alphabet sequence like -     A, B, C, ....., Z, AAA, AAB,....., ZZZ

private void btnGenerate_Click(object sender, EventArgs e)
        {
            List<string> lstSquence = new List<string>();

            int i = 0;
            //Generating 1000 alphabet sequence
            while (i < 1000)
            {
                lstSquence.Add(GenerateSequence(i));
                i++;
            }
        }

        //Method to generate alphabet sequence
        static string GenerateSequence(int index)
        {
            string result = string.Empty;
            while (index > 0)
            {
                index = index - 1;
                result = char.ConvertFromUtf32(65+ index % 26) + result;
                index = index / 26;
            }
            return result;
        }


This logic will generate the alphabet sequence like -     A, B, C, ....., Z, AAA, AAB,....., ZZZ

How to disable or enable all the validation of the page?

2014-02-03T03:35:00.002-08:00

To disable or enable the validation of the page we can simply use this JQuery code-

Check this below code-

        //Function to Enable/ Disable all validation
        function EnableValidation(boolFlag) {
            //Turn on/off all validation
            $.each(Page_Validators, function (index, validator) {
                ValidatorEnable(validator, boolFlag);
            });
        }
Now you can call this function. Just pass boolean value to enable or disable the validations.

To disable the validations-

EnableValidation(false);

To enable the validations-

EnableValidation(true);

Considerations for SQL Server Replication

2014-01-30T20:42:00.001-08:00

There are some points to consider while implementing replication. These points include some technical and environment requirements for the replication, means in this article, I will explain about configuration setting for SQL Server replication.

Check the below points, here you will get clear idea about configuration for replication-

1. Select the proper version of SQL Server

As we know that there are different versions of SQL Server present in the market, so it must that first we have to select proper SQL Server version for replication.

Below table will make you understand to select proper version of SQL Server for Replication.

Reference from- SQL Server Versions

By seeing above table, we can easily identify suitable version of SQL Server for our requirement.

2. Name of the Server (Use actual name of server)

While implementing replication, we should use name of the server (Actual Name of the Server) not IP address, If the user logins to server using IP (without actual SQL Server Name) then the replication wizard for creating publication will not work and it will generate error like this-

So, we should use Server Name not IP Address of server.

3. Start SQL Server Agent Service

This service should be started before going for replication, to start this we can get list of services using the Control Panel and then we can start.

Follow this - Control Panel\All Control Panel Items\Administrative Tools\Services

By default, the SQL Server Agent service is disabled when SQL Server is installed unless you explicitly choose to auto start the service during installation.

4. Enable the TCP IP Ports of SQL Server Instance

TCP IP Ports of SQL Server should be enabled because data transfer is done using TCP Protocol.
To enable this just open the SQL Server Configuration manager and Check for SQL Server Network Configuration, Here we will find Protocols for SQL Server Instance. Just right click on TCP/IP protocol and enable it.

5. Enable the Named Pipes of SQL Server Instance

As we have enabled the TCP IP Ports, the same way we have to enable Named pipes using the SQL Server Configuration manager.
You can see below image, Here TCP/IP port and Names Pipes are enabled.

6. Turn off the Firewall settings

In replication web synchronization requires additional ports to be opened on the firewall because of that firewall should be turned off.

7. Sufficient Disk Space

It may be possible that numbers of Subscribers are more, so in this case we should be more careful about disk space because after synchronization all the database will be sync and this require more space. Synchronization generates high values of data so it is must that we should have sufficient disk space to save the data.

8. High Bandwidth

It is must that Bandwidth should be good because In case of large amount of data, it uses large amount of bandwidth. Database synchronization will be fast in case of high bandwidth.

9. Proper Database design

It is must that database should be designed properly to reduce possibility of conflict. It may be possible, conflict may occur but if our database design is proper then conflict can be resolved very easily.

We can consider these points while designing database structure-

(i) For Update Conflict- Each record should have one column to track update time of the record so that while resolving the conflict, we can decide that which record should be reflected (Publisher or Subscriber record). By this way update conflict can be solved very easily.

(ii) For Insert Conflict- Each record should have primary key, it should not repeat at other subscriber also because after synchronization all records will be in same place. By this way insert conflict will not occur.

Like this, we can reduce possibility of conflict.

10. Selection of replication type

It is must that we should well-known about types of replication before implementing replication because we have to select the proper type of replication based on our environment.

These are the considerations, when we go for replication. By following these points implementation of replication can be done easily.

How to change connection string for EDMX in runtime?

2014-01-30T05:06:00.002-08:00

In some cases, we need to change the connection string of edmx model in run time; we can change it from code behind code.

In this article, I am explaining - How to change connection string for EDMX in runtime?

Check the below code-

protected void btnGetData_Click(object sender, EventArgs e)
        {
            try
            {
                TestDBEntities context = new TestDBEntities(GetConnectionString("DBName"));
                var result1 = from data in context.tab_Employees
                                       select data;
                gvEmpDetails.DataSource = result1.ToList();
                gvEmpDetails.DataBind();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

//Method to get connection string
        private string GetConnectionString(string strDBName)
        {
            SqlConnectionStringBuilder sqlBuilder;
            EntityConnectionStringBuilder entityBuilder;
            try
            {
                sqlBuilder = new SqlConnectionStringBuilder();
                sqlBuilder.DataSource = @"server name";
                sqlBuilder.InitialCatalog = strDBName;
                sqlBuilder.IntegratedSecurity = true;
                sqlBuilder.MultipleActiveResultSets = true;

                entityBuilder = new EntityConnectionStringBuilder();
                entityBuilder.Provider = "System.Data.SqlClient";
                entityBuilder.ProviderConnectionString = sqlBuilder.ToString();
                entityBuilder.Metadata = @"res://*/ModelName.csdl|res://*/ModelName.ssdl|res://*/ModelName.msl";
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            return entityBuilder.ToString();
        }

In above code, while creating connection string, you need to pass details for connection string. Like-
Database name, Server name etc.

Here ModelName= Name of the model which you have created while generating edmx.

How to avoid or lock enter key in form?

2014-01-30T05:04:00.003-08:00

Use this simple code to avoid enter key on form-

<script type="text/javascript">
        $(document).keypress(
                    function (event) {
                        if (event.which == '13') {
                            event.preventDefault();
                            }
                                    }
                            );
</script>

How to insert bulk record into database using SQL Server,C# and XML

2014-01-08T05:13:00.002-08:00

If we have list of records then we can not process each record to insert into database because it is time taking process and it will degrade the performance.In this case we can use bulk insert. Suppose if we have bulk record in xml then we can easily dump that xml record into database.

Check the below code sample to insert bulk record.

Suppose this is sample XML string -

XML Data String

<?xml version='1.0' encoding='utf-8'?>
<Employees>
<Emp>
    <EmpID>101</EmpID>
    <EmpName>Jitendra</EmpName>
    <Age>27</Age>
</Emp>
<Emp>
    <EmpID>102</EmpID>
    <EmpName>Ramesh</EmpName>
    <Age>30</Age>
</Emp>
<Emp>
    <EmpID>103</EmpID>
    <EmpName>Raj</EmpName>
    <Age>24</Age>
</Emp>
</Employees>

Now check the below stored procedure –

Stored Procedure

This stored proceduer will take the XML string as input and it will process this XML to insert into table.

--Stored procedure to insert bulk record using XML

CREATE PROCEDURE [dbo].[SP_EmpBulkInsert]
(    @XMLData text    )
AS
BEGIN
SET NOCOUNT ON
BEGIN TRANSACTION
Begin Try

DECLARE @XMLDocPointer INT
EXEC sp_xml_preparedocument @XMLDocPointer OUTPUT, @XMLData

   INSERT INTO tab_Employees
   (EmpID, EmpName, Age)
   SELECT EmpID,EmpName,Age
   FROM OPENXML(@XMLDocPointer,'/Employees/Emp',2)
   WITH (EmpID INT,EmpName nvarchar(50),Age INT)

   EXEC sp_xml_removedocument @XMLDocPointer
   COMMIT TRANSACTION
   Return 0;
End Try
Begin Catch
   ROLLBACK TRANSACTION
End Catch
END

In this stored procedure I am inserting data into tab_Employees table, based on column selection data will be inserted to this table. Now chek the below code to call this stored procedure from C# application.

C# Code-

//Code to insert bulk records
        private void btnBulkInsert_Click(object sender, EventArgs e)
        {
            try
            {
                //Code to insert bulk record using XML
                string strConnectionString = "Your connection string";
                //Getting XML string
                string strXML = GetXMLString();

                //Connecting to database
                using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection())
                {
                    conn.ConnectionString = Convert.ToString(strConnectionString);
                    System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("SP_EmpBulkInsert", conn);
                    cmd.Parameters.AddWithValue("@XMLData", strXML);
                    cmd.CommandType = CommandType.StoredProcedure;
                    conn.Open();
                    cmd.ExecuteNonQuery();
                    conn.Close();
                    MessageBox.Show("Records inserted successfully.");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

         //XML string to insert bulk record
        private string GetXMLString()
        {
            return @"<?xml version='1.0' encoding='utf-8'?>
<Employees>
<Emp>
    <EmpID>101</EmpID>
    <EmpName>Jitendra</EmpName>
    <Age>27</Age>
</Emp>
<Emp>
    <EmpID>102</EmpID>
    <EmpName>Ramesh</EmpName>
    <Age>30</Age>
</Emp>
<Emp>
    <EmpID>103</EmpID>
    <EmpName>Raj</EmpName>
    <Age>24</Age>
</Emp>
</Employees>";
        }

In above code, I am getting XML string using GetXMLString() method. After getting the XML string I am passing this string as parameter for stored procedure. Finally when this code will be executed then you will find the new records in tab_Employees table.

The process cannot access the file because it is being used by another process

2013-10-29T01:59:00.004-07:00

Problem-

The process cannot access the file because it is being used by another process

This is common problem, when we create file using File.Create() method.

Reason-

When we use File.Create() method to create file then the object of FileStream class is created and no other process can use or access the created file until the file is closed.

Solution -

This problem can be easily resolved by modifying your code like this-

File.Create (@"c:\Text.txt").Close();

Means use Close () with File.Create () method. It will create the file and after that it will close the related file.

How to make DatePicker control as null or empty in Windows Application?

2013-10-01T23:01:00.005-07:00

This is common problem with DatePicker control - We cannot assign null or empty value to its value property. In this case, showing DatePicker control as empty is bit difficult. I have done one work around for this and now I am able to show empty DatePicker control.

In this article, I will explain - How to make DatePicker control as null or empty?

Check the below code implementation.

Workaround-

To make it possible, I have used "CustomFormat" property of DatePicker control.

//To set DatePicker Control format as "MM/yyyy"
private void dtPickerDOB_ValueChanged(object sender, EventArgs e)
{
   dtPickerDOB.Format = DateTimePickerFormat.Custom;
   dtPickerDOB.CustomFormat = "MM/yyyy";
}

In above code, I am setting CustomFormat = "MM/yyyy". So the date will be displayed like this- "10/2013"

Now to make this DatePicker cotrol as empty-

//To make DatePicker Control as empty
private void btnClearDate_Click(object sender, EventArgs e)
{
// Setting CustomFormat as Space.
dtPickerDOB.Format = DateTimePickerFormat.Custom;
dtPickerDOB.CustomFormat = " ";
}

In above code, I have set CustomFormat = " " so empty value will be displayed in DatePicker control.

Try this code

Thanks

How to get index of node based on node value using XSLT?

2013-07-22T06:23:00.004-07:00

While working with XML in some of the cases, we want to get the index or position of particular value. This can be easily done by using XSLT.

In this article, I am explaining - How to get index of node based on node value using XSLT?

Example-

Suppose, I have this XML data-

<ResponseData>
    <value>C</value>
    <value>A</value>
    <value>B</value>
</Response>

Now if I want to get the position of ‘A’ then It should return '2' .

How to get it-

This is small XSLT code to get this position-


<xsl:variable name="TempData" select="A"/>


<xsl:value-of select="count(//abc:ResponseData/abc:value[text()=$TempData]/preceding-sibling::*)+1" />

In above line I have declared one variable - 'TempData'
and using select I have assigned value -'A'

Now to get the position of 'A', I have used count() method.

Here this expression -

count(//abc:ResponseData/abc:value[text()=$TempData]/preceding-sibling::*)+1

Will return the count of preceding sibling of A, which will be position of 'A'.

Like 'A', we can also get the position of other Values ('B' and 'C'), for this we need to assign this value to 'TempData' variable.

Thanks

How to copy data from Virtual machine to our local machine?

2013-04-24T06:51:00.002-07:00

This is common task to work in virtual machine, while working in virtual machine sometime we have a requirement that we need to copy data from virtual machine to our local machine.

There is no direct method to copy the data from virtual machine and paste it to our local machine.

But this can be easily done by simple trick.

In this article I am explaining - How to copy data from Virtual machine to our local machine?

Follow these steps-

1. First create one folder in your local machine.

2. Make that folder as shared; means share this folder for everyone. You can just use sharing tab in properties window of that folder.

3. After share that folder now accesses that folder from Virtual machine.

4. Once you will access that shared folder you will be able to copy data from virtual machine to that shared folder.

Now you are done.

Now you can see data in your local machine.

Thanks

How to use JQuery Accordion in ASP.Net?

2013-03-21T05:56:00.003-07:00

Asp.net Ajax Control Toolkit contains Accordion control, but it is server side control which is heavy weight. We have another alternative of Ajax Accordion Control. We can use JQuery Accordion. Jquery Accordion control is client side control so it is faster that Ajax Accordion control.

In this article I am explaining - How to use JQuery Accordion in ASP.Net?

To use JQuery Accordion first we need to include Jquery plug-in. You can easily download those .CSS and .JS files from jqueryui.com. After downloading those files create your directory structure like this-

http://steptodotnet.blogspot.in/2011/12/jquery-popup-window-in-aspnet.html

In this link you can see the solution structure.

Now here is the code to use Jquery Accordion control-

<head runat="server">
    <script src="Scripts/jquery-1.4.1.min.js" type="text/javascript"></script>
    <script src="Scripts/jquery-ui-1.8.20.custom.min.js" type="text/javascript"></script>
    <link href="Css/jquery-ui-1.8.20.custom.css" rel="stylesheet" type="text/css" />
    <title></title>
    <script>
        $(function () {
            $("#accordion").accordion();
        });
    </script>
</head>

<body>
    <form id="form1" runat="server">
    <div>
        <div id="accordion" style="width: 400px">
            <h3>
                <a href="#">Section 1</a></h3>
            <div>
                Section 1 Description
            </div>
            <h3>
                <a href="#">Section 2</a></h3>
            <div>
                Section 2 Description
            </div>
            <h3>
                <a href="#">Section 3</a></h3>
            <div>
                Section 3 Description
            </div>
        </div>
    </div>
    </form>
</body>

In above code I have included Source files(.js files) and CSS files. Now to make Accordion to work I have written this lines of code-

<script>
        $(function () {
            $("#accordion").accordion();
        });
   </script>

Here "accordion" is the name of Div control which contains Child divs, These Child divs will be displayed as Accordion sections.

Output will be like this-

Note-

This example needs JQuery plug-in so after downloading include these files .js and .cs files in your project .

Thanks

Using #Region in Dot Net

2013-03-21T04:55:00.002-07:00

The #region directive allows organizing code files. Using #region directive we can separate the code. We can create separate region for each code block. Means to declare the variables, constants, functions etc we can use different code block by separating using #region directive.

Here is the example-

// region 1
#region Public Variables
Public int value1
Public int value2
#endregion

//region 2
#region Methods
public string GetData()
{
--------
--------
}
#endregion

in above example we can see that I have created 2 region.

region1 for Public variables
region2 for methods

Like this we can create other regions also.

There are some benefits of using #region directive.

1. Separation of code
2. Readability
3. Easy to maintain
4. Easy to expand or collapse the code block
5. Easy to move entire code block

It is good to use #region directive while doing coding.

Thanks

RichTextBox losing formatting : Workaround

2013-03-07T21:53:00.002-08:00

Problem-

This is the common problem with RichTextBox, when we set any setting like - bold, Italic or Underline, then RichTextBox loses previous setting/formatting. Means it doesn't preserve previous settings.

Example-

We have Text -   Jitendra Faye

after making bold it should be - Jitendra Faye

But output will be - Jitendra Faye

means here RichTextBox not maintaining previous setting UnderLine.

In this article I am explaining - How to maintain RichTextBox setting while applying new settings?

I also faced same problem and came with one work around.

Solution-

This problem can be solved by setting new formatting to each character instead of going for whole string.

Here is the code-

To make Text as Bold

private void btnBold_Click(object sender, EventArgs e)
        {
            int selStart = rtfBox.SelectionStart;
            int selLength = rtfBox.SelectionLength;
            int selEnd = selStart + selLength;

            if (rtfBox.SelectionFont.Bold)
            {
                for (int x = selStart; x <= selEnd - 1; x++)
                {
                    rtfBox.Select(x, 1);
                    rtfBox.SelectionFont = new Font(rtfBox.Font, rtfBox.SelectionFont.Style & ~FontStyle.Bold);

                }
            }
            else
            {
                for (int x = selStart; x <= selEnd - 1; x++)
                {
                    rtfBox.Select(x, 1);
                    rtfBox.SelectionFont = new Font(rtfBox.Font, rtfBox.SelectionFont.Style | FontStyle.Bold);
                }
            }

        }

To make Text as Italic

private void btnItalic_Click(object sender, EventArgs e)
        {
            int selStart = rtfBox.SelectionStart;
            int selLength = rtfBox.SelectionLength;
            int selEnd = selStart + selLength;

            if (rtfBox.SelectionFont.Italic)
            {
                for (int x = selStart; x <= selEnd - 1; x++)
                {
                    rtfBox.Select(x, 1);
                    rtfBox.SelectionFont = new Font(rtfBox.Font, rtfBox.SelectionFont.Style & ~FontStyle.Italic);
                }
            }
            else
            {
                for (int x = selStart; x <= selEnd - 1; x++)
                {
                    rtfBox.Select(x, 1);
                    rtfBox.SelectionFont = new Font(rtfBox.Font, rtfBox.SelectionFont.Style | FontStyle.Italic);
                }
            }
        }

To make Text as UnderLine

private void btnUnderLine_Click(object sender, EventArgs e)
        {
            int selStart = rtfBox.SelectionStart;
            int selLength = rtfBox.SelectionLength;
            int selEnd = selStart + selLength;

            if (rtfBox.SelectionFont.Underline)
            {
                for (int x = selStart; x <= selEnd - 1; x++)
                {
                    rtfBox.Select(x, 1);
                    rtfBox.SelectionFont = new Font(rtfBox.Font, rtfBox.SelectionFont.Style & ~FontStyle.Underline);

                }
            }
            else
            {
                for (int x = selStart; x <= selEnd - 1; x++)
                {
                    rtfBox.Select(x, 1);
                    rtfBox.SelectionFont = new Font(rtfBox.Font, rtfBox.SelectionFont.Style | FontStyle.Underline);
                }
            }
        }

In above code you can toggle for Bold, Italic and UnderLine by maintaining previous setting also.

Try this code.

Thanks

How to download file using C#?

2013-02-27T05:37:00.005-08:00

In some of the cases we need to download file from the Internet, In this article I am explaining-

How to download file using C#?

For this I have used WebResponse, WebRequest Classes so we need to include System.Net Namespace.To download the file from Internet we have to make request to particular object so that I have used webRequest class object. After getting the response from the server we need to handle that response so I have used webResponse class object.

For displaying downloading process I have used ProgressBar control.

Here is the code-

private void btnDownLoadFile_Click(object sender, EventArgs e)
        {

            WebRequest requestObj ;
            WebResponse responseObj;
            Stream readerData ;
            Stream writerData ;
            byte[] data = new byte[1024];
            int count = 0;
            int total = 0;
            this.Text = "Downloading file .....";

            string DestinationFileName= "TargetLocation";
            string SourceLocation= "SourceLocation";

            Application.DoEvents();

            try
            {
                requestObj = WebRequest.Create(SourceLocation);
                responseObj = requestObj.GetResponse();
                readerData = responseObj.GetResponseStream();
                progressBar1.Maximum = Convert.ToInt32(responseObj .ContentLength);
                progressBar1.Value = 0;
                total = 0;
                writerData = File.Create(DestinationFileName);
                while (true)
                {
                    count = readerData .Read(data, 0, 1024);
                    if (count <= 0)
                    {
                        break;
                    }
                    writerData.Write(data, 0, count);
                    total += 1024;
                    if (total < progressBar1.Maximum)
                        progressBar1.Value = total;
                    Application.DoEvents();
                }
                readerData .Close();
                writerData.Close();
                MessageBox.Show("Download completed...");
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error: " + ex.Message);
            }
        }

In above code, I am making request to download file using WebRequest Class object, for that I am passing source file url to download file.

requestObj = WebRequest.Create(TargetLocation);

After making request we will get response, using this line of code-

responseObj = requestObj.GetResponse();

Now using using Stream class object I am reading and writing data to the target file.

count = readerData .Read(data, 0, 1024);

writerData.Write(data, 0, count);

Meanwhile for displaying the download process, I am showing progressbar. Based on data read and write progressbar value will be increased which will show downloading process.

Output-

Thanks

How to update record without primary key?

2013-02-17T22:39:00.000-08:00

If we have any primary key in table then it is very easy to update the records in the database table, but generally we face problem when we don't have primary in table because on that time we can not use any particular column to update records because that column can contain duplicate values.

But there is work around for this problem, we can use” ROW_NUMBER()” function to generate identity value for each record and then based on that “ROW_NUMBER” we can delete record from the table.

In this article, I am explaining - How to update nth record of the table?
Or
How to update record without primary key?

For this I am using “ROW_NUMBER()” function in query, Here is syntax -

Syntax-

WITH Record AS (SELECT *, ROW_NUMBER() OVER (ORDER BY [ColumnName]) AS rownum FROM TableName where condition) update Record set col1=value ,col2=value where Record.rownum = value

Example-

WITH Record AS (SELECT *, ROW_NUMBER() OVER (ORDER BY EmpName) AS rownum FROM tab_Employee ) update Record set Age=25 ,Salary=45000 where Record.rownum = 1

In this example, “ROW_NUMBER()” is a function which will generate sequence number for each record, here ordering will be based on EmpName column, you can change it.

Here "rownum" will be additional column in the result set, this will be used to update the record.

Here “Record “ is result set.

Try this example.

Thanks

How to make Single Click and Double Click Events work together in windows form?

2013-01-03T21:00:00.005-08:00

While working with Windows Application, This is common problem that- Single Click and Double Click Events don't work together (If you have any processing code in Single Click Event like- Showing message using MessageBox), means if we have written some code in Single Click Event and some lines of code in Double Click Event then always Single Click Event code will be executed.

I also faced same problem and came with one workaround.

See this example-

private void Form1_Click(object sender, EventArgs e)
        {
            MessageBox.Show("Single Click Event");
        }

private void Form1_DoubleClick(object sender, EventArgs e)
        {
            MessageBox.Show("Double Click Event");
        }

In above lines of code always Single Click Event code will be executed and always output will be - Single Click only.

In this article, I am explaining - How to make Single Click and Double Click Events work together?

Workaround-

To resolve this problem, I have taken one Timer Control, using Timer control I am handling the Single and Double Click Events functionalities.

Here is the code-

        private void Form1_Load(object sender, EventArgs e)
        {
            timer1.Interval = SystemInformation.DoubleClickTime;
        }

        private void Form1_Click(object sender, EventArgs e)
        {
            timer1.Enabled = true;
        }

        private void Form1_DoubleClick(object sender, EventArgs e)
        {
            timer1.Enabled = false;
            MessageBox.Show("Double Click Event");
        }

        private void timer1_Tick(object sender, EventArgs e)
        {
            timer1.Enabled = false;
            MessageBox.Show("Single Click Event");
        }

In above code, first I am setting Timer Interval as System Double Click Time value. This can be different based on Operating System Settings.

private void Form1_Load(object sender, EventArgs e)
        {
            timer1.Interval = SystemInformation.DoubleClickTime;
        }

Now in Single Click Event, I am just enabling the Timer to execute the code which is written in Tick() Event of Timer.

private void Form1_Click(object sender, EventArgs e)
        {
            timer1.Enabled = true;

        }

In Tick() event write the code which you want to execute in Single Click Event.

    private void timer1_Tick(object sender, EventArgs e)
        {
            timer1.Enabled = false;
            MessageBox.Show("Single Click Event");
        }

Here I am disabling the Timer Control also because this code will be executed once.

Now this is Double Click Event code-

private void Form1_DoubleClick(object sender, EventArgs e)
        {
            timer1.Enabled = false;
            MessageBox.Show("Double Click Event");
        }

Here I am just disabling the Timer Control; here you need to put actual Double Click Event code.

Here all the functionalities depend on Timer Control, Here making Timer control enable and disable is making trick for us.

Try this code.

Thanks

How to get HTML Table cell value on click event?

2012-12-18T03:29:00.002-08:00

In some of the cases we want to access the value of HTML table cell value when we click on particular cell, this can be simply done using client side code only.

Here I am giving simple code to access HTML table cell value.

<script type="text/javascript">
        $(document).ready(function () {
            $('table[id$=TableName] tr>td').click(function () {
                alert($(this).parent()[0].cells[0].innerText);
            });
        });
</script>

This is JavaScript code; here I have used JQuery to get value. Here first I have integrated one function with table cell. This function will be executed when

we will click on cell. To get cell value I have written this line of code-

alert($(this).parent()[0].cells[0].innerText);

This alert() will display value of cell.

Thanks

How to implement data annotation in MVC Razor?

2012-11-28T05:11:00.002-08:00

Validation :

Validation is most important process for any of the application. This process prevents wrong input to the application. For generating the meaningful output it is must that input should be meaningful because based on input only application generates output.

Like other application we can also implement validation process for our MVC application also, in this article, I am explaining – How to implement validation using data annotation in MVC application.

To implement validation I have used Data annotation, for this first we need to use “System.ComponentModel.DataAnnotations” namespace in our application. Here I am giving step by step implementation.

Step1:

Create one simple MVC Application, for this open Visual Studio and select “New Project” option then select “Asp.Net MVC Application Template”.

After creating new application you will find default MVC folder structure.

Step2:

Now right click on “Models” folder and add one Class, I have added by named- “EmployeeModels.cs”.

Here I have declared some properties like this-

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.ComponentModel.DataAnnotations;

namespace DataAnnotationArticle.Models
{
    public class EmployeeModels
    {
        public int ID { get; set; }

       //Validation for empty input
        [Required(ErrorMessage ="First Name can't be empty.")]
        public string FisrtName { get; set; }

       //Validation for length of string
        [StringLength(10, ErrorMessage = "Last Name length can't be greater than 10.")]
        public string LastName{ get; set; }

    }
}

As you can see that I have added reference of “System.ComponentModel.DataAnnotations” Namespace which will help us to implement validation over data using data annotation.

For this I have set some validation over properties like this-

        [Required(ErrorMessage ="First Name can't be empty.")]
        public string FisrtName { get; set; }

        [StringLength(10, ErrorMessage = "Last Name length can't be greater than 10.")]
        public string LastName{ get; set; }

We have other properties also based on our need we can implement other validation.

Step3:

Now add one controller, for this right click on “Controller” folder and click on “Add Controller” option, I have added by named- “EmployeeController.cs”. I have written controller code like this-

public ActionResult EmployeeView()
        {
            return View();
        }

Now we have to bind this ActionResult with one View.

Step4

To bind this ActionResult with View, Just right click on “EmployeeView()“ and you will get menu list here click on “Add View …” option after that you will get one dialog, like this-

Fill the details here like I have given Now Finally say “OK”, then View will be created automatically with following lines of code-

@model DataAnnotationArticle.Models.EmployeeModels

@{
    ViewBag.Title = "EmployeeView";
}

<h2>EmployeeView</h2>

<script src="@Url.Content("~/Scripts/jquery.validate.min.js")" type="text/javascript"></script>
<script src="@Url.Content("~/Scripts/jquery.validate.unobtrusive.min.js")" type="text/javascript"></script>
@using (Html.BeginForm()) {
    @Html.ValidationSummary(true)
    <fieldset>
        <legend>EmployeeModels</legend>

        <div class="editor-label">
            @Html.LabelFor(model => model.FisrtName )
        </div>
        <div class="editor-field">
            @Html.EditorFor(model => model.FisrtName )
            @Html.ValidationMessageFor(model => model.FisrtName )
        </div>

        <div class="editor-label">
            @Html.LabelFor(model => model.LastName )
        </div>
        <div class="editor-field">
            @Html.EditorFor(model => model.LastName )
            @Html.ValidationMessageFor(model => model.LastName )
        </div>

        <p>
            <input type="submit" value="Create" />
        </p>
    </fieldset>
}

<div>
    @Html.ActionLink("Back to List", "Index")
</div>

Here we can see that, one user input form is generated with validation. This is because of “Create” option which we have set at the time of view creation.   For validating user input code is already written, this code will perform user validation based on this JavaScript files-

<script src="@Url.Content("~/Scripts/jquery.validate.min.js")" type="text/javascript"></script>
<script src="@Url.Content("~/Scripts/jquery.validate.unobtrusive.min.js")" type="text/javascript"></script>

Finally our solution explorer structure will be like this-

Now you are done, to test the application just run your application and give some invalid input to the control like I have given , Here we can see the output-

Here we can see that the validation which we have given in EmployeeModels.CS that is taking place for wrong input. Like this we can validation other controls also.

Thanks

How to add ToolTip for DropDownList Items?

2012-11-27T03:26:00.002-08:00

ToolTip-

ToolTip is a small piece of information, which is used to show some idea or information about control and control's functionality. This is most important when we are using icons for performing the operations. In every application it plays very important role either for web applications or windows applications.

Generally it is invisible but when we put mouse over any control then related ToolTip automatically gets visible.

In this article, I am explaining - How to add ToolTip for DropDownList Items?

Generally DropDownList doesn't have any direct property or method to set ToopTip for DropDowbList items; here I am giving simple code to add ToopTip for DropDownList items.

Write this code in Page_Load() event-

protected void Page_Load(object sender, EventArgs e)
    {
        foreach (ListItem item in DropDownList1.Items)
        {
            //Adding ToolTip for each item of DropDownList
              item.Attributes.Add("title", "item - "+ item.Text );
        }
    }

In above code, I have used foreach loop to iterate each item of DropDownList. Here insidse loop, I am using Attributes.Add() method to add title (ToopTip) to each item.

    //Adding ToolTip for each item of DropDownList
   item.Attributes.Add("title", "item - "+ item.Text );

Here "title" is client side property of controls, using this property ToolTip can be added for any controls. Using Attributes.Add() method we can also add any other client side method to any control.

The output of this code will be this this-

Thanks

How to disable back button of browser?

2012-11-27T03:15:00.002-08:00

This is common requirement for all the web application to disable back button of browser after log-out. But there is no direct method or property to disable back button of browser. This only depends on browser cache or history, if browser contains any history or cache then back button will be active after log-out also.

Here I am explaining - How to disable back button of browser?

This can be possible using only after clearing history or cache of browser.
or
Don't allow browser to keep history or cache.

For this we can add this code for all the pages to which we don't want to allow cache.

Here is code-

protected void Page_Load(object sender, EventArgs e)
        {
            Response.Buffer = true;
            Response.ExpiresAbsolute = DateTime.Now.AddDays(-1d);
            Response.Expires = -1000;
            Response.CacheControl = "no-cache";
        }

In this code, I am written code to disallowing browser to cache the page. So that even after browsing the page browser will not keep page as cache or history.

This code should be included for all the pages.

Thanks

How to change NewDataSet xml root name while creating xml using WriteXml() method of Dataset?

2012-11-02T06:22:00.003-07:00

This is default behavior of WriteXml() method when we create xml then it adds <NewDataSet> node as root xml node and <Table> as child node. In this article, I am explaining- How to change <NewDataSet> xml root name while creating xml using WriteXml() method of Dataset?

Let first see the default case-

Suppose you we have one DataSet object ds and we are filling it will data source, like this-

Dataset ds= new DataSet();
ds= datasource;

After that we are using WriteXml() method to create XML, like this-

ds.WriteXml("FileName");

Then in this case output will be like this-

<NewDataSet>
<Table>
    <Emp_ID>717</Emp_ID>
    <Emp_Name>Jitendra Faye</Emp_Name>
    <Salary>35000</Salary>
</Table>
----------
----------
----------
</NewDataSet>

Here we can see that <NewDataSet> and   <Table> is default tag here.

Now to change these default tag follow this code, Here I am changing <NewDataSet> tag as <EmployeeRecords> tag and <Table> tag as <Employee> tag.

Here is code-

Dataset ds= new DataSet();
ds= datasource;

//Giving Name to DataSet, which will be displayed as root tag

ds.DataSetName="EmployeeRecords";

//Giving Name to DataTable, which will be displayed as child tag

ds.Tables[0].TableName = "Employee";

//Creating XML file
ds.WriteXml("FilePath");

Now after executing this above code generated XML file will be like this-

<EmployeeRecords>
<Employee>
    <Emp_ID>717</Emp_ID>
    <Emp_Name>Jitendra Faye</Emp_Name>
    <Salary>35000</Salary>
</Employee>
----------
----------
----------
</EmployeeRecords>

Here we can see that DataSet name is coming as root tag and DataTable name is coming as child tag.

Note-

Before giving name to DataTable (ds.Tables[0].TableName) first check that it should not be null otherwise it will cause an error.

Thanks