ERROR : The OleDbParameterCollection only accepts non-null OleDbParameter type objec

[NIRAL12]

public int ExecuteNonQuery(string query, params OleDbParameter[] parameters)
{
OleDbConnection cnn = new OleDbConnection(strConnectionString);
OleDbCommand cmd = new OleDbCommand(query, cnn);
if (query.StartsWith("INSERT") | query.StartsWith("insert") | query.StartsWith("UPDATE") | query.StartsWith("update") | query.StartsWith("DELETE") | query.StartsWith("delete"))
{
cmd.CommandType = CommandType.Text;
}
else
{
cmd.CommandType = CommandType.StoredProcedure;
}
for (int i = 0; i <= parameters.Length - 1; i++)
{


cmd.Parameters.Add(parameters[i]);

}
cnn.Open();
int retval = cmd.ExecuteNonQuery();
cnn.Close();
return retval;
}

TIHS IS CODE PLEASE HELP VERY URGENT

[shweta123]

Hi,

Can you specify more details about your code and the Line No where you are getting the error?
Are you executing the stored procedure or simple Sql query through the function?
If it is a Sql query and you are using any placehoders for that, see if this Thread helps you.