Insert Web Interface records to SQL database table on Button click

[svgeorge]

Please tell me how to Insert Web Interface records to SQL database table on Button click

I have several records for approving payment
and these records needs to be inserted into a table Payment List
(which is already created) and when i click confirm payment button the records need to be inserted to the payment list table and payment id is generated automatically and the table column Agency approval has to get a boolean value 1 if approved

Please suggest

Thanks,
George

[jhardman]

George,

OK, so what do you have so far? There is a simple tutorial in the ASP Articles section on how to insert records into a db. Let me know if this doesn't answer all of your questions. I'm willing to help, but if you would like one of our experts to do the job for you, it would be better to post in the jobs section.

Jared

[svgeorge]

Thanks for your reply jhardman,
I shall look into the articles too now.
Here is where i am right now

// getting records on Review data grid view  View ID = ReviewSelectionGD
This is the code where i get the data to temp table and then displayed on the reviewdata datagrid page and here the records need to be inserted  into the database table
// (This works Fine)
 
//
protected
 
void ProcPaymBTM_Click(object sender, EventArgs e) 
{
if (Dataviewlisting.ActiveViewIndex < 2) 
{
Dataviewlisting.ActiveViewIndex += 1;
}
int IndexCount = 0; 
 
String ProcessingPayment; 
SessionValues ValueSelected = 
 
null; 
DataTable SelectedPayment = 
 
new DataTable(); 
 
//GridView DataListSelected = (GridView) e; 
 
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; 
}
 
Titlelb.Text = ""; 
 
// copy this code to each Case 
 
// ************************************************* 
 
// Revies the list to see what payment has being approve 
 
foreach (GridViewRow SelectedRows in this .DetailDataList.Rows) 
 
{ 
 
 if (((CheckBox)SelectedRows.FindControl("ApprovalCk")).Checked) 
{
 
IndexCount += 1;
 
 // Setting the index the identified if the record is already in the approval list. 
 
int valueAlreadyProcess = -1; 
 
// Checking for existent and process records 
 
try 
{
 
ValueSelected.TemporaryTable.DefaultView.Sort = 
 
"SSN"; 
valueAlreadyProcess = ValueSelected.TemporaryTable.DefaultView.Find(SelectedRows.Cells[3].Text);
}
 
 catch 
{
 
 // Not space allocated for the table. The table is empty 
}
 
 if (valueAlreadyProcess == -1) 
{
 
 // Create a new row to save the approve payment 
DataRow DataRowCollection = ValueSelected.TemporaryTable.NewRow();
 
for (int ColInd = 3; ColInd < (ValueSelected.TemporaryTable.Columns.Count + 3); ColInd++) 
{
 
 try 
{
 
 if (SelectedRows.Cells[ColInd].Text != "&nbsp;") 
{
 
DataRowCollection[ColInd - 3] = SelectedRows.Cells[ColInd].Text;
 
}
 
 else 
{
 
 // No term code value 
}
}
 
 catch 
{
 
// No Value in the Grid View for date or termination 
}
 
}
 
// collect the comment information 
TextBox CommentAdded;
 
CommentAdded = (TextBox)SelectedRows.FindControl(
 
"CommentsBx"); 
DataRowCollection[
 
"Comments"] = CommentAdded.Text; 
 // save the approve information into the temporary infomation 
ValueSelected.TemporaryTable.Rows.Add(DataRowCollection);
 
}
}
 
// Displaying the data selected 
ReviewSelectionGD.DataSource = ValueSelected.TemporaryTable;
 
ReviewSelectionGD.DataBind();
 
 }
 
 // ************************************************* 
}
 
 [Edit Tags]
 
// ??? NOw for inserting records from datagrid view to SQL table

I am using the following codes for inserting records but it shows errors...please help

//---- CS file/Code behind ---
 
protected void ReviewSelectionGDInsert_ItemCommand(object sender, DetailsViewCommandEventArgs e) 
{
 
if (e.CommandName.Equals("Insert")) 
{
 
ReviewSelectionGD.Insert();
 
}
 
}
 
protected void ComfPaymBRM_Click(object sender,EventArgs e) 
{
 
string SSN = ((TextBox)ReviewSelectionGD.FindControl("SSN")).Text; 
string JC_ID = ((TextBox)ReviewSelectionGD.FindControl("JC_ID")).Text;
 
string AGENCY_ID = ((TextBox)ReviewSelectionGD.FindControl("AGENCY_ID")).Text; 
string Agency_approval = ((TextBox)ReviewSelectionGD.FindControl("Agency_approval")).Text;
 
string Agency_approval_date = ((DropDownList)ReviewSelectionGD.FindControl("Agency_approval_date")).Text; 
e.InputParameters.Add("SSN", "");
 
e.InputParameters.Add("JC_ID", ""); 
e.InputParameters.Add("AGENCY_ID", "");
 
e.InputParameters.Add("Agency_approval", 1);e.InputParameters.Add("Agency_approval_date", getdate()); 
 
}
 
protected void ReviewSelectionGD_Inserted(object sender, ObjectDataSourceStatusEventArgs e) 
{
 
if (e.Exception != null) 
{
 
DivResult.Visible = true; 
}
 
else
 
{
 
// TODO 
 
}
}
 
//BLL/DAL 
 
public static int InsertPayment( 
int SSN,
 
int JC_ID, 
int AGENCY_ID,
 
int Agency_approval,DateTime Agency_approval_date 
 )
{
int rowsAffected = 0;using (SqlConnection connection = ConnectionManager.GetFinanceDBConnection()) 
{
 
SqlCommand command = new SqlCommand("InsertPaymentList", connection); 
command.CommandType = CommandType.StoredProcedure;
 
command.Parameters.Add("@SSN", SqlDbType.VarChar).Value = SSN;
 
command.Parameters.Add("@JC_ID", SqlDbType.VarChar).Value = JC_ID; 
command.Parameters.Add("@AGENCY_ID", SqlDbType.VarChar).Value = AGENCY_ID;
 
command.Parameters.Add("@Agency_approval", SqlDbType.VarChar).Value = Agency_approval;command.Parameters.Add("@Agency_approval_date", SqlDbType.datetime).Value = Agency_approval_date; 
 
rowsAffected = command.ExecuteNonQuery();
 
}
 
return rowsAffected; 
}
 
//stored procedure
 
ALTER PROCEDURE [dbo].[InsertPaymentList](
 
@SSN VARCHAR(50), 
@JC_ID int ,
 
@AGENCY_ID VARCHAR(50),
 
@Agency_approval int,
 
@Agency_approval_date datetime)
 
AS
 
INSERT INTO Payment_LIST_AIMS 
(SSN,JC_ID,AGENCY_ID,Agency_approval,Agency_approval_date)
 
VALUES
 
(@SSN,@JC_ID,@AGENCY_ID,@Agency_approval,@Agency_approval_date)
 
SET @SSN = SCOPE_IDENTITY()
 

[Edit Tags]

[jhardman]

George,

This doesn't look like ASP classic. Is this ASP.NET? What language are you using?

Jared