Exception: Procedure or Function 'sp_ViewSelectedtbJD' expects parameter '@FileNumber' which was not supplied
Code:
private void SelectedRecordsCount()
{
conn = new SqlConnection(@connectionString);
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter();
SqlCommand cmd = new SqlCommand("sp_ViewSelectedtbJD");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@nvarFileID", SqlDbType.Int, 4);
foreach (DataGridViewRow row in dgvViewJDRecords.SelectedRows)
{
cmd.Parameters.Add("@nvarFileID", SqlDbType.Int, 4).Value = Convert.ToInt32(row.Cells["FileNumber"].Value);
//cmd.Connection = conn;
//da.SelectCommand = cmd;
//da.Fill(dt);
}
cmd.Connection = conn;
da.SelectCommand = cmd;
da.Fill(dt);
//foreach (DataGridViewRow row in dgvViewJDRecords.SelectedRows)
//{
// cmd.Parameters["@nvarFileID"].Value = Convert.ToInt32(row.Cells["FileNumber"].Value);
//}
//da.Fill(dt);
}