Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 259
  • Last Modified:

gridview doesn't display data part 2 (with code behind)

I am working in Visual Studio 2005, and ive built a data connection with a gridview (i also tried formview) bound to a table called test. the connection tests fine, everything looks fine, but when i 'run' the page, nothing displays. I'm new at asp.net, so this is probably quite simple, but i cannot seem to find reference to it anywhere. ive tried the things ive found in books and on the web, to no avail. help? thanks in advance.

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>
 
<!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>TEST</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:GridView ID="GridView1" runat="server" AutoGenerateDeleteButton="True" AutoGenerateEditButton="True"
            Caption="Name Table" DataSourceID="SqlDataSource1" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False">
            <AlternatingRowStyle BackColor="#FF8080" Font-Names="Times New Roman" Font-Size="Medium"
                ForeColor="Black" />
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConflictDetection="CompareAllValues"
            ConnectionString="<%$ ConnectionStrings:testConnectionString2 %>" DeleteCommand="DELETE FROM [Name] WHERE [ID] = @original_ID AND [FName] = @original_FName AND [LName] = @original_LName"
            InsertCommand="INSERT INTO [Name] ([FName], [LName], [ID]) VALUES (@FName, @LName, @ID)"
            OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT * FROM [Name]"
            UpdateCommand="UPDATE [Name] SET [FName] = @FName, [LName] = @LName WHERE [ID] = @original_ID AND [FName] = @original_FName AND [LName] = @original_LName" EnableCaching="True">
            <DeleteParameters>
                <asp:Parameter Name="original_ID" Type="Int32" />
                <asp:Parameter Name="original_FName" Type="String" />
                <asp:Parameter Name="original_LName" Type="String" />
            </DeleteParameters>
            <UpdateParameters>
                <asp:Parameter Name="FName" Type="String" />
                <asp:Parameter Name="LName" Type="String" />
                <asp:Parameter Name="original_ID" Type="Int32" />
                <asp:Parameter Name="original_FName" Type="String" />
                <asp:Parameter Name="original_LName" Type="String" />
            </UpdateParameters>
            <InsertParameters>
                <asp:Parameter Name="FName" Type="String" />
                <asp:Parameter Name="LName" Type="String" />
                <asp:Parameter Name="ID" Type="Int32" />
            </InsertParameters>
        </asp:SqlDataSource>
        <asp:FormView ID="FormView1" runat="server" DataSourceID="SqlDataSource1">
        </asp:FormView>
    
    </div>
    </form>
   
</body>
</html>

Open in new window

0
cmajor118
Asked:
cmajor118
1 Solution
 
cmajor118Author Commented:
i figured it out. in the properties, under Misc, go to columns and add those i wish to view. what a noob! lol. thanks tho!
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now