主题：疑惑？请专家指导！

别人说狐表操作外部表和内部表一样，我昨天凭感觉写了一段代码，外部数据表就是不见数据，

难道外部表添加数据只能用这命令吗？cmd.CommandText = "Insert Into   请赐教，谢谢！

 

Dim qq As String= e.Form.Controls("TextBox1").value

Dim ww As String= e.Form.Controls("TextBox2").value

Dim ee As String= e.Form.Controls("TextBox3").value

Dim rr As String= e.Form.Controls("TextBox4").value

Dim tt As String= e.Form.Controls("TextBox5").value

Dim yy As String= e.Form.Controls("TextBox6").value

Dim uu As String= e.Form.Controls("ComboBox1").value

Dim ii As String= e.Form.Controls("ComboBox2").value

Dim cmd As New SQLCommand

Dim dt As DataTable

Dim dr As DataRow

cmd.C

cmd.CommandText = "Select * From {物料表}"

dt = cmd.ExecuteReader(True)

dr= dt.AddNew()

If qq <> "" And ww <> "" And uu<> "" And ii <> "" Then

dr("SKU")= qq

dr("品名")= ww

dr("类别")= uu

dr("属性")= ii

dr("重量")= ee

dr("体积")= rr

dr("包装规格")= tt

dr("托盘装载量")= yy

End If

 

你还需要保存一下.  dt.Save

哦，真的了，太感谢了！狐表确实不错，这代码比SQL代码好看多了！谢谢