& "Phone, Fax FROM Customers WHERE CustomerID = @CustID"
Dim sqlCmd As New SqlCommand(sql, sqlCnn)
Dim sqlParam As New SqlParameter("@CustID", SqlDbType.NChar, 5)
sqlParam.Value = sCustID
sqlCmd.Parameters.Add(sqlParam)
Dim sqlDA As New SqlDataAdapter(sqlCmd)
sqlDA.Fill(ds, "Customers")
另一些表以几乎完全相同方法填充,除了某些被过滤的表需要合并到Orders表中,这样CustomerID才可以访问。
上一页 [1] [2]
Copyright @ 2007-2012 敏韬网(敏而好学,文韬武略--MinTao.Net)(学习笔记) Inc All Rights Reserved. 闵涛 E_mail:admin@mintao.net(欢迎提供学习资源)
鄂公网安备 42011102001154号
站长:MinTao ICP备案号:鄂ICP备11006601号-18