Hi, I am developing a web app using ASP.NET 2.0 (C#), where on home page I am displaying recently added records. Adding of records frequency is around 1-5 records per day, so I decided not to put much overhead on the sql server by fetching recent records every time from db server. So, To make the data cached I have used XML files, I h...
I have a DataSet with some DataTables that are linked together with DataRelations (classic order Header/Detail pair). Is there an easy way to denormalize the whole lot into a single DataTable with all the columns of the related tables? The table names and columns are not known at compile time, and there may be more than two tables/relat...
I've been working on my issue for 30 hours. Each time I fix one thing a new error arises. All I want to do is take a DataTables from memory and simply update an Access .MDB file. Here is my code: using System; using System.Collections.Generic; using System.Data; using System.Data.OleDb; using System.IO; using System.Linq; using System.T...
Given a list of objects, I am needing to transform it into a dataset where each item in the list is represented by a row and each property is a column in the row. This DataSet will then be passed to an Aspose.Cells function in order to create an Excel document as a report. Say I have the following: public class Record { public int I...
In .NET 2.0 (in this case VB), is there a standard API that'll serialize a DataSet object into a stream that can be saved as a tab-delimited file and opened directly in Excel? Or does one have to create the delimited file manually by iterating through the members of the table collection? In this case, the DataSet's small, consisting ...
Does anyone know of examples which show how to encrypt a dataset at the client side and send it over to a web service and have it decrypted there? Another question: What i need to do is a send hundreds of rows of data from a client to a web service and have the web service update the database with these records. I can't think of any o...
Where I work we're finally coming around to the idea of using strongly typed datasets to encapsulate some of our queries to sqlserver. One of the idea's I've been touting is the strength of the strongly typed column's, mainly for not needing to cast any data. Am I wrong in thinking that strongly-typed-datasets would improve performance ...
Hi again all, I'm trying to pull some data from a SQL table in my dataset using C#. In this case I do not need all the columns just a few specific ones, however as I am not pulling back a column with a mandatory NOT NULL, the copy of the table is throwing the exception "Failed to enable constraints. One or more rows contain values...
I use Crystal Reports XI with C# Visual Studio 2005. I am trying to create a subreport from a summary dataset. A simple example would be Company listing with Employees. I load the Company dataset (with CompanyId). I want to create a subreport which is linked by CompanyId whereby the dataset is loaded (obviously) on demand. I can create ...
I have been trying to fill my ultracombo box with data yet it takes a signifigant amount of time. However when I run the same stored procedure from withing sql server it takes relatively no time. The line of code that the program gets hung up on is: SprocPatientsTableAdapter.Fill(Me.PatientsDataSet.sprocPatients, SelectedCustomerID) B...
I am using VS 2008 and trying to create a dataset for ms sql reporting services. I have two tables that I want to relate. One has a column with type of int, the other shortint. VS give me an error of "Parent and Child columns don't have type-matching columns." Is there any way to over ride this? In old sql reporting services I could...
We're using a dataset to throw a small amount of data around amongst various nodes within our application. The dataset is in an assembly by itself as it is reference from many other components. The Visual Studio dataset tool has developed a strange habit of creating a new designer everytime a build is done. So, the project looks like...
I have converted a complex XML File to a Dataset that has 7 Tables and around 70 Columns I have created the tables in SQL Server to match the ones in the Dataset using the XML Schema. How can I easily write my Dataset to the SQL tables? ...
DataSets were one of the big things in .NET 1.0 and even now when using .NET 3.5 I still find myself having to use them....especially when I have to call a stored proc which returns a dataset which I then end up having to manually transform into an object to make it easier to work with. I've never really liked DataSets and have found th...
I have a datatable whose columns are lets say col1,col2,col3 Now I want to validate each column value whether its 0 or not I do not want to use if else clause that will be writing to much stuff. Is there any possibility to do the same task using HashTable or something else ? ...
My boss has asked me to disable constraints for the dataset layer of our application. Seemed easy enough to me, since the .XSDs had the EnforceConstraints boolean. However, after turning that off I'm still getting the "Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints."...
I have a dataset in which I create a new row in the datatable and fill in 1 or 2 field. They may not be the same ones everytime. When I do dataset.update(), all the fields appear to be written back. My database backend has default values set which are not triggered. Is there any way to get the dataset to only insert the values I have m...
Try Dim ds As DataSet = SqlHelper.ExecuteDataset(ConfigurationManager.ConnectionStrings("connstr").ConnectionString, CommandType.StoredProcedure, "Get_All", New SqlParameter("@userid", Session("userid"))) rptBundles.DataSource = ds.Tables(0) Catch ex As Exception showerror(ex, Me) End Try That is the code, I want to be a...
I am writing this in C# using .NET 3.5. I have a System.Data.DataSet object with a single DataTable that uses the following schema: Id : uint AddressA: string AddressB: string Bytes : uint When I run my application, let's say the DataTable gets filled with the following: 1 192.168.0.1 192.168.0.10 300 2 192.168.0....
I am searching a way to print data in tablesw with text and images, in a WYSIWYG, nice and good looking way. So far I have: header + images + web-like decorations + arabic labels & values + data in dataset (xml) + I need to give a way for buisness analysts to change the output layout. Crystal Report does all of this. But I don't like C...