ASP and SQL driving me nuts

[BezerkRogue]

I have gotten my pages to work up to the final edit page. The code executes on load. Variables are passed by session but I get an SQL syntax error. I've tested the sp I'm calling and it works correctly. Here's the code"

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArg s) Handles Me.Load
Dim strSelDate
Dim strShift
Dim strAbsent
Dim strTO
Dim strHeadCount
Dim strSTDHeadCount
Dim strMPNotes
Dim Notes2
Dim strSQL
Dim strRID

strRID = Session.Item("R ID").ToString ()
strSelDate = Session.Item("S elDate").ToStri ng()
strShift = Session.Item("S hift").ToString ()
strAbsent = Session.Item("A bsent").ToStrin g()
strTO = Session.Item("T O").ToString ()
strHeadCount = Session.Item("H eadCount").ToSt ring()
strSTDHeadCount = Session.Item("S TDHeadCount").T oString()
strMPNotes = Session.Item("N otes").ToString ()
'Notes2 = strMPNotes.Repl ace("'", "''")
strSQL = "UP_MANPOWER_RE CORD_UPDATE '" & strSelDate & "', '" & strShift & "', " & strHeadCount & ", " & strSTDHeadCount & ", " & strAbsent & ", " & strTO & ", '" & Notes2 & "', " & strRID
Dim objConn As New Data.SqlClient. SqlConnection(" Data Source=XXXXXX;I nitial Catalog=XXXXXX; User ID=XXXXXX;passw ord=XXXXXX;")
Dim objCmd As New Data.SqlClient. SqlCommand(strS QL, objConn)
objConn.Open()
objCmd.ExecuteN onQuery()
objConn.Close()

End Sub

Here's the error I get:

System.Data.Sql Client.SqlExcep tion: Line 1: Incorrect syntax near '.'.

Can anyone enlighten this drowning noob??

[Plater]

It didn't like that line. Is there another way to cast a string to an int in VB.Net?

What's wrong with that line? (other then if the string is empty or contains non-integer chracters it will throw an exception, but you said they were garunteed to contain correct data)
That and .TryParse() are the first choices for converting a string to an integer.

[BezerkRogue]

What's wrong with that line? (other then if the string is empty or contains non-integer chracters it will throw an exception, but you said they were garunteed to contain correct data)
That and .TryParse() are the first choices for converting a string to an integer.

I put the following line in:

Int32.Parse(str STDHeadCount) and get this error...

Conversion from type 'TextBox' to type 'String' is not valid.

Sigh....another change another error.

[Plater]

strSTDHeadCount is a textbox object then?
Use strSTDHeadCount .Text, I thought it was string since you pulled it from the session.

That coulda been your trouble with the "." error earlier, if Session.Item("S TDHeadCount") is a textbox then Session.Item("S TDHeadCount").T oString() would come back as like "Forms.Text Box"

I would suggest you go back and only store the TEXT in the session, unless you want the whole textbox.

[BezerkRogue]

strSTDHeadCount is a textbox object then?
Use strSTDHeadCount .Text, I thought it was string since you pulled it from the session.

That coulda been your trouble with the "." error earlier, if Session.Item("S TDHeadCount") is a textbox then Session.Item("S TDHeadCount").T oString() would come back as like "Forms.Text Box"

I would suggest you go back and only store the TEXT in the session, unless you want the whole textbox.

I set them to Session.Item.Ad d("HeadCount" , txtHeadCount.Te xt) on the sending page and Session.Item("H eadCount").ToSt ring() on the receiving page.

I get Input string was not in a correct format messages. I have also tried parsing the variable to int by setting Session.Item("H eadCount") and then int32.Parse(str HeadCount).

I'm about ready to tank the whole page and start from scratch.

[Plater]

Yeah, I'm scratchin my head now, not sure why it thinks it's a textbox.
that's really messed up.

[BezerkRogue]

Yeah, I'm scratchin my head now, not sure why it thinks it's a textbox.
that's really messed up.

I have an <%@ reference page%> statement in the pages. Do I need that when using sessions or would it help if you saw the code from both pages?

[Plater]

I have an <%@ reference page%> statement in the pages. Do I need that when using sessions or would it help if you saw the code from both pages?

Umm....I don't know?
My aspx pages start with something like this:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
 

Then I have the aspx.cs (or for vb aspx.vb) where my backend code goes.
Session was just always available to me.

[BezerkRogue]

Umm....I don't know?
My aspx pages start with something like this:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
 

Then I have the aspx.cs (or for vb aspx.vb) where my backend code goes.
Session was just always available to me.

I might have found my issue. The query in the change page is pulling all of the data fields for the record by one of the fields is not being loaded into the assigned text box.

Response.write shows the variable but making the textbox visible shows no data there.

[BezerkRogue]

Umm....I don't know?
My aspx pages start with something like this:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
 

Then I have the aspx.cs (or for vb aspx.vb) where my backend code goes.
Session was just always available to me.

I finally figured it out. Got it to work correctly and pass all variables in the correct data type. Thanks for the help. Sessions for the win