Insert data to Database
I have a session variable that I print data from like
The session variable is declared on my page as objDT
<%
Dim objDT As System.Data.DataTable
Dim objDR As System.Data.DataRow
for each objDR in ObjDT.rows
Response.Write(objDR("Produktnamn") & objDR("PID") & objDR("PAKID") & objDR("quantity") & objDR("styckpris"))
next
%>
This works it print all the rows from the session
How would I change the code so I would get the variables into parameters and then use a storedProcedure to insert into database.
I know that parameters would be like
@Produktnamn
@PID
@PAKID
@Quantity
@styckpris
I manage to do the storedprocedure but what should I write in .aspx file
|
