Help calling an object, new to OOP and know I am missing something stupid.

[Eagle_f90]

Once again I am calling on those more experianced then me for help. Here is the situration. I have an class called "SQLHelper" which contains the objects to make calls to the SQL Server (thanks to another on here for that). I am trying to pass 3 paramiters to one of the objects but keep getting the erro "No overload for method ExecSQLNonQeruy takes X arguments". Can someone look at it and tell me what is wrong? Thanks.

SQLHelper Code:

public static int ExecSQLNonQuery(string SQLQuery, string SingleParam, Array Params)
    {
        int RetVal = 0;

        using (SqlConnection Con = GetCon())
        {
            SqlCommand cmd = new SqlCommand();
            Con.Open();
            {
                cmd.CommandText = SQLQuery;
                cmd.CommandType = CommandType.Text;
                cmd.Connection = Con;

                if (SingleParam == null)
                {
                    cmd.Parameters.Add(SingleParam);
                }
                else
                {
                    foreach (SqlParameter Param in Params)
                    {
                        cmd.Parameters.Add(Param)
                    }
                }

                RetVal = cmd.ExecuteNonQuery();
            }
        }
        return RetVal;
    }

Calling code:

using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class Assignments_add : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (IsPostBack)
        {
            const string SQLStatment = "Insert into TaskList (Task, Status) values ('@Task', 'ToBeWorked')";
            string[] Projects = txtProjects.Value.Split(';');

            foreach (string Project in Projects)
           {
               SQLHelper.ExecSQLNonQuery();
            }
        }
    }
}

I have also tried

SQLHelper.ExecSQLNonQuery(SQLStatment, Project, null);

[mariocatch]

ExecSQLNonQuery takes 3 arguments but you're calling it with zero parameters in your foreach.

[Eagle_f90]

Right but if you look I stated I also tried calling it with:

SQLHelper.ExecSQLNonQuery(SQLStatment, Project, null);

which has 3 arguments but I get the same error.

[mariocatch]

well what you tried will work. what line is the error on. callstack please.

[Eagle_f90]

well what you tried will work. what line is the error on. callstack please.

When I have the line of code with 3 arguments in it I get this:

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: CS1501: No overload for method 'ExecSQLNonQuery' takes '3' arguments

Source Error:



Line 16: foreach (string Project in Projects)
Line 17: {
Line 18: SQLHelper.ExecSQLNonQuery(SQLStatment, Project, null);
Line 19: }
Line 20: }

[TheGreatCthulhu]

Have you recently changed the method's signature?
Try to recompile the whole project/solution. There should be a button or a menu entry named "Rebuild Solution" or "Rebuild ProjectName" or something like that. Could be that the compiler is not aware of some code alterations you made.

[mariocatch]

The sql helper class is either not compiled or you're not showing us something because everything looks right.

[Eagle_f90]

Doing a reupload fixed it. Not sure why but it did, maybe courpted upload. Thanks for helping out!

[Machta]

You should always rebuild your solution after correcting an error in your code that occur during VS build process in order to avoid such minor problems.

PS: Interesting how long did it take you guys to solve it

[Eagle_f90]

You should always rebuild your solution after correcting an error in your code that occur during VS build process in order to avoid such minor problems.

PS: Interesting how long did it take you guys to solve it

The hole site is in development so I am actualy not building the project but just uploading the raw files. Once the major work on the site is compleated I will build the project and upload.