The problem I have is how to PASS THE CONTENTID and insert it into the DB. That is, a user clicks on the Read more, they are taken to the contentDetails page. At the bottom, I have my comments control, for the comments from readers. Any ideas on how to capture this field?
My Comments control looks like this:
Protected Sub btncomments_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btncomments.Click
Dim myObj As New CommentsDB
myObj.Savecomments(CommentId.Text, _ // I need this field passed as hidden field
txtemail.Text, _
txtcomment.Text)
End Sub
Enter Subject:
<asp:TextBox ID="txtsubject" runat="server"></asp:TextBox><br />
<br />
Enter email: <asp:TextBox ID="txtemail" runat="server"></asp:TextBox><br />
<br />
Enter name: <asp:TextBox ID="txtname" runat="server"></asp:TextBox><br />
<br />
My Comments table looks like this:
-------------------------------
CommentId PK Not Null
ContentID Fk â¦â¦â¦â¦.. From
Comment nvarchar
More fieldsâ¦
My Comments class looks like this
--------------------------------------
Public Function Savecomments(ByVal _CommentId As Integer, _
ByVal _PosterEmail As String, _
ByVal _Comments As String) As Boolean
Dim sqlConn As New SqlConnection(ConnectionStrings("Cms").ConnectionS tring)
Dim cmd As New SqlCommand("sprocContentcommentsInsert", sqlConn)
cmd.Parameters.Add("@contentId", SqlDbType.Int).Value = _contentid
cmd.Parameters.Add("@PosterCity", SqlDbType.NVarChar, 50).Value = _PosterCity
cmd.Parameters.Add("@Comments", SqlDbType.NText).Value = _Comments
Try
sqlConn.Open()
cmd.CommandType = CommandType.StoredProcedure
Savecomments = cmd.ExecuteNonQuery()
Catch
Throw
Finally
sqlConn.Close()
cmd.Dispose()
sqlConn.Dispose()
End Try
End Function
Thanks,
yousaid
Chapter 5 CMS extension
