unable to display data on the page

Question

0.00/5 (No votes)

See more:

Hello, can you please help me.

I am trying to bind the grid view in code behind, but the data is not displayed on the page. I checked the query it is working, the problem is displaying the data. here is the code. I am new to web programming

XML

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"  Width="100%">
                <Columns>
                    <asp:BoundField DataField="PropertyType" HeaderText="Property Type" SortExpression="PropertyType" />
                    <asp:BoundField DataField="Area" HeaderText="Area" SortExpression="Area" />
                    <asp:BoundField DataField="Price" HeaderText="Price" SortExpression="Price" />
                    <asp:ImageField HeaderText="Photo" DataImageUrlField="Photo" />
                    <asp:BoundField DataField="PostedDate" HeaderText="PostedDate" SortExpression="PostedDate" />
                </Columns>
            </asp:GridView>

Property cObject = new Property();
                SqlConnection con = cObject.connection();
                SqlDataSource SqlDataSource1 = new SqlDataSource();
                SqlDataSource1.ID = "SqlDataSource1";
                this.Page.Controls.Add(SqlDataSource1);
                SqlDataSource1.ConnectionString = cObject.connection().ToString();

                string query = "SELECT PropertyType, Area, Price, Image, PostedDate FROM TB_Property WHERE PropertyType like '" + "%" + propertyType + "' AND Area like '" + "%" + area + "' AND Price between'" + minPrice + "' AND '" + maxPrice + "'";
                SqlCommand cmd = new SqlCommand(query, con);
                con.Open();
                SqlDataReader dReader = cmd.ExecuteReader();
                
                GridView1.DataSource = SqlDataSource1;
                GridView1.DataBind();
                con.Close();

Posted 21-Dec-13 9:14am

Member 10215709

Updated 22-Dec-13 0:45am

JoCodes

v2

Add a Solution

3 solutions

Solution 1

try declaring the SQLDataSource in the web form code, instead of doing it in the code behind.
then set the datasource to the GridView using the DataSourceID property.

if you need to later modify the query, just change it directly from the SqlDataSource object and call Rebind() on the grid to update results, no need for you to open/close any connections.

XML

<asp:SqlDataSource
         id="SqlDataSource1"
         runat="server"
         DataSourceMode="DataReader"
         ConnectionString="<%$ ConnectionStrings:YourConnectionString%>"
         SelectCommand="SELECT FirstName, LastName, Title FROM Employees">
     </asp:SqlDataSource>

     <asp:GridView
         id="GridView1"
         runat="server"
         DataSourceID="SqlDataSource1">
your columns here..
     </asp:GridView>

Posted 21-Dec-13 9:56am

Leonardo Paneque

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Karthik_Mahalingam · Accepted Answer · 2013-12-21T15:08:00

HI. this will work fine..
This might help you..

C#

Property cObject = new Property();
            SqlConnection con = cObject.connection();
              
            string query = "SELECT PropertyType, Area, Price, Image, PostedDate FROM TB_Property WHERE PropertyType like '" + "%" + propertyType + "' AND Area like '" + "%" + area + "' AND Price between'" + minPrice + "' AND '" + maxPrice + "'";
            SqlCommand cmd = new SqlCommand(query, con);
            con.Open();
             
            DataTable dt = new DataTable();
            new SqlDataAdapter( cmd).Fill(dt);

            GridView1.DataSource = dt;
            GridView1.DataBind();
            con.Close();

joginder-banger · Accepted Answer · 2013-12-21T16:35:00

Try This code i have used many time it's working

ASP.NET

<asp:gridview ID="Gridview1" runat="server" AutoGenerateColumns="False">
    <Columns>
        <asp:TemplateField HeaderText="Property Type">
           
            <ItemTemplate>
                <asp:Label ID="Label1" runat="server" Text='<%#Eval("PropertyType") %>'></asp:Label>
            </ItemTemplate>
           
        </asp:TemplateField>
        <asp:TemplateField HeaderText="Area">
            <ItemTemplate>
                <asp:Label ID="Label2" runat="server" Text='<%#Eval("Area") %>'></asp:Label>
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="Price">
            <ItemTemplate>
                <asp:Label ID="Label3" runat="server" Text='<%#Eval("You Column Name (Price) change if you need ") %>'></asp:Label>
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="Photo ">
            <ItemTemplate>
                <asp:Image ID="Image1" runat="server" ImageUrl='<%#Eval("You Column Name (Photo) change if you need") %>' />
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="Posted Date">
            <ItemTemplate>
                <asp:Label ID="Label3" runat="server" Text='<%#Eval("You Column Name (Posted Date) change if you need") %>'></asp:Label>
            </ItemTemplate>
        </asp:TemplateField>
    </Columns>
        </asp:gridview>

I hope your problem has been solve, for any problem hit to reply.

unable to display data on the page

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0