Hijri Date to Gregorian Date or Vice Versa Sql Server

Hijri Date to Gregorian Date or Vice Versa Sql Server:

SELECT

GETDATE() [Today Date],

CONVERT(VARCHAR(11),GETDATE(),131) [Hijri Date],

CONVERT(datetime, CONVERT(VARCHAR(11),GETDATE(),131), 131) [Gregorian Date]

The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine

To resolve this issue open the project in Visual Studio then:

 

1. From the solution explorer right-click your project then click Properties

2. Click the Build tab

3. Change Platform target from: Any CPU to x86

4. Re-build your solution

How to: Send Data Using the WebRequest Class

using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Net;
using System.Text;
using System.Threading.Tasks;

namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {

//The remote server returned an error: (417) Expectation Failed.
System.Net.ServicePointManager.Expect100Continue = false;

            // Create a request using a URL that can receive a post.
            WebRequest request = WebRequest.Create("http://www.contoso.com/PostAccepter.aspx ");
            // Set the Method property of the request to POST.
            request.Method = "POST";
            // Create POST data and convert it to a byte array.
            string postData = "This is a test that posts this string to a Web server.";
            byte[] byteArray = Encoding.UTF8.GetBytes(postData);
            // Set the ContentType property of the WebRequest.
            request.ContentType = "application/x-www-form-urlencoded";
            // Set the ContentLength property of the WebRequest.
            request.ContentLength = byteArray.Length;
            // Get the request stream.
            Stream dataStream = request.GetRequestStream();
            // Write the data to the request stream.
            dataStream.Write(byteArray, 0, byteArray.Length);
            // Close the Stream object.
            dataStream.Close();
            // Get the response.
            WebResponse response = request.GetResponse();
            // Display the status.
            Console.WriteLine(((HttpWebResponse)response).StatusDescription);
            // Get the stream containing content returned by the server.
            dataStream = response.GetResponseStream();
            // Open the stream using a StreamReader for easy access.
            StreamReader reader = new StreamReader(dataStream);
            // Read the content.
            string responseFromServer = reader.ReadToEnd();
            // Display the content.
            Console.WriteLine(responseFromServer);
            // Clean up the streams.
            reader.Close();
            dataStream.Close();
            response.Close();
        }
    }
}

The remote server returned an error: (417) Expectation Failed.

Solution :::

System.Net.ServicePointManager.Expect100Continue = false; (at first line)

add above line above WebRequest.......

// Create a request using a URL that can receive a post. 

WebRequest request = WebRequest.Create("http://www.contoso.com/PostAccepter.aspx ");

Could not load file or assembly or one of its dependencies. Access is denied. The issue is random, but after it happens once, it continues

C:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files. 

Google told me that their might be permission issue against current user, then i found i have Current Identity: IIS APPPOOL in malfunctioning server where as rest of server have Current Identity: NT AUTHORITY\NETWORK SERVICE. then i changed Current Identity from IIS APPPOOL to NT AUTHORITY\NETWORK SERVICE. then found after recompiling(modification in web.config recompile the web application), i have found Temporary ASP.NET Files. which now malfunctioning server start creating temp file.

Other Labels:


System.IO.FileLoadException: Could not load file or assembly

Solution to "Could not load file or assembly or one of its dependencies. Access is denied"

Could not load file or assembly '******' or one of its dependencies. Access is denied.

C#: Could not load types from assembly

How to change port address in WampServer

WampServer Port Number Change




1. Open httpd.conf file (left click on right bottom on wamp server icon -> Apache -> httpd.conf)




2. Search (Find) -> Listen 80




3. change 80 with desired port number




4. restart wamp server




Have Fun :)

Handler "PageHandlerFactory-Integrated" has a bad module "ManagedPipelineHandler" in its module list

IIS 7.5 error: Handler “PageHandlerFactory-Integrated” has a bad module “ManagedPipelineHandler” in its module list

Handler "PageHandlerFactory-Integrated" has a bad module "ManagedPipelineHandler" in its module list

Execute this command:


Start -> All Programs -> Microsoft Visual Studio 2010 -> Visual Studio Tools -> Visual Studio Command Prompt (2010)


