I have predefined grid view it's contain two column (colEmpCode,colEmpName) those column name are assign by object properties
this is my code
OdbcCommand OpenEmp = new OdbcCommand("SELECT EMPLOYEE_GROUP_ASSIGN.EmpNo, EMPLOYEE_PERSONAL.FullName FROM " +
"EMPLOYEE_GROUP_ASSIGN INNER JOIN EMPLOYEE_PERSONAL ON EMPLOYEE_GROUP_ASSIGN.EmpNo = EMPLOYEE_PERSONAL.EmpId " +
"WHERE (EMPLOYEE_GROUP_ASSIGN.EmpGroupCode = '" + cmbEmpGrup.Text.Trim().ToString() + "')", MainMod.Conn);
OdbcDataReader readEmp = OpenEmp.ExecuteReader();
DataTable table = new DataTable();
table.Columns.Add("EmpNo", typeof(string));
table.Columns.Add("FullName", typeof(string));
while (readEmp.Read())
{
table.Rows.Add(MainMod.NullableString(readEmp.GetValue(0).ToString()),MainMod.NullableString(readEmp.GetValue(1).ToString()));
}
readEmp.Dispose();
gvEmployee.DataSource = table;
when i call (gvEmployee.DataSource = table) it give me record to new columns
in data grid view
but i want to add the records to my predefined columns like this
gvEmployee.columns[0].value = table.columns[0].value
gvEmployee.columns[1].value = table.columns[1].value
how to achieve the target ?
Please help me