Simple Insert, Update, And Delete, Using Csharp COM

Hi,

Few Days Back I was Assigned work To Create Something for classic Asp After Some Gooooogling i have not found solution as I want..I got in Bit and Pieces..
So i Deceided to Write Simple Code for Data Interaction in Csharp and which is used in
Classic Asp..

This Bloog Contains Simple Insert Update and Delete in Classic asp With Csharp

Let Starts ...

What We Reuiquire????....

1} Windows Machine(having IIS Support)
2}VS2008,VS2005 or Dotnet Framework(2.0,3,3.5)
3}SqlServer2000,Sqlserver2005
4} More Than Anyting INTEREST IN DOING THING..

LET START THE Process..

Step1 } Open Project Select DLL Project














2} Once U have added Project Add One Class File of Insert,Update and Delete I have Only Added For Insert Record














3} Know Adding DataBase in Your Sqlserver2000














4}Creating a Table in Which Data Would Be Stored















5} Know Adding Website For Debugging in dotent Enviroment
So That we can debug our COM before Deployment















6} Know Refernceing DLL In Your DebugProject














8} Know Making Your DLL COM VISIBLE














9} Know Creating Strong Key for DLL

Go start->Vs2008->Tools->cmd













10} Know Adding Strong Key To Application














11} Know Registrating Dll Into Reistery There Command Regasm /code base














12} Know Reistring Your DLL In GAC














13} Know Seeing Message When Data Is Sucessfully Entered.. I had Only Shown a Sample For Insert














14} If Error Ocuurs The Message Seen Is














15} Know Unregistraing Your Dll From Resitry (Or using Regasm)














16} Know Unstialling Your Dll From GAC














Know U have Follwed Whole Step..For Creating COM In Chsarp
Alway Rember To restart The IIS Every Time U Register or UnRegister
The DLL On Server

You Can Download Complete Source Code from
Follwing Link:--

http://www.mediafire.com/?sharekey=5082eaf05dd192a9c79b87b207592a1ce04e75f6e8ebb871