Hello Ma'am,
I hope all is well at your end. He has to pass parameter and run StoreProcs.
Below parameter I passed on my .net project to retrieve Historical Aged Trial Balance.
cmd.Parameters.Add("@I_dAgingDate", SqlDbType.Date).Value = Convert.ToDateTime(dtpFromDate.Text);
cmd.Parameters.Add("@I_cStartVendorID", SqlDbType.Char).Value = FromVendorID.ToString().Trim();
cmd.Parameters.Add("@I_cEndVendorID", SqlDbType.Char).Value = ToVendorID.ToString().Trim();
cmd.Parameters.Add("@I_cStartVendorName", SqlDbType.Char).Value = "";
cmd.Parameters.Add("@I_cEndVendorName", SqlDbType.Char).Value = "zzzzzzzzzz";
cmd.Parameters.Add("@I_cStartClassID", SqlDbType.Char).Value = "";
cmd.Parameters.Add("@I_cEndClassID", SqlDbType.Char).Value = "zzzzzzzzzz";
cmd.Parameters.Add("@I_cStartUserDefined", SqlDbType.Char).Value = "";
cmd.Parameters.Add("@I_cEndUserDefined", SqlDbType.Char).Value = "zzzzzzzzzz";
cmd.Parameters.Add("@I_cStartPaymentPriority", SqlDbType.Char).Value = "";
cmd.Parameters.Add("@I_cEndPaymentPriority", SqlDbType.Char).Value = "zzzzzzzzzz";
cmd.Parameters.Add("@I_cStartDocumentNumber", SqlDbType.Char).Value = "";
cmd.Parameters.Add("@I_cEndDocumentNumber", SqlDbType.Char).Value = "zzzzzzzzzz";
cmd.Parameters.Add("@I_tUsingDocumentDate", SqlDbType.TinyInt).Value = 0;
cmd.Parameters.Add("@I_dStartDate", SqlDbType.DateTime).Value = "1900-01-01";
cmd.Parameters.Add("@I_dEndDate", SqlDbType.Date).Value = Convert.ToDateTime(dtpFromDate.Text);
cmd.Parameters.Add("@I_tExcludeNoActivity", SqlDbType.TinyInt).Value = 1;
cmd.Parameters.Add("@I_tExcludeMultiCurrency", SqlDbType.TinyInt).Value = 1;
cmd.Parameters.Add("@I_tExcludeZeroBalanceVendors", SqlDbType.TinyInt).Value = 1;
cmd.Parameters.Add("@I_tExcludeFullyPaidTrxs", SqlDbType.TinyInt).Value = 1;
cmd.Parameters.Add("@I_tExcludeCreditBalance", SqlDbType.TinyInt).Value = 0;
cmd.Parameters.Add("@I_tExcludeUnpostedAppldCrDocs", SqlDbType.TinyInt).Value = 1;
Thanks
Sandip
