I will try to not make this too confusing.
I have the following which works fine.
dress); //loads all db info into dataGridView1
//saves the changed info back to db
Below is some code I wrote to do a manual query. The data shows up in the same dataGridView1. and also using same dataSet1. I just can't get it to save.
OdbcConnection con = new OdbcConnection("DSN=ShipData");
string sqlQuery = "SELECT * FROM Address where " + searchfield.Text.ToString() + " LIKE \'%" + searchvalue.Text.ToString() + "%\'";
OdbcCommand com = new OdbcCommand(sqlQuery, con);
OdbcDataAdapter da = new OdbcDataAdapter(sqlQuery, con);
DataSet1 ds = new DataSet1();
dataGridView1.DataMember = "Address";
dataGridView1.DataSource = ds;