Fire3.san's Q&A profile

• SQL Server Same effect as Cross Join?

  How can I achieve the same effect as a cross join (since the merge operator doesn't have a cross join) Situation is this... a flat file has some header and footer information that I need to keep and attach to each row. So for simplicity sake of an example lets just say header has only 1 thing we care about - a row that says DATE=01/01/06. I take the file and run a split to split into "Date" "Data" and "other" (other has all the throwaway rows in header and footer I don't care about). Then I use a derived column object to get all the columns out of the "Data". Finally I want to add that Date metadata back to every row in the data... I thought this would be an easy thing to do.. but I can't s ...Show All

• Visual Studio Tools for Office vsto - .Net framework 2 security - publisher certificate as avidance

  Hello, I cannot find the way to implement certificate as security for my vsto word application. how can i do that references thanks Hilla i will make myself more clear - i need a security mothod that i can set once on installation - and then be able to use on vsto documents which are not present during this initial installation. (the dll's of the documents are not present when setting the security ). so as far as i could see publisher certificate is my only option. please correct me if i am wrong. so i tried creating a test certifiace using "makecert" and binding it to the dll using "signcode" - which opens a wizard. the binding seemed to be fine + i set ...Show All

• Visual Basic Using third party DLL files

  I have been supplied a third party DLL written and tested under for VB 5. Its function is to extend modbus to be able to use chars and longs. I would like to make use of the functions it contains under the VB.NET 2005. I have the standard version. Could someone explain how to make calls or incorporate it within this environment please. Thank you in advance Hi and thanks for the reply. Since posting I have been doing a little more research and you are right I can do it by sending out via the Modbus commands. The part I was trying to avoid was splitting the longs to send to the relevant location. If it is Modbus you are interested in I am using the Sapia product www.sapia-inc.com ...Show All

• Visual Basic In the registery?

  I have written a program that requires a password to be created when it is first run, this is then encrypted and stored on the computer C:/Test.txt . the next time the program is run you enter your password, which is encrypted and compared against the encrypted password on file, and if they match you can use the program. I don't think storing the encrypted password as C:/Test.txt is a good thing, so where is the best place to hide it away, and how is it done Any help, advice or interesting articles will be welcome. To get the path to the password file text, Dim passwordFilePath As String = My .Computer.FileSystem.CombinePath( _     My .Computer.FileSystem.SpecialDirectories.CurrentUs ...Show All

• Software Development for Windows Vista My display drivers

  I have a ASUS a9250 radeon graphics card and i can't install the program for it so I can watch videos without it being laggy. It sais " Setup can only run in Administrator mode" And then I can't install it, i used the capability wizard but same problem. What do i do hi, Provide administrative rights to the User in which you are trying to install the s/w. To provide admin. role, go to : Control Panel --> User Accounts Select the user name to which you need to provide rights and click Properties button. Now change the user account to admin. user Regards, Perumal.R ...Show All

• Visual Studio checkout file dialog box does not show the username.

  hi, I am working with vs2005 and vss 6.0.Can anyone please tell me how do i show the user name who has checked out the file in vs2005. is there any option for this in vs2005/vss6.0 thank you.. thanks for the post steve. It was helpfull.But i want to show the username who have checked out the file. The problem is .. whenever i try to open any alreay checked out file from VS2005 it show a dialog box named "checkout error or user cancellation". Which show the path of the file which i tried to access with this message "filename.aspx.cs - File is exculsively checked out by another user." Here instead of another user i want to show the unsername who has already checked o ...Show All

• Smart Device Development Selecting items in Listview

  I am trying to select items in a listview. The Listview is enabled but when I add "msgbox "hello" into the "click" event of the listview nothing happens The listview is enabled, just can't understand it I also need to get the selected "text" from the item that is "clicked", how is this done Thanks is advance. Hello! I tried using the ItemActivate event but I had a problem getting the selected index because no item is actually selected but the event is received (SelectedIndices.Count = 0). May be because I use the PocketPC the emulator (Not trying from the actual device) Any ideas Regards! ...Show All

• Visual Studio Team System Can't execute Team Build - TF30063 error

  Hi, I'm trying to execute a Build on my local machine, but I am getting the following error: TF42056: The build service could not connect to the Team Foundation Server: TF30063: You are not authorized to access http://buildServerName:8080/ I have Team Foundation for Testers installed on my machine. I know that I actually can access port 8080 on the build server because that's where our code lives, and I can access and modify the code. I'm really stuck as to how to get builds working. Can builds only be done on machines that have Team Foundation for Developers on it I hope not, because it wouldn't make any sense that a tester couldn't launch a build so they could run their tests. Any help would be greatly appreciated!! I am at a ...Show All

• SQL Server Connection to SQL Server

  I have installed MS SQL Server 2005 Express Edition with Advanced Services and MS SQL Server 2005 Express Edition Toolkit SP1. Everything istalled without any errors noted. When starting SQL Server Management Studio Express, accepting the server name MAYNARD-MAIN with authentication as windows authentication. I get the following message: Cannot connect to MAYNARD-MAIN Additional information: An error has occurred while establishing a connection to the server. Wehn connecting to SQL Server 2005, this failure may be caused by the fact that under the default setting SQL Server does not allow remote connections.(provider:Shared Memory Provider, error:36 - The Shared Memory dll used to connect to SQL Server was not found)(Microsoft ...Show All

• Visual Studio Express Editions How do I plot a graph (with x and y axis) on my form?

  Hi, how do i plot a graph (with x and y-axis) on my form Fifty million bizarre machine errors later........................ Here it is... it compiles and run without errors. Remember make a big form (770 x 565 ) and a big picture box ( 715 x 470). Paint it Black! Enjoy. using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; namespace WindowsApplication1 { public partial class Form1 : Form { protected Graphics g; protected GraphClass a; protected bool firsttime; private int start; private ...Show All

• Visual FoxPro Mixing XLS and DBF tables

  In l ieu of some latest trends in my FoxPro development I want to know how do you sensible mix Excel .xls tables, workbooks and projects with FoxPro .dbf tables and databases. I have followed Marcia's earlier suggestion to use convert .dbf into .xls for graphs and now I want to integrate my .xls into existing databases. I tried to attach an .xls table to my databases but only could do in the browser as free table. This was to now avail, however, since I could not open it in FoxPro anyway. Another question, somewhat related: I used a wizard to define the connection string to a FoxPro Database. How can I do it if I need to define a connection string to an .xls table What is the equivalent for a database in Excel: a workbook Is th ...Show All

• Windows Forms Dragging and Dropping an Object

  Hi guys, I'm trying to determine if it is possible to drag and drop an object between two controls. I have a class called AudioTrack which inherits ListViewItem so that it can go straight into a listview. It has strings for the Artist and Title, and a byte array for the track data itself. I have another control (a player) which can load an AudioTrack class and play it. Is it possible to drag the AudioTrack from a ListView onto the control, and have all the data intact I've already got it starting the dragdrop operation, but can't get the player to accept it - I'm getting stuck in the DragDrop event at e.Data.GetData() and don't know what to put as the format. Hope you can help! Regards, Graham How are you startin ...Show All

• .NET Development is guaranteed message delivery possible in .net remoting?if possible how?

  any vb.net sample codes regarding certified messaging in remoting... Well, no. People have built channels over MSMQ to achieve something like this ( http://www.codeproject.com/csharp/msmqchannel.asp ). There is also reliable messaging in WCF. ...Show All

• Smart Device Development How to Format SD Card with FAT16

  Hi guys, I want to develop a program to format SD Card with FAE16 in Wince5.0,VS2005. I've tried the following two methods: 1.OpenStore()->DismountStore()->FormatStore()->CreatePartitionEX(),the parameter bByteType is 0x04,which indicates FAT16.The result,File System is FAT32. 2.FormatVolume(),after include "Formatdisk.h" my complier sad the function "Formatdisk.h" is not founded. and then I use "Find" to find the file,and then found the file is not existed in my computer. Why does the msdn say the function is supported in Windows CE .NET 4.0 and later but I can't use it http://msdn.microsoft.com/library/default.asp url=/library/en-us/wcemain4/html/cmrefformatvolume.asp All suggestion is apprecia ...Show All

• .NET Development Validate xml through the embedded resource DTD

  Hello, is it possible to validate an XML file through the DTD that is the embedded resource in my project Just a guess, an UTF-16 encoded XML document has a BOM (byte order mark) at the beginning, an UTF-8 encoded XML document can have one. Not sure however why the XML parser would fall over a BOM, unless there is something wrong with that. Can you upload the XML to a HTTP server and post the URL so that we can check it ...Show All