yavari
سه شنبه 24 بهمن 1385, 14:31 عصر
سلام
من برا روال جستجوم این SP رو نوشتم ! (در ساده ترین حالت)
ALTER PROCEDURE [dbo].[Mtn_Find]
-- Add the parameters for the stored procedure here
(@WordFind nvarchar(50) )
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
SELECT Matn from MatnBook WHERE CONTAINS (Matn,N'@WordFind')
END
اینجوریم ازش استفاده کردم
Private Function GetFind(ByVal MyWord As String) As String
' Create Instance of Connection and Command Object
Dim cnn As SqlConnection = New SqlConnection(ConStr)
Dim myCommand As SqlCommand = New SqlCommand("Mtn_Find", cnn)
' Mark the Command as a SPROC
myCommand.CommandType = CommandType.StoredProcedure
myCommand.Parameters.Add(New SqlParameter("@WordFind", MyWord))
'Create a new SqlDataAdapter object for the Matn table
Dim da As SqlDataAdapter = New SqlDataAdapter(myCommand)
' Populate the data
cnn.Open()
Return myCommand.ExecuteScalar
End Function
اما جواب نمیده !
ممنون میشم یکی بگه کجای کارم میلنگه؟ :افسرده:
با تشکر
من برا روال جستجوم این SP رو نوشتم ! (در ساده ترین حالت)
ALTER PROCEDURE [dbo].[Mtn_Find]
-- Add the parameters for the stored procedure here
(@WordFind nvarchar(50) )
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
SELECT Matn from MatnBook WHERE CONTAINS (Matn,N'@WordFind')
END
اینجوریم ازش استفاده کردم
Private Function GetFind(ByVal MyWord As String) As String
' Create Instance of Connection and Command Object
Dim cnn As SqlConnection = New SqlConnection(ConStr)
Dim myCommand As SqlCommand = New SqlCommand("Mtn_Find", cnn)
' Mark the Command as a SPROC
myCommand.CommandType = CommandType.StoredProcedure
myCommand.Parameters.Add(New SqlParameter("@WordFind", MyWord))
'Create a new SqlDataAdapter object for the Matn table
Dim da As SqlDataAdapter = New SqlDataAdapter(myCommand)
' Populate the data
cnn.Open()
Return myCommand.ExecuteScalar
End Function
اما جواب نمیده !
ممنون میشم یکی بگه کجای کارم میلنگه؟ :افسرده:
با تشکر