My Code isnt working, why?!?!

[David Lozzi]

I corrrected the issue with the delete command. That was a stupid issue on
my behalf, as i'm sure you'll see....

However, still battleing the stupid update command.

thanks for your help!

--
David Lozzi
Web Applications Developer
[email]dlozzi@(remove-this)delphi-ts.com[/email]



"David Lozzi" <DavidLozzi@nospam.nospam> wrote in message
news:e90PphczFHA.3540@TK2MSFTNGP10.phx.gbl...

> VB Code is attached.
>
>
> --
> David Lozzi
> Web Applications Developer
> [email]dlozzi@(remove-this)delphi-ts.com[/email]
>
>
>
> "David Lozzi" <DavidLozzi@nospam.nospam> wrote in message
> news:%23jwEcZczFHA.3188@TK2MSFTNGP14.phx.gbl...

>> Howdy,
>>
>> Attached are my two files, aspx and code behind vb. My problem is that
>> the
>> update command doesn't process the new information. It will process any
>> other commands within the function( i.e. updating a lable for status) but
>> doesnt update the database. If I run the stored proc in query analyzer,
>> it
>> runs fine and the data updates. Having the same issue with the delete
>> button
>> column, driving me NUTS!
>>
>> The update command is lines 196-218 and the delete command is 225-239.
>>
>> Line 210 should return rows affected, and it displays 0.
>>
>> Thanks a lot!
>>
>> --
>> David Lozzi
>> Web Applications Developer
>> [email]dlozzi@(remove-this)delphi-ts.com[/email]
>>
>>
>>
>>
>>

>
>
>

[David Lozzi]

I've narrowed down the issue to this column.... <asp:BoundColumn
DataField="ID" Visible="False" />. When I response.write the fields before
assigning them to the parameters fo the sqlcommand, this returns a blank
value, while the other fields return the correct information. Any ideas?

--
David Lozzi
Web Applications Developer
[email]dlozzi@(remove-this)delphi-ts.com[/email]



"David Lozzi" <DavidLozzi@nospam.nospam> wrote in message
news:uEXgxrczFHA.596@TK2MSFTNGP12.phx.gbl...

>I corrrected the issue with the delete command. That was a stupid issue on
>my behalf, as i'm sure you'll see....
>
> However, still battleing the stupid update command.
>
> thanks for your help!
>
> --
> David Lozzi
> Web Applications Developer
> [email]dlozzi@(remove-this)delphi-ts.com[/email]
>
>
>
> "David Lozzi" <DavidLozzi@nospam.nospam> wrote in message
> news:e90PphczFHA.3540@TK2MSFTNGP10.phx.gbl...

>> VB Code is attached.
>>
>>
>> --
>> David Lozzi
>> Web Applications Developer
>> [email]dlozzi@(remove-this)delphi-ts.com[/email]
>>
>>
>>
>> "David Lozzi" <DavidLozzi@nospam.nospam> wrote in message
>> news:%23jwEcZczFHA.3188@TK2MSFTNGP14.phx.gbl...

>>> Howdy,
>>>
>>> Attached are my two files, aspx and code behind vb. My problem is that
>>> the
>>> update command doesn't process the new information. It will process any
>>> other commands within the function( i.e. updating a lable for status)
>>> but
>>> doesnt update the database. If I run the stored proc in query analyzer,
>>> it
>>> runs fine and the data updates. Having the same issue with the delete
>>> button
>>> column, driving me NUTS!
>>>
>>> The update command is lines 196-218 and the delete command is 225-239.
>>>
>>> Line 210 should return rows affected, and it displays 0.
>>>
>>> Thanks a lot!
>>>
>>> --
>>> David Lozzi
>>> Web Applications Developer
>>> [email]dlozzi@(remove-this)delphi-ts.com[/email]
>>>
>>>
>>>
>>>
>>>

>>
>>
>>

>
>

[David Lozzi]

I setup this column as the others and called the ID the same way:
CType(e.Item.Cells(0).FindControl("txtEditID"), TextBox).Text.
Works great with the column visible, but I want the column invisible. When I
set visible to false, it doesn't see the ID.

--
David Lozzi
Web Applications Developer
[email]dlozzi@(remove-this)delphi-ts.com[/email]



"David Lozzi" <DavidLozzi@nospam.nospam> wrote in message
news:eUox$3czFHA.2424@TK2MSFTNGP12.phx.gbl...

> I've narrowed down the issue to this column.... <asp:BoundColumn
> DataField="ID" Visible="False" />. When I response.write the fields before
> assigning them to the parameters fo the sqlcommand, this returns a blank
> value, while the other fields return the correct information. Any ideas?
>
> --
> David Lozzi
> Web Applications Developer
> [email]dlozzi@(remove-this)delphi-ts.com[/email]
>
>
>
> "David Lozzi" <DavidLozzi@nospam.nospam> wrote in message
> news:uEXgxrczFHA.596@TK2MSFTNGP12.phx.gbl...

