I’ve got a predefined Dataset with DataTables and DataAdapters in my applications. However, I now want to be able to modify the SP in SQL Server to add fields as needed, and have that reflected in the DataSet’s DataTable dynamically. This goes from a WebService into XML then goes to the client and gets converted back to the DataSet and...
Hi, I'm trying to reduce dataset dimension. PCA is a good metric but that gives me new dataset. My goal is to determine from number of events (e.g. 60) and number of trials (e.g. 6) which events are more relevant. For example: 1st, 3rd, 21st, 45th ... (N total) events are good enough to approximate behavior of dataset. That will al...
I have a table with several columns that allow NULLs. How would I go about writing a SQL Query that will allow me to skip that column in an update if the value is "empty". Should I use a boolean flag letting the query know to update that value? I do something similar in a SELECT like this SELECT * FROM table WHERE (@boolFlag = 1 OR col1...
I use a DataGrid to show a xml file. The Grid's DataSource is a DataSet.(using schema) Assembly assembly = Assembly.GetExecutingAssembly(); Stream stream = assembly.GetManifestResourceStream("XML_Reader.Resources.schema.xsd"); XmlSchemaSet schemas = new XmlSchemaSet(); XmlReaderSettings se...
Hello folks, I've run into a problem recently, hoping you all could help. I was tasked with creating an application that can take any DataSet, and display it in a series of grids (using something like a tab control). I was able to do this pretty easily in WPF: 1. Create a WCF Service that returns a DataSet object 2. Create a WPF Windo...
I have a dataset. I added a column "Tags". I need to run a function to update the value, for each row one at a time, for the "Tags" column. Here's what I've tried so far, tell me what I'm missing. public System.Data.DataSet PopulateDataGrid(int nViewMode) { System.Data.DataSet ds = _data.GetGridView(nViewMode) ds.Tables[0].Column...
I use a DataGrid to show a xml file. The Grid's DataSource is a Typed DataSet.(using schema) Assembly assembly = Assembly.GetExecutingAssembly(); Stream stream = assembly.GetManifestResourceStream("XML_Reader.Resources.schema.xsd"); XmlSchemaSet schemas = new XmlSchemaSet(); XmlReaderSettings settings = new XmlReaderSett...
In SSRS 2005 we have a query in a dataset and the query filters on a certain value which happens to contain an @. Eg: select * from test where testfield = '@LC'. SSRS thinks this value should be a parameter and treats it that way. How can configure my query so that SSRS treats it as a fixed value? Thanks! ...
I have a System.Web.UI.WebControls.Xml control (Xml1) in a webforms app that I have upgraded from .NET 2.0 to .NET 4.0 I am getting two warnings from the code-behind page that I'd like to do something about. ... Dim ds As DataSet = app.GetObjects Dim xmlDoc As New System.Xml.XmlDataDocument(ds) Xml1.Document = xmlDoc Xml1.TransformSou...
How many copies of data does the datatable store ? I found this question from a year before but not a whole lot of details on there ? http://stackoverflow.com/questions/424598/what-is-the-memory-overhead-of-storing-data-in-a-net-datatable Spefically, when do the copies get created? Are they flushed only on .Save() / .Update() ? I have...
I have two mirrored datatables (same structure with two primary keys) : DataTable_A ---> bound to a datagridView DataTable_B ---> filled from a database Since DataTable_B is filled by a query into database every 2 seconds, I need to mirror the DataTable_A like DataTable_B avoiding filling directly DataTable_A. When a record disappea...
Hello. I'm using DataRelation to nest tables in a DataSet, to get a XML result like this: <Customer> <Name>John</Name> <Age>30</Age> <Sex>Male</Sex> <Order> <Id>123</Id> <Price>200.00</Price> </Order> </Customer> I want to group the data by a field value, like sex, to get a result like this: <Male...
Hi Dear, I am dealing with SQLite with .net environment. When I use a TableAdapterManager to update a dataset, which is designed in the visual studio and contain "RowState is Deleted" rows, the ConcurrencyDBException occurr. If I go to the dataset designer and disable the optimistic concurrency option, it will works. But I don't want...
Hey all, I'm doing some work on Max Cut, and the algorithm I have works on every graph that I can think to throw at it, but those have been graphs that I can work out the solution by hand to validate, so they've been somewhat small. I am looking for a bunch of medium/large graphs (in any format, I dont mind writing parsers) that already...
Need: Need to bind data to WPF controls for a user to update a database. Approach: I am trying to implement a solution similar to this but am having an issue because I will be using a DataSet and not LINQ to SQL Class (hitting an Oracle db for my data). If this is a correct approach how can I do this? I'm also thinking instead of addi...
Hi experts! I would like to ask regarding C#.Net why my _DataSet.GetChanges(DataRowState.Modified) return a null value? using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; ...
I'm writing a game server to which many players connect. I load up the DB into a DataSet(strong typed). Every time a player logs in, I add a new row to Messages table using a TableAdapter. code var newRow = _db.Messages.NewMessagesRow(); // _db is a strong-typed-dataset { newRow.Title = title; new...
I had spent so many hours failing to find a line graph generator for my benchmark results that I just wanted to plug in. I tried quite a few like Google's chart API but it still seemed confusing or not graceful looking, I am clueless. Examples of benchmark images I wished to make something like are this: http://developer.studivz.net/wp-...
Hi, I have one asp.net application, and now i am using dataset for data manipulation. recently i started to convert this dataset to List collection. But, in some places i can't work. One is that in my old version i am using datarow[] drow = dataset.datatable.select(searchcriteria). But in List collection there is no method available for...
I am working on an application where I need to convert a DataSet into XDOcument in the Middle Tier ( XDOcument is much lighter to transport than XmlDocument) and then covert the XDocument back into DataSet at the Front end. I am not able to figure out an efficient way of doing this. As of now I am converting the DataSet to XMlDocumenmt ...