private void GetDateSIR() { DataSet dsSIR = new DataSet(); try { if (ddlSirNo.SelectedIndex != 0) { SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char), new SqlParameter("@SIRNO", SqlDbType.Char) }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = ddlSirNo.SelectedValue.ToString(); dsSIR = SysFunc.SP_Parts_Get_SIRDataGetForStockIssue(param); if (Convert.ToString(dsSIR.Tables[0].Rows[0]["Requsitioner"]) == "J") { lblSource.Text = "Job Card #"; txtJC_CS_No.Text = dsSIR.Tables[0].Rows[0]["JobCardNO"].ToString(); } else if (Convert.ToString(dsSIR.Tables[0].Rows[0]["Requsitioner"]) == "C") { lblSource.Text = "Counter Sale #"; txtJC_CS_No.Text = dsSIR.Tables[0].Rows[0]["InvoiceNO"].ToString(); } txtSource.Text = dsSIR.Tables[0].Rows[0]["Requsitioner"].ToString(); txtSIRDate.Text = dsSIR.Tables[0].Rows[0]["SIRDate"].ToString(); txtRemarks.Focus(); } } catch (Exception ex) { LbErr.Text = ex.Message; } }