dataset

wsDualHttpBinding failing with larger datasets

I am using wsDualBinding in my wcf service to handle 2 way communication in my software. Everything seems to work fine except when I call a method to get a customer list. If in the service I limit the results of the query to 2730 records I can get the results in about 1-2 seconds and display them in a datagrid. If I limit the results to ...

LINQ to DataSet, DataTable.AsEnumerable() not recognized

I am brand new to LINQ and am trying to query my DataSet with it. So I followed this example to the letter, and it does not work. I know that my DataTable needs the .AsEnumerable on the end, but it is not recognized by the IDE. What am I doing wrong? Am I missing a reference/import that is not shown in the example (wouldn't be the fi...

Requirements for design-time data source in Report Viewer 2010

What are the requirements for a custom data source to be listed in the 'Data Source' drop-down list when adding a Dataset to a .rdlc report in Report Viewer 2010? As can been seen from the screen grab, for some reason it is listing potential sources from a variety of referenced assemblies, but I can't see an obvious pattern as to why it...

Import unique records from datatable to sql table

Hi, I have a datatable matching the structure of a MS Sql table and I would like to import new records from the datatable into SQL. So, in the example below, I am looking to import the record for Jim. DataTable: Name DOB Country Brian 11-11-78 USA Dave 01-01-80 UK Jim 02-02-81 FR SQL: Name DOB Country...

Databind only 3 columns of a table in Gridview

Hey i have a simple ASP.NET application Table with this schema: id | Owner | Customer | SentOn | Deleted |. I want the gridview to show only Owner | Customer | SentOn columns of the DataTable which is inside the DataSet. How can i do this? Note: I want to do this programmatic without any dataSource Controls. I want to display CheckBox...

WPF TextBox won't update source

I'm trying to make a simple form that contains textboxes that draw from a db in my project. I'm using the table adapter's GetData() method in the xsd file to populate the data context. I want to update one of these textboxes and have the changes reflected in the database. The textboxes populate fine, but the changes don't make it back to...

Does the dataset WriteXml(string fileName) method rewrite the whole datset to a file or just appends the changes?

I am using datasets WriteXml method to write changes on to a local file for persistancy. I am willing to pay the penalty for the I/O but cannot figure if each time that i call WriteXml the whole dataset is rewritten to file. Does anybody know if this is the case? And if so what can i do to just append the latest row? ...

.NET: Import Excel files, which are a embedded in a resource file, into a dataset.

I have a resource file with some embedded Excel files. How can I import these files into datasets? I found several libraries / code snippets which works for files, which are on the harddisk, but nothing if the files are part of a resource file. ...

Data source wizard: An error occurred while retrieving information from the database

I have a winform application with 15 different datasets. Lately, when I open a dataset for modification or try to create a new database the wizard gives an E_UNEXPECTED error saying "An error occurred while retrieving information from the database". I tried going through server exploere to connect to the same database and still get the s...

select distinct from dataset

I have got duplicate rows in a dataset. how can i select distinct rows from that. From comments: My query is something like this: select name, age from student When I receive its output in a dataset the output consists of rows having duplicate names. Using dataset itself I have to select distinct name from this because I need the s...

How do you convert a DataSet/DataTable into a generic list of certain type?

I have looked at the answered topic with the answer: List list = dt.AsEnumerable().ToList(); However, what if wanted to convert to a list of some entity type? For instance, I have an entity class Property: public class Property { public int ID { get; set; } public string Chain { get; set; } public string Na...

Error calling Locate() on DataSet

Consider the code below. I need to remove the error which is coming because of Locate. Please help me to do the same. public virtual void updateZeroPointLast(Decimal bdID) { if (!qdsErosionElSave.Open) { qdsErosionElSave.open(); } // Locate the row to update DataRow dr = qdsErosionElSave.Tables["erosionelemen...

How to combine data from datatables

I have filled my dataset from multiple xml files in C#.Net. As a result I have a dataset which contains multiple DataTables in it. All of them are having two columns each namely "ID" and "Name". These data tables can contain rows for same ids actoss all the tables. For Example: DataTable 1 ------------ ID Name1 1 S1 2 S2 4 S4 D...

How is AWS for Data mining for school project?

I have to do a class project for data mining subject. My topic will be mining stackoverflow's data for trending topics. So, I have downloaded the data from here but the data set is so huge (posts.xml is 3gb in size), that I cannot process it on my machine. So, what do you suggest, is going for AWS for data processing a good option or n...

Plotting Contrasting graph(s) from a dataset using R

Dear R users, I have a set of data (1000+ animals) from two seasons (winter and summer) and would like to demonstrate the differences in the gestation length (days) pattern in these two seasons. My data is similar to this: id <- c(1,2,3,4,5,6,7,8,9,10) season <- c(1,1,2,2,1,2,1,1,2,1) gest <- c(114,NA,123,116,NA,120,110,NA,116,119) da...

Large text file dictionary of random words for benchmarking purposes?

I was wondering if anyone could point me to a very very large dictionary of random words that could be used to test some high performance string data structures? I'm finding some that are in the ~2MB range... however I'd like some larger if possible. I'm guessing there has to be some large standard string dataset somewhere that could b...

Test database to test performance tuning techniques in Oracle

Hello gurus, I want to test some performance tuning techniques on a realistic database with many database tables and a lot of data. I would like to do this in Oracle 11g Release 1 and would like to know how best to go about this or if there is a website I could get realistic datasets/database from. Many thanks for your audience. Cheer...

Loading a different dataset per test method in DBUnit

Hi folks, I'm trying to use DBUnit to test my DAO layer methods. Every method needs different set of seed data. Example: getEmployeeById(Long id) needs data from Employee table updateOrder(CustomerId cId) needs data from Orders table Is there an elegant way to load different seed data before running different methods instead of loa...

Most efficient way of bulk loading unnormalized dataset into PostgreSQL?

I have loaded a huge CSV dataset -- Eclipse's Filtered Usage Data using PostgreSQL's COPY, and it's taking a huge amount of space because it's not normalized: three of the TEXT columns is much more efficiently refactored into separate tables, to be referenced from the main table with foreign key columns. My question is: is it faster to ...

Import Excel file to SQL Server row-by-row

I'm importing an Excel file (about 1000 records only) to a dedicated SQL Server database. As I need to work on the incoming data from Excel (add a GUID per row, some data conversions) I want to do it row by row and don't want to bulk import (I have nothing against transactions, though). I'm confused on how to do it correctly. I can eith...