Printable View
Hi I am wondering if anyone has ever used pay pal solution integrated with asp.net web project? Currently, I signed up for pay pal service that allows me to have the code to place on my website. It's free, but will be charged when there's a payment made through the customers. What I want to accomplish is able to once the client pays the money, allow them access in my sql server database.
Hey,
What exactly do you mean, provide them access to your SQL Server? This doesn't seem to have anything to do with your original question regarding paypal?!?
If I have understood you correctly, you would need to provide them with a login with access to your SQL Server, once they have provided you with a payment.
Gary
No... not that way. I meant like the user makes purchase on the website, which is handled by the pay pal, but I want system to automatically give them instance access once the payment is approved and I don't have to go to the db to give them access..
Hey,
The way I understand it is this....
You collect the information regarding the purchase, you submit this information to pay pal, and they collect the users payment information, pay pal completes the transaction, and returns control back to your site, at which point, based on a successful transaction, you can do other work.
In your case, the other work will be providing access to your SQL Server. I personally have never programmatically added users to a SQL Server instance, I have always preferred to control this through an IDE like SQL Server Management Studio, but that is not to say that it can't be done. You would just need to execute the necessary SQL to add permissions for the user that you want.
You can find an example of this here:
http://www.visualbasic.happycodings....uff/code1.html
Hope that helps!
Gary
I should point out that the above link is using an ADODB connection, which is considered outdated, in preference to an ADO.Net connection to the database, however, the technique is the same.
Gary
To do it in .NET, you'd use the SMO classes. Some sample code here (read the entire thread for some corrections. You need to create a login first, make a user, assign the user to a login, then create)