hi there, I have this C# code. j = myAccountDataset.Tables["AccountsTables"].Rows.Count; for (i = 0; i <= (j - 1); i++ ) { listAccountList.Items.Add(myAccountDataset.Tables[0].Rows[i][1]); } this.listAccountList.SelectedIndex = 0; the idea is to ite...
Hi, I have a dynamic query which returns a DataTable. This DataTable will contain a varying number of columns depending on the selection used in the query. I want an efficient way of filtering the records in the DataTable. For Example The DataTable contains columns : A, B, C and D I need to query this data at serveral points in my ...
I have set up a class as a facade to access the session variables for my app. In this app I store an entire dataset for a particular employer as a session variable. Within one of the sub pages I have a button that adds a row to an existing table stored in that dataset. Dim curRow As Data.DataRow = mySession.tWorksiteOtherMeasures....
I am working on a web application that is consuming a Dataset returned by a web service. As the application is running I store that Dataset as a session variable to be used over and over again as the user navigates to the different pages that will edit the tables within the dataset. The idea was the user will only have to wait for t...
I am unable to fill a typed dataset Using reader as New StringReader(My.Resources.sampledata) typedDataset.ReadXML(reader) 'typedDataset.WriteXML("c:\data.xml") End Using The above does not work. If I enable the commented line to write the results to file I get a 1K file with <?xml version="1.0" standalone="yes"?> <testSchema xml...
Using c#, vs2008. Howdy, I have a slq server table that has a primary key column that is auto incrementing when new record is added. I am loading a dataset with sqlAdaptor.select sql statement, created with query editor and auto generate update and insert using the wizard. I need advice. When i have loaded dataset with select stateme...
I want to get a list of all available datasets (that I'd creat in my Asp.net project) After that I want to select a Dataet from the list and get The list of Available DataTable included in that Dataset. Finally I should b able to check all Data Tables Fields How To Do This ? Note that I know VS already has a dataset Panel but that...
I'am filling tables in .net DataSet with data. There is a nested relation between the tables, so the exported XML (by using GetXml() method) is nested (the child rows are becoming child nodes). I 'am sending this XML to a conversion module that converts the XML from the DataSet schema (I' am using the dataset XSD file) to other schema b...
I have seen blogs and people saying Returning dataset/datatable from an ajax enabled wcf service is a bad idea.... I have gone through this Scott Hanselman's blog about datasets fr0m wcf... So what is the alternative for dataset returned form ajax enabled wcf service? ...
I am building a demo dataset for my webapp. I would like thousands of "real looking" names. They should not be names of famous people or fiction heroes or names that will evoke associations. They should all have various and different sounding but realistic male and female names and surnames. Birth dates and other data can be randomly ge...
Hi, I have a DataTable that contains 2000 records. How would you retrieve the first 100 records in the DataTable? ...
I have a parent table and child table and I would want to insert into them using a dataset/datatable/dataadapter combination. Inside the SQL Server database the parent table is declared with a primary key, and the child table with a foreign key -- the primary of the parent. One entry in the parent table could potentially have 0->n entrie...
Hello, I want to change the field title to integer max value 21......... not 200 chars only. When I change the value 200 of Size and confirm OK button a 2nd Dataset1.designer file is created and I get a lot of duplicate variable errors... I already changed the value in the designer and saved everything ok, but when I check again the ...
When I open DataSet in Visual Studio 2008 to design or modify it, it always take a very long time (more than five minutes) before I can continue to do my job. While I'm waiting I can't do anything on Visual Studio, moreover CPU and memory usage is growth dramatically. I want to know, Is it has anyway to reduce this waiting time? Hardwa...
Hi all, Im having trouble with some javascript in the onFetch step of a dataset in a BIRT report. I've added logging in the initialise step of the report in a few different ways. The runtime im using is Tivoli Common Reporting, and they supply a logging framework. Its initialised as so reportContext.setPersistentGlobalVariable("logfil...
Hello :) I've got a little problem with a query which I create in the Visual Studio Designer. I need a query with a lot of 'OR'-clauses for the same column. I found the operator 'IN', but I don't know how to use that in the Visual Studio Designer: Example IN: SELECT EmployeeID, FirstName, LastName, HireDate, City FROM Employees WHER...
Hello everyone, I am using Microsoft Search Server 2008 + C# + .Net 3.5 + VSTS 2008 + ASP.Net to develop a web application which invokes Search Server 2008 Web Services when a button in the html page is pressed. I am using the following code to query content from Microsoft Search Server 2008. My question is how to display the search re...
here's my code. I have a dataset that has its values and then i run an independent query which uses the same tables as dataset. now when i run the dataset, i want it to get a where condition on the query result. here's the code - sql = "SELECT ID, name FROM books WITH(NOLOCK) WHERE id =" & Session("ID") ds = FillDataset(sql) ...
What is the best way to represent the following data for subsequent parallel computations: A set of quadruples (approximately 20,000,000) of integers that need to be acessible by the first three elements of a quadruple as indexes? The computation is supposed to be done with MPI in C/C++. UPD: I should also emphasize that I have two si...
My solution architects and I have exhausted both pure Dataset and Datareader solutions. Basically we have a Microsoft.NET 2.0 windows service application that pulls data based on a query and processes additional tasks per record; almost a poor mans workflow system. The recordsets are broader (in terms of the columns) and deeper (in terms...