OleDbCommand problem

[homer.favenir]

hi,
i have a code that i cant make it work

string myName = "homerfavenir";
            string source = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=user.mdb";
            string input = @"INSERT INTO Users (firstname) values (" + myName + ")";
            OleDbConnection conn = new OleDbConnection(source);
            conn.Open();

            // Do something useful

            OleDbCommand cmd = new OleDbCommand(input,conn);
            cmd.ExecuteNonQuery();
            conn.Close();

error

No value given for one or more required parameters.

thanks

[boudino]

I think that myName shoud be qouted in SQL to get something like INSERT INTO Users (firstname) values ('myName')

Try

   string input = @"INSERT INTO Users (firstname) values ('" + myName + "')";

[homer.favenir]

thanks!
ok, but when the INSERT is success, i need to close the application and open it again to update the table and see the record.
how can i refresh it so that when i insert a record it will show automatically

tia

[nelo]

ok, but when the INSERT is success, i need to close the application and open it again to update the table and see the record.
how can i refresh it so that when i insert a record it will show automatically

How about reading the information from the table using another command before you close the connection? The SQL should be simple

"SELECT * FROM Users"

How you read the data depends on how you've structured your application and how you want to display the data. The two simple options are using a OleDbDataReader and custom class representing the user or using OleDbDataAdapter and a DataSet. I generally go for the former approach but second is equally valid.
Using OleDBDataReader
Using OleDbDataAdapter
These links should get you going.

[boudino]

It is good practice to enumare all required columns in select clause rather than using "*" because it is more robust forward schema changes.

[homer.favenir]

thanks again!