哪位高手说说DataTable和Command和区别
喜欢用DataTable来进行数据库操作,
这是我经常用的:
Dim strCon As String = "Driver={Progress OpenEdge 10.1C driver};DB=mfgsys;UID=sysprogress;PWD=sysprogress;HOST=192.168.0.9;PORT=9070;"
Dim dt_dataGridView As DataTable = New DataTable()
Dim con_odbc As OdbcConnection = New OdbcConnection(strCon)
Dim ada_dataGridView As OdbcDataAdapter = New OdbcDataAdapter(strsql, strCon)
ada_dataGridView.Fill(dt_dataGridView)
但在网上看到有的人喜欢用Command
Dim OdbcDbConnetion3 As System.Data.ODBC.OdbcConnection
Dim StrDriver As String = "Driver={Progress OpenEdge 10.1C driver};DB=mfgsys;UID=sysprogress;PWD=sysprogress;HOST=192.168.0.9;PORT=9070"
OdbcDbConnetion3 = New System.Data.ODBC.OdbcConnection(StrDriver )
OdbcDbConnetion3.Open()
Dim MtlQueue As New OdbcDataAdapter
Dim myUpdateStr As String = "update pub.UD35 set ShortChar13='" + DeptID + "'"
MtlQueue.UpdateCommand = New OdbcCommand(myUpdateStr, OdbcDbConnetion3)
Dim m As integer
m = MtlQueue.UpdateCommand.ExecuteNonQuery()
哪位高手说说两者的优劣