Home / Technology

Using PayPal’s PayFlowPro to setup Recurring Billing in

16.04.2013   gyanendra   No comments

First step is to set up a business account with PayPal in addition to creating an Internet Merchant Account which will allow you to work with PFP. These tasks are

Server Error in ‘/’ Application, The resource cannot be found

16.04.2013   gyanendra   No comments

The resource cannot be found. Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily

Unable to convert MySQL date/time value to System.DateTime

The problem in the format, actually mysql have a different format (yyyy-mm-dd) for the date/time data type and to solve this problem adding this to the connection string  ( web.config):

Remove query limit of 1000 from MySQL Workbench

2.04.2013   gyanendra   My SQL   1 Comment

1.  Go to Edit -> Preferences. 2.  Click on the SQL Editor tab. 3.  Under Query Editor, uncheck Limit Rows. 4.  Enjoy!

Drop all the tables, stored procedures, triggers, constriants and all the dependencies in one sql statement

Lot many times people asking me how to delete or drop all object like SP, Table and views of any table. For them i have written following solution. /* Drop

SQL Server Message: Prevent saving changes that require the table re-creation

I have seen and faces following issue most of the time .. when you are going to alter the table .. Saving Changes in not permitted. The changes you have

Reset AutoIncrement in SqlServer after Delete

Hi, This is most common issue face everybody in day to day life, to resolve this use following command to reseed mytable to start at 1:  DBCC CHECKIDENT (mytable, RESEED,1)