dataset

Suggestions for cleaning up dataset designer layout?

Is there a tool/addin for VS to clean up the design view of a dataset by automatically repositioning the tableadapters, etc based on relationships? Thanks ...

How to view a DataTable while debuging

I'm just getting started using ADO.NET and DataSets and DataTables. One problem I'm having is it seems pretty hard to tell what values are in the data table when trying to debug. What are some of the easiest ways of quickly seeing what values have been saved in a DataTable? Is there someway to see the contents in Visual Studio while deb...

C# Convert a 2-dimensional array into a dataset / datatable

hi, does anyone know how to turn a 2-dimensional array into a dataset or datatable in c#? Source: a range of values from excel (interop) in an object[,] array. Thanks. ...

How do you use ADO.NET to create a data source rather then read and manipulate one

I'm writing a plug-in for another program that generates a fairly complex tree structure of objects. The users will need to export this data from the plug-in for analysis and reporting. I definitely want them to be able to export to an MS Access database as it would be the most accessible for them to create quick and clean reports. But I...

Inserting a dataset into a database table

Hi guys, I have table on a database on a server, that is identical to a table on my local. I have click once application that needs to download the version of records on the server down to my local. At the moment i have webservice that pulls back the records on the server in batches, using asp.net datasets as containers. How do i commi...

How can I use multiple Datatables on my CrystalReport?

I have a dataset that connects with three databases. How can I attach my Crystalreport viewer so all three are included? protected void Page_Load(object sender, EventArgs e) { ReportDocument X = new ReportDocument(); DataTable DTable = new DataTable(); DataSet1TableAdapters.TableAdapterMana...

Sorting a dataset with a dataview

This code correctly fetches data, and displays it; however, the sort is completely ignroed. DataTable dt = f.Execute().Tables[0]; dt.DefaultView.Sort = summaryColumn; rptInner.DataSource = dt.DefaultView; rptInner.DataBind(); Is there something I can do to force the view to sort itself? (f.Execute() returns a dataset with at table a...

NHibernate, quickest possible primer

I moved away from typed DataSets and I (happily) never looked back. I am looking into NHibernate for persistence of my objects, and would like to see some text such as 'NHibernate for (DataSet) Dummies'. Some text that will assure me that I will be able to seamlessly update data islands, have possibilities of class inheritance, and so ...

Exporting/updating to a data source using a DataSet with a variable schema

I'm using a tree structure in an application I'm writing, and have written recursive methods that will iterate down the tree and populate a number of new DataTables with values. I want to be able to export these tables to a data source, and then later update that data source when the tree or members of the tree change. There are a few ...

Databinding, dataset with datarelations, and refreshing single DataTable from DB

In a nutshell: I have a DataSet with multiple DataTables inside, which are connected via multiple DataRelations. I've created a form using databinding on this DataSet, and you could say it is pretty complex. The scenarios is next: the main purpose of the form is the insertion of a new record. For it to be inserted, various parent-child ...

Maximum size for a byte[] in a .Net DataSet/DataTable

Is there any maximum size for a cell of data in a DataTable (like a byte[]), or can you grow it until the system runs out of memory? ...

How to handle exceptions generated by DataSets?

Hi, DataSets in ADO.Net throw exceptions when there are constraint violations etc. It is easy to catch these exceptions in the WinForms UI Layer using DataGridView (using DataError event). However, I am unable to find a way to catch and handle these exceptions when using simple data bound (to datasets) controls such as textboxes. Any i...

Working DataSets with LINQ

Hello, Im using LINQ over DataSet but just to get data from some tables, by the way Im interesting on Fill those DataTables using LINQ2SQL cause I recently discover that on some clients with less than 1GB of RAM, the machine memory is Lacking and freeze 1 or 2 seconds and there it go normal, well whatever is frustrating for the client. ...

Returning DataTable objects with WCF service

This is a strange problem that I am having with WCF trying to send DataTable in the response. I have the following service contract: [ServiceContract] public interface ISapphireDataService { [OperationContract] DataTable LoadData(string query, DateTime start, DateTime end); [OperationContract] string LoadDataTest(); } ...

DAL using typed dataset

Are there any performance issues in using Typed Data Sets as DAL? Is it a recommended approach? I am using it for listing purposes only (repeater). It has paging, sorting functionalities too. ...

inserting items to dropdownlist

Hi friends, I want to display the items in my dropdownlist2 (from table 2 )based on the selected item of the dropdownlist1(from table 1) . in the following, i just tried to select the lang column values from table2 based on the value which is in the dropdownlist1..((just to insert into the dropdownlist1)) is that correct code...? SqlDa...

C#: How do I iterate the contents in a DataColumn?

I have a database column I simply need to check to see if a value is there. DataTable dt = masterDataSet.Tables["Settings"]; DataColumn SETTINGS = dt.Columns["DEFAULTSETTINGS"]; I just need to iterate over the values in this column to see if a value exists. Help ...

Is there a generic way to create a data source from a DataSet?

I'm working on an application that generates a ADO.Net DataSet, which I want to be able to export to various data source types. I'd like to keep my export code generic so that I could switch between exporting to an MS Access file, SQL Server, MS Excel or other data source types with out creating a lot of duplicate code. DbProviderFactor...

Serializing fields in a custom DataSet to XML

Is there any way to add fields to a DataSet which will be serialized along with the table information when the DataSet is serialized in XML? I have some information that describes the DataSet that I want to try to include inside it when I throw it around in XML. I've tried adding fields and classes in the partial class Visual Studio gene...

LINQ Query Returning No Value

Hi guys. I'm currently trying to run a LINQ query over a MS SQL database. This is what I have done. I can see the database, the table, and the data inside if i want to via the Server Explorer. I've created a new DataSet automatically from "Add new item..". I've then dragged the table from the server explorer into the designer view of...