Alastair Q's Q&A profile

• .NET Development Primary key collision

  I am rather new to the web development but is currently working on a small project that would store the data on the production office output. As the part of it, the system will provide a form to insert the order placed. 1.The order is intended to have a unique OrderID key and would store several items with their respective qtys under the same OrderID. 2.This means that there will be two tables in the DB - Order and Order_Item in order to tie the order items to the orderID. I would be using a stored procedure to insert the data in the DB. 3. There is a need to identify repetitve orders within a certain period of time (i.e. 2 weeks) in order to avoid the duplicates. THEREFORE ------------------------------------------------------ ...Show All

• Visual C# How to sort a two-dimensional and parallel array?

  I am trying to sort 3 parallel arrays, one being two-dimensional. Is there an Array.Sort method to do that Here is an example of what I am trying to sort. namear [0] = name1 [1] = name2 [2] = null [3] = name3 datear [0] = date1 [1] = date2 [2] = null [3] = date3 infoar [0, 0] = salesday1 [0, 1] = salesday2 [0, 2] = salesday3 [1, 0] = salesday1 [1, 1] = salesday2 [1, 2] = salesday3 [2, 0] = null [2, 1] = null [2, 2] = null [3, 0] = salesday1 [3, 1] = salesday2 [3, 2] = salesday3 Im trying to get it to sort into this - namear [0] = name1 [1] = name2 [2] = name3 [3] = null ...Show All

• Visual C# Accessing another app's message queue in C#

  I'm not actually sure if this is possible, but how would you go about this in C# if it is possible Say I wanted to minimize every occurence of Notepad, how would I code it so that it posts a message into the message queues of every instance of notepad.exe telling it to minimize Thanks in advance! - Javawag You need to use PInvoke and send the messages. Here is a code sample of how to close a Window http://forums.microsoft.com/msdn/showpost.aspx postid=935502&siteid=1 changing WM_CLOSE to WM_MINIMIZE will do it for one window. Changing FindWindow for EnumWindow like in http://pinvoke.net/default.aspx/user32/EnumWindows.html Should do it for more than one window. ...Show All

• Visual Basic VB Date to Access database - specified cast is not valid

  I have two date fields being inserted into a table in an Access database. In Access the format is set up as date/time (general). In VB it is the usual: Dim DateIn As Date Dim DateOut As Date They each store a value of DateTime.Now . The data actually gets into the database but everytime I hit submit I get "specified cast is not valid". I should note when I changed the format to text in Access and String in VB the error message went away. Below is my SQL to insert the fields into the database. Any help is greatly appreciated. Dim myInsertQuery As String = _ "INSERT INTO Test (DateTimeIn, DateTimeOut, PGMSSN, Batch) VALUES ('" & DateIn & "', '" & DateOut & "', '" ...Show All

• SQL Server OnError Script error

  I am using following script to combine all the System:ErrorDescription on OnError Dts.VariableDispenser.LockForRead( "ErrorCode" ) Dts.VariableDispenser.LockForRead( "ErrorDescription" ) Dts.VariableDispenser.LockForRead( "SourceName" ) Dts.VariableDispenser.LockOneForWrite( "Errordesc" , vars) Dts.VariableDispenser.GetVariables(vars) errNumber = CType (vars( "ErrorCode" ).Value, Integer ) errDescription = vars( "ErrorDescription" ).Value.ToString() errSource = vars( "SourceName" ).Value.ToString() errdesc = vars("Errordesc").Value.ToString() vars("Errordesc").Value = errdesc + errNumber.ToString() + vbNewLine + vbN ...Show All

• .NET Development BitConverter.ToSingle with a two dimensional byte array

  i am having trouble converting 4bytes to a single in a two dimensional array. how do i specify the position i want in this array i tried treating it as a long one dimensional array.   Short of making it one, does anyone have any ideas Any help is greatly appreciated.   int traceLength = 9200; byte [,] cobbleData = new byte [traceLength,6]; . . y1[ i ] = BitConverter.ToSingle(cobbleData, traceLength + 4*i));   Not yet i tried a few more things. i might be able to expand on the actual goal i am trying to achieve. i receive around 100 arrays, each 19kb long. I want to put them into a two dimensional array. Each array has bytes that represent character strings, floats, and in ...Show All

• Windows Forms Thread Pools

  I'm using thread pools to update multiple windows forms. The question i have is that when i close a form the thread doesn't get disposed and eventually the app locks-up when i open and close to many forms and won't display any data unless the app is restarted. What happens is the threads are getting stuck trying to update the closed form and when it hits that section of code its stays there trying to find the form but can't. It won't get deleted or die it just stays there until all the available threads are used then i get no more updates. Is there a way to delete the threads as the forms are closed or are they supposed to stay and i just need to add more threads to support what i need to get done Thank Y ...Show All

