Hi
I have issue that I could not execute MSsql stored procedure in asp.net
It is working fine and gives the return value when executing in Mssql server console.
My code in asp.net page
Dim strConnString As String = ConfigurationManager.ConnectionStrings("ConnectString").ConnectionString
Dim con As New SqlConnection(strConnString)
Dim cmd As New SqlCommand()
cmd.CommandType = CommandType.StoredProcedure
cmd.CommandText = "usp_Z_SO_Details"
cmd.Parameters.AddWithValue("@DATEFROM", Me.txtDateFrom.Text)
cmd.Parameters.AddWithValue("@DATETO", Me.txtDateTo.Text)
cmd.Parameters.AddWithValue("@CATEGORY ", Me.cboCategory.SelectedValue)
cmd.Connection = con
con.Open()
cmd.ExecuteReader()
con.Close()
con.Dispose()
My stored Procedure
INSERT INTO [dbo].[RPT_SO_Details](SoNo, SDate, SDay, DealerCode, Dealer, DistCode, DistName, Area,
RouteCode, [Route], CatCode, Category, ZoneCode, ZoneDesc, NoStand,
Nocopies)
SELECT SoNo, SDate, SDay, DealerCode, Dealer, DistCode, DistName, Area,
RouteCode, [Route], CatCode, Category, ZoneCode, ZoneDesc, NoStand,
Nocopies
FROM SUNMedia.dbo.StandingOrder
WHERE SDATE >= @DATEFROM AND SDATE <= @DATETO AND CATEGORY = @CATEGORY
ORDER BY CATEGORY
SELECT * FROM [dbo].[RPT_SO_Details] ORDER BY ROUTECODE,sono
Pls advice me where i did wrong
Thank you
Maideen
What I have tried:
Dim strConnString As String = ConfigurationManager.ConnectionStrings("ConnectString").ConnectionString
Dim con As New SqlConnection(strConnString)
Dim cmd As New SqlCommand()
cmd.CommandType = CommandType.StoredProcedure
cmd.CommandText = "usp_Z_SO_Details"
cmd.Parameters.AddWithValue("@DATEFROM", Me.txtDateFrom.Text)
cmd.Parameters.AddWithValue("@DATETO", Me.txtDateTo.Text)
cmd.Parameters.AddWithValue("@CATEGORY ", Me.cboCategory.SelectedValue)
cmd.Connection = con
con.Open()
cmd.ExecuteReader()
con.Close()
con.Dispose()