[RESOLVED] [2.0] Which Is to use Add or AddWithValue

[shakti5385]

Hi all
I just create my first stored procedures
I am using that one in the C# now related to command I have some question that want to use for adding the parameter in the command.
.Add
or
.AddWithValue

private DatabaseHelper dataBaseHelper = new DatabaseHelper("SQLServer");
public string Name
    {
        get
        {
            return _Name;
        }
        set
        {
            _Name = value;
        }
    }
 
    public string LastName
    {
        get
        {
            return _LastName;
        }
        set
        {
            _LastName = value;
        }
    }
 
 System.Data.SqlClient.SqlCommand sqlCommand = new System.Data.SqlClient.SqlCommand();
 sqlCommand = dataBaseHelper.ReturnStoredProcedureCommand();
 
//Now what TO USE this code
 
 sqlCommand.Parameters.Add("@Name", SqlDbType.VarChar).Value = Name;
            sqlCommand.Parameters.Add("@LastName", SqlDbType.VarChar).Value = LastName;
 
//oR this code
 
sqlCommand.Parameters.AddWithValue("@Name",Name);
            sqlCommand.Parameters.AddWithValue("@LastName",LastName);
 
 sqlCommand.ExecuteNonQuery();

Please tell me also that where I Pass the stored procure name??

Thanks