Newbie, adding a row to Gridview in VB

Discussion in 'ASP .Net Building Controls' started by verci, Aug 28, 2006.

  1. verci

    verci Guest

    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 that adds a new row in my
    gridview control, so I can insert a new record in the table, 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>

    <asp:parameter 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>

    <asp:DropDownList ID="DropDownList1" runat="server"
    DataSourceID="SqlDataSource2"

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

    </asp:DropDownList>

    </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>
    verci, Aug 28, 2006
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Luis Esteban Valencia

    My addnew row button is only adding one row?

    Luis Esteban Valencia, Mar 23, 2005, in forum: ASP .Net
    Replies:
    0
    Views:
    823
    Luis Esteban Valencia
    Mar 23, 2005
  2. H5N1
    Replies:
    0
    Views:
    2,711
  3. Replies:
    5
    Views:
    656
  4. D
    Replies:
    0
    Views:
    203
  5. verci

    Newbie, adding a row to Gridview in VB

    verci, Aug 28, 2006, in forum: ASP .Net Datagrid Control
    Replies:
    0
    Views:
    138
    verci
    Aug 28, 2006
Loading...

Share This Page