JoachimPetersen
asked on
Calling SQL Stored procedure from codebehind problems
hello, I am having a bit problems with this one and I dont know why, it should work.
The stored procedure works fine when I execute, but when I use codebehind to call it, thats where it does not work.
codebehind (vb .net)
Stored procedure code(works fine when executed)
it gives no error when I try the use the codebehind to execute it, but it does not write anything in table. (tested the stored procedure by executing it, works great)
Thanks in advance, I have no clue why this does not work.
The stored procedure works fine when I execute, but when I use codebehind to call it, thats where it does not work.
codebehind (vb .net)
Function ssRadioStatistik(ByVal ChannelName As String, ByVal AlbumTitle As String, ByVal TrackTitle As String, ByVal DisplayArtist As String, ByVal StartTime As String)
Try
If DisplayArtist.ToLower.Contains("wrd1") = True And DisplayArtist.ToLower.Contains("wrd2") = True Then
'tested with a msgbox to see if it comes to here and it does...
Dim myConnectionString As String = ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString
Response.Write(myConnectionString)
Dim myConnection As SqlClient.SqlConnection = New SqlClient.SqlConnection(myConnectionString)
myConnection.Open()
Try
Dim command As SqlClient.SqlCommand = New SqlClient.SqlCommand("ErDetsStoredProcedure", myConnection)
command.CommandType = CommandType.StoredProcedure
command.Parameters.AddWithValue("@ChannelName", ChannelName)
command.Parameters.AddWithValue("@AlbumTitle", AlbumTitle)
command.Parameters.AddWithValue("@TrackTitle", TrackTitle)
command.Parameters.AddWithValue("@DisplayArtist", DisplayArtist)
command.Parameters.AddWithValue("@StartTime", StartTime)
Finally
myConnection.Close()
End Try
End If
Catch ex As Exception
End Try
End Function
Stored procedure code(works fine when executed)
ALTER PROCEDURE [Joachim_ErDets].[ErDetBieberStoredProcedure]
@ChannelName nvarchar(50),
@AlbumTitle nvarchar(50),
@TrackTitle nvarchar(50),
@DisplayArtist nvarchar(50),
@StartTime datetime
AS
IF NOT EXISTS (SELECT * FROM ErDetsTable WHERE StartTime = @StartTime AND ChannelName = @ChannelName)
BEGIN
INSERT INTO ErDetsTable (ChannelName, AlbumTitle, TrackTitle, DisplayArtist, StartTime, DatetimeStamp)
VALUES (@ChannelName, @AlbumTitle, @TrackTitle, @DisplayArtist, @StartTime, GETDATE())
END
it gives no error when I try the use the codebehind to execute it, but it does not write anything in table. (tested the stored procedure by executing it, works great)
Thanks in advance, I have no clue why this does not work.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
you are missing
again if u face issues, add
command.ExecuteNonQuery()
again if u face issues, add
.....
Catch ex As Exception
response.write ex.toString() 'For Testing only
End Try
I already mentioned command.ExecuteNonQuery() as part of my previous post.
@mas_oz2003,
Sorry about that..... truly, i didn't read your comment properly..
Sorry about that..... truly, i didn't read your comment properly..
Error?