Advice using sql_sp to insert data

[jjay24]

Hello All GoodMorning,

I created a sql stored procedure that will insert data for me depending on user input. Now I would like to know usually I would do something of this nature

 Dim con As New SqlConnection(connectionString)
        Dim cmd As New SqlCommand("usp_userinput", con) 'references connectionstring and calls store procedure
        cmd.CommandType = Data.CommandType.StoredProcedure 'sets default to be storeprocedure
        lblMessage.Text = String.Empty

        With cmd.Parameters
            If (Session("UserInitials")) IsNot Nothing Then
                .AddWithValue("@UserInitials", Session("UserInitials").ToString())
            End If
End With

That is just an example how i usually approach calling the stored procedure in vb. However for this particular form I am going to have 50 or 60 textboxes which each one would require a session state variable.Seems a little tedious to have to create a session state variable for each textbox on the form

was hoping there was a more efficient way to approach this if so is there anything i can reference in order to understand how to do this.

Thanks in advance for any help

[wild_bill]

Rather than storing User Initials in session state, you could pass them to you function directly.