OleDbCommand problem

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

Code:

---

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

Code:

---

No value given for one or more required parameters.

---

thanks

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

Try

Code:

---

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

---

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

Quote:

---

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

Code:

---

"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.

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

thanks again!