I have a Session where I have stored some data.
But I want now to store them into database.
How would I get the value from session?
When I use Response.write(ceobjDR("PID")) in normal I get the value of it but when I use it in a DataAdapter it wont work.
Where Is the problem?
<script runat="server">
Dim ceobjDT As System.Data.DataTable
Dim ceobjDR as System.Data.DataRow
Dim ceobjDS as system.Data.DataSet()
sub page_load (Sender As Object, E As EventArgs)
Dim loConn as New SqlConnection(ConfigurationSettings.AppSettings("M M_CONNECTION_STRING_HWB"))
if not session("cart") is Nothing Then
ceobjDT = Session("cart")
for each ceobjDR in ceobjDT.rows
             Dim cmdInsert as New SQLCommand("order_details", loConn)
             cmdInsert.CommandType = CommandType.StoredProcedure
             cmdInsert.Parameters.Add(New SqlParameter("@OrderID", SqlDbType.int,4, "OrderID"))
             cmdInsert.Parameters("@OrderID").Value = Request("OrderID")
             cmdInsert.Parameters.Add(New SqlParameter("@PID", SqlDbType.int, 4, "PID"))
             cmdInsert.Parameters("@PID").Value = Request(ceobjDR("PID"))
             cmdInsert.Parameters.Add(New SqlParameter("@PAKID", SqlDbType.int, 4, "PAKID"))
             cmdInsert.Parameters("@PAKID").Value = Request(ceobjDR("PAKID"))
             cmdInsert.Parameters.Add(New SqlParameter("@StyckPris", SqlDbType.decimal, 9, "StyckPris"))
             cmdInsert.Parameters("@StyckPris").Value = Request(ceobjDR("StyckPris"))
             cmdInsert.Parameters.Add(New SqlParameter("@Mangd", SqlDbType.int, 4, "Mangd"))
             cmdInsert.Parameters("@Mangd").Value = Request(ceobjDR("Quantity"))
             loConn.Open()
             cmdInsert.ExecuteNonQuery()
             loConn.Close()
next
end if
Session("cart") = ceobjDT
end sub

</script>