Hi,
I want to Search User accroding to DOB. See below code.
I want to select all user whose dob between 01-01-1980 and 01--01-1990
ERROR IS:
Parameter '@dob' was supplied multiple times.
DAL:
public DataSet FindCandidate1(int code, DateTime sta, DateTime end)
{
cmd = new SqlCommand("Sp_Recruit_Job", cls.connect());
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@JobCode", SqlDbType.Int)).Value = code;
cmd.Parameters.Add(new SqlParameter("@dob", SqlDbType.DateTime)).Value = sta;
cmd.Parameters.Add(new SqlParameter("@dob", SqlDbType.DateTime)).Value = end;
cmd.Parameters.Add(new SqlParameter("@callval", SqlDbType.Int)).Value = 1;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
return ds;
}
BAL:
public DataSet FindCandidate1(int code, DateTime sta, DateTime end)
{
FetchDataDal FDB = new FetchDataDal();
try
{
return FDB.FindCandidate1(code, sta, end);
}
catch
{
throw;
}
finally
{
FDB = null;
}
}
C#:
public void FindCandidate()
{
FetchDataBal FDB = new FetchDataBal();
DataSet ds = new DataSet();
ds = FDB.FindCandidate1(Convert.ToInt32(ddl_position.SelectedItem.Value), Convert.ToDateTime(txtFrom.Text), Convert.ToDateTime(txtBetween.Text));
RadGrid2.DataSource = ds;
RadGrid2.DataBind();
}
protected void btn_search_Click(object sender, EventArgs e)
{
FindCandidate();
}
Stored Procedure:
if @callval=1
begin
select rp_tbl_personal_details.c_f_name + '' +c_m_name + ''+ c_l_name as name,
rp_tbl_personal_details.dob,
rp_tbl_academic_details.prof_qual ,rp_tbl_academic_details.grad_qual,
rp_tbl_academic_details.prof_stream,rp_tbl_academic_details.prof_year,
rp_tbl_academic_details.grad_stream,rp_tbl_academic_details.grad_year,
rp_tbl_professional.ex_yyyy,
rp_tbl_family.assignment1,rp_tbl_family.assignment2,rp_tbl_family.assignment3,
rp_tbl_family.assignment4,rp_tbl_family.assignment5,
rp_tbl_professional.emp_gross,rp_tbl_CreateNewJob.JobCode,rp_tbl_CreateNewJob.Position,
rp_tbl_ApplyforJob.email,rp_tbl_ApplyforJob.TimeReq,rp_tbl_ApplyforJob.ExpSalary,
dtInterview = case rp_tbl_ApplyforJob.dtInterview
when 1 then 'Any Day'
when 2 then 'Week Day'
when 3 then 'Weekends'
else 'Other'
end
from rp_tbl_CreateNewJob inner join rp_tbl_ApplyforJob
on rp_tbl_CreateNewJob.JobCode=rp_tbl_ApplyforJob.JobCode
inner join rp_tbl_personal_details on
rp_tbl_ApplyforJob.email=rp_tbl_personal_details.email
inner join rp_tbl_academic_details on
rp_tbl_personal_details.personal_id=rp_tbl_academic_details.personal_id
inner join rp_tbl_family on rp_tbl_academic_details.academic_id=rp_tbl_family.academic_id
inner join
rp_tbl_professional on
rp_tbl_family.family_id=rp_tbl_professional.family_id
where rp_tbl_CreateNewJob.JobCode = @JobCode and
rp_tbl_personal_details.dob BETWEEN @dob and @dob
endif @callval=10
begin
select rp_tbl_personal_details.c_f_name + '' +c_m_name + ''+ c_l_name as name,
rp_tbl_personal_details.dob,
rp_tbl_academic_details.prof_qual ,rp_tbl_academic_details.grad_qual,
rp_tbl_academic_details.prof_stream,rp_tbl_academic_details.prof_year,
rp_tbl_academic_details.grad_stream,rp_tbl_academic_details.grad_year,
rp_tbl_professional.ex_yyyy,
rp_tbl_family.assignment1,rp_tbl_family.assignment2,rp_tbl_family.assignment3,
rp_tbl_family.assignment4,rp_tbl_family.assignment5,
rp_tbl_professional.emp_gross,rp_tbl_CreateNewJob.JobCode,rp_tbl_CreateNewJob.Position,
rp_tbl_ApplyforJob.email,rp_tbl_ApplyforJob.TimeReq,rp_tbl_ApplyforJob.ExpSalary,
dtInterview = case rp_tbl_ApplyforJob.dtInterview
when 1 then 'Any Day'
when 2 then 'Week Day'
when 3 then 'Weekends'
else 'Other'
end
from rp_tbl_CreateNewJob inner join rp_tbl_ApplyforJob
on rp_tbl_CreateNewJob.JobCode=rp_tbl_ApplyforJob.JobCode
inner join rp_tbl_personal_details on
rp_tbl_ApplyforJob.email=rp_tbl_personal_details.email
inner join rp_tbl_academic_details on
rp_tbl_personal_details.personal_id=rp_tbl_academic_details.personal_id
inner join rp_tbl_family on rp_tbl_academic_details.academic_id=rp_tbl_family.academic_id
inner join
rp_tbl_professional on
rp_tbl_family.family_id=rp_tbl_professional.family_id
where rp_tbl_CreateNewJob.JobCode = @JobCode and
rp_tbl_personal_details.dob BETWEEN @dob and @dob
endif @callval=10
begin
select rp_tbl_personal_details.c_f_name + '' +c_m_name + ''+ c_l_name as name,
rp_tbl_personal_details.dob,
rp_tbl_academic_details.prof_qual ,rp_tbl_academic_details.grad_qual,
rp_tbl_academic_details.prof_stream,rp_tbl_academic_details.prof_year,
rp_tbl_academic_details.grad_stream,rp_tbl_academic_details.grad_year,
rp_tbl_professional.ex_yyyy,
rp_tbl_family.assignment1,rp_tbl_family.assignment2,rp_tbl_family.assignment3,
rp_tbl_family.assignment4,rp_tbl_family.assignment5,
rp_tbl_professional.emp_gross,rp_tbl_CreateNewJob.JobCode,rp_tbl_CreateNewJob.Position,
rp_tbl_ApplyforJob.email,rp_tbl_ApplyforJob.TimeReq,rp_tbl_ApplyforJob.ExpSalary,
dtInterview = case rp_tbl_ApplyforJob.dtInterview
when 1 then 'Any Day'
when 2 then 'Week Day'
when 3 then 'Weekends'
else 'Other'
end
from rp_tbl_CreateNewJob inner join rp_tbl_ApplyforJob
on rp_tbl_CreateNewJob.JobCode=rp_tbl_ApplyforJob.JobCode
inner join rp_tbl_personal_details on
rp_tbl_ApplyforJob.email=rp_tbl_personal_details.email
inner join rp_tbl_academic_details on
rp_tbl_personal_details.personal_id=rp_tbl_academic_details.personal_id
inner join rp_tbl_family on rp_tbl_academic_details.academic_id=rp_tbl_family.academic_id
inner join
rp_tbl_professional on
rp_tbl_family.family_id=rp_tbl_professional.family_id
where rp_tbl_CreateNewJob.JobCode = @JobCode and
rp_tbl_personal_details.dob BETWEEN @dob and @dob
end
Please help me.