以下内容为程序代码:
1 DataTables("表C").DataRows.Clear()
2 Dim dt As DataTable
3 Dim i As Integer
4 Dim SQL As String
5 Dim Date1 As WinForm.DateTimePicker = e.Form.Controls("DateTimePicker1")
6 Dim Date2 As WinForm.DateTimePicker = e.Form.Controls("DateTimePicker2")
7
8 If Date1.Text = Nothing OrElse Date2.Text = Nothing Then
9
10 Messagebox.Show("请输入开始结束日期!")
11 Return
12 End If
13
14 SQL = " EXEC CFYRW_SP '" & Replace(Date1.Text,"-","") & "'"
15
16 Messagebox.Show(SQL)
17 DataTables("表C").Fill(SQL,"测试机",True)
我设计了个新窗口,按钮Click事件中,使用如上方法调用存储过程,然后通过Datatables.Fill运行存储过程,企图把存储过程返回的表填充到"表C"中.运行时点击按钮,表C没有填充数据,也没有报错.(此存储过程在SQL查询分析器中能正常运行并返回表) 请各位大师指点