Solved

ObjectDataSource Wizard doesn't detect Class files in App_Code

Posted on 2008-10-08
6
305 Views
Last Modified: 2012-05-05
Hi,

I'm trying to set up a web site with Class files in the App_Code directory.  When using the ObjectDataWizard configuration set up wizard, the first screen reads "Select your business object"

The dropdown only contains references to my master page files, no sign of the .cs files I have created
0
Comment
Question by:krapvag
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 18

Expert Comment

by:carlnorrbom
ID: 22670053
Hi,

Have You specified the component model attributes in your class files? I.e:

[System.ComponentModel.DataObject]

public partial class MyDataAccess {
    [System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, true)]
    public static DataSet GetMyData()    {

    }
}

/Carl.
0
 
LVL 1

Author Comment

by:krapvag
ID: 22670109
Thanks for the quick response.

I don't think I have.  Would I do this in the CS file?  I'm new to .net, so I've added the class file I'm trying to use

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Collections.Generic;
using System.Data.SqlClient;
 
/// <summary>
/// Summary description for TimePlanData
/// </summary>
/// 
 
public class TimePlanData
{
 
    private string _conString;
 
	public TimePlanData()
	{
        _conString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
	}
 
    public IList<TimePlan> GetTimePlans(int idFilter)
    {
        string sql = "SELECT * FROM TimePlan ";
 
        if (idFilter > 0)
        {
            sql += "where tp_id=" + idFilter;
        }
 
        sql += " order by tp_name";
        SqlConnection connection = null;
        IDataReader reader = null;
 
        IList<TimePlan> result = new List<TimePlan>();
        try
        {
            connection = new SqlConnection(_conString);
            connection.Open();
            IDbCommand cmd = connection.CreateCommand();
            cmd.CommandText = sql;
            reader = cmd.ExecuteReader();
            while (reader.Read())
            {
                result.Add(new TimePlan(reader));
            }
        }
        catch (Exception ex)
        {
        }
        finally
        {
            if (reader != null)
                reader.Close();
            if (connection != null)
                connection.Close();
        }
        return result;
    }
 
}

Open in new window

0
 
LVL 18

Accepted Solution

by:
carlnorrbom earned 500 total points
ID: 22671506
Hi,

You should get by through changing your class file as the attached snippet.

/Carl.
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.ComponentModel;
 
/// <summary>
/// Summary description for TimePlanData
/// </summary>
/// 
 
[DataObject(true)]
public class TimePlanData
{
 
    private string _conString;
 
	public TimePlanData()
	{
        _conString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
	}
    [DataObjectMethodAttribute(DataObjectMethodType.Select, true)]
    public IList<TimePlan> GetTimePlans(int idFilter)
    {
        string sql = "SELECT * FROM TimePlan ";
 
        if (idFilter > 0)
        {
            sql += "where tp_id=" + idFilter;
        }
 
        sql += " order by tp_name";
        SqlConnection connection = null;
        IDataReader reader = null;
 
        IList<TimePlan> result = new List<TimePlan>();
        try
        {
            connection = new SqlConnection(_conString);
            connection.Open();
            IDbCommand cmd = connection.CreateCommand();
            cmd.CommandText = sql;
            reader = cmd.ExecuteReader();
            while (reader.Read())
            {
                result.Add(new TimePlan(reader));
            }
        }
        catch (Exception ex)
        {
        }
        finally
        {
            if (reader != null)
                reader.Close();
            if (connection != null)
                connection.Close();
        }
        return result;
    }
 
} 

Open in new window

0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 1

Author Closing Comment

by:krapvag
ID: 31504266
Excellent, thanks!

I take it for every other method I add, for example an Insert method, I put the line:
 [DataObjectMethodAttribute(DataObjectMethodType.Insert, true)]

before it?
0
 
LVL 18

Expert Comment

by:carlnorrbom
ID: 22671895
Hi,

Yes, exactly.

/Carl.
0
 
LVL 1

Author Comment

by:krapvag
ID: 22842548
Hi,

I'm trying to add an Insert routine to this class file, but the ObjectDataSource wizard is only detecting the "GetData" method

It is not showing the "AddData" method, and when I type in "[DataObjectMethodAttribute" this is not detected in the intelisense


[DataObjectMethodAttribute(DataObjectMethodType.Insert, true)]
    public void AddData()
    {
 
    }
 
    [DataObjectMethodAttribute(DataObjectMethodType.Select, true)]
    public IList<Data999> GetData(string telNumber)
    {

Open in new window

0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

624 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