Populate Repeater if racord exist based on form data using C# in ASP.Net

simflex

SOLVED CLOSED ACTIVE ANSWERED
User: simflex
Posted: on Sep 19, 2017 03:42 PM
Forum: Data Controls
Answer: 1
Views: 3732

Please don't run out of patience with me just yet. I still have some major problems.

The issue I have now is that when I enter the following values for Repeater1: MarineRegNo TaxPyrRetdVal VesselRegNo VesselTaxPyrRetdVal

and click Next to go to page2(Repeater), I expect the values to display on the next page. Right now, they are blank.

However, if I have two dynamically generated rows and enter values for both rows, only the second row gets populated. The first row is blank.

It appears that values are being over-written perhaps in SetInitialRow and SetInitialRow2 functions.

Please kindly help me one more time with this issue.

Thank you very much

    private void SetInitialRow()
    {
        myMultiView.ActiveViewIndex = 0;
        DataTable dt;
        if (ViewState["CurrTable"] == null)
        {
            dt = new DataTable();
            DataRow dr = null;
            dt.Columns.Add(new DataColumn("ID", typeof(string)));
            dt.Columns.Add(new DataColumn("MarineRegNo", typeof(string)));
            dt.Columns.Add(new DataColumn("TaxPyrRetdVal", typeof(string)));
            dt.Columns.Add(new DataColumn("VesselRegNo", typeof(string)));
            dt.Columns.Add(new DataColumn("VesselTaxPyrRetdVal", typeof(string)));

            dr = dt.NewRow();
            dr["ID"] = 1;
            dr["MarineRegNo"] = string.Empty;
            dr["TaxPyrRetdVal"] = string.Empty;
            dr["VesselRegNo"] = string.Empty;
            dr["VesselTaxPyrRetdVal"] = string.Empty;
            dt.Rows.Add(dr);
        }
        else
        {
            dt = (DataTable)ViewState["CurrTable"];
        }
        ViewState["CurrTable"] = dt;
        if (dt.Rows.Count > 0)
        {
            Repeater1.DataSource = dt;
            Repeater1.DataBind();
        }
    }

    private void SetInitialRow2(string registerNumber, string bregisterNumber)
    {
        DataTable dts;
        if (ViewState["CurrentTable"] == null)
        {
            dts = new DataTable();
            DataRow dr = null;
        //Create DataTable columns
        dts.Columns.Add(new DataColumn("RowNumber", typeof(string)));
        dts.Columns.Add(new DataColumn("boatcnty", typeof(string)));
        dts.Columns.Add(new DataColumn("aRegNo", typeof(string)));
        dts.Columns.Add(new DataColumn("aMake", typeof(string)));
        dts.Columns.Add(new DataColumn("mMake", typeof(string)));
        dts.Columns.Add(new DataColumn("ModelNoA", typeof(string)));
        dts.Columns.Add(new DataColumn("ModelNoM", typeof(string)));
        dts.Columns.Add(new DataColumn("boatYrBuilt", typeof(string)));
        dts.Columns.Add(new DataColumn("motorYrBuilt", typeof(string)));
        dts.Columns.Add(new DataColumn("blength", typeof(string)));
        dts.Columns.Add(new DataColumn("hullmaterial", typeof(string)));
        dts.Columns.Add(new DataColumn("mhorsepower", typeof(string)));
        dts.Columns.Add(new DataColumn("rdlmhorsepType", typeof(string)));
        dts.Columns.Add(new DataColumn("datePurchased", typeof(string)));
        dts.Columns.Add(new DataColumn("mdatePurchased", typeof(string)));
        dts.Columns.Add(new DataColumn("PurchaseType", typeof(string)));
        dts.Columns.Add(new DataColumn("rblmPurchasedType", typeof(string)));
        dts.Columns.Add(new DataColumn("PrevOnwerName", typeof(string)));
        dts.Columns.Add(new DataColumn("prevAddr", typeof(string)));
        dts.Columns.Add(new DataColumn("prevCity", typeof(string)));
        dts.Columns.Add(new DataColumn("PrevState", typeof(string)));
        dts.Columns.Add(new DataColumn("prevzip", typeof(string)));
        dts.Columns.Add(new DataColumn("mPrevOnwerName", typeof(string)));
        dts.Columns.Add(new DataColumn("mprevAddr", typeof(string)));
        dts.Columns.Add(new DataColumn("mprevCity", typeof(string)));
        dts.Columns.Add(new DataColumn("mPrevState", typeof(string)));
        dts.Columns.Add(new DataColumn("mprevzip", typeof(string)));
        dts.Columns.Add(new DataColumn("buyername", typeof(string)));
        dts.Columns.Add(new DataColumn("buyeraddress", typeof(string)));
        dts.Columns.Add(new DataColumn("buyercity", typeof(string)));
        dts.Columns.Add(new DataColumn("buyerstate", typeof(string)));
        dts.Columns.Add(new DataColumn("buyerzip", typeof(string)));
        dts.Columns.Add(new DataColumn("datesold", typeof(string)));
        dts.Columns.Add(new DataColumn("salePrice", typeof(string)));
        dts.Columns.Add(new DataColumn("Description", typeof(string)));
        dts.Columns.Add(new DataColumn("mbuyername", typeof(string)));
        dts.Columns.Add(new DataColumn("mbuyeraddress", typeof(string)));
        dts.Columns.Add(new DataColumn("mbuyercity", typeof(string)));
        dts.Columns.Add(new DataColumn("mbuyerstate", typeof(string)));
        dts.Columns.Add(new DataColumn("mbuyerzip", typeof(string)));
        dts.Columns.Add(new DataColumn("mdatesold", typeof(string)));
        dts.Columns.Add(new DataColumn("msalePrice", typeof(string)));
        dts.Columns.Add(new DataColumn("mDescription", typeof(string)));
        dts.Columns.Add(new DataColumn("boatCost", typeof(string)));
        dts.Columns.Add(new DataColumn("motorCost", typeof(string)));
        dts.Columns.Add(new DataColumn("rblIssues", typeof(string)));
        dts.Columns.Add(new DataColumn("functionalIsses", typeof(string)));
        dts.Columns.Add(new DataColumn("mrblIssues", typeof(string)));
        dts.Columns.Add(new DataColumn("mfunctionalIsses", typeof(string)));
        dts.Columns.Add(new DataColumn("vesseltypeUse", typeof(string)));
        dts.Columns.Add(new DataColumn("vesselname", typeof(string)));
        dts.Columns.Add(new DataColumn("vessellength", typeof(string)));
        dts.Columns.Add(new DataColumn("vesselYrBult", typeof(string)));
        dts.Columns.Add(new DataColumn("VesselHullMateria", typeof(string)));
        dts.Columns.Add(new DataColumn("vesselhorsepEngine", typeof(string)));
        dts.Columns.Add(new DataColumn("coastGuardNumber", typeof(string)));
        dts.Columns.Add(new DataColumn("VesselYrPurchased", typeof(string)));
        dts.Columns.Add(new DataColumn("PurchasedNew", typeof(string)));
        dts.Columns.Add(new DataColumn("VesselPurchaseAmt", typeof(string)));
        dts.Columns.Add(new DataColumn("homePort", typeof(string)));
        dts.Columns.Add(new DataColumn("whereDocked", typeof(string)));
        dts.Columns.Add(new DataColumn("bmequipAccessoryList", typeof(string)));
        //Create Row for each columns
        dr = dts.NewRow();
        dr["RowNumber"] = 1;
        dr["boatcnty"] = string.Empty;
        dr["aRegNo"] = registerNumber;
        dr["aMake"] = string.Empty;
        dr["mMake"] = string.Empty;
        dr["ModelNoA"] = string.Empty;
        dr["ModelNoM"] = string.Empty;
        dr["boatYrBuilt"] = string.Empty;
        dr["motorYrBuilt"] = string.Empty;
        dr["blength"] = string.Empty;
        dr["hullmaterial"] = string.Empty;
        dr["mhorsepower"] = string.Empty;
        dr["rdlmhorsepType"] = string.Empty;
        dr["datePurchased"] = string.Empty;
        dr["mdatePurchased"] = string.Empty;
        dr["PurchaseType"] = string.Empty;
        dr["rblmPurchasedType"] = string.Empty;
        dr["PrevOnwerName"] = string.Empty;
        dr["prevAddr"] = string.Empty;
        dr["prevCity"] = string.Empty;
        dr["PrevState"] = string.Empty;
        dr["prevzip"] = string.Empty;
        dr["mPrevOnwerName"] = string.Empty;
        dr["mprevAddr"] = string.Empty;
        dr["mprevCity"] = string.Empty;
        dr["mPrevState"] = string.Empty;
        dr["mprevzip"] = string.Empty;
        dr["buyername"] = string.Empty;
        dr["buyeraddress"] = string.Empty;
        dr["buyercity"] = string.Empty;
        dr["buyerstate"] = string.Empty;
        dr["buyerzip"] = string.Empty;
        dr["datesold"] = string.Empty;
        dr["salePrice"] = string.Empty;
        dr["Description"] = string.Empty;
        dr["mbuyername"] = string.Empty;
        dr["mbuyeraddress"] = string.Empty;
        dr["mbuyercity"] = string.Empty;
        dr["mbuyerstate"] = string.Empty;
        dr["mbuyerzip"] = string.Empty;
        dr["mdatesold"] = string.Empty;
        dr["msalePrice"] = string.Empty;
        dr["mDescription"] = string.Empty;
        dr["boatCost"] = string.Empty;
        dr["motorCost"] = string.Empty;
        dr["rblIssues"] = string.Empty;
        dr["functionalIsses"] = string.Empty;
        dr["mrblIssues"] = string.Empty;
        dr["mfunctionalIsses"] = string.Empty;
        dr["vesseltypeUse"] = string.Empty;
        dr["vesselname"] = string.Empty;
        dr["vessellength"] = string.Empty;
        dr["vesselYrBult"] = string.Empty;
        dr["VesselHullMateria"] = string.Empty;
        dr["vesselhorsepEngine"] = string.Empty;
        dr["coastGuardNumber"] = bregisterNumber;
        dr["VesselYrPurchased"] = string.Empty;
        dr["PurchasedNew"] = string.Empty;
        dr["VesselPurchaseAmt"] = string.Empty;
        dr["homePort"] = string.Empty;
        dr["whereDocked"] = string.Empty;
        dr["bmequipAccessoryList"] = string.Empty;
        dts.Rows.Add(dr);
        }
        else
        {
            dts = (DataTable)ViewState["CurrentTable"];
        }
        //Store the DataTable in ViewState for future reference
        ViewState["CurrentTable"] = dts;
        if (dts.Rows.Count > 0)
        {
        Repeater2.DataSource = dts;
        Repeater2.DataBind();
        }
    }

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 21

