loading data to a DataGridView control

Hi,
I am new to Grid view Control.
I have a page with many icons on it for different purposes.
I want to add a Grid View where I want to load data with different columns.
Below is my code(xyz.aspx).Where i need to add the aspx page to my original page.(I tried adding to my HTML page but it returns with an error(We’re sorry, the application is currently unavailable. If you need any assistance, please contact ...)instead of loading data.

I appreciate if any one helps me in this issue

My Code is:

Expand|Select|Wrap|Line Numbers

 <%@ Page Language="C#" AutoEventWireup="true" CodeFile="xyz.aspx.cs" Inherits="xyz" %>
 
<!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>
 
        LOADING DATA...<br />

        <asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>

        <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>

        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 

            CellPadding="4" DataKeyNames="NAMEID" DataSourceID="SqlDataSource1" 

            ForeColor="#333333" GridLines="None">

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

            <RowStyle BackColor="#EFF3FB" />

            <Columns>

                <asp:BoundField DataField="NAMEID" HeaderText="NAMEID" ReadOnly="True" 

                    SortExpression="NAMEID" />

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

                <asp:BoundField DataField="STATUS" HeaderText="STATUS" 

                    SortExpression="STATUS" />

                <asp:BoundField DataField="RMPROPID" HeaderText="RMPROPID" 

                    SortExpression="RMPROPID" />

                <asp:BoundField DataField="BIRTHDAY" HeaderText="BIRTHDAY" 

                    SortExpression="BIRTHDAY" />

                <asp:BoundField DataField="LASTNAME" HeaderText="LASTNAME" 

                    SortExpression="LASTNAME" />

                <asp:BoundField DataField="FIRSTNAME" HeaderText="FIRSTNAME" 

                    SortExpression="FIRSTNAME" />

                <asp:BoundField DataField="MIDINIT" HeaderText="MIDINIT" 

                    SortExpression="MIDINIT" />

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

                <asp:BoundField DataField="LICENSE" HeaderText="LICENSE" 

                    SortExpression="LICENSE" />

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

                <asp:BoundField DataField="COMMENT" HeaderText="COMMENT" 

                    SortExpression="COMMENT" />

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

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

                <asp:BoundField DataField="QUALIFY" HeaderText="QUALIFY" 

                    SortExpression="QUALIFY" />

                <asp:BoundField DataField="PREVRESIDENCE" HeaderText="PREVRESIDENCE" 

                    SortExpression="PREVRESIDENCE" />

                <asp:BoundField DataField="OCCUPATION" HeaderText="OCCUPATION" 

                    SortExpression="OCCUPATION" />

                <asp:BoundField DataField="INCOME" HeaderText="INCOME" 

                    SortExpression="INCOME" />

                <asp:BoundField DataField="GUARANTOR" HeaderText="GUARANTOR" 

                    SortExpression="GUARANTOR" />

                <asp:BoundField DataField="LOCATION" HeaderText="LOCATION" 

                    SortExpression="LOCATION" />

                <asp:BoundField DataField="MRKTID" HeaderText="MRKTID" 

                    SortExpression="MRKTID" />

                <asp:BoundField DataField="LEASAGID" HeaderText="LEASAGID" 

                    SortExpression="LEASAGID" />

                <asp:BoundField DataField="COMPANY" HeaderText="COMPANY" 

                    SortExpression="COMPANY" />

                <asp:BoundField DataField="JOBTITLE" HeaderText="JOBTITLE" 

                    SortExpression="JOBTITLE" />

                <asp:BoundField DataField="JOBYRS" HeaderText="JOBYRS" 

                    SortExpression="JOBYRS" />

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

                <asp:BoundField DataField="NOLATE" HeaderText="NOLATE" 

                    SortExpression="NOLATE" />

                <asp:BoundField DataField="PAYALLOWED" HeaderText="PAYALLOWED" 

                    SortExpression="PAYALLOWED" />

                <asp:BoundField DataField="LASTDATE" HeaderText="LASTDATE" 

                    SortExpression="LASTDATE" />

                <asp:BoundField DataField="USERID" HeaderText="USERID" 

                    SortExpression="USERID" />

                <asp:BoundField DataField="NAMEGROUP" HeaderText="NAMEGROUP" 

                    SortExpression="NAMEGROUP" />

                <asp:BoundField DataField="RESPROPID" HeaderText="RESPROPID" 

                    SortExpression="RESPROPID" />

                <asp:BoundField DataField="RMBLDGID" HeaderText="RMBLDGID" 

                    SortExpression="RMBLDGID" />

                <asp:BoundField DataField="UNITID" HeaderText="UNITID" 

                    SortExpression="UNITID" />

                <asp:BoundField DataField="RMLEASE" HeaderText="RMLEASE" 

                    SortExpression="RMLEASE" />

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

                <asp:BoundField DataField="SHWLDATE" HeaderText="SHWLDATE" 

                    SortExpression="SHWLDATE" />

                <asp:BoundField DataField="SHWLSEQNO" HeaderText="SHWLSEQNO" 

                    SortExpression="SHWLSEQNO" />

                <asp:BoundField DataField="MARRIED" HeaderText="MARRIED" 

                    SortExpression="MARRIED" />

                <asp:BoundField DataField="PREVNAMEID" HeaderText="PREVNAMEID" 

                    SortExpression="PREVNAMEID" />

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

                <asp:BoundField DataField="BANKACCT" HeaderText="BANKACCT" 

                    SortExpression="BANKACCT" />

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

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

                <asp:BoundField DataField="CREDITSTATUS" HeaderText="CREDITSTATUS" 

                    SortExpression="CREDITSTATUS" />

                <asp:BoundField DataField="RCTENANDID" HeaderText="RCTENANDID" 

                    SortExpression="RCTENANDID" />

                <asp:BoundField DataField="RCTENANTID" HeaderText="RCTENANTID" 

                    SortExpression="RCTENANTID" />

                <asp:BoundField DataField="PASSTID" HeaderText="PASSTID" 

                    SortExpression="PASSTID" />

                <asp:BoundField DataField="OCCUPYDATE" HeaderText="OCCUPYDATE" 

                    SortExpression="OCCUPYDATE" />

                <asp:BoundField DataField="VACATEDATE" HeaderText="VACATEDATE" 

                    SortExpression="VACATEDATE" />

                <asp:BoundField DataField="WORKPHONE1" HeaderText="WORKPHONE1" 

                    SortExpression="WORKPHONE1" />

                <asp:BoundField DataField="WORKPHONE2" HeaderText="WORKPHONE2" 

                    SortExpression="WORKPHONE2" />

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

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

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

                <asp:BoundField DataField="MVIREASN" HeaderText="MVIREASN" 

                    SortExpression="MVIREASN" />

                <asp:BoundField DataField="NMBRRESIDENTS" HeaderText="NMBRRESIDENTS" 

                    SortExpression="NMBRRESIDENTS" />

                <asp:BoundField DataField="NOSSNO" HeaderText="NOSSNO" 

                    SortExpression="NOSSNO" />

                <asp:BoundField DataField="BACKGRNDSTATUS" HeaderText="BACKGRNDSTATUS" 

                    SortExpression="BACKGRNDSTATUS" />

                <asp:BoundField DataField="OTRESBCKGRNDREQ" HeaderText="OTRESBCKGRNDREQ" 

                    SortExpression="OTRESBCKGRNDREQ" />

                <asp:BoundField DataField="BCKGRNDFLUP" HeaderText="BCKGRNDFLUP" 

                    SortExpression="BCKGRNDFLUP" />

                <asp:BoundField DataField="WEBNOCHECKS" HeaderText="WEBNOCHECKS" 

                    SortExpression="WEBNOCHECKS" />

                <asp:BoundField DataField="OCCINACTIVE" HeaderText="OCCINACTIVE" 

                    SortExpression="OCCINACTIVE" />

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

                <asp:BoundField DataField="TCCERTIFIED" HeaderText="TCCERTIFIED" 

                    SortExpression="TCCERTIFIED" />

                <asp:BoundField DataField="AUTOSPREAD" HeaderText="AUTOSPREAD" 

                    SortExpression="AUTOSPREAD" />

                <asp:BoundField DataField="EMAILSENT" HeaderText="EMAILSENT" 

                    SortExpression="EMAILSENT" />

                <asp:BoundField DataField="CHKOPTOUT" HeaderText="CHKOPTOUT" 

                    SortExpression="CHKOPTOUT" />

                <asp:BoundField DataField="EXCLUDENWP" HeaderText="EXCLUDENWP" 

                    SortExpression="EXCLUDENWP" />

                <asp:BoundField DataField="NWPDATE" HeaderText="NWPDATE" 

                    SortExpression="NWPDATE" />

                <asp:BoundField DataField="CALLCENTERENTRY" HeaderText="CALLCENTERENTRY" 

                    SortExpression="CALLCENTERENTRY" />

                <asp:BoundField DataField="RLEASETYPE" HeaderText="RLEASETYPE" 

                    SortExpression="RLEASETYPE" />

                <asp:BoundField DataField="RNTINCR" HeaderText="RNTINCR" 

                    SortExpression="RNTINCR" />

                <asp:BoundField DataField="ARRESTEDPENDINGTRIAL" 

                    HeaderText="ARRESTEDPENDINGTRIAL" SortExpression="ARRESTEDPENDINGTRIAL" />

                <asp:BoundField DataField="caBrokenLease" HeaderText="caBrokenLease" 

                    SortExpression="caBrokenLease" />

                <asp:BoundField DataField="caControlledSubstance" 

                    HeaderText="caControlledSubstance" SortExpression="caControlledSubstance" />

                <asp:BoundField DataField="caConvictedPersons" HeaderText="caConvictedPersons" 

                    SortExpression="caConvictedPersons" />

                <asp:BoundField DataField="caConvictedProperty" 

                    HeaderText="caConvictedProperty" SortExpression="caConvictedProperty" />

                <asp:BoundField DataField="caEvicted" HeaderText="caEvicted" 

                    SortExpression="caEvicted" />

                <asp:BoundField DataField="caSued" HeaderText="caSued" 

                    SortExpression="caSued" />

                <asp:BoundField DataField="CONVICTEDFELONY" HeaderText="CONVICTEDFELONY" 

                    SortExpression="CONVICTEDFELONY" />

                <asp:BoundField DataField="LICENSESTATE" HeaderText="LICENSESTATE" 

                    SortExpression="LICENSESTATE" />

                <asp:BoundField DataField="OCCUPANT" HeaderText="OCCUPANT" 

                    SortExpression="OCCUPANT" />

            </Columns>

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

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

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

            <EditRowStyle BackColor="#2461BF" />

            <AlternatingRowStyle BackColor="White" />

        </asp:GridView>
 
    </div>

    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 

        ConnectionString="<%$ ConnectionStrings:BasemriConnectionString %>" 

        SelectCommand="SELECT * FROM [NAME] WHERE ([email] = @EMAILID)">

        <SelectParameters>

            <asp:QueryStringParameter Name="EMAILID" QueryStringField="EMAILID" 

                Type="String" />

        </SelectParameters>

    </asp:SqlDataSource>

    </form>

</body>

</html>

Thanks in advance'
T

Aug 31 '08 #1

Subscribe Post Reply

1229

by: John Richardson | last post by:

I've been bothered for some time about my DataGrid not populating my rows very quickly. I have about 10K rows loading into the grid. I create a datatable dt with 2 columns, an ID and a display. ...

C# / C Sharp

VS2005 - DefaultValuesNeeded - bug? Adding default values in DataGridView

by: dbuchanan | last post by:

Hello, Is this a bug? Is there some kind of work around? I want to add default values for a few columns in my datagridview I found the "DefaultValuesNeeded" event for the datagridview I...

Visual Basic .NET

Loading a Datagridview taking a long time...sometimes

by: RSH | last post by:

I have a simple Windows Form, where i have a datagridview. The user can switch between databases and select the tables via DropDownLists. I am having a problem that I can't really pinpoint when...

C# / C Sharp

Datagridview loading rows

by: Luca Beretta | last post by:

I think this a simple question but i'm breaking my brain without results. I've a datagridview bounded to a datatable, with an imagecolumn that should contain a different bitmap depending from a...

C# / C Sharp

Issue with DataGridView on initial data load

by: Rick Shaw | last post by:

Hi, I have a problem with the datagridview not refreshed when the application first appear on the screen. The datagridview display data from a table in the dataset. At the same time, I've added...

C# / C Sharp

DataGridView Error

by: jeastman - Hotmail | last post by:

Hello world Excuse, not to be written English and it helps me with a translator. I am new programming in C#. I made a control inheriting the DataGridView to be able to add controls done by...

C# / C Sharp

problem sizing a DataGridView

by: Jeff | last post by:

Hey ..NET 2.0 I've created a User Control which contain a DataGridView. This User Control is displayed on a TabPage. This TabPage is added to the TabControl during runtime. The problem is...

C# / C Sharp

Binding data to the custom DataGridView

by: jchaturv | last post by:

All, I have a customized DataGridView where I have implemented extra functionality and bounded datasource in the same custom DataGridView (Using C# and .NET). Now, I could able to use it...

C# / C Sharp

Wierd exception from DataGridView, why?

by: alex21 | last post by:

Ok im getting this exception from a DataGridView control in my program. System.ArgumentOutOfRangeException was unhandled Message="Value of '132' is not valid for 'Value'. 'Value' should be...

Visual Basic .NET

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

loading data to a DataGridView control

Similar topics