16,718
社区成员
发帖
与我相关
我的任务
分享请问如何将查询出来的rows放到一个新建的table里,另外用rows.find()返回的是一个row还是所有符合的row?
谢谢各位大侠的解答!本人新手,多多谅解,请答的浅显易懂一些,不好意思了!
...全文
请发表友善的回复…
发表回复
tony325 2004-11-21
- 打赏
- 举报
"SELECT SubAgentNO, AgentNO, AgentName, AgentTelphone,AgentMobile, " & _
"AgentEmail,AgentAccount,AgentInvoice FROM AgentTable WHERE SubAgentNO IS" + tempNOStr
tempNOStr是从comboBox中去到的值,请问这样写对不对???
在线等,请各位仁兄不吝赐教!!
"AgentEmail,AgentAccount,AgentInvoice FROM AgentTable WHERE SubAgentNO IS" + tempNOStr
tempNOStr是从comboBox中去到的值,请问这样写对不对???
在线等,请各位仁兄不吝赐教!!
tony325 2004-11-21
- 打赏
- 举报
tempNOStr = subAgentNOComboBox.Text
tempStr = "SELECT SubAgentNO, AgentNO, AgentName, AgentTelphone,AgentMobile, " & _
"AgentEmail,AgentAccount,AgentInvoice FROM AgentTable WHERE" + tempNOStr
OleDbDataAdapter1.SelectCommand = New Data.OleDb.OleDbCommand(tempStr, OleDbConnection1)
gridAgentTable.DataSource = tempTable
OleDbDataAdapter1.Fill(tempTable)
为什么我得到的还是整个table而不是查询出来的结果呢??
很郁闷!!!
tempStr = "SELECT SubAgentNO, AgentNO, AgentName, AgentTelphone,AgentMobile, " & _
"AgentEmail,AgentAccount,AgentInvoice FROM AgentTable WHERE" + tempNOStr
OleDbDataAdapter1.SelectCommand = New Data.OleDb.OleDbCommand(tempStr, OleDbConnection1)
gridAgentTable.DataSource = tempTable
OleDbDataAdapter1.Fill(tempTable)
为什么我得到的还是整个table而不是查询出来的结果呢??
很郁闷!!!
canyqf 2004-11-21
- 打赏
- 举报
1. DataAdapter.Fill()
2. DataTable.Rows.Find是根据PK查找，返回一个DataRow
2. DataTable.Rows.Find是根据PK查找，返回一个DataRow
