我想在客户端发送一串命令到服务端,比如
Data1.Recordset.AddNew
Data1.Recordset("类型") = Text1.Text
Data1.Recordset.Update
怎样令服务端依次执行以上的命令?请高手指点~~请详细说明一下~~谢谢~~解决后马上给分~~
Data1.Recordset.AddNew
Data1.Recordset("类型") = Text1.Text
Data1.Recordset.Update
怎样令服务端依次执行以上的命令?请高手指点~~请详细说明一下~~谢谢~~解决后马上给分~~
解决方案 »
- API中SendMessage的问题
- Picturebox控件实时绘制的曲线放大缩小的问题,Help!
- CAB包下载?
- 急!在ORACLE过程里RAISE_APPLICATION_ERROR抛出错误信息,可VB却拿不到。
- 数据库的小问题::
- 关于数据库控件的两个貌似简单的问题,无从下手!
- 各位大侠今天对我的帮助很大,我决定免费送出46分。
- vb中用crystal report做报表问题求助!!!!!!!!!!!!
- 这是我的最后的积分了,帮忙啊!如何用VB作上传控件!!
- 菜鸟问题--睡眠状态不见了?
- 如何调用Outlook时不显示安全警告提示
- 用VB打开EXCEL文件后,如何让EXCEL文件获得焦点
服务端:
With Me
.SckServer.RemoteHost = "192.168.0.46" '设置远程IP,本例设为本机。
.SckServer.LocalPort = 1001 '本地端口
.SckServer.Listen '开始监听
End With
End SubPrivate Sub sckServer_ConnectionRequest(ByVal requestID As Long)
With Me
If .SckServer.State <> sckClosed Then .SckServer.Close
.SckServer.Accept (requestID)
End With
End SubPrivate Sub sckServer_DataArrival(ByVal bytesTotal As Long)
On Error Resume Next
Dim strData As String
SckServer.GetData strData
Text1.Text = strData
End Sub客户端:
Private Sub Command1_Click()
sckClient.SendData Text2.Text
End SubPrivate Sub form_Load()
With Me
.sckClient.RemoteHost = "192.168.0.46" '设置远程IP,本例设为本机。
.sckClient.RemotePort = 1001 '远程端口,就为server中的设置一样.
End With
sckClient.Connect
End Sub我想将客户端的TEXT2中的命令发送到服务端的TEXT1中,再由服务端执行TEXT1中的命令~~
请高手发上完整源代码,给满分~~谢谢~~
客户端发送:
tcpClient.SendData "AddNew:" & Text1.Text服务端:
Private Sub tcpServer_DataArrival (ByVal bytesTotal As Long)
Dim strData As String, n As Integer
tcpServer.GetData strData
n = InStr(strData, ":")
If n = 0 Then Exit Sub
Select Case Left(strData, n - 1)
Case "AddNew"
Data1.Recordset.AddNew
Data1.Recordset("类型") = Mid(strData, n+1)
Data1.Recordset.Update
......
End Select
End Sub
如楼上的见到AddNew 就执行相应的动作,见到其他的字符再做其他的动作
比如:
Data1.Recordset.AddNew
Data1.Recordset("类型") = 客户端的TEXT1.TEXT
Data1.Recordset("编号") = 客户端的TEXT2.TEXT
Data1.Recordset("名称") = 客户端的TEXT3.TEXT
Data1.Recordset("单位") = 客户端的TEXT4.TEXT
Data1.Recordset("数量") = 客户端的TEXT5.TEXT
...............
Data1.Recordset.Update那应该怎样写呢?~~头都晕了~~
请写得详细一点~~回复后马上给分~~谢谢~~
.SckServer.RemoteHost = "192.168.0.46" '设置远程IP,本例设为本机。
.SckServer.LocalPort = 1001 '本地端口
.SckServer.Listen '开始监听
End With
End SubPrivate Sub sckServer_ConnectionRequest(ByVal requestID As Long)
With Me
If .SckServer.State <> sckClosed Then .SckServer.Close
.SckServer.Accept (requestID)
End With
End SubPrivate Sub sckServer_DataArrival(ByVal bytesTotal As Long)
On Error Resume Next
Dim strData As String
SckServer.GetData strData
Text1.Text = strData
SELECT CASE Text1.Text
case "Name"
Data1.Recordset.AddNew
Data1.Recordset("类型") = Text1.Text
Data1.Recordset.Update
case else
......
end select
End Sub客户端:
Private Sub Command1_Click()
sckClient.SendData Text2.Text 'Text2.Text 里面的内容要和上面的相同才是.否则执行CASE ELSE
End SubPrivate Sub form_Load()
With Me
.sckClient.RemoteHost = "192.168.0.46" '设置远程IP,本例设为本机。
.sckClient.RemotePort = 1001 '远程端口,就为server中的设置一样.
End With
sckClient.Connect
End Sub
Data1.Recordset.AddNew
Data1.Recordset("类型") = 客户端的TEXT1.TEXT
Data1.Recordset("编号") = 客户端的TEXT2.TEXT
Data1.Recordset("名称") = 客户端的TEXT3.TEXT
Data1.Recordset("单位") = 客户端的TEXT4.TEXT
Data1.Recordset("数量") = 客户端的TEXT5.TEXT比如:
Private Sub Command1_Click()
sckClient.SendData trim(Text1.Text) & "*" & trim(Text2.Text) & "*" & trim(Text3.Text) & "*" & trim(Text4.Text) & "*" & trim(Text5.Text)
End Sub
接收的时候
Private Sub sckServer_DataArrival(ByVal bytesTotal As Long)
dim a() as string
On Error Resume Next
Dim strData As String
SckServer.GetData strData
a()= split(strData,"*")
Data1.Recordset.AddNew
Data1.Recordset("类型") = a(0)
Data1.Recordset("编号") = a(1)
Data1.Recordset("名称") = a(2)
Data1.Recordset("单位") = a(3)
Data1.Recordset("数量") = a(4)
...............
Data1.Recordset.Update
End Sub