NikkiZ's Q&A profile

• .NET Development Inserting large amount of rows using ADO.NET

  Hi , I have a requirement to read rows from Table A on Server A and insert into Table B on Server B. Unfortunatley, Server A and B are not linked , so i can't use a Insert SQL to do the inserts. I am thinking of reading rows from Table A and inserting into Table B using ADO.NET. My question is : 1) Is there a way in ADO.NET 1.1 to do bulk inserts The insert will be done by a stored procedure , but I don't want this Stored proc to be called for every row in the datatable. 2) In case I do have to call the Insert Stored Proc for each row in the table, will it be efficient enough for a datable with say 1 million rows 3) Is there ...Show All

• Windows Forms Making my form visible to other classes

  Hi, Im writing a program in managed c++ in which there is a class called "World" and a form "Form1" amongst other things. I would like 'World' to have a pointer to my form so it could access properties in that form. So I have declared a static data member in World.h of type Form1 which required me to make a forward declaration of Form1 in World.h. However when my form is created and it tries to pass a reference to itself back to World to hold in the static data member I get the error "cannot convert from 'testproject3::Form1 ^const ' to 'Form1 ^' " Trying another approach I changed the type of the pointer in 'World' to 'Form' and ...Show All

• Smart Device Development registering an activeX control

  hi guys, i want 2 register an activex control with windows mobile 5.0 ,. For the desktop thing we have regsvr32. is there any command specific to that, thanx in advance regards .netguy Hi You can use the regsvrce.exe for registering. Select the proper regsvrce.exe according to the device you are using. like (ARM,MIPS,etc.,) ...Show All

