Dear experts, i'm still new in asp.net. I got problem in inserting data to database.. can u help me out? Thanksss..Try this out, i'm not sure if it have a great difference, but try it anyway 
Try
Dim cn As New SqlClient.SqlConnection("data source=CHIONG;initial catalog=library;integrated security=SSPI;persist security info=False;workstation id=CHIONG;packet size=4096")
Dim SQL As String = "INSERT INTO member (MemEmail, MemPwd, MemFName, MemLName, MemGender, MemBirthMonth, MemBirthDay, MemBirthYear) VALUES ('" & EmailAdd.Text & "','" & Password2.Text & "','" & FirstName.Text & "','" & LastName.Text & "','" & genderlist.SelectedItem.Value & "','" & monthlist.SelectedItem.Value & "','" & daylist.SelectedItem.Value & "','" & yearlist.SelectedItem.Value & "')"
Dim cm As New SqlClient.SqlCommand(SQL, cn)
cn.Open()
cm.ExecuteNonQuery()
'you should make any action here, like placing a label and write in it that
'insert is complete
'or redirect the user to other page
cn.Close()
Catch ex As Exception
Response.Write(ex.Message)
End TryThanks.. I guess i din sign in for SQL server, that's why it gives me problems.. Thanks yea..
Try
Dim cn As New SqlClient.SqlConnection("data source=CHIONG;initial catalog=library;integrated security=SSPI;persist security info=False;workstation id=CHIONG;packet size=4096")
Dim SQL As String = "INSERT INTO member (MemEmail, MemPwd, MemFName, MemLName, MemGender, MemBirthMonth, MemBirthDay, MemBirthYear) VALUES ('" & EmailAdd.Text & "','" & Password2.Text & "','" & FirstName.Text & "','" & LastName.Text & "','" & genderlist.SelectedItem.Value & "','" & monthlist.SelectedItem.Value & "','" & daylist.SelectedItem.Value & "','" & yearlist.SelectedItem.Value & "')"
Dim cm As New SqlClient.SqlCommand(SQL, cn)
cn.Open()
cm.ExecuteNonQuery()
'you should make any action here, like placing a label and write in it that
'insert is complete
'or redirect the user to other page
cn.Close()
Catch ex As Exception
Response.Write(ex.Message)
End TryThanks.. I guess i din sign in for SQL server, that's why it gives me problems.. Thanks yea..