SQL问题

[wx_zl]

Public Function JOBSPLIT_INSERT(ByVal str1 As Data.DataSet, ByVal str2 As String) As Boolean
dsCommand.InsertCommand = New SqlCommand("INSERT INTO JOB_SPLIT SELECT * FROM str1() WHERE WIP_ENTITY_NAME=" + str2 + "", con)
Try
dsCommand.InsertCommand.Connection.Open()
dsCommand.InsertCommand.ExecuteNonQuery()
JOBSPLIT_INSERT = True
Catch
JOBSPLIT_INSERT = False
End Try
dsCommand.InsertCommand.Connection.Close()
End Function

请问其中的SQL语句如何才能引用到str1啊??我的语句好象没引用到..

[rookie_one]

到C#区问问吧
不过无非是单引号双引号和加号吧

[marco08]

--try

Public Function JOBSPLIT_INSERT(ByVal str1 As Data.DataSet, ByVal str2 As String) As Boolean
dsCommand.InsertCommand = New SqlCommand("INSERT INTO JOB_SPLIT SELECT * FROM str1() WHERE WIP_ENTITY_NAME='" + str2 + "'", con)
Try
dsCommand.InsertCommand.Connection.Open()
dsCommand.InsertCommand.ExecuteNonQuery()
JOBSPLIT_INSERT = True
Catch
JOBSPLIT_INSERT = False
End Try
dsCommand.InsertCommand.Connection.Close()
End Function

[wx_zl]

楼上的大哥,不是str2,是str1呀

[wx_zl]

问题解决 谢谢各位