Can-Ann's Q&A profile
SQL Server Lookup Transformation Join Column Types
Does anyone have a clue as to why DT_R4, DT_R8 are not allowed as join columns This means I cannot join tables on AccountNumbers, InvoiceNumbers, etc. What a pain... We didn't include support for floating point joins, because of the inherent inability of computers to accurately compare two floating point numbers. To make the comparisons consistent, we would need to introduce some sort of rounding and user specified precision. If we did not, you may might be now posting a question about why 1.75 is not equal to 1.75 J I hardly every see people store invoice or account numbers as floating point, I would be interested to know why you made this choice. ...Show All
Visual Studio Express Editions Confused, please help!
I did a randomize function in form1 and now I need that value to appear on dialog1. How can I connect the statement It says it's not declared. "Dim floorwalkers() As String = Me .TextBox1.Text.Split( New Char () { "," }) 'split the characters by the comma from the input Dim theRandom As New Random() Dim floorwalkerschosen = theRandom.Next(0, floorwalkers.Length) Dim Floorwalkernumber1 As String = floorwalkers(floorwalkerschosen) My .Forms.Dialog1.Show()" I need floorwalkers(floorwalkerschosen) to appear on my diolag as textbox3.text . How can I do that I would assume that form this code you have a form called dialog1 and this is what you are refering to. My.Forms.Dia ...Show All
Smart Device Development Error when closing threaded modal dialog.
Hi, I am getting ThreadAbortException when my ShowDialog completes its work. I have created a thread and called DisplayInformation, which creates form instance and call its ShowDialog (means form displayed as Modal). In the form I have a button by clicking on it, I set the DialogResult to OK. Whenever I press that button the thread terminated abnbormally with following exception. This behavior is for CF2.0 and PocketPC 2003 SE emulator. Sometimes it work on Device. ERROR: ThreadAbortException at Microsoft.AGL.Forms.WL.SetVis() at System.Windows.Forms.Control.set_Visible() at System.Windows.Forms.Form.ShowDialog() at UtilitiesThreadedDialog.DisplayInformation() at Utilities.ShowInfo() at WorkItem.doWork() at System.Threading. ...Show All
Windows Forms minimize, maximize, and close button image...
hey, In Visual C# 2005 express how would I use some images I made for the minimize, maximize, and close buttons, and change the defaults to the ones I made The images are .PNG if that is somthing you need to know... Thanks :) 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 { public Form1() { InitializeComponent(); } private Point mouseOffset; private bool isMouseDown = false; private void MOUSEDOWNEVENT(object sender, MouseEventArgs e) { int xOffset; int yOffset; if (e.Button == Mou ...Show All
Visual Studio 2008 (Pre-release) How to get texture Coordinate when I click 3d model in Viewport3D ?
I am trying to get texture Coordinate for the picked one point when I click 3d model in Viewport3D , I have a sphere model in Viewport3D . I don't know what I have to do to get texture Coordinate when I click 3d sphere model in Viewport3D . Can anyone help thanks. It should be something like: MeshGeometry3D mesh = rmg3dhtr.MeshHit; Point texCoord1 = mesh.TextureCoordinates[rmg3dhtr.VertexIndex1]; Point texCoord2 = mesh.TextureCoordinates[rmg3dhtr.VertexIndex2]; Point texCoord3 = mesh.TextureCoordinates[rmg3dhtr.VertexIndex3]; Point texCoordHit = rmg3dhtr.VertexWeight1 * texCoord1 + rmg3dhtr.VertexWeight2 * texCoord2 + rmg3dhtr.VertexWeight3 * texCoord3; This may not be right if you have a Brus ...Show All
Visual Studio VSS bat file script issue
I have a bat file which gives me all the checked-in source files from the VSS6.0 database. The script as follows " C:\Program Files\microsoft visual studio\vss\win32\ss.exe" Get $/Project/Application -I- -R -GL"D:\Apps\Project " This script works absolutely fine. It gets the necessary files from the VSS6.0d database. My question is how can I use the same script to get source files from VSS 2005 database. ...Show All
Visual FoxPro How to copy one column to another
Hi all, I would like to copy a column that has prices (fprice) for parts in it to another column within the same table. Then I am going to do a replace on the original column (fprice) to increase the price by a fixed amount (I know how to do that). The table has a column that is not used for anything (by us) within the application. It is a User Character 3 field (fcusrchr3). I need to do this so our CFO can look back at the old pricing if need be. Any help copying the column would be greatly appreciated. FYI, this is in Visual Foxpro 6. Thanks, Erik FYI scope clause "ALL" that is found in many commands like replace,delete etc are an easy way ...Show All
Visual Studio Express Editions Shared network drive : "The project location is not trusted"
Hm, trying to open a solution in Visual C# from a shared network drive, getting the error "The project location is not trusted...". I can open the project but it gives me nasty security permissions errors in middle of running the application etc. Is there any way to mark this drive or project as trusted Please note that copying the file on a local drive is NOT an option for me. Thanks in advance, /regards Siyavash sure, I think you need to sign the assembly (but dont quote me) take a look at these and see if it helps: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=262680&SiteID=1 http://msdn2.microsoft.com/en-us/library/xc31ft41.aspx http://www.codeguru.com/Csharp/.NET/net_general/ ...Show All
Windows Forms How to change a sql string "on the fly"
I am using vb.net 2.0 visual studio professionel. In my dataset i have a sql command that look like this: SELECT jumboId, nr, navn, tekst, aar, dato, pic FROM tblJumbo ORDER BY nr created with the TableAdaptor configuration wizard. I wonder, is it possible to change that string, or add a new one, when the program is running It is called like this: .TblJumboTableAdapter.Fill(.JumboDataSet.tblJumbo) If i want to change the select command to: SELECT jumboId, nr, navn, tekst, aar, dato, pic FROM tblJumbo WHERE nr = 2 ORDER BY nr (This is only a simplified eksample, the real one is much more complicated). The string is depending of the users choise. Anybody know how to do this Maybe i am blind, i just can seem to ...Show All
Visual C++ Extremely memory efficient file sort?
Hello, We need a C function to sort files that are up to 10,000 rows long with 100 bytes per row (1MB), but only have 10KB of memory available to do so (this is an old 16 bit application ... we have over 500K lines of 16 bit code, so upgrading to 32 bit is not an option right now). At most, we can store about 90 of the 10,000 rows in memory at any one time, and the routine needs to be reasonably fast. Previously we had used a very small footprint database to do the sort, but recently had to scrap it since it maxed out at 16KB of memory and our newest upgrade reduced the space available for sorting to 10KB. Any thoughts on the best way to accomplish this Maybe the following articles and samples can help you: ...Show All
Visual C# Add Node existing XML file
- < RadioBar > < Genre_Genre_Country > Genre_Country </ Genre_Genre_Country > - < Genre_Genre_Country > < Title > KPIG presents Cowboy Cultural Society Radio - an American tradition since 2002 </ Title > < url > http://205.188.215.232:8028 </ url > </ Genre_Genre_Country > - < Genre_Genre_Country > < Title > Classic Heartland - Classic Country, Western, Bluegrass, Alternative Country [Dial-up] </ Title > < url > http://130.166.72.1:8008 </ url > </ Genre_Genre_Country > Genre_Genre_Favorites ...Show All
Visual Studio Express Editions i need help
When i runs this code i get an error saying: PInvokeStackImbalance was detected Message: A call to PInvoke function 'Auto Clicker!Autoclicker.Form1::GetAsyncKeyState' has unbalanced the stack. This is likely because the managed PInvoke signature does not match the unmanaged target signature. Check that the calling convention and parameters of the PInvoke signature match the target unmanaged signature. i have no idea what that means. if anyone can at least explain it, id really appreciate that. Public Class Form1 Declare Function GetAsyncKeyState Lib "user32.dll" ( ByVal vKey As Long ) As Integer Declare Function mouse_event Lib "user32.dll" ( ByVal dwflags As Integer , ByV ...Show All
.NET Development how to jscript in vb.net
hi , i my dot net application vb.net i have add web browser control at the time of loading the application can it automatically open a html file and can anybody tell how i write code for the html file using java script in vb.net Hello Narasiman, I have a question to ask first. What is it that you want to do in the html file using JavaScript ...Show All
Visual Studio Express Editions RenderSurface_X11.obj : error LNK2001: unresolved external symbol
I am using vc++ express 2005 and receiving this error trying to compile : openscenegraph.org < I think I deleted a DIR setting under OPTIONS possibly causing this and Im not sure how to fix it. I have gone into project settings and linked ( linked to the dir that contains that missing .obj file but its not helping atm. here is long output from console window: ------ Build started: Project: Producer, Configuration: Debug Win32 ------ Compiling... Utils.cpp PipeTimer.cpp Generating Code... Compiling... Window3D.cpp WGLExtensions.cpp VisualChooser.cpp Version.cpp Trackball.cpp Timer.cpp RenderSurface_X11.cpp RenderSurface_Win32.cpp RenderSurface.cpp KeyboardMouse.cpp Keyboard.cpp InputArea.cpp ConfigParser.cpp d:\programs\programming\osg_o ...Show All
SQL Server Migrating a column from ntext to XML
After SQL Server 2005 migration, I'm trying to change my ntext column to XML type. The "alter table TableName alter column XMLCol xml" command throw this error : XML parsing: line 1, character 39, unable to switch the encoding 1. Do I have to reformat my nText column before the migration to XML type 2. Is there a way to create an XML data type with UFT-8 in SQL Server 2005 Thank you for your help Thank you for your help hi, if you would be converting the column from ntext and you have several hundereds of record in it already it would be difficult to pinpoint the problem. here's my suggestion 1. add a new column with XML data type. leave the old ntext column untouched 2. insert into ...Show All
