I have two tables in a DataSet in .NET. I want to join them on an ID column. Then I want a DataGridView to display two columns from the first table and one column from the second table. If it makes it easier, the relation between the two tables is one-to-one. Can it be done? ...
I've written an XML Schema file by hand (not using the DataSet Designer in VS) and a corresponding XML file containing structured data to be read in. I ran the xsd.exe program to generate a Typed DataSet class; on the whole it looks fine to begin with (ignoring how it uses lowercase for public class members), but when it comes to using ...
Hi Folks, im using Crystal Repots in vs2008, so im using datasets with procedures to get the data from the db, my escenario is the following: In the same Crystal Report, i have to show two reports, basically using the sames datasets, and the same database, but they are diferents querys (have grouping and summing instead) is this possi...
Let's say I have an interface representing a domain object: public interface IFoo { Bar Bar { get; } } The Bar type is a family of objects, each of which has a slightly different schema. In the database, this is represented as XML (this is a mobile app, so it is simply nvarchar, not a true XML column). I have a generated DataSet ...
Hello, I have a generated DataSet with bunch of tables. In one table I have a custom query that I use to select people that are older than 15 years. I would like to change this query during working program, so that the query will look like 'select * from people where age > 17'. Now it looks like 'select * from people where age > 15'. A...
I have a strange, sporadic issue. I have stored procedure that returns back 5 small tables (e.g. IDs and Text Descriptions for Status drop down lists and such). The code calls this and places the returning dataset into ASP.Net cache. Separate methods are called to retrieve individual tables from the dataset to databind to controls t...
I have typed dataset with 1:N relationship between two tables. Child table has 'Order' column, that I use for sorting (ordery by) in SP when loading data into dataset. As I understand, this order is not guaranteed when working with dataset. I need GetChildRows of parent row and ensure that rows are in specific order defined in order co...
I have two TDBLookupComboBox controls that I'd like to connect to the same dataset, but have each one display a different subset of the data. If I only needed one box, I'd use filtering on the dataset, but I need to be able to display both of them at the same time, and I'm not aware of any way to do that. Does anyone know if it can be d...
The title pretty much says it all. I'm using a TClientDataset to store an array of objects, and one of the objects has a member defined as a set of an enumerated type. As I understand it, Delphi sets are bitfields whose size can vary from 1 to 32 bytes depending on how much data they contain, and Delphi doesn't define a TSetField. What...
Hi, I have this code: SELECT idcallhistory3, callid, starttime, answertime, endtime, duration, is_answ, is_fail, is_compl, is_fromoutside, mediatype, from_no, to_no, callerid, dialednumber, lastcallerid, lastdialednumber, group_no, line_no FROM "public".callhistory3 WHERE (starttime >= ?) AND (...
I'm trying to insert a column into an existing DataSet using C#. As an example I have a DataSet defined as follows: DataSet ds = new DataSet(); ds.Tables.Add(new DataTable()); ds.Tables[0].Columns.Add("column_1", typeof(string)); ds.Tables[0].Columns.Add("column_2", typeof(int)); ds.Tables[0].Columns.Add("column_4", typeof(string)); ...
Hi All... I have been searching for a simple way to convert a dataset from a postgres database to JSON for use in a project that i am building. This is my first time using JSON and I have found it really tricky to find a simple way of doing this. I have been using a stringbuilder at the moment to create a JSON string from the informatio...
Since silverlight does not have any support for DataSets/DataTables, what would be the best approach if I wanted to consume a table of data from a database? A bit like this: user action in silverlight -> get data from server -> display in GridView The thing is, I do NOT know how many and which columns the data will have... Can I bind ...
I have a small dataset with a few datatables. I load the datatables from various DBs and have a config file that I read to determine the primary keys I want to enforce on the given datatables. If the config doesn't contain a proper (non unique) primary key, how can I catch this event when applying the primary key to the datatable? Cur...
In this question, I asked about breaking a dataset into subsets, and got a good response. Now I have the opposite problem. I've got two different datasets, representing objects of two different subclasses of a common ancestor, and I need to have the same TDBLookupComboBox search both of them at the same time, using two properties, ID #...
Hi, I need a solution to export a dataset to an excel file without any asp code (HttpResonpsne...) but i did not find a good example to do this... Best thanks in advance ...
OK, It sounds like piece of cake, but please accept my ignorance and help me with this. I have this: If String.IsNullOrEmpty(editTransactionRow.pay_id.ToString()) = False Then stTransactionPaymentID = editTransactionRow.pay_id 'Check for null value End If Now, when editTransactionRow.pay_id is Null vb thhrows an exce...
Hello, During development of client-server system using .NET Remoting (.NET 2.0) for communications I found extremely weird behavior if my remoting objects return custom datasets. For some reason it takes from 0.5 to 4 seconds for remoting infrastructure to process an empty dataset instance on the client side, if I'm using TCP channel w...
Hi, I have a SSRS report and using PL/SQL for the dataset creation. My report needs two tables 1 one gives detailed view.(dataset 1) 2 one below that gives a summary table (data should come from the calculations based on the data in 1 table) I am using a temporary table for the dataset one. What are the methods to get calculated ...
I am looking for some large public datasets, in particular: Large sample web server logs that have been anonymized. Datasets used for database performance benchmarking. Any other links to large public datasets would be appreciated. I already know about Amazon's public datasets at: http://aws.amazon.com/publicdatasets/ ...