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