用SQLCommand执行存储过程,存储过程中是临时表,datatable取不到?必须是实表才行吗?Dim cmd As new S QLCommand
cmd.C
cmd.C ommandText = "EXEC P_1 ?,?,? output"
cmd.Parameters.Add("@A1",e.Form.Controls("txt1").Text)
cmd.Parameters.Add("@A2",e.Form.Controls("txt2").Text)
cmd.Parameters.Add("@A3",0,False)
Dim dt As DataTable = cmd.ExecuteReader
msgbox(dt.DataRows.Count) 这里得到的是0
Tables(e.Form.Name & "_Table1").DataSource = dt
Dim count As Integer = Cmd.Parameters("@A3") '取得存储过程的返回值
msgbox(count)