private void GVSubLocFill() { DataSet ds = new DataSet(); try { SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char), new SqlParameter("@PartsLocCode", SqlDbType.VarChar) }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = txtPartLocationCode.Text.Trim(); ds = SysFunc.SP_Spare_Get_PartsSubLocation(param); dtg_PartLocation.DataSource = ds.Tables[0]; dtg_PartLocation.DataBind(); } catch (Exception ex) { LbErr.Text = ex.Message; } }