I have access to a database table that has been added as a datasource in project (A). Is there any way to refer to this database table from project (B) WITHOUT adding it to project (B)'s datasource? i.e. ProjB.databasetable.GetDataSetSchema Any ideas would be really appreciated. Thanks guys! ...
Scenario I have a c# winforms application with a gridview. The gridview datasource is populated by a dataset. The contents of this dataset get updated every few seconds, and there are not always the same number of items in the dataset etc. The dataset actually gets populated (or needs to get populated) by multiple other datasets being p...
Having deployed a new build of an ASP.NET site in a production environment, I am logging dozens of data errors every second, almost always with the error "Cannot find table 0." We use datasets and frequently refer to Table[0], and while I understand the defensive coding practice of checking the dataset for tables before accessing Table[...
I am using VFPOLEDB driver to read DBF files and I keep getting this error and I am not sure why and how to fix the problem: The provider could not determine the Decimal value. For example, the row was just created, the default for the Decimal column was not available, and the consumer had not yet set a new Decimal value. Here is the c...
Hi, I am building an occasionally-connected WinForms application and have been following link text tutorial. When using a datasheet to edit data, as the tutorial has me do, everything works fine. If, however, I bind the data to other controls on my form, the data is not saved. For example, I am tracking StaffID, FName, and LName. ...
Hello! I have a small/big problem... I'm tring to bind some comboboxes, datagridview and bindingnavigator. My situation: I load all table and data from different tables into ONE DataSet! Let's say there are tables "MAIN_TABLE" and "COMBO_TABLE". then I'm doing this: DataViewManager dsView = dataSet.DefaultViewManager; ...
I have an MDB file created with Microsoft Access 2007. I would like to read the 10 tables from that file. I would like to avoid multiple trips to the database so I would like to get all the data into memory when the for loads. And I will commit any changes when the form is closed. Can I create 1 DataSet and fill it up with all 10 tab...
I'm a complete newbie to VB.NET, how can I test if a dataset has rows? I'm trying to see if my sql procedure call managed to fill up my dataset. Also, is there an easy way to print the rows to a label? ...
Ok so I'm trying to use the JavaScriptSerializer to work with this code. However it crashes when it reaches the last line; Dim json As New String(sr.Serialize(dt)) I get this error message; A circular reference was detected while serializing an object of type 'System.Reflection.Module'. I would really appreciate any insights...
I need to refresh dbgrid constantly, in real time. Close and open dataset works fine, but blink the dbgrid. What can I do to avoid this? I'd like a solution like Ajax, that update only the necessary. Thanks ...
I'm currently using a technique I found while poking around the interwebs for flipping a datagrid's orientation in C# for a SharePoint web part. It's working correctly, pulling data from a SQL Server 2005 database and displaying it in the datagrid. I'd like to know if there is a simple way to change the column names, either using an exte...
Hi. Is there any faster way to iterate through an ADO Dataset than while (not ADOQuery1.Eof) do begin /* Do something */ ADOQuery1.Next; end; I need to scan a dataset of around 9000 items and only extract records matching a pre-defined set of branch numbers. Thanks, Pieter. ...
hi, I'm using the stackoverflow dataset, I would like to know if I should convert the dataset from xml to mysql to improve the retrieval performances and work more efficiently. If it is better to convert to mysql, can you suggest conversion tools (I'm on a mac) thanks ...
Scenerio: I want to add a calculated field to given (any) dataset during runtime. I don't know any other way to obtain a dataset structure other than performing DataSet.Open method. But the Open method causes that atleast one row of a data needs to be transfered from server to client. Then I need to close the DataSet, add field and reo...
I load 10 tables from an ACCESS 2007 file database. IS their a way I can get the column names into the dataset or do I have to rename each column? I am using Visual Studio 2008 in VB.NET. I would like to reference the columns in the code by the name and not have to use an index I just went ahead and added the following code for eac...
I need to save the DataSet, results of a reporting app, to a table in SQL Server 2000. Do I save the datasets the same way I would store files in the DB, via Byte Array()? ...
This is the code: Dim dr() As DataRow = DataSet.Tables("TableName").Select("EVENTNAME = '" & name & "'") I get an "Object reference not set to an instance of an object." Error when this line is executed. It is looping through a list of selected items in a listbox. I think it has to do with how I have the datarow declared because I c...
Hi, I need to filter the results I obtain when I load my xml file. For example I need to search the xml data for items with keyword "Chemistry" for example. The below xml example is a summary of my xml file. The data is loaded in a gridview. Could you help? Thanks! Xml File (summary): <CONTRACTS> <CONTRACT> <CONTRA...
Is it a good idea to re-use a dataset in .net? What I mean is...I have the following code which loops a gridview For Each row in GridView ds = New DataSet ds.ReadXML(GetStream(row.Field)) ... export the dataset Next What I am doing in the loop is creating a new instance of the DataSet. Can't I just call ds.Clear() and then reuse...
What is the easiest way to apply to database changes to the structure (not the data) made to DataSet? Do I need stuff like DataAdaptors? Is it possible to use in this way the DataSet that I configured via Visual Studio wizards? How to access such a DataSet? ...