title: I've tried different ways but still it's throwing an error that cannot convert varchar to int
body: <pre><code>private void button_submit_Click(object sender, EventArgs e)
          {
  
              con = new OleDbConnection("Provider=SQLNCLI11;Data Source=.;Integrated Security=SSPI;Initial Catalog=AdventureWorks2012");
              cmd = new OleDbCommand();
              cmd.CommandType = CommandType.StoredProcedure;
              cmd.CommandText = "usp_empinfo";
              cmd.Connection = con;
              cmd.Parameters.AddWithValue("@bid",textBox_BID.Text);
              cmd.Parameters.AddWithValue("@job",SqlDbType.VarChar).Direction = ParameterDirection.Output;
              cmd.Parameters.AddWithValue("@gender",SqlDbType.VarChar).Direction = ParameterDirection.Output;
              cmd.Parameters.AddWithValue("@maritalstatus",SqlDbType.VarChar).Direction = ParameterDirection.Output;
              con.Open();
              cmd.ExecuteNonQuery();
              label_Job.Text =label_Job.Text + "" + cmd.Parameters["@job"].Value.ToString();
              label_gender.Text=label_gender.Text + "" + cmd.Parameters["@gender"].Value.ToString();
              label_MStatus.Text=label_MStatus.Text + "" + cmd.Parameters["@maritalstatus"].Value.ToString();
  
          }
  </code></pre>
  
  <p>My stored procedure with input and output parameters:</p>
  
  <pre><code>alter PROC USP_EMPINFO
  @bid AS varchar(20),
  @job as varchar(20) output,
  @gender as varchar(20) output,
  @maritalstatus as varchar(20) output
  as
  begin
  select @Job=JobTitle,@Gender=Gender,@maritalstatus=MaritalStatus  from humanresources.employee
  where BusinessEntityID = @bid
  end
  </code></pre>