Solved

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

Posted on 2008-10-28
1
249 Views
Last Modified: 2010-04-14
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
Comment
Question by:cmajor118
1 Comment
 

Accepted Solution

by:
cmajor118 earned 0 total points
ID: 22822504
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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

This article discusses the ASP.NET AJAX ModalPopupExtender control. In this article we will show how to use the ModalPopupExtender control, how to display/show/call the ASP.NET AJAX ModalPopupExtender control from javascript, how to show/display/cal…
Sometimes in DotNetNuke module development you want to swap controls within the same module definition.  In doing this DNN (somewhat annoyingly) swaps the Skin and Container definitions to the default admin selections.  To get around this you need t…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now