>>I corrrected the issue with the delete command. That was a stupid issue on
>>my behalf, as i'm sure you'll see....
>>
>> However, still battleing the stupid update command.
>>
>> thanks for your help!
>>
>> --
>> David Lozzi
>> Web Applications Developer
>> [email]dlozzi@(remove-this)delphi-ts.com[/email]
>>
>>
>>
>> "David Lozzi" <DavidLozzi@nospam.nospam> wrote in message
>> news:e90PphczFHA.3540@TK2MSFTNGP10.phx.gbl...

>>> VB Code is attached.
>>>
>>>
>>> --
>>> David Lozzi
>>> Web Applications Developer
>>> [email]dlozzi@(remove-this)delphi-ts.com[/email]
>>>
>>>
>>>
>>> "David Lozzi" <DavidLozzi@nospam.nospam> wrote in message
>>> news:%23jwEcZczFHA.3188@TK2MSFTNGP14.phx.gbl...
>>>> Howdy,
>>>>
>>>> Attached are my two files, aspx and code behind vb. My problem is that
>>>> the
>>>> update command doesn't process the new information. It will process any
>>>> other commands within the function( i.e. updating a lable for status)
>>>> but
>>>> doesnt update the database. If I run the stored proc in query analyzer,
>>>> it
>>>> runs fine and the data updates. Having the same issue with the delete
>>>> button
>>>> column, driving me NUTS!
>>>>
>>>> The update command is lines 196-218 and the delete command is 225-239.
>>>>
>>>> Line 210 should return rows affected, and it displays 0.
>>>>
>>>> Thanks a lot!
>>>>
>>>> --
>>>> David Lozzi
>>>> Web Applications Developer
>>>> [email]dlozzi@(remove-this)delphi-ts.com[/email]
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>

>>
>>

>
>

[David Lozzi]

FIXED IT. Had to put the boundcolumn to ReadOnly="True" Why? I have no idea,
but it worked

thanks for bearing with my insanity.

--
David Lozzi
Web Applications Developer
[email]dlozzi@(remove-this)delphi-ts.com[/email]



"David Lozzi" <DavidLozzi@nospam.nospam> wrote in message
news:ODVQl7czFHA.904@tk2msftngp13.phx.gbl...

>I setup this column as the others and called the ID the same way:
>CType(e.Item.Cells(0).FindControl("txtEditID"), TextBox).Text.
> Works great with the column visible, but I want the column invisible. When
> I set visible to false, it doesn't see the ID.
>
> --
> David Lozzi
> Web Applications Developer
> [email]dlozzi@(remove-this)delphi-ts.com[/email]
>
>
>
> "David Lozzi" <DavidLozzi@nospam.nospam> wrote in message
> news:eUox$3czFHA.2424@TK2MSFTNGP12.phx.gbl...

>> I've narrowed down the issue to this column.... <asp:BoundColumn
>> DataField="ID" Visible="False" />. When I response.write the fields
>> before assigning them to the parameters fo the sqlcommand, this returns a
>> blank value, while the other fields return the correct information. Any
>> ideas?
>>
>> --
>> David Lozzi
>> Web Applications Developer
>> [email]dlozzi@(remove-this)delphi-ts.com[/email]
>>
>>
>>
>> "David Lozzi" <DavidLozzi@nospam.nospam> wrote in message
>> news:uEXgxrczFHA.596@TK2MSFTNGP12.phx.gbl...

>>>I corrrected the issue with the delete command. That was a stupid issue
>>>on my behalf, as i'm sure you'll see....
>>>
>>> However, still battleing the stupid update command.
>>>
>>> thanks for your help!
>>>
>>> --
>>> David Lozzi
>>> Web Applications Developer
>>> [email]dlozzi@(remove-this)delphi-ts.com[/email]
>>>
>>>
>>>
>>> "David Lozzi" <DavidLozzi@nospam.nospam> wrote in message
>>> news:e90PphczFHA.3540@TK2MSFTNGP10.phx.gbl...
>>>> VB Code is attached.
>>>>
>>>>
>>>> --
>>>> David Lozzi
>>>> Web Applications Developer
>>>> [email]dlozzi@(remove-this)delphi-ts.com[/email]
>>>>
>>>>
>>>>
>>>> "David Lozzi" <DavidLozzi@nospam.nospam> wrote in message
>>>> news:%23jwEcZczFHA.3188@TK2MSFTNGP14.phx.gbl...
>>>>> Howdy,
>>>>>
>>>>> Attached are my two files, aspx and code behind vb. My problem is that
>>>>> the
>>>>> update command doesn't process the new information. It will process
>>>>> any
>>>>> other commands within the function( i.e. updating a lable for status)
>>>>> but
>>>>> doesnt update the database. If I run the stored proc in query
>>>>> analyzer, it
>>>>> runs fine and the data updates. Having the same issue with the delete
>>>>> button
>>>>> column, driving me NUTS!
>>>>>
>>>>> The update command is lines 196-218 and the delete command is 225-239.
>>>>>
>>>>> Line 210 should return rows affected, and it displays 0.
>>>>>
>>>>> Thanks a lot!
>>>>>
>>>>> --
>>>>> David Lozzi
>>>>> Web Applications Developer
>>>>> [email]dlozzi@(remove-this)delphi-ts.com[/email]
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>
>>>

>>
>>

>
>