Monday, August 31, 2009

Hanging A Punching Bag, Doorway

As allowed to read files from Excel 2007 64-bit systems (x64)

Perhaps this might happen when working on either Windows Vista or Windows 7 x64 my case, I tried to read an Excel 2007 file from an application . NET and gave me the following error:

Microsoft.ACE.OLEDB.12.0

provider is not registered on the local computer. or English

The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine.

It turns out that this is because there is no office for x64 drivers, so you have to change the type of compilation of the application, which defaults to "Any CPU" to "x86", this in the properties -> Build.

With this we can read the files as normal, something I hope they serve.

Hanging A Punching Bag, Doorway

As allowed to read files from Excel 2007 64-bit systems (x64)

Perhaps this might happen when working on either Windows Vista or Windows 7 x64 my case, I tried to read an Excel 2007 file from an application . NET and gave me the following error:

Microsoft.ACE.OLEDB.12.0

provider is not registered on the local computer. or English

The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine.

It turns out that this is because there is no office for x64 drivers, so you have to change the type of compilation of the application, which defaults to "Any CPU" to "x86", this in the properties -> Build.

With this we can read the files as normal, something I hope they serve.

Lindberg Men Frames Prices

Using Client Application Services Part 02

In previous post talked about how to create an application that allows us to manage user access now see how we can use the ASP membership service. NET in a Windows Forms application that was what he was not available before.

1. Creating the Client application

Let's create a simple Windows Forms application as shown in the image:

image

As this is only illustrative not need to create a complex application.

2. Linking

Service

Now we will integrate the service they had created previously to make use of validation users, for them we go to the project you just created and right click-> Properties, there we see the left side we have a Services tab, that's where you enable Client Application Services, the check mark and entered the data as shown in the image:

image

also must add a reference to System.Web in our project right click-> Add Reference on the NET tab look for the assembly and add it, this is for that we can use Class Membership in our application.

3. Validating Users

We will work in the form's Load event, within this will the following code to validate the credentials of a user if they are correct will be shown the form, otherwise it will display a message and close the application.

   if (! Membership.ValidateUser ("User  ", "Password  ")) {

MessageBox.Show ("Invalid User ");
this . Close ();}


Now we can validate user data, even if belonging to validate a role, all that could be done in ASP. NET 2.0 in terms of users, now available for use by other applications, not only that, but also enables centralized user management.



was helpful I hope this post, if there was something that became clear, do not hesitate to leave your comments, also attached the example source code so they can review it.



Download Code Example