Help in C Sharp Web Interface

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • svgeorge
    New Member
    • Aug 2007
    • 14

    #1

    Help in C Sharp Web Interface

    I need help in C Sharp Web Interface ,
    I have web pages for making several 9 type of payments.
    The data gets loaded on web page from SQL server 2005 database.
    Then I have Process payment button(ProcPaym BTM_Click) on the web page(Detail View) on clicking this button all selected (checked) data needs to be stored temperorily and displayed on another page (Review Data) In this page i click confirm payment button to insert selected data to the SQL Tables.
    I need help to get the selected data on Detail View to appear on the next page Review Data.
    Also how to insert the data to tables in SQL.
    Please help !!
    .
  • svgeorge
    New Member
    • Aug 2007
    • 14

    #2
    I need help in C Sharp Web Interface

    I need help in C Sharp Web Interface ,
    I have web pages for making several 9 type of payments.
    The data gets loaded on web page from SQL server 2005 database.
    Then I have Process payment button(ProcPaym BTM_Click) on the web page(Detail View) on

    clicking this button all selected (checked) data needs to be stored temperorily and

    displayed on another page (Review Data) In this page i click confirm payment button to

    insert selected data to the SQL Tables.
    I need help to get the selected data on Detail View to appear on the next page Review Data.
    Also how to insert the data to tables in SQL.
    Please help !!
    .

    Comment

    • svgeorge
      New Member
      • Aug 2007
      • 14

      #3
      I need help in C Sharp Web Interface

      I need help in C Sharp Web Interface ,
      I have web pages for making several 9 type of payments.
      The data gets loaded on web page from SQL server 2005 database.
      Then I have Process payment button(ProcPaym BTM_Click) on the web page(Detail View) on

      clicking this button all selected (checked) data needs to be stored temperorily and

      displayed on another page (Review Data) In this page i click confirm payment button to

      insert selected data to the SQL Tables.
      I need help to get the selected data on Detail View to appear on the next page Review Data.
      Also how to insert the data to tables in SQL.
      Please help !!
      .

      Comment

      • Plater
        Recognized Expert Expert
        • Apr 2007
        • 7872

        #4
        We have an article on Sessions for passing data between pages.

        And an article on using a database in your program for using the database

        Comment

        • just a feeling
          New Member
          • Aug 2007
          • 86

          #5
          I think that SQL forum gonna help u.
          kindly, put ur question there.

          Comment

          • svgeorge
            New Member
            • Aug 2007
            • 14

            #6
            Originally posted by just a feeling
            I think that SQL forum gonna help u.
            kindly, put ur question there.
            I need help in C Sharp Web Interface ,
            I have web pages for making several 9 type of payments.
            The data gets loaded on web page from SQL server 2005 database.
            Then I have Process payment button(ProcPaym BTM_Click) on the web page(Detail View) on clicking this button all selected (checked) data needs to be stored temperorily and displayed on another page (Review Data) In this page i click confirm payment button to insert selected data to the SQL Tables.
            I need help to get the selected data on Detail View to appear on the next page Review Data.
            Also how to insert the data to tables in SQL.
            Please help !!


            Here is the button on click code... that has to open the ne page with checked data fron earlier page.....Please let me know where the data set needs to be coded as u said earlier Shuja!! Please Help..

            protected void ProcPaymBTM_Cli ck(object sender, EventArgs e)
            {
            Dataviewlisting .ActiveViewInde x += 1;
            int IndexCount = 0;
            String ProcessingPayme nt;
            SessionValues ValueSelected = null;
            DataTable SelectedPayment = new DataTable();

            if (Session[Session_UserSPe rsonalData] == null)
            {
            ValueSelected = new SessionValues() ;
            Session.Add(Ses sion_UserSPerso nalData, ValueSelected);
            }
            else
            {
            ValueSelected = (SessionValues) (Session[Session_UserSPe rsonalData]);
            }

            ProcessingPayme nt = ValueSelected.P aymentSelected;
            switch (ProcessingPaym ent)
            {
            case "EnollNotPaidBT M":
            break;
            case "PlacNotPaidBTM ":
            break;
            case "Ret1NotPaidBTM ":
            break;
            case "Ret3NotPaidBTM ":
            break;
            case "Ret6NotPaidBTM ":
            break;
            case "Place2ndNotPai dBTM":
            break;
            case "EnrollBonusNot PaidBTM":
            break;
            case "WPRNotPaidBTM" :
            break;
            case "SatisCompleteN otPaidBTM":
            break;
            default:
            break;
            }
            foreach (GridViewRow DataSelected in this.DetailData List.Rows)
            {
            if (((CheckBox)Dat aSelected.FindC ontrol("Approva lCk")).Checked )
            {
            IndexCount += 1;
            }
            }




            This is the code i used to get the data displayed on First web page........thi s data generated from checked values here needs to be displayed on next page only when clicked on the button , So as you said can you assist me with the dataset ot new table to be created with the selected data only to be displayed.

            // Not_Paid_BTM

            protected void Cick_Detail_Enr ollment(object sender, EventArgs e)
            {
            //EnrollNotPaidBT M
            WebLibraryClass ConnectionFinan ceDB;
            ConnectionFinan ceDB = new WebLibraryClass ();
            Button ObjectClick = (Button)sender;
            string ConditionValue;
            SessionValues ValueSelected = null;

            ProcPaymBTM.Vis ible = true;
            if (Session[Session_UserSPe rsonalData] == null)
            {
            ValueSelected = new SessionValues() ;
            Session.Add(Ses sion_UserSPerso nalData, ValueSelected);
            }
            else
            {
            ValueSelected = (SessionValues) (Session[Session_UserSPe rsonalData]);
            }

            ConditionValue = ValueSelected.C ONDITION;
            ValueSelected.P aymentSelected = ObjectClick.ID. ToString();


            if (ObjectClick.ID .ToString() == "EnrollNotPaidB TM")
            {


            DbDataReader CollectingDataS elected = null;
            Dataviewlisting .ActiveViewInde x += 1;
            try
            {
            CollectingDataS elected = ConnectionFinan ceDB.CollectedF inaceData("SELE CT DISTINCT SSN,[FIRST NAME],[LAST NAME],Project_ID as [PROJECT ID],[PROJ START DT]AS ENROLLMENT,[PROJ END DT] AS TERMINATION,TER M AS [TERM CODE] FROM dbo.V_1st_Enrol lment_Agency_Pa yment_List " + ConditionValue) ;
            }
            catch
            {

            }
            DataTable TableSet = new DataTable();
            TableSet.Load(C ollectingDataSe lected, LoadOption.Over writeChanges);
            DetailDataList. DataSource = TableSet.Defaul tView;
            DetailDataList. DataBind();
            }
            }


            Hope you will guide me .....

            Thanks ,

            Santosh George

            Comment

            • kenobewan
              Recognized Expert Specialist
              • Dec 2006
              • 4871

              #7
              Please stop posting multiple times, it is against site rules. Thanks.

              MODERATOR

              Comment

              Working...