private string GetPartLocation(string StrLocationCode) { DataSet ds = new DataSet(); string StrLocationNM = ""; try { SqlParameter[] param = { new SqlParameter("@PartsTransLocCode", SqlDbType.Char), new SqlParameter("@DealerCode", SqlDbType.Char) }; param[0].Value = StrLocationCode; param[1].Value = Session["DealerCode"].ToString(); ds = SysFunc.SP_Spare_Get_PartLocation(param); if (ds.Tables[0].Rows.Count != 0) { StrLocationNM = ds.Tables[0].Rows[0]["PartsTransLocDesc"].ToString(); } return(StrLocationNM); } catch (Exception ex) { SysFunc.UserMsg(LbErr, Color.Red, ex.Message); return(""); } }