C# (CSharp) SysFunctions.SP_Spare_Get_PartsSubLocation Beispiele

Beispiel #1

        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;
            }
        }