David Ray's Q&A profile

• Windows Forms How to call custom action on button click

  Hi guys, I have an MSI file and I have a UI form inside of it that has all the standard buttons on it – Cancel, Next and Previous. What I need to do is to execute custom action on a click event of one of these buttons. As I understand I could do it creating event on DoAction in ControlEvent table of the MSI database with the Orca. So far it is pretty clear. But what I cannot find is how I could execute action that is inside of the .NET assembly or .NET assembly compiled as an installer class (basically same custom action that .NET using to execute when I build installation in Visual Studio .NET). I have loaded binary content of the .NET assembly into the Binary table, but I do not see how I could call any specific method inside ...Show All

• SQL Server Please help with partitions!!

  Hi everyone, Primary platform is sql25k 32-bit. I'm trying to move data from one partition to a table I am not able at all. Find attached the full script for that: CREATE PARTITION FUNCTION rangoAnualFP ( datetime ) AS RANGE LEFT FOR VALUES ( '200301' , '200401' , '200501' , '200601' ); CREATE PARTITION SCHEME rangoAnualFE AS PARTITION rangoAnualFP TO ( PRIMERO , SEGUNDO , TERCERO , CUARTO , QUINTO ) --Where PRIMERO, SEGUNDO and so on are FILEGROUPS, of course.. -- SOURCE TABLE CREATE TABLE [dbo] . [DatosMensuales] ( [Id] [int] NOT NULL, [Concepto] [varchar] ( 50 ) NULL, [FechaAlta] [datetime] NOT NULL ) ON [rangoAnu ...Show All

• Smart Device Development ICon in start emnu bar

  Hey all, I am writing my 1st live applicaiton. I need a quickly accessible icon to change the brightness on my WM5 device I would liek to put an icon in the "Start" menu bar similar to the Spekaer icon with a slider that will adjust the brightness. Unfortunatly I cant find any way to do this. I am also an extreme noob in VB programming. Any help woudl be appreciated. j ...Show All

• SQL Server Cannot find an item in a big table

  Hello people, I have a table of 30,000 records on my handheld which runs windows 4.2 and sql me. When the item I am searching for is at the top of the table, the search finds it easily. When the item is in the middle or lower, it doesnt find it. I am not running out of memory and my database is on the local memory. Here is my code: String query = "SELECT * FROM Products WHERE Barcode = " + TheReaderData.Text; DataSet ds = GetDescription(query); label2.Text = TheReaderData.Text; label1.Text = "No description" ; if (ds.Tables[0].Rows.Count != 0) { label2.Text = (ds.Tables[0].Rows[0].ItemArray[0]).ToString(); label1.Text = (ds.Tables[0].Rows[0].ItemArray[1]).ToString(); } -- ...Show All

• Visual Studio Express Editions Getting my applications startup path

  Is there anyway to find out what directory my application is running out of I usually program in VB.net 2003 and use it's 'Application.StartupPath' but I can't find anything similar to it in C#   Thanks for the help ! By default a windows application is based mainly on forms and so contains a reference to the System.Windows.Forms namespace. A new XNA based application does not have this reference, adding it will make the forms namespace availible which contains the Application.StartupPath variable ;) adding this reference also opens up the ability to use things like message boxes too ;) ...Show All

• Visual Studio Express Editions timer question...

  In VB6 I use the following code to automatically "push" a button every 2 seconds an display the result in a Msg box Private Sub Command1_Click () MsgBox "My Text" End Sub Private Sub Timer1_Timer () Call Command1_Click End Sub How do I do this in VB Express Kind regards, Herman Private Sub Button1_Click ( ByVal sender As System .Object, ByVal e As System . EventArgs ) Handles Button1 . Click MessageBox . Show ( "my text" ) End Sub Private Sub Timer1_Tick ( ByVal sender As System .Object, ByVal e As System . EventArgs ) Handles Timer1 . Tick But ...Show All

• Internet Explorer Development Tool button c# DLL

  I am having trouble getting a toolbar button placed in the standard toolbar to execute something in a DLL written in c# The button turns up on the toolbar but nothing happens when I click it I think i have followed the msdn toolbar button tutorial to the letter Any help would be appreciated using System; using System.Collections.Generic; using System.Reflection; using System.Runtime.InteropServices; using System.Text; using System.Windows.Forms; using Microsoft.Win32; namespace HypodyneThumbNailer { public class Cows: IOleCommandTarget { public void QueryStatus( ref Guid pguidCmdGroup, UInt32 cCmds, [MarshalAs(UnmanagedType.LPArray, SizeParamIndex = 1)] OLECMD prgCmds, ref OLECMDTEXT pCmdText) ...Show All

