how to submit a form that contains text boxes, checkboxes and dropdown

Ivonne Aspilcueta

Hello,

I build some code, but I am still missing some part of the puzzle, what I am trying to do is how to submit a form that contains text boxes, checkboxes and dropdown list to a database in web form asp.net.

It gives me an error as well:

Compilation Error

Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: CS7036: There is no argument given that corresponds to the required formal parameter 'sender' of 'Subpoena.Button1_Click(object, EventArgs)'

Source Error:

Thank you

public partial class Subpoena : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        // Create a list of month names
        string[] months = { "January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December" };
        // Add each month to the dropdown list
        foreach (string frommonth in months)
        {
            fromMonth.Items.Add(new ListItem(frommonth, frommonth));
        }
        foreach (string tomonth in months)

        {
            toMonth.Items.Add(new ListItem(tomonth, tomonth));

        }

        // Create a list of Year

        if (!IsPostBack)

        {
          

            fromYear.Items.Clear();
            fromYear.Items.Add("From Year");
            var currentYear = DateTime.Today.Year;
            for (int i = 7; i >= 0; i--)
            {
                // Now just add an entry that's the current year minus the counter
                fromYear.Items.Add((currentYear - i).ToString());
            }

        }
    }

    protected void Button1_Click(object sender, EventArgs e)
    {
                                
        // Extract values from textboxes
        int memberacct = int.Parse(memberAcct.Text);
        string membername = memberName.Text;
        duedate.Text = DateTime.Now.AddDays(3).ToString("dd/MM/yyyy");


        // Extract values from dropdownlist
        string frommonth = fromMonth.SelectedValue;
        string tomonth = toMonth.SelectedValue;

        // Insert the data into the database
        using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DBCS"].ToString()))
        {
            connection.Open();
            SqlCommand cmd = new SqlCommand("INSERT INTO Main (@memberNumber,@memberName, @fromMonth, @fromYear, @toMonth, @toYear, @dueDate)", connection);

            cmd.Parameters.AddWithValue("@memberNumber", memberacct);
            cmd.Parameters.AddWithValue("@memeberName", membername);
            cmd.Parameters.AddWithValue("@fromMonth", frommonth);
            cmd.Parameters.AddWithValue("@fromYear", fromYear);
            cmd.Parameters.AddWithValue("@toMonth", tomonth);
            cmd.Parameters.AddWithValue("@toYear", toYear);
            cmd.Parameters.AddWithValue("@dueDate", duedate);
            cmd.Parameters.AddWithValue("@imageData", toMonth);

            cmd.ExecuteNonQuery();
            connection.Close();

            Response.Write("Image has been Added");
        }
    }
}


    
            
                
                SUBPOENA FORM
            
    
          

                
                    
                        

                        

                                
                        

                        

                                
                                
                                
                       
                       

                                
                                
                                
                       
                       
                       

                                
                                
                                
                        
                        

                                
                                
                                
                        

                
                
                    
                    
                        
                    
               

               
                    
                
                         
                
             
            
            
           




              
              
                    
                    
                    
                    
                    
                    
                    
                    
                    
               
           
           


                      
                      
                      
                      
                      
                      
                      
                      
                     
            
            


                
                
                    
                    
                    
                    
                    
                    
            
            

                   
                   
                   
                   
                   
                  
           
           

                 
                 
                 
                 
                 
               
           
           

                
                
                
                
                
            
          

       

       
         


                Comment*
                
         
      

      
         


                

          
        
      


        
            
                 © <%= DateTime.Now.ToLongDateString() %>

2 Replies

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

Jignesh Kumar1y ago
Accepted answer
Hello,

Just remove () from your button onClick="Button1_Click()"

Replace Below line
```
 
```
With this,
```
 
```

Ivonne Aspilcueta1y ago

