Last post Jul 21, 2011 01:45 PM by joserwanta
Jan 31, 2008 04:38 PM|dune44|LINK
I created a DataSet called GetHouses.xsd that gets data from a table based on which user is logged in. I named the Return a DataTable Method name: GetDataByUser.
I have tried Google and these forums but I haven't found anything matching what I am experiencing. I've done similar scenarios with success.
When I go to bind the DataObjectSource to GridView there are no DataSet TableAdapter listed, the Business Object dropdown is completely empty whether I have 'Show only data components' checked or not.
I get this when I try to manually type asp:ObjectDataSource:
The type 'GetHousesTableADaters.GetHousesTableADaters' could not be loaded. If the type is located in the App_Code folder, please check that it compiles. If the type is located in a compiled assembly, please check that the assembly is referenced by
Could not load type 'GetHousesTableADaters.GetHousesTableADaters' from assembly 'Microsoft.Web.Design.Client, Version=22.214.171.124, Culture=neutral, PublicKeyToken=b03f5f711d50a3a'.
I am connecting to the database on a hosted server MS SQL 2005. I have tried with a local sql express db as well with the same result.
I am using VS 2008 Beta 2 but have also tried with VS 2005 in case it was a glitch with VS.
I am using the Membership API for users to login in a seperate DB
My web.config connection string:
connectionString="Data Source=hidden;Initial Catalog=hidden;Persist Security Info=True;User ID=hidden;Password="hidden""
connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\DatabaseName.mdf;Integrated Security=True;User
SQL Query string:
WHERE (UserName = @UserName)
object data source
Gridview - dataset
Feb 05, 2008 12:42 AM|Nai-Dong Jin - MSFT|LINK
From your description, it seems that you can’t choose the business object since it disappears when you configure your objectdatasource, right?
Generally there are two potential causes. First, you’ve create a dataset, but didn’t initialized the table setup the TableAdatper; Another is you didn’t save the dataset file (.xsd) in the APP_CODE folder. In your case, please make sure if you have put the
dataset file into the App_Code folder, since for a dataset to be generally consumable in your site, it should be placed inside the 'App_Code' folder.
Feb 06, 2008 02:00 PM|dune44|LINK
Thank you for your reply, it is very appreciated.
I did however have my dataset in the App_Code folder. So I've been playing around with things and decided to disable Membership on a whim and low and behold my datasets could be accessed from the wizard again. Everything seems to work fine when I re-enable
memberships and upload to my server.
Mar 26, 2009 07:05 PM|marius.dumitru|LINK
Jul 21, 2011 01:45 PM|joserwanta|LINK
Yes, that is why I really like Stack Overflow.. it encourages folks to post the answer to their problem so others can benefit. I ran into the same thing today (7/21/2011) and I am stuck as well.