ALTER PROCEDURE Fill_Find
@GradeID int,
@TopicID int,
@key varchar(50)AS
declare @sele varchar(500)
set @sele = 'select * from D_fill where gradeId = 1 and topicId = 1 and Content Like ''' + '%' + @key + '%'''
exec (@sele)
RETURN
@GradeID int,
@TopicID int,
@key varchar(50)AS
declare @sele varchar(500)
set @sele = 'select * from D_fill where gradeId = 1 and topicId = 1 and Content Like ''' + '%' + @key + '%'''
exec (@sele)
RETURN
给你个参考ALTER PROCEDURE Fill_Find
@GradeID int,
@TopicID int,
@key varchar(50)AS
declare @sele varchar(500)
set @sele = 'select * from D_fill where gradeId = 1 and topicId = 1 and Content Like ''' + '%' + @key + '%'''
exec (@sele)
调用: Public Function GetAdminRights(ByVal adminid As Integer) As datasets
'PROCEDURE(pr_GetAdminRights)
'@intAdminID int,
'@chvErrmsg varchar(128) output
Dim returns As New datasets Dim dblink As New DBLink
dblink.ChangeCatalog("manage")
Dim conn As SqlConnection = dblink.CreateConn() Dim comm As SqlDataAdapter = New SqlDataAdapter("pr_GetAdminRights", conn)
comm.SelectCommand.CommandType = CommandType.StoredProcedure Dim sqlparam As SqlParameter
sqlparam = comm.SelectCommand.Parameters.Add(New SqlParameter("@return", SqlDbType.Int))
sqlparam.Direction = ParameterDirection.ReturnValue sqlparam = comm.SelectCommand.Parameters.Add(New SqlParameter("@intAdminID", SqlDbType.Int))
sqlparam.Direction = ParameterDirection.Input
sqlparam.Value = adminid sqlparam = comm.SelectCommand.Parameters.Add(New SqlParameter("@chvErrmsg", SqlDbType.VarChar, 128))
sqlparam.Direction = ParameterDirection.Output Try
Dim ds As New DataSet
conn.Open()
comm.Fill(ds)
returns.flag = comm.SelectCommand.Parameters("@return").Value
If returns.flag < 0 Then
returns.returnmsg = comm.SelectCommand.Parameters("@chvErrmsg").Value
Else
returns.ds = ds
End If
Catch ex As Exception
returns.flag = 0
returns.returnmsg = ex.Message
End Try
comm.Dispose()
conn.Close()
conn.Dispose() Return returns