I'm getting a set of data by a DataReader
and assigning to a string. Now I need to fill the DataTable
columns with the query fields. The DataTable
is connected to a grid to display the filled data.
query is :
strSQL = "SELECT EmpCode,EmpID,EmpName FROM dbo.Employee
DataTable
columns are EmpCode, EmpID, EmpName
.
I need to read the query and assign to the columns of DataTable
and fill the table. I have tried as below but i dont get the proper output,
Me.DtShifts.Tables("NonAllocated").Clear()
Me.DtShifts.Tables("NonAllocated").Load(dr)
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…