NOW Paste this command


Solution: %windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis.exe -i

iPhone 4

Beginning February 10, the phone that changed everything will be available on both AT&T and Verizon Wireless in the United States. Qualified Verizon Wireless customers will also have the exclusive opportunity to pre-order iPhone 4 online on February 3, ahead of general availability.
Whichever network you choose, you’ll get FaceTime video calling, the high-resolution Retina display, a 5-megapixel camera, HD video recording, long battery life, and all the other great features of iPhone 4.
Source

Top 10 reasons to try Office 2010

Express your ideas more visually.

Office 2010 opens up a world of design options to help you express your ideas with more impact. New and improved picture formatting tools, such as color saturation and artistic effects, let you transform your visuals into works of art. And a wide range of new customizable themes and SmartArt® graphic layouts offer more ways to make your ideas stick.

Accomplish more when working together.

Brainstorm ideas, keep versions in sync, and meet deadlines faster when you’re working in groups. Co-authoring in Word 2010, PowerPoint 2010, Excel Web App, and OneNote 2010 shared notebooks enable you to edit the same file at the same time with other people — even when they’re in different locations.¹

Enjoy the familiar Office experience from more locations and devices.

With Office 2010, you can get things done on your schedule.

• Microsoft Office Web Apps. Extend your Office 2010 experience to the Web. Store your Word, Excel, PowerPoint, and OneNote files online and then access, view, edit, and share content from virtually anywhere.²
• Microsoft Office Mobile. Stay current and respond quickly using new mobile versions of Office applications designed specifically for your Windows Phone 7 device.³
• Microsoft SharePoint Workspace 2010. Synchronize SharePoint 2010 lists and libraries with SharePoint Workspace, formerly known as Microsoft Office Groove, so you can access, view, and edit files anytime and anywhere from your computer. Everything will automatically sync to the SharePoint server when you’re back online.

How to Download Microsoft Visual Studio 2010 for free from Microsoft DreamSpark

Microsoft Visual Studio2010 is the set of new software development tools, like Visual C++, VisualBasic, Visual C#(C-Sharp), J#,F# etc. You can develop all kinds of applications using this tool, Desktop, Mobile, LightSwitch, Cloud and Web Sites etc. Microsoft Visual Studio 2010 has some editions which includes Ultimate, Express, Professional , Premium etc. Microsoft provides such Development tools on Microsoft DreamSpark. Microsoft DreamSpark is a platform from where you can get free Professional, Development softwares for the students all around the world.Microsoft DreamSpark provides help to the students who want their programming skills to grow or their innovations to be created. Like DreamSpark says:

DREAM TODAY, CREATE TOMORROW

As we told you guys earlier about Microsoft Visual Studio 2010. Microsoft Visual Studio 2010 is also available free for the students to learn and develop applications to enhance their developing abilities. Now you can also download Microsoft Visual Studio 2010 Professional and Microsoft Visual Studio 2010 Express for free, from “Microsoft DreamSpark”.
There are three simple steps:

• Sign In.
• Get Verified.
• Download.

Followinf is the whole procedure of downloading Microsoft Visual Studio 2010 from Microsoft DreamSpark:
1-Log onto DreamSpark.

2-For downloading Microsoft Visual Studio 2010 for free, first of all you have to Sign In with your Hotmail ID, if you don’t have one then get it from Live.

Hewlett Packard in Photofair 2011 New Delhi [Pictures]

Everyone wants to save every moment of his/her life in the form of photos. Hewlett Packard’s imaging and Printing Group allows you to do it in what way you want with the help of smart and cool printers from HP IPG. Recently , the pioneer in the Imaging and Printing field in the world , exhibits its latest and innovative digital printing technology along with the solutions through an outstanding kind of display at ‘Photofair 2011’ being held at Pragati Maidan, New Delhi , India. Photofair 2011 is India’s largest exhibition of photography equipment & accessories.

This New Year began with innovative eye-catching applications showcased by HP which attracted a large number of visitors to the stall. HP cares a lot about its customers and it wants to provide technology to preserve their memorable pictures and that is the main demand of the customers.