Click here to Skip to main content
15,918,049 members
Home / Discussions / ASP.NET
   

ASP.NET

 
QuestionCode is inserting only one row of records. Any ideas? Pin
samflex9-Oct-17 5:16
samflex9-Oct-17 5:16 
Hi again,

This is part of our ongoing dynamic row creation in Repeater.

By default, the first row is available.

After filling in data into the cells of the first row, user clicks the Add New Row button to add another row.

This part works fine.

The issue is that whether user enters one row or several rows, when you submit the data to the database, only one row of data is saved.

Here is the code that I am using.

Any ideas how to modify this so that no matter how many rows are created in the markup, those rows are saved to the database.

Thanks in advance.

foreach (DataRow row in table.Rows)
{
    string txBoatRegNum = row.ItemArray[1] as string;
    string txTaxPayerRet = row.ItemArray[2] as string;

    if (txBoatRegNum != null & txTaxPayerRet != null)
    {
        if (string.IsNullOrEmpty(txTaxPayerRet))
        {
            txTaxPayerRet = "0";
        }
        SqlCommand aircmd = new SqlCommand("sp_savetInfo", conn);
        aircmd.CommandType = CommandType.StoredProcedure;
        aircmd.Parameters.AddWithValue("@pid", accountnumber.Text);
        aircmd.Parameters.AddWithValue("@eID", Request["pageId"]);
        aircmd.Parameters.AddWithValue("@txYr", txtTaxYr.Text);
        aircmd.Parameters.AddWithValue("@regno", txBoatRegNum);
        aircmd.Parameters.Add("@txretval", SqlDbType.Money).Value = decimal.Parse(txTaxPayerRet); //convert text back to money

        aircmd.ExecuteNonQuery();


        //Display some feedback to the user to let them know it was processed
        lblResult.ForeColor = System.Drawing.Color.Green;
        lblResult.Text = "Thank you! <br>You have successfully completed the form.";


        //If the message failed at some point, let the user know
        lblResult.ForeColor = System.Drawing.Color.Red;
        lblResult.Text = "Your form failed to save, please try again.";

    }
}

AnswerRe: Code is inserting only one row of records. Any ideas? Pin
F-ES Sitecore11-Oct-17 0:54
professionalF-ES Sitecore11-Oct-17 0:54 
AnswerRe: Code is inserting only one row of records. Any ideas? Pin
ZurdoDev11-Oct-17 9:44
professionalZurdoDev11-Oct-17 9:44 
QuestionHave a form result invisible until submission? Pin
The Rarispy8-Oct-17 16:48
The Rarispy8-Oct-17 16:48 
AnswerRe: Have a form result invisible until submission? Pin
Richard Deeming9-Oct-17 8:42
mveRichard Deeming9-Oct-17 8:42 
QuestionChanging the text of a GridView buttonfield text dynamically Pin
Stephen Holdorf7-Oct-17 15:10
Stephen Holdorf7-Oct-17 15:10 
QuestionASP.Net Core and global.asax Pin
Mou_kol5-Oct-17 23:21
Mou_kol5-Oct-17 23:21 
AnswerRe: ASP.Net Core and global.asax Pin
Afzaal Ahmad Zeeshan11-Oct-17 12:31
professionalAfzaal Ahmad Zeeshan11-Oct-17 12:31 
QuestionDesktop application "communicating" with ASP.NET Pin
The Junior4-Oct-17 23:02
The Junior4-Oct-17 23:02 
AnswerRe: Desktop application "communicating" with ASP.NET Pin
Atlapure Ambrish5-Oct-17 4:04
professionalAtlapure Ambrish5-Oct-17 4:04 
GeneralRe: Desktop application "communicating" with ASP.NET Pin
The Junior5-Oct-17 4:24
The Junior5-Oct-17 4:24 
SuggestionRe: Desktop application "communicating" with ASP.NET Pin
Richard Deeming5-Oct-17 4:08
mveRichard Deeming5-Oct-17 4:08 
GeneralRe: Desktop application "communicating" with ASP.NET Pin
The Junior5-Oct-17 4:21
The Junior5-Oct-17 4:21 
GeneralRe: Desktop application "communicating" with ASP.NET Pin
David Mujica5-Oct-17 9:08
David Mujica5-Oct-17 9:08 
GeneralRe: Desktop application "communicating" with ASP.NET Pin
The Junior5-Oct-17 21:34
The Junior5-Oct-17 21:34 
QuestionProgramming Chat supports video and audio and the number of connected high Pin
Member 1343772929-Sep-17 12:07
professionalMember 1343772929-Sep-17 12:07 
AnswerRe: Programming Chat supports video and audio and the number of connected high Pin
ZurdoDev2-Oct-17 4:10
professionalZurdoDev2-Oct-17 4:10 
QuestionImplementation advice for quiz with 4 choice questions Pin
Farhad Eft28-Sep-17 10:09
Farhad Eft28-Sep-17 10:09 
AnswerRe: Implementation advice for quiz with 4 choice questions Pin
Farhad Eft30-Sep-17 6:31
Farhad Eft30-Sep-17 6:31 
QuestionASP.NET authorization Pin
SaeedPol27-Sep-17 8:30
SaeedPol27-Sep-17 8:30 
AnswerRe: ASP.NET authorization Pin
The Junior5-Oct-17 4:34
The Junior5-Oct-17 4:34 
QuestionRepeater Template Desinging Pin
Member 1337195126-Sep-17 8:41
Member 1337195126-Sep-17 8:41 
AnswerRe: Repeater Template Desinging Pin
A_Griffin26-Sep-17 9:26
A_Griffin26-Sep-17 9:26 
GeneralRe: Repeater Template Desinging Pin
Member 1337195126-Sep-17 9:28
Member 1337195126-Sep-17 9:28 
GeneralRe: Repeater Template Desinging Pin
A_Griffin26-Sep-17 9:33
A_Griffin26-Sep-17 9:33 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.