Unhandled exception has occurred in your application - no value given for one or ...

[kolinhar1]

I have developed a visual studio 2008 / C# / access 2000 application on XP professional this works fine. I am now testing on a vista home basic machine (both machines are 32)

The application is installed on both the XP Professional and Vista Home Edition machines.

I am getting the error message 'Unhandled exception has occurred in your application ... No value given for one or more required parameters'

this line occurs following line of code

            row_cnt = username_adapter.Fill(username_rec,
                                            "username");
 

I have visual studio installed on both machines and when installed on both machines the application runs fine with out errors. I use an application call 'Advanced Installer' to generate a setup executable to install the application on the machines. when installed on to the XP professional machine, the application runs fine.

The full listing of the class this error occurrs in is as below

        OleDbConnection conn_string;
        connection_string connection_string = new connection_string();
 
        DataSet username_rec;
        OleDbDataAdapter username_adapter = new OleDbDataAdapter();
        DataTable username_table;
        DataRow[] username_rows;
        DataRow username_row;
 
        Int32 row_cnt = 0;
 
        public username_class()
        {
            conn_string = connection_string.get();
 
            username_adapter = create_username_adapter(conn_string);
        }
 
        private void username_load()
        {
            username_rec = new DataSet("username");
 
            username_rec.Clear();
 
            row_cnt = username_adapter.Fill(username_rec,
                                            "username");
            MessageBox.Show("row_cnt = " + row_cnt);
 
            username_table = username_rec.Tables["username"];
        }
 
        public Int32 get_no_of_username()
        {
            username_load();
            return (row_cnt);
        }
 
        public Boolean is_username_set(Int32 resource_id)
        {
            string select_filter;
            Boolean username_set;
 
            username_set = false;
            if (row_cnt > 0)
            {
                username_row = username_table.Rows[0];
                row_cnt = username_table.Rows.Count;
                if (row_cnt > 0)
                {
                    select_filter = "resource_id = " + resource_id;
                    username_rows = username_table.Select(select_filter);
                    row_cnt = username_rows.Length;
                    if (row_cnt > 0)
                    {
                        username_set = true;
                    }
                }
            }
            return (username_set);
        }
 
        public Int32 get_username_data(Int32 username_id,
                                       Int32 resource_id,
                                       out String username,
                                       out String password)
        {
            string select_filter;
 
            username = "";
            password = "";
 
            if (row_cnt > 0)
            {
                username_row = username_table.Rows[0];
                row_cnt = username_table.Rows.Count;
                if (row_cnt > 0)
                {
                    if (username_id == -1)
                    {
                        select_filter = "resource_id = " + resource_id;
                    }
                    else
                    {
                        select_filter = "username_id = " + username_id;
                    }
                    username_rows = username_table.Select(select_filter);
                    row_cnt = username_rows.Length;
                    if (row_cnt > 0)
                    {
                        username_row = username_rows[0];
                        username = Convert.ToString(username_row["user_name"]);
                        password = Convert.ToString(username_row["pass_word"]);
                    }
                }
            }
            return (row_cnt);
        }
 
        private void save_username_record(string username,
                                          string password,
                                          Int32 new_resource_id)
        {
            username_row["user_name"] = username;
            username_row["pass_word"] = password;
            username_row["resource_id"] = new_resource_id;
        }
 
        public void save_username_record(Int32 username_id,
                                         Int32 resource_id,
                                         string username,
                                         string password,
                                         Int32 new_resource_id)
        {
            Int32 row_cnt;
 
            if (username_id == -1)
            {
                username_row = username_table.NewRow();
                username_row.BeginEdit();
                save_username_record(username,
                                     password,
                                     new_resource_id);
                username_row.EndEdit();
                username_table.Rows.Add(username_row);
            }
            else
            {
                username_row = username_rows[0];
                username_row.BeginEdit();
                save_username_record(username,
                                     password,
                                     new_resource_id);
                username_row.EndEdit();
            }
 
            username_adapter.Update(username_table);
            if (username_id == -1)
            {
                row_cnt = get_username_data(username_id,
                                            resource_id,
                                            out username,
                                            out password);
            }
        }
 
        public static OleDbDataAdapter create_username_adapter(OleDbConnection connection)
        {
            OleDbDataAdapter adapter = new OleDbDataAdapter();
 
            adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;
 
//          Create the SelectCommand.
            OleDbCommand command = new OleDbCommand("SELECT username_id, " +
                                                           "user_name, " +
                                                           "pass_word, " +
                                                           "resource_id " +
                                                      "FROM username ", connection);
 
            adapter.SelectCommand = command;
 
//          Create the InsertCommand.
            command = new OleDbCommand("INSERT INTO username (user_name, " +
                                                             "pass_word, " +
                                                             "resource_id) " +
                                       "VALUES (@user_name, " +
                                               "@pass_word, " +
                                               "@resource_id)", connection);
 
//          Add the parameters for the InsertCommand.
            command.Parameters.Add("@user_name",
                                   OleDbType.Char,
                                   50,
                                   "user_name");
 
            command.Parameters.Add("@pass_word",
                                   OleDbType.Char,
                                   50,
                                   "pass_word");
 
            command.Parameters.Add("@resource_id",
                                   OleDbType.Double,
                                   5,
                                   "resource_id");
 
            adapter.InsertCommand = command;
 
//          Create the UpdateCommand.
            command = new OleDbCommand("UPDATE username " +
                                          "SET user_name = @user_name, " +
                                              "pass_word = @pass_word, " +
                                              "resource_id = @resource_id " +
                                        "WHERE username_id = @oldusername_id", connection);
 
//          Add the parameters for the UpdateCommand.
            command.Parameters.Add("@user_name",
                                   OleDbType.Char,
                                   50,
                                   "user_name");
 
            command.Parameters.Add("@pass_word",
                                   OleDbType.Char,
                                   50,
                                   "pass_word");
 
            command.Parameters.Add("@resource_id",
                                   OleDbType.Double,
                                   5,
                                   "resource_id");
 
            OleDbParameter parameter = command.Parameters.Add("@oldusername_id", 
                                                              OleDbType.Double,
                                                              5,
                                                              "username_id");
            parameter.SourceVersion = DataRowVersion.Original;
 
            adapter.UpdateCommand = command;
 
//          Create the DeleteCommand.
            command = new OleDbCommand("DELETE FROM username " +
                                        "WHERE username_id = @username_id", connection);
 
//          Add the parameters for the DeleteCommand.
            parameter = command.Parameters.Add("@username_id",
                                               OleDbType.Double,
                                               5,
                                               "username_id");
            parameter.SourceVersion = DataRowVersion.Original;
 
            adapter.DeleteCommand = command;
 
            return adapter;
        }
 