• Visual Studio Tools for Office Using user properties in Find method

  Hello all, I want to filter the appointment items collection with the Find or Restrict methods. But when I use these methods by filtering the collection on a "test" user property and set the IncludeRecurrences property to true and sort the collection by the [Start] property, no appointments are returned. If I don't set the IncludeRecurrences property to true and don't sort the collection by the [Start] property, many appointments are returned. Why My code is as following : List<Outlook.AppointmentItem> results = new List<Outlook.AppointmentItem>(); Outlook.Items items = Globals.ThisApplication.Session.GetDefaultFolder(O ...Show All

• Windows Forms CallBack in GridView

  Hello: I am in the process of extending GridView and adding some functionalities. For example, I added a single row click to postback and handle the event. I would like now to be able to do a CallBack instead of PostBack. Do you know if there is a whitepaper on how that CallBack functionality is added to the Grid currently through sorting and paging I believe it is better to follow the same technique used. I have been trying for some time, im getting all the needed methods and functions, and I have added for example: Grid1.EditIndex = e.GridViewRow.RowIndex; inside the handler of the sinlge click which is being fired upon a ...Show All

• SQL Server Calculate Median Value

  I am converting a report created using Crystal Reports 10 to Reporting Services.  The report contains a list of items with dollar values.  The original report displays both the Average and Median value.  I can easily ( using avg(Field1.Value!) ) determine the average but cannot find a function to determine the median. How can I add the Median to the report   Thanks in advance, Greg Thanks very much for that, I managed to get it working. However I was actually trying to get it to work for a graph - any idea where I would place the “ =Count(Code.addToMedianArray(Fields!Total ...Show All

• .NET Development Noob question - why is my remote function call not working?

  OK, I've just started working with .Net remoting. I've made a couple of test scenarios which have worked where I can call a MessageBox from another application domain. (although I can't seem to get an HTTP connection request to work, but that's another question) I'm trying to set up a server-side user settings table which will (amongst other things) set up a client-side DataGridView with user-specific customizable columns. My remote call right now is simply initializing a class on the server and passing it as a return value to the client. I'm getting a 'SerializationException was unhandled' 'Unable to find assembly' error when the serv ...Show All

• Smart Device Development HELP

  My opetrting system is windows2000 professional sp4, when I run DEVICE EMULATOR PREVIEW,  it shows "Failed to open XML parser COM object. PPC-2003-Square\PocketPC-2003-Square_Skin.xml". What can I do now Shall I download other softwares Thanks alot   It appears to me that your system doesn't has SAX XML parser. Can you please try installing it from  http://msdn.microsoft.com/downloads/default.asp URL=/code/topic.asp URL=/msdn-files/028/000/072/topic.xml Hope this will work. -Thanks, Mohit ...Show All

• SQL Server How to Pass parameters in SSIS dataflow

  I am using a parameterized select query as displayed below to fetch values from source. SELECT A.Account_GUID, M.Merchant_GUID, H.Household_GUID, B.BankAU_GUID, SR.SalesRep_GUID, E.Entitlement_GUID, I.Income_GUID, Exp.Expense_GUID, SP.Sales_Product_GUID, P.Product_cd, SUM(S.Sales) AS Monthly_gross_MC_VI_amt, SUM(S.Sales) - SUM(S.[Returns]) AS Monthly_net_MC_VI_amt, SUM(S.SaleTxns) AS Monthly_gross_MC_VI_tran_cnt, SUM(S.SaleTxns) - SUM(S.ReturnTxns) AS Monthly_net_MC_VI_tran_cnt FROM Account AS A LEFT OUTER JOIN dbKAIExtract.dbo.tblSales_STG AS S ON A.Account_No = S.AccountNo And S.BucketNo = And S. ...Show All

• Software Development for Windows Vista DependentUpon missing in VS2K5 Extensions beta 2

  Hi, I've installed Visual Studio 2005 Extensions for Windows Workflow Foundation (beta 2) and I have a problem when I add "Sequential Workflow (with code separation)" to a "Sequential Workflow Console Application" project. After adding the item to the project two files appear in the VS Solution Explorer: Workflow.xoml as Workflow.xoml.cs. But the problem is that they aren't related. The .xoml.cs isn’t under the .xoml. I can edit the workflow in the designer, I even can add activities to the workflow but when I try to add a Code activity and try to set the ExecuteCode property the method isn't created in the .xoml ...Show All

• Visual Studio ValueProvider for the first selected Item in a project?

  I am trying to derive a string from the currently selected item in a project. e.g. - I have a file called "MyData.xsd" selected in the project. I would like to be able to get a handle on that item from a ValueProvider so I can get the name of it. I see the CurrentSelectedProject ValueProvider but have not been able to find anything for CurrentSelectedItem. my first instinct was to inspect the Properties collection on the Project, but I didn't see anything useful for this situation there. Is there already a ValueProvider that will get me that Item If not, are there any suggestions/hints as to how I might access it within ...Show All

• Visual Basic Finding length of structured data

  I am trying to convert a VB.6 program to VB .Net 2005. The program reads up fixed length records from a file and does stuff with them. The code to read the file and load up a combobox looks something like this (sorry about the double-spacing ... don't know how to avoid it): fPayees = FreeFile FileOpen(fPayees, gMasterPayeeDatabaseFile, OpenMode.Random, , , Len(PayeeData)) i = Len(HistoryItem) i = LOF(fPayees) j = Len(PayeeData) intTotPayeeRecs = LOF(fPayees) / Len(PayeeData) For j = 1 To intTotPayeeRecs ' Display all payees in payee database FileGet(fPayees, PayeeData, j) cboPayee.Items.Add( ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Simple (Beginners) Explanation DXInput needed please.

  Dead all, I'm wanting to read a joystick using DX and VB (using VS2005). Most tutorials (Sample browser, etc) seem to be in C# or C++, and I'm wanting to write my app in VB. Can anybody explain to me how it is done... As far as I'm reading, you need to have a GUID for a joystick, as there are so many around there, I can tell the differece with it's ID so to speak Now the the joystick I'm wanting to read, doesn't have an x or y or z, all it has is fire buttons, 20 of them to be presise, it is the controller that comes with the PS2 Game "Buzz", and with it being USB it works on a PC. Can anybody help m ...Show All

• Architecture Dependency between Business and DAL - Problems with unit testing

  We just started to reorganize our code and are separating the DAL from the Business. We have also started playing with unit testing, but we've come up with a few problems. 1) Unit testing the DAL. Yes, we've noticed that this is not a trivial task, and are looking at using the com+ / service enterprise approch. The quuestion is: Are there any help for adding rollback option built into the Team Systems 2) Unit testing the Business. Quite a few of our business class depends quite heavily on the data access layer. The problem occurs when we create an instance of a business class, it requires a lot of DAL access. Typically today this acces ...Show All

• Visual Studio Team System Changing Drop Location in team build

  Hi, We have developers at two different sites.   Is it possible to have a single team build type that we can run on build machines at each site using a drop location local to the site Dean Yes, you are right.  In Beta 3 we were redundantly passing the DropLocation. We fixed this sometime after Beta 3 and since I tried on my dev box which has latest build installed, it worked.  Sorry about it.  You will be able to use above approach in RTM. For Beta 3, you can workaround this by overriding BeforeEndToEndIteration target.  Add the following code (instead of the above one) in TFSB ...Show All