Insert Record using Repeater

Jagjit Saini

How to insert record from repeater

public int AddLeadInput(LeadInput objLeadInput)
{
    try
    {
        int ack = 0;
        context.Connection.Open();
        context.Transaction = context.Connection.BeginTransaction();

        context.LeadInputs.InsertOnSubmit(objLeadInput);
        context.SubmitChanges();

        context.Transaction.Commit();
        ack = objLeadInput.LeadInputID;
        return ack;
    }
    catch (Exception ex)
    {
        context.Transaction.Rollback();
        throw ex;
    }
}

BALLeadInput bALLeadInput = new BALLeadInput();
LeadInput leadInput = new LeadInput();

Thanks

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rijwan Ansari4y ago
Check this, if it helps you.

https://www.aspsnippets.com/questions/157989/Insert-record-to-database-from-Repeater-using-C-and-VBnet-in-ASPNet/
+2
Muhammad Imran Ansari4y ago
Try the following code:
protected void btnSave_Click(object sender, EventArgs e)
{
    LeadInput leadInput = new LeadInput();

    foreach (RepeaterItem item in rpQuestion.Items)
    {
        TextBox Ansbox = item.FindControl("txtAns") as TextBox;
        string Answer =  Ansbox.Text;

        if (!string.IsNullOrEmpty(Answer))
        {
            leadInput.answer = Answer;
            // Fill other properties
            context.Connection.Open();
            context.Transaction = context.Connection.BeginTransaction();
    context.LeadInputs.InsertOnSubmit(objLeadInput);
            context.SubmitChanges();
    context.Transaction.Commit();
        }
    }
}
+1