USE [subpoenaDB]
GO
/****** Object:  StoredProcedure [dbo].[Subpoena_FinalInsert]    Script Date: 11/25/2024 11:18:58 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[Subpoena_FinalInsert]
(
    @processed bit,
	@submittedDate VARCHAR (50),
	@comment VARCHAR (MAX),
	@memberNumber INT,
    @memberName VARCHAR(100),
    @fromMonth VARCHAR(50),
    @fromYear VARCHAR(50),
	@ToMonth VARCHAR(50),
	@ToYear VARCHAR(50),
	@dueDate VARCHAR(50),
	@checkType VARCHAR(200),
	@memberIDType VARCHAR(200),
	@receiptsType VARCHAR(200),
	@signatureCardType VARCHAR(100),
	@StatementType VARCHAR (200),
	@wireTransferType VARCHAR (200),
	@loanType VARCHAR (200)
)
AS
BEGIN
    ---------------------------------------------------------------
    DECLARE @lrefID INT
    DECLARE @lmainID INT
	DECLARE @lcheckID INT
	DECLARE @lmemberID INT
	DECLARE @lreceiptID INT
	DECLARE @lsigID INT
	DECLARE @lstatID INT
	DECLARE @lwtransferID INT
	DECLARE @lloanID INT
    -----------------------------------------------
    IF NOT EXISTS ( SELECT 1 FROM ReferenceNumber WHERE memberNumber = @memberNumber AND processed = 0)
    BEGIN
        INSERT INTO ReferenceNumber (memberNumber, processed, submittedDate, comment)
        VALUES ( @memberNumber, 0, @submittedDate, @comment)
        SELECT @lrefID = @@IDENTITY
    END
    ELSE
    BEGIN
        SELECT @lrefID = refID FROM ReferenceNumber
        WHERE memberNumber = @memberNumber AND processed = 0 AND submittedDate = @submittedDate AND comment = @comment
    END
    ----------------------------------------------------
    IF NOT EXISTS ( SELECT 1 FROM Main
    WHERE refID = @lrefID AND memberNumber = @memberNumber AND memberName = @memberName AND fromMonth = @fromMonth AND fromYear = @fromYear AND toMonth = @ToMonth AND toYear = @ToYear AND dueDate = @dueDate)
    BEGIN
        INSERT INTO Main(memberNumber, refID, memberName, fromMonth, fromYear, toMonth, toYear, dueDate)
        VALUES ( @memberNumber, @lrefID, @memberName, @fromMonth, @fromYear, @ToMonth, @ToYear, @dueDate) SELECT @lmainID = @@IDENTITY
    END
    ELSE
    BEGIN
        SELECT @lmainID = mainID FROM Main
        WHERE refID = @lrefID AND memberNumber = @memberNumber AND memberName = @memberName AND fromMonth = @fromMonth AND fromYear = @fromYear AND toMonth = @ToMonth AND toYear = @ToYear AND dueDate = @dueDate
    END
    -----------------------------------------------------
	  IF NOT EXISTS ( SELECT 1 FROM MemberID
    WHERE refID = @lrefID AND memberNumber = @memberNumber AND memberIDType = @memberIDType)
    BEGIN
        INSERT INTO MemberID(memberNumber, refID, memberIDType)
        VALUES ( @memberNumber, @lrefID, @memberIDType) SELECT @lmemberID = @@IDENTITY
    END
    ELSE
    BEGIN
        SELECT @lmemberID = memberID FROM MemberID
        WHERE refID = @lrefID AND memberNumber = @memberNumber AND memberIDType = @memberIDType
    END
	---------------------------------------------------------
    IF NOT EXISTS ( SELECT 1 FROM Checks
    WHERE refID = @lrefID AND memberNumber = @memberNumber AND checkType = @checkType)
    BEGIN
        INSERT INTO Checks(memberNumber, refID, checkType)
        VALUES ( @memberNumber, @lrefID, @checkType) SELECT @lcheckID = @@IDENTITY
    END
    ELSE
    BEGIN
        SELECT @lcheckID = checkID FROM Checks
        WHERE refID = @lrefID AND memberNumber = @memberNumber AND checkType = @checkType
    END
	------------------------------------------------------------
	IF NOT EXISTS ( SELECT 1 FROM Receipts
    WHERE refID = @lrefID AND memberNumber = @memberNumber AND receiptsType = @receiptsType)
    BEGIN
        INSERT INTO Receipts(memberNumber, refID, receiptsType)
        VALUES ( @memberNumber, @lrefID, @receiptsType) SELECT @lreceiptID = @@IDENTITY
    END
    ELSE
    BEGIN
        SELECT @lreceiptID = receiptID FROM Receipts
        WHERE refID = @lrefID AND memberNumber = @memberNumber AND receiptsType = @receiptsType
    END
	----------------------------------------------------------
	IF NOT EXISTS ( SELECT 1 FROM SignatureCards
    WHERE refID = @lrefID AND memberNumber = @memberNumber AND signatureCardType = @signatureCardType)
    BEGIN
        INSERT INTO SignatureCards(memberNumber, refID, signatureCardType)
        VALUES ( @memberNumber, @lrefID, @signatureCardType) SELECT @lsigID = @@IDENTITY
    END
    ELSE
    BEGIN
        SELECT @lsigID = sigID FROM SignatureCards
        WHERE refID = @lrefID AND memberNumber = @memberNumber AND signatureCardType = @signatureCardType
    END
	-------------------------------------------------------------
	IF NOT EXISTS ( SELECT 1 FROM Statements
    WHERE refID = @lrefID AND memberNumber = @memberNumber AND StatementType = @StatementType)
    BEGIN
        INSERT INTO Statements(memberNumber, refID, StatementType)
        VALUES ( @memberNumber, @lrefID, @StatementType) SELECT @lstatID = @@IDENTITY
    END
    ELSE
    BEGIN
        SELECT @lstatID = statID FROM Statements
        WHERE refID = @lrefID AND memberNumber = @memberNumber AND StatementType = @StatementType
    END
	------------------------------------------------------------------
		IF NOT EXISTS ( SELECT 1 FROM WireTransfer
    WHERE refID = @lrefID AND memberNumber = @memberNumber AND wireTransferType = @wireTransferType)
    BEGIN
        INSERT INTO WireTransfer(memberNumber, refID, wireTransferType)
        VALUES ( @memberNumber, @lrefID, @wireTransferType) SELECT @lwtransferID = @@IDENTITY
    END
    ELSE
    BEGIN
        SELECT @lwtransferID = wtransferID FROM WireTransfer
        WHERE refID = @lrefID AND memberNumber = @memberNumber AND wireTransferType = @wireTransferType
    END
	------------------------------------------------------------------------
		IF NOT EXISTS ( SELECT 1 FROM Loan
    WHERE refID = @lrefID AND memberNumber = @memberNumber AND loanType = @loanType)
    BEGIN
        INSERT INTO Loan(memberNumber, refID, loanType)
        VALUES ( @memberNumber, @lrefID, @loanType) SELECT @lloanID = @@IDENTITY
    END
    ELSE
    BEGIN
        SELECT @lloanID = loanID FROM Loan
        WHERE refID = @lrefID AND memberNumber = @memberNumber AND loanType = @loanType
    END
END

Created a store procedure. Thank you.