请找出下面这段程序的错误并修正Public Function getDataFromDB(ByVal strID As String, ByRef tblDT As DataTable) As IntegerDim connStr As String = _System.Configuration.ConfigurationSettings.AppSettings("DBConnectionString")Dim conn As SqlConnectionDim ds As New DataSetDim iRet As Integer = 0Dim sqlDA As SqlDataAdapterDim sqlComm As SqlCommandDim sql As StringIf IsNothing(strID) ThenstrID = String.EmptyEnd IfstrID = strID.Trimconn = New SqlConnection(connStr)Tryconn.Open()sql = "SELECT * FROM WWJB01 WHERE ID LIKE '%" strID "%'"sqlComm = New SqlCommand(sql, conn)sqlDA = New SqlDataAdaptersqlDA.SelectCommand = sqlCommsqlDA.Fill(ds)If Not IsNothing(ds) ThenIf ds.Tables.Count 1 Then tblDT = ds.Tables(0).CopyiRet = ds.Tables(0).Rows.CountEnd IfEnd IfCatch ex As ExceptionThrow exFinallyIf Not conn.State = ConnectionState.Closed Thenconn.Close()conn.Dispose()End IfEnd TryReturn iRetEnd Function

请找出下面这段程序的错误并修正

Public Function getDataFromDB(ByVal strID As String, ByRef tblDT As DataTable) As Integer

Dim connStr As String = _

System.Configuration.ConfigurationSettings.AppSettings("DBConnectionString")

Dim conn As SqlConnection

Dim ds As New DataSet

Dim iRet As Integer = 0

Dim sqlDA As SqlDataAdapter

Dim sqlComm As SqlCommand

Dim sql As String

If IsNothing(strID) Then

strID = String.Empty

End If

strID = strID.Trim

conn = New SqlConnection(connStr)

Try

conn.Open()

sql = "SELECT * FROM WWJB01 WHERE ID LIKE '%" & strID & "%'"

sqlComm = New SqlCommand(sql, conn)

sqlDA = New SqlDataAdapter

sqlDA.SelectCommand = sqlComm

sqlDA.Fill(ds)

If Not IsNothing(ds) Then

If ds.Tables.Count > 1 Then tblDT = ds.Tables(0).Copy

iRet = ds.Tables(0).Rows.Count

End If

End If

Catch ex As Exception

Throw ex

Finally

If Not conn.State = ConnectionState.Closed Then

conn.Close()

conn.Dispose()

End If

End Try

Return iRet

End Function

相关考题：

下面程序创建了一个线程并运行，请填空，使程序完整。public class ThreadTest {public static void main (String[] args) {Hello h=Hew Hello ()；【 】t.start ()；}}class Hello implements Runnable {int i;public void run () {while(true) {System.out.println("Hello" +i++)；if(i==5) break；}}}
查看答案
下面程序的结果是includeclass A{int a;public:A( ) :a(1) {}void showa ( ) {cout 下面程序的结果是 #include＜iostream.h＞ class A { int a; public: A( ) :a(1) {} void showa ( ) {cout ＜ ＜ a;} }; class B { int a; public: B( ) :a(2) {} void showa( ) {cout ＜ ＜ a;} }; class C: public A, public B { t a; public: C( ) :a(3) {} void showa( ) {cout ＜ ＜ a;} }; void main( ) { C c; c.showa( ) ; }A．1B．2C．3D．程序有错误
查看答案
请分析下面的程序并给出该程序的执行结果【】。 include class AA {int a;public: AA() 请分析下面的程序并给出该程序的执行结果【 】。include ＜iostream＞class AA {int a;public:AA() {cout＜＜" Initializing AA!\n" ; }AAM() {cout＜＜" Destroying AA!\n" ;};class BB {int b;AA p;public:BB() {cout＜＜"Initializing BB!\n" ;~BB() {cout＜＜"Destroying BB!\n" ;};void main() {BB X;cout＜＜"Ending main!\n' ;}
查看答案
下面程序的结果是includeclass A { int a;public: A():a(1){} void showa(){cout 下面程序的结果是 #include＜iostream．h＞ class A { int a； public： A()：a(1){} void showa(){cout＜＜a；} }； class B { int a； public： B()：a(2){} void showa(){cout＜＜a；} }； class C：public A，public B { int a； public： C()：a(3) ㈠ voidshowa(){cout＜＜a；} }； voidmain() { C c； c．showa()； }A．1B．2C．3D．程序有错误
查看答案
下面程序的结果是includeclass A{int a;public:A( ):a(1){}void showa( ){cout 下面程序的结果是 #include＜iostream.h＞ class A { int a； public： A( ):a(1){} void showa( ){cout＜＜a；} }； class B { int a； public： B( ) ：a(2) {}A．1B．2C．3D．程序有错误
查看答案
下面程序的结果是()。includeclass A{int a;public:A():a(1){}void showa(){cout 下面程序的结果是( )。 #include＜iostream.h＞ class A { int a； public： A()：a(1){} void showa(){cout＜＜a；} }； Class B { int a； public： B()：a(2){} void showa(){cout＜＜a；} )； class C：public A，public B { int a； puA．1B．2C．3D．程序有错误
查看答案
请找出下列程序中错误之处 ______。 include classA{private: intx1;protected: int 请找出下列程序中错误之处 ______。#include＜iostream.h＞class A{private：int x1；protected：int x2；public：int x3；};class B：public A{private：int y1；protected：int y2；public：int y3；void disp(){cout＜＜x1＜＜y1＜＜end1：} //Avoid set(int i) {x2=i；} //B}；void main() {B bb；bb.x3=10； //Cbb.y3=10； //D}A．AB．BC．CD．D
查看答案
5、下面的代码使用__interrupt关键字定义了一个中断服务子程序（ISR)，请找出这段代码的错误之处。 __interrupt double compute_area（double radius) { double area=PI*radius*radius; printf（"nArea=%f",area); return area; }
查看答案
找出错误并修改下面的代码： public class Test{ public static void main（String[] args){ double[100] r; for（int i = 0; i ＜ r.length（); i++); r（i) = Math.random * 100; } }指出错误代码的位置，并写出修改后的正确代码。提交的作业内容中的程序代码以代码格式提交（如题目中的代码）。
查看答案
热门标签