Article Discussion: ASP.NET Guestbook

We are going to see the steps involved in designing a guestbook using ASP.NET and SQLServer as the backend. Guestbooks are an important tool to know about your site’s visitors and their opinions. I would like to give you an idea of a basic guestbook web application in this article.


Read the full article here: ASP.NET Guestbook

Would some mind helping me with this one? I am trying to setup this Guest book in Visual Web Studio Express and I am running into problems with the code. I guess VWSE doesn't like the SqlDataAdapter1.Fill (DataSet11) in the following code. What would be the express equivalent ?

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Line1: SqlDataAdapter1.Fill (DataSet11)
End Sub

I am having the same problem with the following code:

Private Sub llPost_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles llPost.Click
Line1: Dim insertData As DataRow = DataSet11.Tables("feedback").NewRow 'create a new row
'populate the datarow with data from the form
Line2: insertData("name") = txtName.Text
Line3: insertData("email") = txtEmail.Text
Line4: insertData("comments") = txtComments.Text
Line5: insertData("rating") = CInt(ddnRating.SelectedItem.Value)
Line6: DataSet11.Tables("feedback").Rows.Add(insertData) 'add the populated row to the dataset
Try
Line7: SqlDataAdapter1.Update(DataSet11.Tables("feedback")) 'update the database
'always close the connection
Line8: SqlConnection1.Close()
Line9: Response.Redirect("viewcomments.aspx", True)
Line10: Catch ex As SqlClient.SqlException
'do something here
Line11: Catch ex As Exception
'do something here
Line12: End Try
End Sub
Thanks in advance
Dave