Thanks to Hard_Rockz, with the help of him, i solved this issue.
i'm sticking my code for Ref#
try
{
string Jobname = txtjobname.Text;
string JobCode = txtjobcode.Text;
DateTime strDate = Convert.ToDateTime(txtsdate.Text);
DateTime endDate = Convert.ToDateTime(txtedate.Text);
string Client = txtclient.Text;
string JobDesc = txtjobdescription.Text;
int rig = Convert.ToInt32(ddlrig.SelectedValue);
int well = Convert.ToInt32(ddlwell.SelectedValue);
int Section = Convert.ToInt32(ddlSection.SelectedValue);
string hours = txtehrs.Text;
SqlParameter[] Param = new SqlParameter[11];
Param[0] = new SqlParameter("@JobName", Jobname);
Param[1] = new SqlParameter("@JobCode", JobCode);
Param[2] = new SqlParameter("@StartDate", strDate);
Param[3] = new SqlParameter("@EndDate", endDate);
Param[4] = new SqlParameter("@Client", Client);
Param[5] = new SqlParameter("@JobDesc", JobDesc);
Param[6] = new SqlParameter("@Rig", rig);
Param[7] = new SqlParameter("@Well", well);
Param[8] = new SqlParameter("@SectionID", Section);
Param[9] = new SqlParameter("@hours", hours);
Param[10] = new SqlParameter("@JobID", SqlDbType.Int);
Param[10].Direction = ParameterDirection.Output;
if (Section > 0)
{
DAL.Insertion("Sp_JobStep1", Param);
}
string JobID = Param[10].Value.ToString();
Response.Redirect("JobStep2.aspx?JobID=" + JobID);
}
catch (Exception)
{
throw;
}