Hi All,
I am using Microsoft Visual studio 2010 Express Edition,in that SQL Server 2008 is built-in .When i insert rows into the table ,it is only shown in dataset.It is not reflected in the database.when I try to see the data in the table, by using "Show Table Data" option , the changes are not reflected.i had used the following code,

Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim con As SqlConnection = New SqlConnection("Datasource=.\SQLEXPRESS;AttachDbFil ename=D:\My VB.net Prgs\Friends\Friends\friendinfo.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True")
Dim cmd As New SqlCommand
cmd.Connection = con
cmd.CommandText = "insert into FriendDetails values(11,'Rithanya','Journalist')"
MsgBox("Row inserted !! ")
Catch ex As Exception
End Try


End Sub

Can anyone Please give me the solution for this.