Hello again gurus,
By now,you good helpers are pretty familiar with this project I have been working on now for quite some time.
To refresh, here is the link to one of the threads:
http://www.aspforums.net/Threads/163144/Display-GridView-and-Repeater-data-in-Preview-page-on-Button-click-using-C-in-ASPNet/
Right now, we have a new requirement from management.
Since users have to go from page to page, management has asked us to add a new button called "Save and finish later"
This means that at any stage during their form completion, users can save their work, exit the form and come back to continue from where they
stopped.
This functionality is working fine.
The issue that I am having right now is that when user comes back to complete his or her form, s/he enters his/her account number and
all the data already entered will populate the form.
This way, user can continue from where s/he stopped without having to start all over again.
I have written a stored procedure that queries the db and pulls results based on account number.
Then I have come up with a function that calls the stored procedure.
I have attempted to use it to populate the Repeater form but it is not working.
Any assistance is greatly appreciated.
private void getRecs(int pin)
{
SqlConnection conn = new SqlConnection(connStr);
SqlCommand cmd = new SqlCommand("sp_AllRecs", conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter p1 = new SqlParameter("@pin", pin);
cmd.Parameters.Add(p1);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
pin = reader.GetInt32(0);
mTaxYear = reader.GetInt32(1);
mMarineRegNo = reader.GetString(2);
mVesselRegNo = reader.GetString(3);
mTaxPyrRetdVal = reader.GetDecimal(4);
mEquipmentTypeID = reader.GetInt32(5);
mVesselTaxPyrRetdVal = reader.GetDecimal(6);
mpDateSold = reader.GetDateTime(7);
mpSalePrice = reader.GetDecimal(8);
mpDescr = reader.GetString(9);
mpBuyerFullName = reader.GetString(10);
mpBuyerFirstName = reader.GetString(11);
mpBuyerLastName = reader.GetString(12);
mpBuyerAddress = reader.GetString(13);
mpBuyerCity = reader.GetString(14);
mpBuyerState = reader.GetString(15);
mpBuyerZipCode = reader.GetString(16);
mDateSold = reader.GetDateTime(17);
mSalePrice = reader.GetDecimal(18);
mDescription = reader.GetString(19);
mBuyerFullName = reader.GetString(20);
mBuyerFirstName = reader.GetString(21);
mBuyerLastName = reader.GetString(22);
mBuyerAddress = reader.GetString(23);
mBuyerCity = reader.GetString(24);
mBuyerState = reader.GetString(25);
mBuyerZipCode = reader.GetString(26);
mpPreviousOwnerName = reader.GetString(27);
mpPreviousOwnerFirstName = reader.GetString(28);
mpPreviousOwnerLastName = reader.GetString(29);
mpPreviousOwnerAddress = reader.GetString(30);
mpPreviousOwnerCity = reader.GetString(31);
mpPreviousOwnerState = reader.GetString(32);
mpPreviousOwnerZipCode = reader.GetString(33);
mPreviousOwnerName = reader.GetString(34);
mPreviousOwnerFirstName = reader.GetString(35);
mPreviousOwnerLastName = reader.GetString(36);
mPreviousOwnerAddress = reader.GetString(37);
mPreviousOwnerCity = reader.GetString(38);
mPreviousOwnerState = reader.GetString(39);
mPreviousOwnerZipCode = reader.GetString(40);
mpsignDte = reader.GetDateTime(41);
mpsTitle = reader.GetString(42);
msCounty = reader.GetString(43);
msRegistration_No = reader.GetString(44);
msMotor_MFG_Make = reader.GetString(45);
msBoat_MFG_Make = reader.GetString(46);
msMotor_MFG_Model = reader.GetString(47);
msBoat_MFG_Model = reader.GetString(48);
msBoat_Year_Built = reader.GetInt16(49);
msMotor_Year_Built = reader.GetInt16(50);
msbLength = reader.GetString(51);
msHullMaterial = reader.GetString(52);
msHorsePower = reader.GetString(53);
msHorsePowerType = reader.GetString(54);
msBoat_DatePurchased = reader.GetDateTime(55);
msMotor_DatePurchased = reader.GetDateTime(56);
msBoat_PurchaseType = reader.GetString(57);
msMotor_PurchaseType = reader.GetString(58);
msMotorCost = reader.GetDecimal(59);
msBoatCost = reader.GetDecimal(60);
msFileDate = reader.GetDateTime(61);
msboatIssues = reader.GetString(62);
msmotorIssues = reader.GetString(63);
msboatIssuesDetails = reader.GetString(64);
msmotorIssuesDetails = reader.GetString(65);
mfTypeOfVessel = reader.GetString(66);
mfVesselName = reader.GetString(67);
mfHorspwrTypOfEngine = reader.GetString(68);
mfCoastGuardNo = reader.GetString(69);
mfYearPurchased = reader.GetInt16(70);
mfPurchaseType = reader.GetString(71);
mfAmtOfPurchase = reader.GetDecimal(72);
mfHomePort = reader.GetString(73);
mfWhereDocked = reader.GetString(74);
mfBoat_Motor_Accsry_Equip = reader.GetString(75);
mfvesselLength = reader.GetString(76);
mfYrVesselBuilt = reader.GetInt16(77);
mfVHullMaterial = reader.GetString(78);
}
//Then on pageload() event, I call the function:
int pid = Int32.Parse(Session["accountNum"].ToString());
getRecs(pid);