How to make it faster ? c# and dataBase

[1qaz2wsx7]

Hi :)

I have 3 DataGrids (and even more in the future) that supose to present data from a DataBase.
When i press on the main DG all the rest
are updated according to a cartein Code Index.

The problem is that its very slow and
i want to make it faster.

Im doing it like that:
1) When clicking on the main DG.
2) Code Index is taking from the DG.
3) a connection is created to a diffrent
table in the DataBase.
4)according to this Code Index, this
table is fitered using SQL string.
5)the dataSet is presented in a dataGrid.

Thos steps happend everytime i click
on a cell in the main DataGrid.

The problem is that this is slow
and i want to make it faster,
how can i do that ?

HERE IS THE CODE:

******************************************
 dataGridView2.DataSource = null;

 string CoString = @"Provider=PervasiveOLEDB;" + @"Data Source=Z:\index;";
string strSql2 = "SELECT description,street,number,settling FROM addresses WHERE code=" + code;

OleDbConnection con = new OleDbConnection(CoString);
con.Open();


// Addresses Table
OleDbDataAdapter adapter = new OleDbDataAdapter();
adapter.SelectCommand = new OleDbCommand(strSql2, con);
DataSet dataset2 = new DataSet();
adapter.Fill(dataset2, "addresses");

this.dataGridView2.DataSource = dataset2.Tables[0];

            this.dataGridView2.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader;
            this.dataGridView2.AutoResizeColumns();

//Close Connection
con.Close();
******************************************

Thanks.

[RwCC]

Are you preforming the jobs one at a time? One way to make everything faster is to build a list first instead of doing them one at a time

[Jugortha]

I propose for u a solution, may be that get your application faster
use the tool negen.exe of the dotnet framework it creates a native image of your exe assembly in aspecified files and install them in the native image cache of the computer and that avoid the JIT compile your exe assembly each time u use the application
to do this
click on start -> Microsoft.Net Framework SDK v2.0 -> SDK command prompt
the tape
negen install exefilepath.exe
and then press enter
try this proposal