Hi, I'm fixing a C++ Builder 5 application and I have this code: void __fastcall TFPrincipal::DBGModuleStartDrag(TObject *Sender, TDragObject *&DragObject) { m_pParentNodesDragDrop = NULL; DragObject = NULL; bool bAbort = false; m_ListaModulosDragDrop->Clear(); m_ListaContenedoresDragDrop->Clear(); CInfoNode *pInfoN...
We use calculated columns in a few SQL Server 2005 tables which always return data of a specific type (bit, varchar(50), etc...). These tables are consumed by a .NET data layer using strongly-typed datasets and tableadapters, however since the calculated columns are not constrained to a specific type (we always return a specific type, b...
Hey everyone, This is driving me insane. I am trying to get a basic Report to show with Report Viewer but cant get the DataSet to show in the Website Data Source window no matter what I do. I created a dataset..picked the proc I want, etc. without any problems. I added my RDLC and tried adding a table that I can bind data to but the Wi...
I am trying a "very" simple task to output values of each rows from a dataset : $Data = '' for($i=0;$i -le $ds.Tables[1].Rows.Count;$i++) { write-host 'value is : '+$i+' '+$ds.Tables[1].Rows[$i][0] } OUTPUT : value is : +0+ +System.Data.DataSet.Tables[1].Rows[0][0] value is : +1+ +System.Data.DataSet.Tables[1].Rows[1][0] value i...
As part of a system which I am developing I need a method of taking a set of class definitions which define an object model and constructing a dataset from them which can then be populated by instantiating instances of the classes (either singletons or through collections for multiple table rows). The kind of approach I had in mind woul...
Hello all, I have a strongly typed DataTable created with the VS2005/VS2008 DataSet designer. The table has a Primary Key column that is a guid, which gets populated by SQL server. The problem is when I want add a row (or multiple rows) to my DataTable and then call the DataAdapter.Update method (passing in the DataTable). When DataA...
Hi, I am using asp.net and i would like to define the elements of a dataset in my html code. The problem is when i attempt to use: <%@Using namespace="System.Data" %> this is giving me an error also I am using foreach (DataRow row in ds.Tables[0].Rows) {.....} DataSet ds is obtained from an sql query. I don't believe...
Hi, I have a news portal. For this portal I have a database with a "News" table and with the following columns (NewsID, CategoryID, NewsTitle, NewsText, DateAdded, ImagePath, TotalRead, NewsType, isActive) I use dataset files (.xsd) and for this one, I have a query that returns the last 3 days' news into a custom class that I coded, ...
I am creating as stored procedure that brings back a bunch of data that I need from multiple tables, however the tables share some duplicate column names. It works fine in SQL but I am wondering what will happen and how I will differentiate between them once I am accessing them as DataRows from a DataSet. Anyone know? ...
Hi, This is my problem: I need to store a lot of log messages and thought it would be smart to keep it in a SQLite3 database to be able to search and filter it easily. I will display the log messages in a standard list widget (using wxWidgets). The list will have several columns and can be sorted and filtered by the user. Now, I'm not...
Which is recommended while (reader.Read()) { table.Rows.Add( new object[] { reader[0], reader[1], reader[2], reader[3] } ); table.AcceptChanges(); } or while (reader.Read()) { table.Rows.Add( new object[] { reader[0], reader[1], reader[2], reader[3] } ); } table.AcceptChanges(); ...
I am preparing a crystal report for library system... two tables.. 1)BookIssueDetail: fields : grno ,bookno,issuedat 2)studentMaster fileds: grno,stdename,(and lots more)..only these filed are req to display... now i have made a dataset : "bookissuedataset" which have two table which are assign above. these is my code on print butt...
What would be the best way, in delphi, to create and store data which will often be searched on and modified? Basically, I would like to write a function that searches an existing database for telephone numbers and keeps track of how many times each telephone number has been used, the first date used, and the latest date used. The data...
I'd like to do a subtraction of sets based on criteria. A pseudo-query would look like: select table1.columnn1 ,table1.column2 from table1, table2 where (table1.column1.value1 not in table2.column1 and table1.column2.value2 not in table2.column2) I can make it to about here: dim list = From tbl1 In table1 Whe...
I use Delphi 7 + Zeos + MySQL, and I got a problem when I try to post Master table, the Details datasets are posted first, raising a referencial integrity exception in data base, 'couse details tables needs the ID of the Master table. Can I revert this behavior? Can I persist the master table before the details? ...
I'm dynamically adding a Boolean column to a DataSet. The DataSet's table is the DataSource for a GridView, which AutoGenerates the columns. Issue: The checkboxes for this dynamically generated column are all disabled. How can I enable them? ds.Tables["Transactions"].Columns.Add("Retry", typeof(System.Boolean)); ds.Tables["Transactions...
So, I have a situation where I need to pass in three values into a serial BlockingQueue queue: (SelectableChannel, ComponentSocketBasis, Integer). They don't actually need to be hash mapped at all, and to use a HashMap is ridiculous as there will always be only one key for each entry; it'd be fine if they were just in some sort of o...
I assume I have to do this via a DataSet, but it doesn't like my syntax. I have an XMLDocument called "XmlDocument xmlAPDP". I want it in a DataTable called "DataTable dtAPDP". I also have a DataSet called "DataSet dsAPDP". - if I do DataSet dsAPDP.ReadXML(xmlAPDP) it doesn't like that because ReadXML wants a string, I assume a file...
Hi, I need to export a large amount of data (~100mb) from a sql table to a user via the web. What would be the best solution for doing so? One thought was to export the data to a folder on the db server, compress it (by some means) and then provide a download link for the user. Any other methods for doing so? Also, can we compress data...
We are currently havin a discussion if dataset should go in the data or business layer? My friend thinks all ADO.NET components should go in data layer. For me this does not seem right for the followin reasons: If you create a fat Data Layer Client, it will be much more difficult to for example migrate everything to a different dat...