Insert data in database using user-defined method

Question

Hi all I want to create a user-defined method which helps to insert any type of data into the database For example public DataTable BindGrid(string proc_nme) { con.Open(); DataTable dt = new DataTable(); SqlDataReader dr; cmd = new SqlCommand(proc_nme, con); dr = cmd.ExecuteReader(); dt.Load(dr); return dt; } This is the method for getting data from the database we have to only pass the procedure name. As the same, I want to create a method for insertion. Thanks in advance.

Dhrutika Rathod · Answer

Hi, Below code will help you to insert data. public int AddUser(AddEditUserModel objAddUser) { using (SqlConnection Con = new SqlConnection(ConnectionString)) { using (SqlCommand cmd = new SqlCommand("Insert_User", Con)) { int Success =0; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@FirstName", SqlDbType.NVarChar, 50)).Value = objAddUser.FirstName; cmd.Parameters.Add(new SqlParameter("@LastName", SqlDbType.NVarChar, 50)).Value = objAddUser.LastName; cmd.Parameters.Add(new SqlParameter("@DOB", SqlDbType.NVarChar, 50)).Value = objAddUser.DOB; SqlParameter paramOutPut = new SqlParameter("@ReturnValue", SqlDbType.Int); paramOutPut.Size = 15; paramOutPut.Direction = ParameterDirection.Output; cmd.Parameters.Add(paramOutPut); cmd.Connection.Open(); object resultValue = cmd.ExecuteNonQuery(); if (cmd.Parameters["@ReturnValue"].Value != DBNull.Value) Success = Convert.ToInt32(cmd.Parameters["@ReturnValue"].Value); cmd.Connection.Close(); return Success; } } }