Posting a Session Value into a database

Albanian

New Member
Hi I am using a Session variable to hold a data. But when I try to insert that Data into the Database its not entering. But if I just print it on the page, I can see the value. <BR><BR>The Error Code is here.<BR><BR>Exception Details: System.FormatException: Index (zero based) must be greater than or equal to zero and less than the size of the argument list.<BR><BR>Source Error: <BR><BR><BR>Line 50: cmdSelect.Parameters.Add("@Title",txtTitle.Text)<BR>Line 51: cmdSelect.Parameters.Add("@ServiceDescription",txtDescription.Text)<BR>Line 52: cmdSelect.Parameters.Add("@BoatId",Session("BoatId"))<BR>Line 53: cmdSelect.Parameters.Add("@userId", Session("UserId")) <BR>Line 54: cmdSelect.ExecuteNonQuery()<BR> <BR>THe Actual code is here<BR><BR>conPubs.Open()<BR>ServiceRequestId = Request.QueryString("mid") <BR>cmdSelect = new SqlCommand("addServiceRequest", ConPubs)<BR>cmdSelect.CommandType =CommandType.StoredProcedure<BR><BR>cmdSelect.Parameters.Add("@parent",ServiceRequestId )<BR>cmdSelect.Parameters.Add("@Title",txtTitle.Text)<BR>cmdSelect.Parameters.Add("@ServiceDescription",txtDescription.Text)<BR>cmdSelect.Parameters.Add("@BoatId",Session("BoatId"))<BR>cmdSelect.Parameters.Add("@userId", Session("UserId")) <BR>cmdSelect.ExecuteNonQuery()<BR>conPubs.Close()<BR> <BR><BR>Thank you very much.<BR>pradeep<BR>
 
Back
Top