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
------
-------
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
------
Code:
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;