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

Pratish Vagadiya

9y970Visual Basic .NET

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Gautam Parmar9y ago
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
+1
Gautam Parmar9y ago
From this two method you can perfom Insert Update Delete And Retrive Any table data...
2. //For Inserting Record for any table Parameters are Store Procedure Name ANd Array of Sqlparameter
3. public int InsertRecord(string spName, SqlParameter[] sqlParamaeter)
4. {
5. int result = 0;
6. using (SqlConnection con = new SqlConnection(ConfigurationManager.Co nnectionStrings["yourconnectionname"].ConnectionString))
7. {
8. using (SqlCommand cmd = new SqlCommand(spName, con))
9. {
10. cmd.CommandType = CommandType.StoredProcedure;
11. if (sqlParamaeter != null)
12. {
13. foreach (SqlParameter sqlp in sqlParamaeter)
14. {
15. cmd.Parameters.Add(sqlp);
16. }
17. }
18. con.open();
19. result=cmd.ExecuteNonQuery();
20. con.Close();
21. }
22. }
23. return result;
24. }
25. //To Retrive Data
26. public DataSet GetRecord(string spName, SqlParameter[] sqlParamaeter)
27. {
28. DataSet dt = new DataSet();
29. using (SqlConnection con = new SqlConnection(ConfigurationManager.Co nnectionStrings["yourconnectionname"].ConnectionString))
30. {
31. using (SqlCommand cmd = new SqlCommand(spName, con))
32. {
33. cmd.CommandType = CommandType.StoredProcedure;
34. if (sqlParamaeter != null)
35. {
36. foreach (SqlParameter sqlp in sqlParamaeter)
37. {
38. cmd.Parameters.Add(sqlp);
39. }
40. }
41. SqlDataAdapter sda = new SqlDataAdapter();
42. sda.Fill(dt);
43. }
44. }
45. return dt;
46. }
0

Ramesh Palanivel9y ago

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.