DataSource Controls :: Configuring ObjectDataSource Not Giving Option To Select Correct TableAdapter
Sep 16, 2010
So, I have 3 table adapters in my dataset, and trying to configure the objectDataSource will not give me the option to select the correct table adapter.
I set up a temporary website to illustrate what I am talking about, along with pics, not much, just 4 pics.
The first 2 pics are irrelevant but just in case anyone thinking I don't have it set up properly. The other table adapters are working fine, which I have gridviews being populated etc.
why it will not give me the option to select aspnet_GetRecordDatesTableAdapter?
Going to start this thread over so that it makes more sense.Anyways, my problem is that when trying to configure my ObjectDataSource in design mode, it only gives me 2 options and never gives me the option for the one I need. The other 2 work fine, but for some reason, this 3rd one will not show up in the list.I have a webpage with pics illustrating how I have it setup and the problem ----------> https://sites.google.com/site/configuringobjectdatasource/And I have another webpage with pics illustrating steps I have taken to fix this problem but still nothing -----> https://sites.google.com/site/configodspart2/what is going on and why it will not show up in my list when I try to configure?
I have a dataset with several tableAdapters in it. For some reason, one of them that I created doesn't show up when I try to put it into my objDataSource?
I can access and use it from codebehind (testing purposes for this post.
Now i can populate my gridview trough code by this: //gvwDiensten.DataSource = new BindingList<diensten>(dataManager.GetList<diensten>().ToList());But i would like to use an objectdatasource, so i created this:
[Code]....
</asp:ObjectDataSource>
But when running the page i get:
ObjectDataSource 'dsDiensten' could not find a non-generic method 'GetList' that has no parameters.
System.NotSupportedException was unhandled by user code Message=The data source does not support sorting. Source=namespace StackTrace: at namespace.Admin.ToolkitScriptManager1_AsyncPostBackError(Object sender, AsyncPostBackErrorEventArgs e) in C:projectMaster.cs:line 27 at System.Web.UI.ScriptManager.OnAsyncPostBackError(AsyncPostBackErrorEventArgs e) at System.Web.UI.PageRequestManager.OnPageError(Object sender, EventArgs e) at System.Web.UI.TemplateControl.OnError(EventArgs e) at System.Web.UI.Page.HandleError(Exception e).......
below is my code using for simple gridview and i am only having problem with the sorting and paging is working as expected and i even define the ONSorting event but it still throws me an error: The data source does not support sorting.
namespace mynamespace { public class Product { private int _id; public int Id { get { return _id; } set { _id = value; } } private string _code; public string Code { get { return _code; } set { _code = value; } } private string _name;
I have a dataset with a table adapter that has several queries. I want to execute on of the queries and fill a data table but am having trouble with this operation. Am I invoking my table adapter incorrectly? See line 56.
I have a objectdatasource control with a field of date and time and I was wanting to know how you format the date to uk format with the select statement through my objectdatasource. And what type of integer is bigint in SQL?
I am having a problem configuring the select link in the gridview, I have build a search engine, that works. When I click the select link in results gridview to pass the selected results to the next page I am having a problem getting the select link to work and pass my selection to a results page. My code is as follows below:
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Configuration;
I have a dynamic dropdown that is populated from sql. The user is supposed to select an option from the dropdown, then click a search button on the form to return some results based on that selection. It works fine if the dropdown gets populated with more than one record. However, if only one record is returned, that one record can't be selected. Whether you select it or just leave it alone since it's the only one, when you click the form button (search button), no results are returned b/c the dropdown selection must not be actually selected.
I've included the relevant code below. First the DDL, then the datasource, and finally the C# code in the if (!Page.IsPostBack)
I am using 3 tables and are trying to get the correct info belonging to the correct id. Like this: I go to a page and here i want to see the information from the 3 tables using a specific id.
I have written this so far in a query:
[Code]....
My problem is that the last line does not work and i am uncertain how to make this work? How to write it correctly that is.
There are several articles and blogs that are sort of about this subject but I haven't found one on point. Wondering if anyone has done this? Using VS2008 creating an ASP.NET 3.5 app with a strongly-typed dataset connecting to an MS SQL backend. In one TableAdapter, I have a custom Insert statement that inserts the record into the primary table. There are two other tables the also need records inserted into them and those records contain the record ID from the primary table. Here's an example of what I'm trying to accomplish:
I am currently using VS 2008 Pro for an ASP.Net class. I got VS from school as part of MSDNAA program. It is version 9.0.21022.8 with .NET framework 3.5 SP1.
My problem is that when I start it up, it does not give me the option to Create or Open a Website. It only gives me the option to Create or Open a Project. So, when I start my homework or in-class assignments, I have to press Shift+Alt+N to Create a Website.
Where the problem comes in is after I start working on the website, I hit Save and it changes it to a Solution. This seemed to have caused a problem with BIND commands being lost in my last homework assignment. Is there something wrong with my install or a setting I can change? I'd rather not reinstall it unless I have to since it is such a pain to uninstall it in the first place.
I have this Insert statement working fine: [Code]....
It inserts a new record into a single table. The PK is a field named QID.what the equivalent Update code would be? I'm not sure of the syntax for the Update values (old and new) and Where clause.I'm assuming something beginning with: existingQ.Update
I have a quite baffling problem. I've created a Table adapter with 3 queries. 1. GetMemberData() - Return ALL rows. 2. SearchMembersLastName(@q) - Return specified columns from rows that have a column starting with a specified letter. 3. GetMemberDataById(@id) - Return all rows matching a specified ID.
The Problem is that SearchMembersLastName(@q) is returning ALL coloumns instead of just the ones I want. Here's the query that's in the Table Adapter:
[Code]....
The problem is that it is acting like: [Code]....
Here's the code that's calling it: [Code]....
I just can't figure out why this is happening, any help will be greatly appreciated.
I right click on a TableAdapter, select Add Query, select using QueryBuilder, then select a field to filter upon, and add Filter as =@BookStem. Automatically the QueryBuilder adds the WHERE clause to my new query:HERE (BookStem = '@BookStem')When I press OK, I get "BookStem in expression is not part of the query". And filtering doesn't work.
I create Dataset(Add new item dateset(the name is myDataset)), after that I made a simple TableAdapter(myTableAdapter) sql query, I want to know how to connect with code to this tableadapter and then with DataGrid(I don't wont to use wizard).
I am creating a TableAdapter using corresponding wizard, with a GetDataByID() query. The select statement is like this:select * from books where ID = ?Thus books are filtered by ID. But in case a null is passed as a parameter, I want to select all records rather than none. Could you please tell me how I can do it?
I have created a function that is called when a user wishes to upload a file to the database. The problem I am having is that it won't write the files to the database anymore. This function used to work before I implemented a treeview (which connects to the database). I am struggling to see how the treeview could have cause the file upload to stop working (the error may not even be related to the implementation of the treeview).
The error message I am receiving is: 'Update' is not a member of 'CMS.SiteFilesDSTableAdapters.SiteFilesTableAdapter'.
The code for the upload function is:
<System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Insert, True)> _ Public Function AddSiteFile(ByVal FileData As Byte(), ByVal FileName As String, ByVal FileDescription As [code]....
It is throwing the error at: Dim rowsAffected As Integer = Adapter.Update(SiteFiles) ' Return true if precisely one row was inserted, otherwise false Return rowsAffected = 1
EDIT: I managed to solve this problem by following:
I'm lost as to where to look next. Here is a sample of what I'm doing:
[Code].... The related tableadapter insert statement was autogenerated by VS2008:
INSERT INTO [ProductCycleCountItem] ([ProductCycleCountLocationID], [ProductID], [CountOnly], [Status]) VALUES (@ProductCycleCountLocationID, @ProductID, @CountOnly, @Status); SELECT id, ProductCycleCountLocationID, ProductID, CountOnly, Status FROM ProductCycleCountItem WHERE (id = SCOPE_IDENTITY())
With multiple users it's as if it was returning @@IDENTITY instead of SCOPE_IDENTITY(). The table will look like this:
id Location product
1 A 5321
2 A 8273
3 B 2827
4 A 1743 The returned dataset will look like this:
id Location Product
1 A 5321 2 A 8273 3 A 1743
Is it maybe a SQL Server (2005) setting that's incorrect?
I need to insert two rows into a tableadapter - and then take the identity column from each row and update them into a column on each row.
My problem is that I cannot update a column on a newly inserted row. Stepping through the code seems to indicate that I have updated the column, but when I check the database - the column indicates null.
I have tried calling Update on the TableAdapter, then performing the update on the column, and then calling Update again, but the update still isn't taking.
I dragged and dropped a sqldatasource and want to do an insert statement, taking the new values from a textbox. I did this already however when i do my insert statement eg. INSERT INTO Development_Programme(MHID) VALUES (@m) HOWEVER when to select the insert parameters the 'Next' button and the 'Finish' button is shaded off, I added a Select statement and the 'Next' was unshaded HOWEVER the screen to select the insert parameters is not appearing it goes straight to the Test Query.
