datagrid command buttons

CyberW · November 16th, 2008, 01:50 PM

Hello,
I have a datagrid that is connected to ms-access DB.
I would like to make a delete link for each row, that clicking on that link will delete its value from the DB

I tried to add "ondelete" command,
and add a linkbutton to the templatecoulm, but that script is never executed when i click!

How can i call a sub when i click on a button in the templatecoulm?

thsnk you !

Lee Dumond · November 18th, 2008, 05:54 PM

Just curious -- why are you using a DataGrid instead of a GridView?

_________________________________

Visit my blog at http://leedumond.com

CyberW · November 19th, 2008, 03:29 AM

what is greedview?

Lee Dumond · November 19th, 2008, 03:58 AM

The GridView is the thing that has replaced the DataGrid since ASP.NET 2.0.

http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.gridview(VS.80).aspx

You should not be using the DataGrid any more, unless you're still on 1.0. Use a GridView (or possibly a ListView, if you're working in 3.5).

_________________________________

Visit my blog at http://leedumond.com

CyberW · November 22nd, 2008, 12:19 PM

Hi there,
I switched to GridView.

Can you explain me please how do i get the value of a specific field in the row that i select\button click on it?

thank you

Lee Dumond · November 22nd, 2008, 01:28 PM

You would handle the SelectedIndexChanged event of the GridView.

You wanted to know how to get the value of a specific field in a selected row, right?

Okay, let's say you want the value of something in the third column. That would be index #2 in the cells collection of that row (remember, the index starts at 0).

So, you'd go like this:

Code:

    Protected Sub GridView1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) _
     Handles GridView1.SelectedIndexChanged
        Dim row As GridViewRow = GridView1.SelectedRow
        Label1.Text = "You selected " & row.Cells(2).Text & "!"
    End Sub

The above code would take whatever is displayed in the third column of the selected row, and display it in a label. Of course, you could do whatever you need to with that value.

_________________________________

Visit my blog at http://leedumond.com

CyberW · November 22nd, 2008, 02:50 PM

yjank you,

Does it work with the rowdeleting event?

But counting the cells sounds premitive.

|Imagine you have a table with 100 fields..
You need to count each cell till you get the one you want?

Lee Dumond · November 22nd, 2008, 10:18 PM

I'm not sure what you're asking.

You can easily create a CommandField with a Delete button in it. But are you asking if it's possible to get the value of a field in a row you are deleting?

_________________________________

Visit my blog at http://leedumond.com

CyberW · November 23rd, 2008, 06:34 AM

Hi there.

I need to create a rowdeleting event,
in that event i have to create a sql statment that deleted the record from the db.

I have an invisible field with the rowID of every row displayed.

I need to get that ID when i click on the delete button...

Lee Dumond · November 23rd, 2008, 11:38 AM

You don't have to do any of that when deleting records, as the Gridview supports deleting records directly through the datasource to which it is bound.

Let's say you had a list of products, and the primary key is called ProductID. By specifying the DataKeyNames="ProductID" in the Gridview, you can configure it to automatically call the Delete method of the datasource, passing the primary key as the parameter.

So, your GridView may look something like this:

Code:

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="true" 
   DataKeyNames="ProductID" DataSourceID="SqlDataSource1" AutoGenerateDeleteButton="True">
</asp:GridView>

and your datasource would look like this:

Code:

<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
   ConnectionString="<%$ ConnectionStrings:MyConnectionString %>" 
   SelectCommand="SELECT [ProductName], [QuantityPerUnit], [ProductID], [UnitPrice] FROM [Products]" 
   DeleteCommand="DELETE FROM [Products] WHERE [ProductID] = @ProductID"           
      <DeleteParameters>
         <asp:Parameter Name="ProductID" Type="Int32" />
      </DeleteParameters>          
</asp:SqlDataSource>

This will automatically create the deletebutton, which will automatically call the delete method in the datasource when clicked.

_________________________________

Visit my blog at http://leedumond.com