dim PhoneNumArr() as string PhoneNum= tex1.text Msg = text2.text PhoneNumArr =split(PhoneNum,",") For i = 0 To ubound(PhoneNumArr) adoRecordset.AddNew adoRecordset.Fields("phoneNum") = PhoneNumArr(0) adoRecordset.Fields("msg") = msg adoRecordset.update Next
PhoneNum= tex1.text
Msg = text2.text
PhoneNumArr =split(PhoneNum,",")
For i = 0 To ubound(PhoneNumArr)
adoRecordset.AddNew
adoRecordset.Fields("phoneNum") = PhoneNumArr(0)
adoRecordset.Fields("msg") = msg
adoRecordset.update
Next
adoRecordset.Fields("phoneNum") = PhoneNumArr(i)
在DataGrid里显示就只需要
Set .DataSource = adoRecordset
然后Refresh一下就行了