0

its been 6 days passed since i started making this assignment of mine
it is to show how objectdatasource is used,

until now, i still cannot getaway with this error,

The data source for GridView with id 'GridView1' did not have any properties or attributes from which to generate columns. Ensure that your data source has content.

is anybody can help me? and check what is wrong with my codes?

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" %>

<!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></title>
</head>
<body>
    <form id="form1" runat="server">
    <div style="background-color: #FFCC00" >
        &nbsp;<asp:GridView 
            ID="GridView1" runat="server" DataSourceID="ObjectDataSource1">
            <Columns>
                <asp:BoundField DataField="id" HeaderText="pID" />
                <asp:BoundField DataField="firstname" HeaderText="firstName" />
                <asp:BoundField DataField="lastname" HeaderText="lastName" />
                <asp:BoundField DataField="age" HeaderText="age" />
                <asp:BoundField DataField="contact" HeaderText="contact" />
                <asp:BoundField DataField="address" HeaderText="address" />
                <asp:BoundField DataField="email" HeaderText="email" />
            </Columns>
        </asp:GridView>
&nbsp;<asp:ObjectDataSource ID="ObjectDataSource1" runat="server" 
            SelectMethod="select" TypeName="yaxclas" 
            >
        </asp:ObjectDataSource>

    </div> <br />

<div  style="background-color: #800000"> 
        <asp:Button ID="btn_prev" runat="server" Text="previous page" Font-Bold="True" 
            onclick="btn_prev_Click" /> 
    </div>
    

    </form>
</body>
</html>
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

/// <summary>
/// simple class with select method to be connected
///  to the objectdatasource
/// </summary>
public class yaxclas
{
    int id;
    int age;
    int contact;
    string email;
    string address;
    string firstname;
    string lastname;
    

    public yaxclas()
	{
		
	}

    public yaxclas select() 
    {
       yaxclas yxperson = new yaxclas();

      

      string ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["DatabaseConnectionString"].ConnectionString;

        SqlConnection con = new SqlConnection(ConnectionString);

        string queryString ="SELECT * FROM person;";
        
       try
       {
            con.Open();
            SqlCommand cmd =  new SqlCommand(queryString, con);
            cmd.CommandType = CommandType.Text;
            SqlDataReader reader = cmd.ExecuteReader();


           if(reader.Read())
                   {
                        yxperson.id = (int)reader["pID"];

                        yxperson.firstname = reader["firstName"].ToString();
                        yxperson.lastname = reader["lastName"].ToString();
                        yxperson.age = (int)reader["age"];
                        yxperson.contact = (int)reader["contact"];
                        yxperson.address = reader["address"].ToString();
                        yxperson.email = reader["email"].ToString();
                  }
       }
        finally
        {
                
                con.Close();
        }

       return yxperson;
       
    }
}

Edited by cutebaboi: reason of posting or error encountered not stated very clearly

2
Contributors
4
Replies
6
Views
6 Years
Discussion Span
Last Post by cutebaboi
0

Create Properties for the above fields you declared it will work

like example below:

int mid;

public int Mid
{
    get { return mid; }
    set { mid = value; }
}

Edited by pyTony: fixed formatting

0

ahww...i haven't thought of creating setters and getters :-D

Thank you very much shravan24

i've got to try this one

Edited by cutebaboi: i have wrote wrong term

0

why am i having this error?
An unhandled exception of type 'System.StackOverflowException' occurred in App_Code.7fwkmzwo.dll

it pointed somewhere in the bold letters below

public int id 
    {
        set { this.Id = id; }
       [B] get { return id; }[/B]
    }

Edited by cutebaboi: i accidentally hit the enter in my keyboard

0

it already worked, i just changed my properties from

public int id 
    {
        set { this.Id = id; }
        get { return id; }
    }

to something like this

public int Id 
    {
        get { return this.id; }
        set { id=value; }
    }

thank you very much, thank you for this site

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.