Recent content by SHelton

Found a solution, for anyone that is interested read this: http://technicalsupport.businessobjects.com/KanisaSupportSite/search.do?cmd=displayKC&docType=kc&externalId=5452225&sliceId=&dialogID=19090947&stateId=1%200%2019098001

Using CRXI in C# (VS2005), Vista Home Premium, SQL2000. I have a very basic report with 2 parameters - if I run the report in CRXI I get prompted for the parameters and the report shows the correct data. Viewing the query in SQL Profiler shows the correct WHERE statement. However, if I open...

Hey Rick, I'm running the Beta 2 of Orcas and can't see a way to selectively show checkboxes on nodes in a TreeView (Windows Forms). Can you point me in the right direction ?

In my opinion (which may differ from others!): 1. You don't design the software on the PPC, use Visual Studio 2005 (you may need Professional edition). 2. You can use web services if you want to pass data from a PPC to a central database and vice-versa. If you are passing data while synched...

ShowCheckBox is a property of the System.Web.UI.WebControls.TreeNode object. I think that you are using the Windows Forms TreeNode, which does not have a ShowCheckBox property. In a Windows Forms TreeView, you can have either all check boxes showing or none at all, not a mixture. The only way...

Very quick examples, please excuse any slack coding! Both assume that the distinct column in the source datatable is called DistinctCol and is of an integer type. Example 1 (CellValidating event) Private Sub DataGridView1_CellValidating(ByVal sender As System.Object, ByVal e As...

One of two ways I can think of: 1. Use the CellValidating event for the key column and check if the value already exists. This prevents the user trying to enter a duplicate. 2. Use DataView.ToTable when the user clicks the save button. This has a overload that returns a datatable...

Just set the DataSource, ValueMember and DisplayMember properties of the combo column to a DataTable populated from the Access table. Make sure that the ValueMember matches the underlying DataGridView datasource column so that a change in the combo is correctly applied to the grid datasource.

Thanks for the help guys. I'm going to look at a stored procedure which uses temp tables. I can call it asynchronously from the app which will allow the user to carry on doing other stuff while the copy is carried out.

Thanks for the quick reply gmmatros. But..... If a row in TableA has 15 related rows in TableB, when I use Insert Into...Select for TableA how will I know what the primary key (which is an identity column) is to be able to insert the TableB rows with the correct foreign key ?

Can anyone suggest a decent strategy for copying (potentially) large amounts of data into the same tables in a database ? To explain, I have a database which holds estimate details in a number of related tables. The client would like a facility to copy an estimate, creating a clean version...

The easist and quickest way is to not bother loading the data at all. You can do this with a SqlCommand object using DELETE FROM tblUser as the CommandText.

ca8msm is right, ProcessorCount returns 2 on my dual core machine, and 4 on a dual processor (each a dual core) server.

If the two databases have tables with the same schema, you can load an empty DataSet from db2, then merge in a populated DataSet from db1. You can then update the DataSet to db2.

Surely this is easier ? For Each t As TreeNode In TreeView1.Nodes t.Nodes.Clear() Next