I have a crystal report that is based on an XSD schema file. Within the report definition, I can modify the datasource location, specifically, the file path. This is where I can set the file path to where the XSD schema file resides on my machine. At this point, everything works correctly. Here is the problem: If the file path does ...
Hello all. VB.NET newbie here. I've learned (through this site) how to negotiate a dataset via: For Each dRow In quanDS.Tables(0).Rows 'do something to each row Next I now need to figure out now to loop through a subset of the records returned in the dataset - here's a VB6 example I need to convert: strSQL = "select * from tblDQ ...
Greetings, I have a large dataset (1GB of pure compressed text). Right now I'm rewriting the dataset based on information in the data, for example: Turn 2009-10-16 into Friday Count the number of times something happen and how long they last for Right now I'm doing all this in Java. I'm wondering if anyone knows of a tool or langu...
Hi, Assumption - For a simple app I have with only a few tables & I plan to stay simple and use DataSet for my data access as well as domain layer. In other way, in this small application, I won't create separate classes but rather just use the DataSet directly. Question - Does anyone have any code/patterns/suggestions re how best to...
I'd like to add a DataTable to more than one DataSet without calling DataTable.Copy(). Simply copying the DataTable doubles the amount of data in memory and causes me to manage its changes. This problem exists because I am implementing a detail tables solution where a detail table can have more than one master. If it helps, consider thi...
In my app, I'm downloading a spreadsheet from FTP, moving the data read from the spreadsheet to a DataTable, and, depending on certain conditions, emailing a new spreadsheet (one that contains certain rows from the 1st spreadsheet). My problem is creating the spreadsheet that will be mailed. I can't seem to work out how to add the row f...
Here is the code, any ideas why I get this error? private SQLiteDataAdapter DA_Webfiles; // Setup connection, fill dataset etc DataTable dt = this.dataSet.Tables["WEBFILES"]; DataRow newRow = dt.NewRow(); newRow["PATH"] = _url; dt.Rows.Add(newRow); this.DA_Webfiles.Update(this.dataSet, "WEBFILES"); // Works to Here newRow["CONTENT_TYP...
Hi, I am using a stored procedure to fetch the data from the database and populating the dataset with the output. I am trying to update some valued to the dataset that is populated. Now how do i update the modified dataset to the database. 1) Should i update the database by looping through the dataset rows? 2) Will dataadapter.Upda...
From API In a typical multiple-tier implementation, the steps for creating and refreshing a DataSet, and in turn, updating the original data are to: Build and fill each DataTable in a DataSet with data from a data source using a DataAdapter. Change the data in individual DataTable objects by adding, updating, or deleting DataRow objec...
I'm having a problem and I've got the feeling it is something simple that I'm not doing right. I've got a simple ASP.NET project going. I've got a DataSet that I populate from an Oracle database. The table in the DataSet has two columns: "account_code" and "account_descr". The user enters in a search term into a textbox. I use LINQ to ...
What was (or would be) the reasoning behind creating TDataSource as an intermediary between data bound components and the actual underlying TDataSets, rather than having the components just connect directly to the TDataSets themselves? This may seem like kind of a stupid question, but I am working on a broad set of "data viewer" compon...
Hi , I have a dataset with some 30 records in it. I want to update it to the database tables. which is the best method to update the table. I am unable to use dataadapter.update() since i am using a procedure to populate the dataset. is there any efficient way to update other than iterating through EACH record ...
Hi There, Well, first of all sorry about this question it must be pretty straight forward for you guys but I'm struggling myself on it, and I need to make it work :( Well I'm trying t o use DataSet on my application and when I render it I got: The type 'System.Data.DataSet' is defined in an assembly that is not referenced. You must add...
How do I delete a selected ListViewItem from a WPF ListView when the ItemsSource is set to a DataView? I can get the ListViewItem that was selected and then how do remove the actual row in the DataView? DataView dv = (DataView)myListView.ItemsSource; ListViewItem lvi = (ListViewItem)myListView.ItemContainerGenerator.ContainerFromItem(m...
We currently have an application that retrieves data from the server through a web service and populates a DataSet. Then the users of the API manipulate it through the objects which in turn change the dataset. The changes are then serialized, compressed and sent back to the server to get updated. However, I have begin using NHibernate w...
I have a users table where there are two types of users in it, users a and users b. There is a page on my website that shows 20 of each type based on querystring parameter. I want to cache these for 6 hours as their order is not that important. My question is is it better to have two different SqlDataAdapter calls and two different Dat...
I'm attempting to use the DataSet designer to create a datatable from a query. I got this down just fine. The query used returns a nullable datetime column from the database. But, when it gets around to this code: DataSet1.DataTable1DataTable table = adapter.GetData(); This throws a StrongTypingException from: [global::System.Diag...
The xml dataset file after I add it to a dataset like this: <?xml version="1.0" standalone="yes"?> <root> <Email></Email> <FirstName></FirstName> <LastName></LastName> <Addresses> <item> <Address1></Address1> </item> <item> <Address1></Address1> </item> </Addresses> <Friends> <item> <Name></Name> <...
I have a ASP.NET web page that needs to make a SQL Server call from the client side in a script sectipn of my aspx file. I'm calling a stored proc which takes one parm. This sp works fine in SQL Server Management Studio returning records as expected. When I try to fill a dataset from a call to this sp the ds gets filled with zero records...
Can anyone suggest best method for what I want to accomplish? I have an VS 2008 asp.net(MVC) web app and I am using Crystal Reports as my report engine. My app accepts parms from a form and calls a SQL Server stored proc to create a Dataset which I set as the datasource for the report. The report was created using an XSD file as a schema...