C#-Get data from database into Datagridview Row

[ratana30]

Dear All,

I have a datagridview has many columns inside.
I would like to retrieve data from database into all columns that I have already created.

How to do it?
If I used this below code, it will get all data from database into datagridview by adding many new columns

------

myConnection myCon1 = new myConnection();
myCon1.openConnection();
string query1 = "SELECT * FROM tblContractDetail WHERE Contract_No = @value1";
OleDbParameter sp = new OleDbParameter("value1", OleDbType.VarChar);
sp.Value = valuesearch;
DataTable dt = myCon1.executeSelectQuery(query1, new OleDbParameter[] { sp });
dgvContractDetail.DataSource = dt;

-------