Web Interface To display selected data on new page

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

ASP.NET

Web Interface To display selected data on new page

Author

Topic

svgeorge
Starting Member

23 Posts

Posted - 2007-08-28 : 10:13:28

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(ProcPaymBTM_Click) on the web page(Detail View)This is done. on clicking this button(ProcPaymBTM_Click) on (Detail View) all selected (checked) data columns needs 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 Please Help..

protected void ProcPaymBTM_Click(object sender, EventArgs e)
{
Dataviewlisting.ActiveViewIndex += 1;
int IndexCount = 0;
String ProcessingPayment;
SessionValues ValueSelected = null;
DataTable SelectedPayment = new DataTable();

if (Session[Session_UserSPersonalData] == null)
{
ValueSelected = new SessionValues();
Session.Add(Session_UserSPersonalData, ValueSelected);
}
else
{
ValueSelected = (SessionValues)(Session[Session_UserSPersonalData]);
}

ProcessingPayment = ValueSelected.PaymentSelected;
switch (ProcessingPayment)
{
case "EnollNotPaidBTM":
break;
case "PlacNotPaidBTM":
break;
case "Ret1NotPaidBTM":
break;
case "Ret3NotPaidBTM":
break;
case "Ret6NotPaidBTM":
break;
case "Place2ndNotPaidBTM":
break;
case "EnrollBonusNotPaidBTM":
break;
case "WPRNotPaidBTM":
break;
case "SatisCompleteNotPaidBTM":
break;
default:
break;
}
foreach (GridViewRow DataSelected in this.DetailDataList.Rows)
{
if (((CheckBox)DataSelected.FindControl("ApprovalCk")).Checked)
{
IndexCount += 1;
}
}

This is the code i used to get the data displayed on First web page........this 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_Enrollment(object sender, EventArgs e)
{
//EnrollNotPaidBTM
WebLibraryClass ConnectionFinanceDB;
ConnectionFinanceDB = new WebLibraryClass();
Button ObjectClick = (Button)sender;
string ConditionValue;
SessionValues ValueSelected = null;

ProcPaymBTM.Visible = true;
if (Session[Session_UserSPersonalData] == null)
{
ValueSelected = new SessionValues();
Session.Add(Session_UserSPersonalData, ValueSelected);
}
else
{
ValueSelected = (SessionValues)(Session[Session_UserSPersonalData]);
}

ConditionValue = ValueSelected.CONDITION;
ValueSelected.PaymentSelected = ObjectClick.ID.ToString();

if (ObjectClick.ID.ToString() == "EnrollNotPaidBTM")
{

DbDataReader CollectingDataSelected = null;
Dataviewlisting.ActiveViewIndex += 1;
try
{
CollectingDataSelected = ConnectionFinanceDB.CollectedFinaceData("SELECT DISTINCT SSN,[FIRST NAME],[LAST NAME],Project_ID as [PROJECT ID],[PROJ START DT]AS ENROLLMENT,[PROJ END DT] AS TERMINATION,TERM AS [TERM CODE] FROM dbo.V_1st_Enrollment_Agency_Payment_List " + ConditionValue);
}
catch
{

}
DataTable TableSet = new DataTable();
TableSet.Load(CollectingDataSelected, LoadOption.OverwriteChanges);
DetailDataList.DataSource = TableSet.DefaultView;
DetailDataList.DataBind();
}
}

Hope you will guide me .....

Thanks ,

Santosh George

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources