SQL function help

[oceantrain]

I am trying to archive a datagrid into a datatable so I can find it in the table by the archive date. I am using an INSERT SQL statement as follows:

INSERT INTO [VendorArchive] ([Booth], [Deposit], [Rent], [Electric], [Security], [AmountPaid], [DatePaid], [PeriodPaid], [TotalDue], [Notes], [ArchiveDate], [BalanceDue], GETDATE());
 
SELECT Booth, Deposit, Rent, Electric, Security AmountPaid, DatePaid, PeriodPaid, TotalDue, BalanceDue, Notes
 
FROM Vendors 

I then call the sql function in my code inside a button click event:

private void vendorArchiveToolStripButton_Click(object sender, EventArgs e)
 
        {
 
            if (MessageBox.Show("Are you sure you wish to archive?", "Perform Archive", MessageBoxButtons.YesNo) == DialogResult.Yes)
 
            {
 
                vendorArchiveTableAdapter.PerformArchive();
 
                MessageBox.Show("Archive has completed.");
 
            }
 
 
 
        }
 

When i debug and hit the archive button I get this error: "No overload for method 'PerformArchive' takes 0 arguments"

I don't understand. Am I using the wrong SQL statement? Do I need to add all the columns as argumnets in the method call?

Please help.

[Christopher Nigro]

The 'PerformArchive' method expects you to pass one or more arguments with the call to it. You aren't passing any. If you don't understand this, show us the signature/defintion for the 'PerformArchive' method.

[oceantrain]

Thanks for responding Christopher. I was under the impression that I created the function/method in A SQL statement and was just calling it with :

vendorArchiveTableAdapter.PerformArchive();

The arguments in the SQL statement are (@p1, @p2, @p3 ect.) I did try to add those arguments in code but still no help. Do I need to define the method like any other as a SQL staement? Confused.

[Christopher Nigro]

Hi,

I am having a hard time with the terminolgy you are using. Please show the complete defintion of PerformArchive.