Search access database with other than primary key

[mhmd3210]

In C# ... How can i search my access database by some column(other than the primary key).. for example if i want user to search entries by Entring last name in a textbox .. and this could have more than one entry and show the results in the grid view table ...???

[Mitja Bonca]

You simply specify the columns name you want to seach by in the WHERE clause, and define it as parameter of the query:

DataTable table = new DataTable();
OdbcConnection conn = new OdbcConnection("connString");
string query = @"SELECT * FROM Person WHERE LastName = @last";
OdbcCommand cmd = new OdbcCommand(query, conn);
cmd.Parameters.Add("@last", SqlDbTyple.VarChar, 50).Value = textBox1.Text;
OdbcDataAdapter da = new OdbcDataAdapter(cmd);
da.Fill(table);

Now your table has all the rows from the table, based on the lastnames (the rows that have this name written in textbox