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(ProcPaymBTM_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_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