strongly-typed-dataset

TableAdapterManager does not contain "table adapter" and no extension method

I created a simple form that uses a typed dataset generated by Visual Studio (Express to be exact). I altered the default "Fill" query to pull in values from a few other tables and then tried to run my application and got the following error: TableAdapterManager does not contain "table adapter" and no extension method Prior to m...

Create entire DataSet from existing stored procedure

Hi, I have stored procedures (they accept parameters) that return multiple result sets and I'd like to have this saved in a typed dataSet. The question is: can I have Visual studio 2010 generate the typed dataset based on stored procedure? I know I can have this for a single table, but I need the whole dataSet (multiple tables, one for...

Putting forward a solution to replace Typed datasets

Hi all, A project I am currently employed with will have some time soon to improve and specialise a product that is currently in use. We may have about 4 man weeks spare in which we could replace the typed datasets that are in use. The project is currently written in Vb.Net and we will definitely not have time to replace this code with...

Dataset Designer set default parameters

Hi guys, I have many typed datasets in my project. My purpose is to set two parameters of these datasets when I instantiate any of these datasets. (RemotingFormat and ExcludeSchema) Therefore I am looking for a solution like setting these two parameters in constructor of each dataset class. But this solution has two drawbacks: First, I...

Can you sort Typed DataSet DataTables with Linq OrderBy?

I have a Typed DataSet DataTable which inherits TypedTableBase<T>, which in turn implements IEnumerable<T>. I can't seem to get this to work. myDataTable.OrderBy(x => x.ID).ThenBy(y => y.ID2); Instead I have to assign this statement to an IEnumerable(or List), then refill my DataTable manually with the newly ordered IEnumerable before...

how to know Datatable is already subscribed ??

How to know that DataTable is already subscribed to OnRowChanged or OnColumnChanged events ? I am facing a issue with many notifications in my app ? so I wanted to put a check and want to subscribe table only once ?? ...

How to perform a Linq "First" query on a strongly-typed DataTable object ?

Hi, I'm trying to perform a simple Linq "find first" query on a typed DataTable, but cannot seem to get the syntax correct. (If I don't use typed data table/row objects, things work just fine.) I have this... class Program { static void Main(string[] args) { MyDataTable table = new MyDataTable("table"); table.Rows.Add(...

programmatically change table names in .net strong typed dataset

hi I've developed an application using strong-typed dataset with .net framework 3.5. is there a way to change the source table for a tableadapter programmatically? thnx ...