Reply
ANSWER
User: dharmendr
Replied: on Oct 05, 2017 05:52 AM
Report

Hi simflex,

I have modified your PopulateRecord method. Since you are not fetching any record from database so its not populated in the repeater. So inorder to populate the record you need to fetch the record based on the marineregistrationnumber and add the records to the datatable table2 and bind the datatable to repeater.

private void PopulateRecord(DataTable table1)
{
    DataTable table2 = LoadTable2(true);
    table2.Rows.Clear();

    foreach (DataRow row in table1.Rows)
    {
        string marineRegNo = row.ItemArray[1].ToString();
        SqlConnection conn = new SqlConnection(connStr);
        SqlCommand cmd = new SqlCommand("sp_AllRecsBasedOnMarineRegNo", conn);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.AddWithValue("@marineRegNo", marineRegNo);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataTable dtRecords = new DataTable();
        da.Fill(dtRecords);
        if (dtRecords.Rows.Count > 0)
        {
            table2.ImportRow(dtRecords.Rows[0]);
        }
        else
        {
            DataRow dr = table2.NewRow();
            dr["RowNumber"] = table2.Rows.Count + 1;
            dr["aRegNo"] = row["MarineRegNo"];
            dr["coastGuardNumber"] = row["VesselRegNo"];
            dr["boatcnty"] = string.Empty;
            dr["aMake"] = string.Empty;
            dr["mMake"] = string.Empty;
            dr["ModelNoA"] = string.Empty;
            dr["ModelNoM"] = string.Empty;
            dr["boatYrBuilt"] = 0;//string.Empty;// error
            dr["motorYrBuilt"] = 0;//string.Empty;// error
            dr["blength"] = string.Empty;
            dr["hullmaterial"] = string.Empty;
            dr["mhorsepower"] = string.Empty;
            dr["rdlmhorsepType"] = string.Empty;
            dr["datePurchased"] = DateTime.Now;//string.Empty;// error
            dr["mdatePurchased"] = DateTime.Now;//string.Empty;// error
            dr["PurchaseType"] = string.Empty;
            dr["rblmPurchasedType"] = string.Empty;
            dr["PrevOnwerName"] = string.Empty;
            dr["prevAddr"] = string.Empty;
            dr["prevCity"] = string.Empty;
            dr["PrevState"] = string.Empty;
            dr["prevzip"] = string.Empty;
            dr["mPrevOnwerName"] = string.Empty;
            dr["mprevAddr"] = string.Empty;
            dr["mprevCity"] = string.Empty;
            dr["mPrevState"] = string.Empty;
            dr["mprevzip"] = string.Empty;
            dr["buyername"] = string.Empty;
            dr["buyeraddress"] = string.Empty;
            dr["buyercity"] = string.Empty;
            dr["buyerstate"] = string.Empty;
            dr["buyerzip"] = string.Empty;
            //    dr["datesold"] = string.Empty;
            //   dr["salePrice"] = string.Empty;
            dr["Description"] = string.Empty;
            dr["mbuyername"] = string.Empty;
            dr["mbuyeraddress"] = string.Empty;
            dr["mbuyercity"] = string.Empty;
            dr["mbuyerstate"] = string.Empty;
            dr["mbuyerzip"] = string.Empty;
            //   dr["mdatesold"] = string.Empty;
            //  dr["msalePrice"] = string.Empty;
            dr["mDescription"] = string.Empty;
            //  dr["boatCost"] = string.Empty;
            //   dr["motorCost"] = string.Empty;
            dr["rblIssues"] = string.Empty;
            dr["functionalIsses"] = string.Empty;
            dr["mrblIssues"] = string.Empty;
            dr["mfunctionalIsses"] = string.Empty;
            dr["vesseltypeUse"] = string.Empty;
            dr["vesselname"] = string.Empty;
            dr["vessellength"] = string.Empty;
            //  dr["vesselYrBult"] = string.Empty;
            dr["VesselHullMateria"] = string.Empty;
            dr["vesselhorsepEngine"] = string.Empty;
            //   dr["VesselYrPurchased"] = string.Empty;
            dr["PurchasedNew"] = string.Empty;
            //  dr["VesselPurchaseAmt"] = string.Empty;
            dr["homePort"] = string.Empty;
            dr["whereDocked"] = string.Empty;
            dr["bmequipAccessoryList"] = string.Empty;
            table2.Rows.Add(dr);
        }
    }

    Repeater2.DataSource = table2;
    Repeater2.DataBind();

    foreach (RepeaterItem item in Repeater2.Items)
    {
        ((Button)item.FindControl("BtnAdd2")).Visible = table2.Rows.Count > 2;
        ((Button)item.FindControl("btnDelete2")).Visible = table2.Rows.Count > 2;
    }
}

