dear fellas
my dropdown list keep giving value -1 even i choose one of it already. can anyone tell me where i was doing wrong?
this is my code
<asp:DropDownList ID="ddl_viewer" runat="server">
</asp:DropDownList>
this is my vb code
Protected Sub LoadViewer()
ddl_viewer.DataSource = SQL_Viewer()
ddl_viewer.DataTextField = ("view_group")
ddl_viewer.DataValueField = ("view_ID")
ddl_viewer.DataBind()
ddl_viewer.Items.Insert(0, New ListItem("-- Choose --", "-1"))
End Sub
Protected Sub btn_save_Click(sender As Object, e As EventArgs) Handles btn_save.Click
.......
If ddl_viewer.SelectedIndex = 0 Then
MessageUser("Enter viewer")
Else
ClsNews.iNewsViewer = ddl_viewer.SelectedValue
End If
ClsNews.iNewsAuthor = Session("accid").ToString
If ClsNews.CreateNews() = True Then
.....
end if
end sub
this is my class
Dim sqlCmd As SqlCommand = New SqlCommand("Insert_News", ClsDBConn.GetDBConn)
sqlCmd.CommandType = Data.CommandType.StoredProcedure
Dim sqlParameter As SqlParameter
sqlCmd.Parameters.Add(New SqlParameter("RETURN_VALUE", SqlDbType.Int))
sqlCmd.Parameters("RETURN_VALUE").Direction = ParameterDirection.ReturnValue
sqlParameter = sqlCmd.Parameters.Add("@News_Title", Data.SqlDbType.VarChar, 500)
sqlParameter.Value = NewsTitle
sqlParameter = sqlCmd.Parameters.Add("@News_Viewer", Data.SqlDbType.VarChar, 500)
sqlParameter.Value = NewsViewer
sqlParameter = sqlCmd.Parameters.Add("@News_Message", Data.SqlDbType.VarChar, 5000)
sqlParameter.Value = NewsMessage
sqlParameter = sqlCmd.Parameters.Add("@News_Author", Data.SqlDbType.VarChar, 20)
sqlParameter.Value = NewsAuthor
sqlParameter = sqlCmd.Parameters.Add("@NewsID", Data.SqlDbType.VarChar, 500)
sqlParameter.Direction = Data.ParameterDirection.Output
sqlParameter = sqlCmd.Parameters.Add("@News_Status", Data.SqlDbType.VarChar, 500)
sqlParameter.Direction = Data.ParameterDirection.Output
sqlCmd.ExecuteNonQuery()
NewsStatus = sqlCmd.Parameters("@News_Status").Value
If sqlCmd.Parameters("RETURN_VALUE").Value <> 0 Then
newsID = ""
Return False
Else
newsID = sqlCmd.Parameters("@NewsID").Value
Return True
End If
and this is my stored procedure
ALTER PROCEDURE [dbo].[Insert_News]
-- Add the parameters for the stored procedure here
@News_Title VARCHAR (500),
@News_Viewer VARCHAR (500),
@News_Message VARCHAR (300),
@News_Author VARCHAR (100),
@NewsID VARCHAR (50) OUTPUT,
@News_Status VARCHAR (500) OUTPUT
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
INSERT INTO News_MessageBoard (news_Viewer,news_Title, news_Message, news_Author, news_AddedDate)
VALUES (@News_Viewer, @News_Title, @News_Message, @News_Author, CONVERT(SMALLDATETIME,GETDATE()))
SET @NewsID = SCOPE_IDENTITY()
SET @News_Status = 'News Succesfully Added.'
END