Insert data in database using user-defined method

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.

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;

}

1 Reply

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