• Visual Basic Mismatch of "Typeof obj Is Form" condition

  Join Date: Oct 02 Posts: 173 Mismatch of "Typeof obj Is Form" condition ...Show All

• Visual Studio Express Editions Get data from RFID reader + RS232

  Hello, I've an RFID reader which is connected with my local pc. I'm trying to get the data from the tags and put them in a database. See code below how I'am connected to the COM port but I can't get data of it... what do I do wrong Thanks Imports OpenNETCF.IO.Serial Public Class Form1 Public WithEvents SerialPort As New OpenNETCF.IO.Serial.Port( "COM1" ) Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click With SerialPort .PortName = "COM1:" '.RThreshold = 1 .Settings.BaudRate = OpenNETCF.IO.Serial.BaudRates.CBR_38400 .Settings.ByteSize = 8 .Settings.Parity = OpenNETCF.IO.Serial.Parity.even .Set ...Show All

• .NET Development is this a memory leak?

  one of my customers put my program through the performance monitor, and found out that my application was eating up memory. my first thought was what GC GC!!! well, i guess it's possible. i've tried various profilers, including memprofiler and automateqa. the realtime monitor shows a zigzag pattern of increasing memory usage. my application communicates with a device through the serial port. i'm stressing the application by having constant stream of data coming in, and the app parses data and displays it to windows controls. now, if i just leave the application running, it will just keep eating up memory forever. however, if i manually call GC.Collect, i am able to retrieve all of the memory that it was eaten. now i'm confused, if ther ...Show All

• Visual C++ Font smoothing for textout in Win 2000

  Hi all, I am using textout Windows API to write a text string on a DIB created using myDc = CreateCompatibleDC(GetDC(0)); Selected font is created with CreateFontIndirect() with lfQuality set to DEFAULT_QUALITY. The problem is on Windows 2000, the the output is not smoothed even though in display settings, the Font smoothing option is enabled. On Windows XP, this problem is not happenng. I am using VC++ 6.0 for building the application. Thanks in advance for any help Gojon Hello Such questions are outside the scope of this forum - for the scope of the VC General forum please look at: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=19445&SiteI ...Show All

• Visual Studio 2008 (Pre-release) Support for logging

  Now the datacontext is more or less a black box. It would be nice to have a logging event added to the datacontext for diagnostics. The logging event should trigger on event types such as: - inserts, updates, deletes and selects to the datasource. (with the sql statements) - Objects added, removed, updated or deleted from the datacontext. (with the type and id of the object.) - Other important event types. When appropriate,the event should contain important event data such as sql statement strings and object id’s. ...Show All

• Windows Live Developer Forums Robot Invaders Contest Winners

  It's time to annouce the winners for the Robot Invaders contest. The contest ran from May 15th to September 15th and in the end 53 Messenger bots were accepted as valid entries in the contest ( per the how to compete guidelines ). Each entry to the contest was judge by three judges separately using the Judging Criteria outlined on the How to Compete page and then the judges scores were averaged. There were a lot of great robot's submitted but here's the winners: Title Prize LiveBot Grand Mother Nature 1st Spleak 2nd Mobile Record bot 2nd Virtual Secretary 2nd Dr Phile Knowledge 2nd Comtec Travel Bot 2nd Search Bunny 3rd ...Show All

• Visual Studio Express Editions how to populate label on different form.

  I'm trying to populate a label on from. The value for this label is coming from another form which opens up the active current form where the label resides, is this even possible and if so can someone explain how to do it using the C# express designer. ok this is the entire code for the locForm. using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; namespace CaterManager { public partial class locForm : Form { public locForm() { InitializeComponent(); } private void locationsDataGrid_Navigate( object sender, NavigateEventArgs ne) { } p ...Show All

• SQL Server Database Issue

  HI, I can't seem to wrap my head around this problem. Hopefully it's a simple solution. I have 2 tables, one called SETNAME, and one called PLAYERS. SETNAME has 2 fields (NAME and SETNAME ID) PLAYERS has 4 fields (LAST NAME, FIRST NAME, PLAYERSID, and SETNAMEID) The two tables are tied together via the SETNAMEID field. My issue is this, how do I associate more than one set to a player, without duplicating the names of the players in the PLAYERS table Thanks Peter WHat about this here Thats a common approach. SETNAME has 2 fields (PLAYERSID , NAME) COmposed key on Playersid and Name PLAYERS has 4 fields (LAST NAME, FIRST NAME, PLAYERSID) HTH, jens Suessmeyer. --- http://w ...Show All