[arie]

What exeption details you get (you can check in system EventViewer, in Application log)?

You said that when you have VisualStudio installed on your Vista machine it runs fine (or I didn't understood you).

If so, are you sure the exception doesn't occur on your developer machine? Maybe your debugger just ignores it (as, for example, "first time exception")? Sometimes it's the case, even if VisualStudio isn't currently "running". Anyway, check the log and, when debugging, check your Output window.

[kolinhar1]

Yes I have Visual Studio installed on the Vista Home Editon machine. The application runs fine in the development environment, but when installed as an application it fails with the error message. On XP Profeswional, the application run fine in the developement environment and as an installed application.

[arie]

I've had similar problem before. In my case it was "first chance exception".

When VisualStudio is running and you’re debugging your application, the debugger gets notified whenever an exception is encountered. At this point, the application is suspended and the debugger decides how to handle the exception. The first pass through this mechanism is called a "first chance" exception. Now depending on the debugger's configuration, it will either resume the application and pass the exception on or it will leave the application suspended and enter debug mode. If the application handles the exception, it continues to run normally. (Sometimes on non-developer machines application will crash if this issue is left alone!).

When VisualStudio isn't running and exception is thrown, the JIT (just-in-time debugger) intercepts it, if it's enabled. It will launch the Visual Studio program automatically if an application running outside Visual Studio crashes or has an exception occur. And then, if your exception was "first chance", Visual just ignores it.

The problem is, on Vista JIT isn't enabled by default. You have to enable it, but better choice is to deal with the exception (because not everyone that will use your app will have it enabled or installed).

I've found this info here:
http://naveensrinivasan.com/2010/11/16/clr20r3/
http://msdn.microsoft.com/en-us/magazine/cc793966.aspx
http://www.microsoft.com/msj/0197/Ex...Exception.aspx
http://www.codeproject.com/KB/dotnet...xceptions.aspx
http://codeidol.com/csharp/csharpckb...nce-Exception/

Also, you can try surrounding the line that causes exception with try {} catch(){} block. This way you can at least know for sure if and what exactly is going wrong and if it can be ignored or handled in some way.

As for the exception itself, there is probably something wrong with DataSet username_rec or database connection.

[tacton]

Def. throw in the try catch as arie suggested. Also, a quick shot in the dark bc I had something similar happen to me: Make sure that the machines that the app is being installed on have up to date .Net frameworks installed. Also, if your using any really specialized assemblies, set them to copy locally. I was banging my head against the wall for days getting a non-helpful error message such as yours when using assemblies for team foundation server which I finally fixed with a try catch and able to see I had to set the assemblies to copy local. Like I said, a shot in the dark but may just maybe your problem and doesn't take long to test if that is the problem.

[kolinhar1]

Hi I will try the try {} catch {} method, but not sure where to get the error information from? and I will have a look at the .net frame work as well. I have had a problem with the data connection on the vista machine when not using the visual studio environment, also I am assuming that the data set is fine as it works ok on the XP Profressional machine. I will post more information back once I have done some more testing.

Thanks

[kolinhar1]

I am still getting the same problem as before, I am now using TRY {} CATCH {} statements to give only the error message 'No Value given for one or more required parameters'. The error still comes back on the username_adapter.fill statement. The data source is an Access database. I have define the connection string in the properties part of the application. I am only using the select statement at the moment, I had commented out the 'insert', 'update' and 'delete' sql statements when I create the adapter. Are there any extra information i need to include.

many thanks