Database Question

So I have this issue I am working with.
It invloved using classes to do my database dirty work.

Here is the code causing the error




Dim famID As Integer = db.InsertFamilyMember(New FamilyMemberDetails(0, "Test", "Test", [email protected]))


This calls this function


Public Function InsertFamilyMember(ByVal fam As FamilyMemberDetails) As Integer


Dim con As New SqlConnection(connectionString)
Dim cmd As New SqlCommand("InsertFamilyMember", con)
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add(New SqlParameter("@FirstName", SqlDbType.NVarChar, 10))
cmd.Parameters("@FirstName").Value = fam.FirstName
cmd.Parameters.Add(New SqlParameter("@LastName", SqlDbType.NVarChar, 20))
cmd.Parameters("@LastName").Value = fam.LastName
cmd.Parameters.Add(New SqlParameter("@Email", SqlDbType.NVarChar, 200))
cmd.Parameters("@Email").Value = fam.Email
cmd.Parameters.Add(New SqlParameter("@FamilyID", SqlDbType.UniqueIdentifier, 4))
cmd.Parameters("@FamilyID").Direction = ParameterDirection.Output
Try
con.Open()
cmd.ExecuteNonQuery()
Return CInt(cmd.Parameters("@FamilyID").Value)
Catch err As SqlException
Throw New ApplicationException("Data Error")
Finally
con.Close()
End Try


End Function


Also this is where I set the family details


Public Sub New(ByVal nFamilyID As Integer, ByVal strFirstName As String, ByVal strLastName As String, ByVal strEmail As String)


Me.FamilyID = nFamilyID
Me.FirstName = strFirstName
Me.LastName = strLastName
Me.Email = strEmail


End Sub


The rest of the properties are in the class just don't feel like posting it all.


This is the error we return.



Server Error in '/' Application.


Object reference not set to an instance of an object.


Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

Source Error:

Code:

Line 10:     Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Line 11: 
Line 12:         Dim famID As Integer = db.InsertFamilyMember(New FamilyMemberDetails(0, "Test", "Test", "[email protected]"))
Line 13: 
Line 14:         WriteFamilyMemberList()

Source File: E:\web\blueskies9c\htdocs\Default.aspx.vb Line: 12

Stack Trace:

Code:

[NullReferenceException: Object reference not set to an instance of an object.]
   _Default.Page_Load(Object sender, EventArgs e) in E:\web\blueskies9c\htdocs\Default.aspx.vb:12
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +47
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061

Version Information:Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42


I have researched this error message with no success.
Any thoughts?


Thanks in advance.<!--
[NullReferenceException]: Object reference not set to an instance of an object.
at _Default.Page_Load(Object sender, EventArgs e) in http://server/Default.aspx.vb:line 12
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
[HttpUnhandledException]: Exception of type 'System.Web.HttpUnhandledException' was thrown.
at System.Web.UI.Page.HandleError(Exception e)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
at System.Web.UI.Page.ProcessRequest(HttpContext context)
at ASP.default_aspx.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
--><!--
This error page might contain sensitive information because ASP.NET is configured to show verbose error messages using <customErrors mode="Off"/>. Consider using <customErrors mode="On"/> or <customErrors mode="RemoteOnly"/> in production environments.-->

 

Nevermind I fixed it I was missing a new command