CREATE PROCEDURE [dbo].[sp_AllRecsBasedOnMarineRegNo]
@marineRegNo varchar(50)
AS
BEGIN
SET NOCOUNT OFF;
SELECT ROW_Number() OVER (ORDER BY(SELECT 0)) RowNumber, mp.[DateSold] as datesold
      ,mp.[SalePrice] as salePrice
      ,mp.[Description] as Description
      ,mp.[BuyerFullName] as buyername
      ,mp.[BuyerAddress] as buyeraddress
      ,mp.[BuyerCity] as buyercity
      ,mp.[BuyerState] as buyerstate
      ,mp.[BuyerZipCode] as buyerzip
      ,mp.[mDateSold] as mdatesold
      ,mp.[mSalePrice] as msalePrice
      ,mp.[mDescription] as mDescription
      ,mp.[mBuyerFullName] as mbuyername
      ,mp.[mBuyerAddress] as mbuyeraddress
      ,mp.[mBuyerCity] as mbuyercity
      ,mp.[mBuyerState] as mbuyerstate
      ,mp.[mBuyerZipCode] as mbuyerzip
      ,mp.[PreviousOwnerName] as PrevOnwerName
      ,mp.[PreviousOwnerAddress] as prevAddr
      ,mp.[PreviousOwnerCity] as prevCity
      ,mp.[PreviousOwnerState] as PrevState
      ,mp.[PreviousOwnerZipCode] as prevzip
      ,mp.[mPreviousOwnerName] as mprevOnwerName
      ,mp.[mPreviousOwnerAddress] as mprevAddr
      ,mp.[mPreviousOwnerCity] as mprevCity
      ,mp.[mPreviousOwnerState] as mPrevState
      ,mp.[mPreviousOwnerZipCode] as mprevzip
      ,mp.[signDate]
      ,mp.[sTitle]
      ,ms.County As boatcnty
      ,ms.Registration_No As aRegNo
      ,ms.Motor_MFG_Make AS aMake
      ,ms.Boat_MFG_Make as mMake
      ,ms.Motor_MFG_Model as ModelNoA
      ,ms.Boat_MFG_Model as ModelNoM
      ,ms.Boat_Year_Built as boatYrBuilt
      ,ms.Motor_Year_Built as motorYrBuilt
      ,ms.[Length] as blength
      ,ms.HullMaterial as hullmaterial
      ,ms.HorsePower as mhorsepower
      ,ISNULL(ms.HorsePowerType,'NA') as rdlmhorsepType
      ,ms.Boat_DatePurchased as datePurchased
      ,ms.Motor_DatePurchased as mdatePurchased
      ,ISNULL(ms.Boat_PurchaseType,'NA') as PurchaseType
      ,ms.Motor_PurchaseType as rblmPurchasedType
      ,ms.MotorCost as motorCost
      ,ms.BoatCost as boatCost
      ,ms.FileDate
      ,ms.boatIssues as rblIssues
      ,ms.motorIssues as mrblIssues
      ,ms.boatIssuesDetails as functionalIsses
      ,ms.motorIssuesDetails as mfunctionalIsses
      ,mf.TypeOfVessel as vesseltypeUse
      ,mf.VesselName as vesselname
      ,mf.HorspwrTypOfEngine as vesselhorsepEngine
      ,mf.CoastGuardNo AS coastGuardNumber
      ,mf.YearPurchased as VesselYrPurchased
      ,mf.PurchaseType as PurchasedNew
      ,mf.AmtOfPurchase as VesselPurchaseAmt
      ,mf.HomePort as homePort
      ,mf.WhereDocked as whereDocked
      ,mf.Boat_Motor_Accsry_Equip as bmequipAccessoryList
      ,mf.vesselLength as vessellength
      ,mf.YrVesselBuilt as vesselYrBult
      ,mf.VHullMaterial as VesselHullMateria
  FROM MarineInfo m 
  INNER JOIN BoatMarincePurchaserInfo mp ON m.taxpayerID = mp.taxpayerID
  INNER JOIN MarineScheduleD ms ON m.taxpayerID = ms.taxpayerID
  INNER JOIN MarineFedVesselInfo mf ON m.taxpayerID = mf.taxpayerID
  WHERE ms.Registration_No = @marineRegNo
 END

Note: As per your process you need to handle other code aswell when you are getting other error like datatype errors.

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Populate Repeater if racord exist based on form data using C# in ASP.Net

Company

Explore

Follow us

Contact Us