Advice using sql_sp to insert data

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

Code:

---

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

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