Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP .Net Datagrid Control > Newbie, add a button to gridview footer

Reply
Thread Tools

Newbie, add a button to gridview footer

 
 
verci
Guest
Posts: n/a
 
      09-03-2006
Hi
Can anyone help me or point me in the right direction, I'm running Win XP
Pro SP2, VS2005 Team, .Net Framework
2.0 and SQL Server2005.

I want to put a command button in the footer just below the links for edit
and delete autogenerated by the gridview, this because I want to open
another aspx page when the this button is pressed, my control code is below.

Best Regards


<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default3.aspx.vb"
Inherits="Default3" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >

<head runat="server">

<title>Untitled Page</title>

</head>

<body>

<form id="form1" runat="server">

<div>

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$
ConnectionStrings:NwindConnectionString %>"

SelectCommand="SELECT p.ProductID, p.ProductName, p.CategoryID,
c.CategoryName FROM Products p inner join Categories c on p.CategoryID =
c.CategoryID"

UpdateCommand="Update Products Set ProductID=@ProductID,
ProductName=@ProductName, CategoryID=@CategoryID where ProductID=@ProductID"

deletecommand="delete from products where productid=@productid">

<DeleteParameters>

<asparameter Name="productID" Type="Int32" />

</DeleteParameters>

</asp:SqlDataSource>

<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$
ConnectionStrings:NwindConnectionString %>"

SelectCommand="SELECT [CategoryID], [CategoryName] FROM [Categories]">

</asp:SqlDataSource>

</div>

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1" CellPadding="4" ForeColor="#333333"
GridLines="None" AllowPaging="True" DataKeyNames="productID" >

<Columns>

<asp:CommandField ButtonType="Image" CancelImageUrl="~/Images/Cancel.gif"
EditImageUrl="~/Images/WRITE2.gif"

ShowEditButton="True" UpdateImageUrl="~/Images/Update.gif"
DeleteImageUrl="~/Images/waste-trash.gif" ShowDeleteButton="True" />

<asp:TemplateField SortExpression="ProductID">

<EditItemTemplate>

<asp:Label ID="TextBox1" runat="server" Text='<%# Bind("ProductID")%>'
Visible=false></asp:Label>

</EditItemTemplate>

<ItemTemplate>

<asp:Label ID="Label2" runat="server" Text='<%# Bind("ProductID") %>'
Visible=false></asp:Label>

</ItemTemplate>

</asp:TemplateField>

<asp:BoundField DataField="ProductName" HeaderText="ProductName"
SortExpression="ProductName" />

<asp:TemplateField HeaderText="CategoryID" SortExpression="CategoryID">

<EditItemTemplate>

<aspropDownList ID="DropDownList1" runat="server"
DataSourceID="SqlDataSource2"

DataTextField="CategoryName" DataValueField="CategoryID" SelectedValue='<%#
Bind("CategoryID") %>' >

</aspropDownList>

</EditItemTemplate>

<ItemTemplate>

<asp:Label ID="Label1" runat="server" Text='<%# Bind("CategoryName")
%>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

</Columns>

<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />

<SelectedRowStyle BackColor="#D1DDF1" ForeColor="#333333" Font-Bold="True"
/>

<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center"
/>

<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />

<AlternatingRowStyle BackColor="White" />

<RowStyle BackColor="#EFF3FB" />

<EditRowStyle BackColor="#2461BF" />

</asp:GridView>

</form>

</body>

</html>


 
Reply With Quote
 
 
 
 
verci
Guest
Posts: n/a
 
      09-03-2006
Hey thaks!!, that did it.


"Gaurav Vaish (www.EduJini.IN)" <(E-Mail Removed)> wrote
in message news:(E-Mail Removed)...
> 1. Use EditCommandColumn
> 2. Use the FooterText property of the EditCommandColumn class
>
>
>
> --
> Happy Hacking,
> Gaurav Vaish | http://www.mastergaurav.com
> http://www.edujini.in | http://articles.edujini.in/webservices
> -------------------
>
>
> "verci" <(E-Mail Removed)> wrote in message
> news:um$(E-Mail Removed)...
>> Hi
>> Can anyone help me or point me in the right direction, I'm running Win
>> XP
>> Pro SP2, VS2005 Team, .Net Framework
>> 2.0 and SQL Server2005.
>>
>> I want to put a command button in the footer just below the links for
>> edit
>> and delete autogenerated by the gridview, this because I want to open
>> another aspx page when the this button is pressed, my control code is
>> below.
>>
>> Best Regards

>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Add subtotal within the footer in Gridview Ken ASP .Net 1 09-02-2007 11:34 AM
Newbie, add a button to gridview footer verci ASP .Net Building Controls 1 09-03-2006 07:43 PM
Any way to reorder how a datagrid is drawn (header/footer/items vs.header/items/footer)? Henrik ASP .Net Datagrid Control 1 07-06-2006 12:23 AM
add a second row to footer of gridview NewTel ASP .Net 1 02-09-2006 10:19 PM
add Another row to GridView Footer- NewTel ASP .Net 1 02-09-2006 10:18 PM



Advertisments