Hi, I am converting a console application to run from Service Broker in SQL Server 2005. The application makes heavy use of DataSet. Are DataSets supposed to work in SQLCLR? How do I define the connection to use? Is there any documentation about this? Thanks for your help! ...
Hi. How to display an Enumeration Value in Microsoft reporting based on the byte column from a DataTable? I want to cast =Fields!Status.Value to something like (MyEnum)Fields!Status.Value and then call .ToString() on it. Status is a Byte type. ...
I've written a DataSet to a XML file using .WriteXML(FileName), and the DataSetName property of the dataset is the top-level tag in the file. However, when I try to read the file into a different DataSet using .ReadXML(FileName), the DataSetName isn't changed to the value of the top-level tag. Am I doing something wrong, or is ReadXML no...
I create a custom dataset that I pass off to a black boxed component. The dataset consists of usually 5-6 tables (with unique names assigned by me). The component takes the dataset and builds a drop down combo box based off the table names. What I am needing to do though is to change the ordering of the tables within the dataset. I n...
I currently have a single DataSet declared which contains 3 tables. For sake of this example we will call them User, Question and Answer. On each of these I have a TableAdapter with the various methods required, ie. GetData(), Update(), Delete() etc. On the Answer Table I would like to override the Update Method from the TableAdapter t...
I have a Windows Forms application with a DataSet (.xsd) that is currently set to connect to a Sql Ce database. Compact Edition is being used so the users can use this application in the field without an internet connection, and then sync their data at day's end. I have been given a new project to create a supplemental web interface for...
DataSet is not ORM but it is possible to build an ORM with Dataset http://www.15seconds.com/issue/080103.htm This kind of article is very rare as people seem to oppose Datasets and ORMs so any other example ? ...
I need a list of common first names for people, like "Bill", "Gordon", "Jane", etc. Is there some free list of lots of known names, instead of me having to type them out? Something that I can easily parse with the programme to fill in an array for example? I'm not worried about: Knowing if a name is masculine or feminine (or both) If ...
I retrieve data from database like below. How do I check whether the value retrieved from database is null? Private Function GetBatch() As DataSet Dim dataset As New DataSet Dim adapter As Data.SqlClient.SqlDataAdapter Dim cn As New System.Data.SqlClient.SqlConnection(connectionstring()) GetBatchCommand.C...
Hey all, Have an Excel data source which I am querying ok and posting data in data grid. The trick is that I want the data in a string variable but am failing to do that. I have tried arrayLists and arrays and I am not getting there yet because dataset has multiple data types (numbers, strings). Please help me. Source code: <%@ Page ...
.NET I have a web service, one of the data members of a message implements IXmlSerializable, when I do "Add Service Reference" that member becomes a DataSet. I am trying to pass a serialized Expression<TDelegate> as a parameter to the web service. Q: How do I make a DataSet out of the IXmlSerializable instance on the client side? ...
I have 3 sql tables SourceKeys, Channels, and ChannelTypes. These tables are queried and their data is stored in datatables in my dataset. What I need is this: SELECT ... FROM ChannelTypes ct LEFT OUTER JOIN Channels ch ON ct.channelTypeID = channelTypeID LEFT OUTER JOIN SourceKeys sk ON ch.channelID = sk.channelID but in linq form....
I'm passing a table of up to 1000 rows, consisting of name, ID, latitude and longitude values, to the client. The list will then be processed by Javascript and converted to markers on a Google map. I initially planned to do this with JSON, as I want the code to be readable and easy to deal with, and because we may be adding more struct...
I am making a small card game which required a high score list that is saved to an external file, and loaded from it at the begining of each each game. I wrote an xml file in this format bob 10 3:42 21-09-09 I have figured out how to create a dataset, use dataset.readxml, to load the xml into it, create a row and then write each row...
Hi, in my VB.Net application I've created a Dataset that call an existing MS SQL Server stored procedure but after the wizard close no columns where added... how can I add all the columns returned by the stored procedure without adding them manually (off course the stored procedure might change in the future) in which case manually will...
For the most part, the application I'm working on deals with object, and I can bind a list of objects to a gridview without any problems. However, in a couple of cases, I want to display the results of a multi-table join in a gridview. The current code uses a dataset, which is pretty easy, but I'm wondering if there's a better/more eff...
Hello Im using C# 3.5 and I try to solve the "more than one entity situation" using a single query for each one and then joined them with DataRelation, so after I realized that I've tryed to show data on this way : DataColumn parentColumn = dataSet.Tables["Suppliers"].Columns["SupplierID"]; DataColumn childColumn = dataSet.Tables["Prod...
I tried the function from this question and I get the following error at the line row[column] = default(column.DataType); The error is: The type or namespace name 'column' could not be found(are you missing a using directive or an assembly reference?) By the way, I am using VS 2008 and C#. I would appreciate your re...
I need to extract data from a .dbf file and transform it into xml. I wrote a routine that does it just fine. However now we are encountering very large .dbf files - like 2GB +. And this code throws an OutOfMemoryException on those files. Public Function GetData() As DataTable Dim dt As New DataTable(Name) Dim sqlcommand As St...
I have a dataset that has changes. I call the .fill(ds) method to "refresh" the dataset. The dataset is bound to a grid. How do I go to the last position I was in (in the grid) prior to the refresh? ...