Create a common class so that we can make insertupdate easy

Question

i want to create a class so that i can make insertupdatedelete and select/get data in any on my asp.net pages

Gautam Parmar · Answer

Same With Stored Procedure if you id as 0 it will insert record else it will update the record which you have passed id... You can same thing achive in select Record if you pass id than it will retrive single database using if condition else it will retrive all record... create procedure sp_InsertUpdateEmployee @EmployeeId int  @EmployeeName varchar (50) @City varchar (50) AS BEGIN IF(@EmployeeId=0) BEGIN INSERT INTO employeemaster ( EmployeeName City Creationdate ) Values ( @EmployeeId @City GETDATE() ) Select SCOPE_IDENTITY() END ELSE BEGIN UPDATE employeemaster SET EmployeeName=@EmployeeName City=@City ModifiedDate=GETDATE() SELECT @EmployeeId END END

Ramesh Palanivel · Answer

Hi pradish Just create a simple class in your project and declare it as public access. Then write a method to perform insert update delete and get data.. Call the method from your web page and do the actions.

Gautam Parmar · Answer

From this two method you can perfom Insert Update Delete And Retrive Any table data... //For Inserting Record for any table Parameters are Store Procedure Name ANd Array of Sqlparameter public int InsertRecord( string spName SqlParameter[] sqlParamaeter) { int result = 0; using (SqlConnection con = new SqlConnection(ConfigurationManager.Co nnectionStrings[ yourconnectionname ].ConnectionString)) { using (SqlCommand cmd = new SqlCommand(spName con)) { cmd.CommandType = CommandType.StoredProcedure; if (sqlParamaeter != null ) { foreach (SqlParameter sqlp in sqlParamaeter) { cmd.Parameters.Add(sqlp); } } con.open(); result=cmd.ExecuteNonQuery(); con.Close(); } } return result; } //To Retrive Data public DataSet GetRecord( string spName SqlParameter[] sqlParamaeter) { DataSet dt = new DataSet(); using (SqlConnection con = new SqlConnection(ConfigurationManager.Co nnectionStrings[ yourconnectionname ].ConnectionString)) { using (SqlCommand cmd = new SqlCommand(spName con)) { cmd.CommandType = CommandType.StoredProcedure; if (sqlParamaeter != null ) { foreach (SqlParameter sqlp in sqlParamaeter) { cmd.Parameters.Add(sqlp); } } SqlDataAdapter sda = new SqlDataAdapter(); sda.Fill(dt); } } return dt; }

Create a common class so that we can make insert,update easy