• SQL Server How to support multiple language(Latin,chinese,japanese,korea) in one report when exporting to PDF format

  We should support multiple language(Latin,chinese,japanese,korea) in one report when exporting to PDF format in reporting service. We have used Arial Unicode as our font. But when we exported the report, the korean language item can not be displayed. Any idea on that Thanks a lot. ...Show All

• SQL Server SSIS SCRIPT COMPONENT

  Hello, My SSIS design: Source OLE DB -> Script Component -> Destination OLE DB I have a script component that reads and proceeds each row in input. But I have no rows in output. How can you explain that with the viewer, I see the rows in input but in output, I have nothing after the script. The script function: read the value of the ROW.column and flag like this : ROW.columnout = TRUE (columnout is added in output columns) What should I define at the component to retrieve the rows after the script component Thanks ! This sounds like it should work. Find some examples of this working and try and work out what the difference is. There's loads of stuff out on the web (including on my blog). You should make sure that your compo ...Show All

• SQL Server Simple Yes/No Question Regarding Inferences

  I was looking up information regarding SQL when I came across this on a website ( http://www.dbpd.com/vault/9801xtra.htm ): 19. Redundancy is good. Provide as much information as possible in the WHERE clause. For example, if the WHERE clause is WHERE COL1 = COL2 and COL1 = 10, the optimizer will infer that COL2 =10. But if the WHERE clause is WHERE COL1 = COL2 and COL2 = COL3, then optimizer will not infer that COL1 = COL3. Is this true for SQL Server Thanks - Jason "DiZASTiX" DiZASTiX wrote: In Re Adamus: All birds have wings. All flies have wings. ================================= Therefore all birds are flies. <--Logically true but disturbing. The ...Show All

• Visual C# Bound Object Frame Counterpart

  Is there a counterpart for the Bound Object Frame control that exists in MS access in C# ...Show All

• SQL Server Sum Buildin function is not considering negative numbers!

  Hi! i am using the SUM buildin function of AS2005. it is not considering the negative numbers. There are some settings am I forgetting I am just adding, under measures, a new measure with aggrergateFunction=SUM and the database field "AMOUNT". In the db the amount is negative as well.... Thx mcrisf Did you copy the data from an Oracle db using an Oracle ODBC driver I have experienced cases where the sign bit in SQL Server was not set correctly when the data was loaded. The Query Analyzer recognized the negative values but Analysis Services did not. Please see the following link if this could be your case: http://groups.google.co.uk/group/microsoft.public.sqlserver.serv ...Show All

• Visual C++ Interaction with an application running in CMD

  Hi all, I have written code for an appliation which needs to interact with another application which runs in CMD. I want to receive all the information produced by the application running in CMD so that I can manipulate them and at the same time I should be able to provide input to that application. Please suggest me somehting regarding this. Thanks, You can use the RedirectStandardOutput and RedirectStandardInput properties to obtain the output of the console program as well as send input. There are several restrictions on redirecting the standard output stream: - The app has to use standard "DOS" output, not use the Bios or write directly to the video buffer. If the output is the standard light-gray on black background, ...Show All

• Smart Device Development HELP - Signature Capture - Windows Mobile 5.0 - CF 2.0

  Hi all - I am in desperate need of a Windows Mobile 5 example of signature capture. I have found some examples but all are in VS 2003 and the 1.0 CF. If anyone knows of an updated example for the new Windows Mobile 5 - VS 2005 - CF 2 it would save my day - week. Our needs are to capture a signature on a device - store it in sql anywhere on the device until it can be transfered to a server baised SQL database via doking or wifi. Thanks Jim Resco makes a control for the Compact Framework to capture signatures. http://www.resco.net/developer/mobileformstoolkit/default.asp ...Show All

• SQL Server Allowing remote connections during setup?

  Is there a way to automatically setup SQL Server Express to allow remote connections during the installation process We are deploying SQL Server Express with our application and I really can't ask SMB customers to go through a series of rather complicated steps after our "turn key" setup installs everything in order for any of the other computers in their office to connect. What's the reasoning behind that, anyway Why create a database server setup which by default doesn't allow anyone except the server to access it I guess that makes sense for ASP.NET but the web fad isn't the only platform developers use these days. Any assistance would be greatly appreciated. Cheers, Evan Eva ...Show All