OnClick LinkButton

[Gabe Matteson]

I would like the linkbutton when it is clicked to exectute a delete sql
statement on the current page.

etc.
onclick="btndelete_onclick"

how do i get the linkbutton to pass the database id column value to the sub
procedure so it can delete the record? thanks for any help

[David Wier]

that all depends on how you're displaying the data and what's available for
it, to use
for instance, are you using a a gridview ?

David Wier
http://aspnet101.com
http://iWritePro.com
"Gabe Matteson" <gm*******@inquery.biz.nospamwrote in message
news:Ov**************@TK2MSFTNGP05.phx.gbl...

>I would like the linkbutton when it is clicked to exectute a delete sql
statement on the current page.

etc.
onclick="btndelete_onclick"

how do i get the linkbutton to pass the database id column value to the
sub procedure so it can delete the record? thanks for any help

[Gabe Matteson]

I just using a sql data reader and outputting the data into a regular html
table using

<%Response.Write(objSQLDataReader(0) %>

i was hoping there was a way to put

<asp:LinkButton ID="lbtnDelete" onclick="btnDelete"
CommandArgument="<%Response.Write(objSQLDataReader (0))%>"
runat="server">Delete</asp:LinkButton></td>

thank you.

"David Wier" <da*******@davidwier.nospam.comwrote in message
news:u3**************@TK2MSFTNGP02.phx.gbl...

that all depends on how you're displaying the data and what's available
for it, to use
for instance, are you using a a gridview ?

David Wier
http://aspnet101.com
http://iWritePro.com
"Gabe Matteson" <gm*******@inquery.biz.nospamwrote in message
news:Ov**************@TK2MSFTNGP05.phx.gbl...

>>I would like the linkbutton when it is clicked to exectute a delete sql
statement on the current page.

etc.
onclick="btndelete_onclick"

how do i get the linkbutton to pass the database id column value to the
sub procedure so it can delete the record? thanks for any help

[David C]

You could save yourself a lot of time and code by using a GridView.

David
"Gabe Matteson" <gm*******@inquery.biz.nospamwrote in message
news:uP**************@TK2MSFTNGP03.phx.gbl...

>I just using a sql data reader and outputting the data into a regular html
table using

<%Response.Write(objSQLDataReader(0) %>

i was hoping there was a way to put

<asp:LinkButton ID="lbtnDelete" onclick="btnDelete"
CommandArgument="<%Response.Write(objSQLDataReader (0))%>"
runat="server">Delete</asp:LinkButton></td>

thank you.

"David Wier" <da*******@davidwier.nospam.comwrote in message
news:u3**************@TK2MSFTNGP02.phx.gbl...

>that all depends on how you're displaying the data and what's available
for it, to use
for instance, are you using a a gridview ?

David Wier
http://aspnet101.com
http://iWritePro.com
"Gabe Matteson" <gm*******@inquery.biz.nospamwrote in message
news:Ov**************@TK2MSFTNGP05.phx.gbl...

>>>I would like the linkbutton when it is clicked to exectute a delete sql
statement on the current page.

etc.
onclick="btndelete_onclick"

how do i get the linkbutton to pass the database id column value to the
sub procedure so it can delete the record? thanks for any help

[George Ter-Saakov]

You can always do
iRecordId= Request["__EVENTARGUMENT"];

If you look at the source code of the HTML created you will notice that
CommandArgument parameter end up being moved to hidden field with name
__EVENTARGUMENT
George.
"Gabe Matteson" <gm*******@inquery.biz.nospamwrote in message
news:uP**************@TK2MSFTNGP03.phx.gbl...

>I just using a sql data reader and outputting the data into a regular html
table using

<%Response.Write(objSQLDataReader(0) %>

i was hoping there was a way to put

<asp:LinkButton ID="lbtnDelete" onclick="btnDelete"
CommandArgument="<%Response.Write(objSQLDataReader (0))%>"
runat="server">Delete</asp:LinkButton></td>

thank you.

"David Wier" <da*******@davidwier.nospam.comwrote in message
news:u3**************@TK2MSFTNGP02.phx.gbl...

>that all depends on how you're displaying the data and what's available
for it, to use
for instance, are you using a a gridview ?

David Wier
http://aspnet101.com
http://iWritePro.com
"Gabe Matteson" <gm*******@inquery.biz.nospamwrote in message
news:Ov**************@TK2MSFTNGP05.phx.gbl...

>>>I would like the linkbutton when it is clicked to exectute a delete sql
statement on the current page.

etc.
onclick="btndelete_onclick"

how do i get the linkbutton to pass the database id column value to the
sub procedure so it can delete the record? thanks for any help

[Gabe Matteson]

Ah I got it into a gridview, lots of time saved.. i have one column that is
an image column and 3 other data columns. when i click edit, it trieds to
edit the graphic column. is there a way that i can disable edits for that
column?

"George Ter-Saakov" <gt****@cardone.comwrote in message
news:%2****************@TK2MSFTNGP03.phx.gbl...

You can always do
iRecordId= Request["__EVENTARGUMENT"];

If you look at the source code of the HTML created you will notice that
CommandArgument parameter end up being moved to hidden field with name
__EVENTARGUMENT
George.
"Gabe Matteson" <gm*******@inquery.biz.nospamwrote in message
news:uP**************@TK2MSFTNGP03.phx.gbl...

>>I just using a sql data reader and outputting the data into a regular html
table using

<%Response.Write(objSQLDataReader(0) %>

i was hoping there was a way to put

<asp:LinkButton ID="lbtnDelete" onclick="btnDelete"
CommandArgument="<%Response.Write(objSQLDataReade r(0))%>"
runat="server">Delete</asp:LinkButton></td>

thank you.

"David Wier" <da*******@davidwier.nospam.comwrote in message
news:u3**************@TK2MSFTNGP02.phx.gbl...

>>that all depends on how you're displaying the data and what's available
for it, to use
for instance, are you using a a gridview ?

David Wier
http://aspnet101.com
http://iWritePro.com
"Gabe Matteson" <gm*******@inquery.biz.nospamwrote in message
news:Ov**************@TK2MSFTNGP05.phx.gbl...
I would like the linkbutton when it is clicked to exectute a delete sql
statement on the current page.

etc.
onclick="btndelete_onclick"

how do i get the linkbutton to pass the database id column value to the
sub procedure so it can delete the record? thanks for any help