Kenny Grant's Q&A profile

• .NET Development Help with Socket TimeOut? Possible? Help Please?

  Ok, So I have a socket, and i have it connecting to see if it can connect or not. and im doing asynctously. like this. sock.beginconnect(ip,port,new AsyncCallBack AddressOf(ConnectCallBack),nothing) And Is there a way to set like a timeout on it Becuase, it waits like 15 seconds before throwing an error that it couldn't connect Is there a way to set a timeout to like 5 seconds, or anything like that How about to use IAsyncResult Interface, that represents the status of an asynchronous operation. then we can use AysncWaitHandle property to get a WaitHandle that is used to wait for an asynchronous operation to complete. here is what I thought, Dim tmpSocket As IAsyncResult= sock.beginconnect(ip,port,new AsyncCallBack Addr ...Show All

• SQL Server Copying data between database tables

  Hi. I need to move data from one database table to another across database instances. A simple example of the typical move would be: [CODE] INSERT into destination_db.dbo.table1 SELECT column1, column2 , column3 , column4 from source_db.dbo.table2 [/CODE] My options are: 1. Create an SSIS package to perform the move. 2. Create sprocs and schedule the data move as jobs. 3. Write .NET code using sprocs to perform the move. I'll have to move hundreds of thousands of records, so I want the option that provides the best performance. I'm guessing that option 3 will be the slowest. Thanks for the help! To tell you the truth, you could just try it and find out which runs faster. We are probably talk ...Show All

• SQL Server creating a child row with two parents? (in one column)

  Hi! How can I make a relation that would let me relate an employee to two departments There is a table with emloyees and each one works in a department and there is a foreign key relation in the child (employees) table to the parent (departments) table. So can an employee work in two departments (it's not impossible to imagine, is it ) And how would I retrieve all the employees of a department Or in other words, if I were working on some kind of software for my local supermarket and they need to keep track of all bills they ever gave out. I would make this products table and this bills table. Then I would create a foreign key column in the products table and fill it with bill_ids from the bills table and make retrieving bill items a simp ...Show All

• SQL Server Count Item Number

  Hello; Which is the easy way to do this: I have 2 tables:Work_Order_Header and Work_Order_Detail. I need to generate the Item Number from 1 to "qty of items" when I make the JOIN on WorkOrderNumber. Example: WorkOrderNumber WorkOrderItem WorkOrderAmt 122 1 10.00 122 2 15.25 122 3 24.37 How I generate the WorkOrderItem using a select with a JOIN on the 2 tables if you are working on SQL Server 2005, you can use the following (samples tables from Northwind database, as you provided no DDL and sample data) SELECT ROW_NUMBER () OVER ( PARTITION BY O . OrderId order by O . Or ...Show All

• .NET Development Write from form -> dataset -> xml file, HResult -2147467261 int

  Iam writing a product for a PocketPC. Hope this is the right forum, else admins are more then welcome to move the thread to is appropite forum. <Edit> Did some googeling on _HResult    -2147467261    int, and i founded some info about other _HResult exp., and the all leaded to into bugs that were found in the software. I make a silent pray that this not a bugg, is this a bug in the framwork or could it be in the PocketPC operating system that never have beeen updated. Next step is to update all software versions to the most corret version..... Please consult me ASP for thig problem. </Edit> An examaple i found work without a problem, this is a Winform. But I have been checking and it seems ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. incrementing a value over time?

  do you know how I can create a function that runs every second or know of one that runs every second so that I can use it as a means of incrementing a value over time, is their a way to do this, also code would be a big bonus. Create an "elapsed time" member variable in one of your classes - your Game class, for example.In your overridden Game.Update() method, update the member elapsed time using the GameTime that was passed in. When the member elapsed time has passed 1 (for one second), you know that one second has passed. Subtract the 1 second from the variable and then do whatever it is you wanted to do. Your Update() method, in your Game-derived class: protected override void Update(GameTime gameTime) { this.elapsedTime ...Show All

• .NET Development [newbie] Export of a DataSet in a XMLDataDocument

  Hi, I export a DataSet to an XMLDataDocument to use it in CrystalReport but all types of columns of all DataTables are Strings type... Is there a way to define the columns' type in this XML document or to export the DataSet to an other file format that accept columns' type Thanks in advance ...Show All

• .NET Development Reflection not working the way i expect it to

  If I use the code below, the instance that i get a reference to seems to have the non-public members I need access to, but not after i use GetType... //get reference to instance of SomeType Sometype _fred = Somelib.SomeType //now setup reflection Type fred_type = _fred.GetType() Now if I stop at this point, and look in the locals window, _fred will have non-public properties that I need access to, but fred_type WILL NOT. What am i doing wrong I need to use Type.GetProperty to get at a non-public property, but the search fails using fred_type.GetProperty(prop_name, BindingFlags.Instance | BindingFlags.NonPublic | BindingFlags.Public) as well as simply using this fred_type.GetProperty(prop_name) This is why I started looking in the locals ...Show All

• Visual Basic Max form size

  is there a way to set a form to the max screen size, it gets old going back and forwards making sure it fits. I have been using table layout panels to help make my forms, if I am right, those do scale to the form, requardless of the size of the form, I think Davids Learning There are two quick and easy ways you can set the form's size to be the max screen size. You can either set it's WindowState property to Maximized either in the designer or in code, or you can set the form's Location and Size properties based on the primary screen on the system like so: Me .Location = Screen .PrimaryScreen.WorkingArea.Location Me .Size = Screen .PrimaryScreen.WorkingArea.Size Be sur ...Show All

• Visual Studio Team System Updating To New Workflow Transitions after modifying a Process Template

  I'm pretty sure this question makes sense... although I'm prepared to be wrong about that. I need to modify a process template (not CMMI or Agile) to use a new primary workflow by adding new States and Transitions and Reasons. And I can see how to do the template modification part. But then we need to update the backlog of current work items to implement the new workflow. And maybe we need to change all the work item history to display and report and query with the new state names. I can see in the TFS Database tables some places where we might could run some queries to change the names of the historical work items. But its pretty scary to throw down a query on a database as normalized as what TFS looks like with no real understan ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. overlapping boxes in 3d

  Ok, I am a complete noob at 3d. I had the basis of a 2d Sudoku game written in Beta 1. With Beta 2 I am converting it to 3d. So I have a 9x9 grid of cubes but when I render the board the top 2 rows renders over row 3 and the right most 2 collumns render over the 3rd col from the right. They are in the right positions but surfaces that should not be seen based on camera perspective are drawn over adjacent rows/cols. The camera is pointing at block(5,5) in the center. If I reverse the order of drawing the blocks then the situation flips(bottom and left). the Z is 0 for all blocks. What am I leaving out to make it work as expected Any help is much appreciated.Thnx. // Board.Draw() public void Draw( SpriteBatch Batch) { ...Show All

• Visual C# Reading a string from one Pipe delimiter to another

  Hi, would someone please help me out, i'm quite new to C# In C# if I have a string that is pipe delimited, how can I create a while loop to read data from one | to another | and store that value in a variable. E.g. DD|2.7|0076|John Doe|Incredible Man|8412076542354836|A123|ABC| string dispensary = DD; float version = 2.7; string fileLength = 0076; string clientName = “Carel Greaves”; Etc. Any Help would be greatly appreciated. Kind Regards Use the Split method of the string - e.g. string[] substrings = mainstring.Split(new char[] {'|'}); foreach (string s in substrings) {do anything} ...Show All

• Visual Studio Tools for Office How can I put data in Word Documents???

  I'm working in a Windows Project (using Visual Studio .Net 2003), the goal that I have to reach is to put data, (that is taked from database) and put them in a Word document. The problem that I have is that I'm NOT working with Visual Studio Tools For Office, instead of that, I'm writing code. A good example of what I'm trying to do is the following link: http://www.codeproject.com/csharp/Simple_Ms_Word_Automation.asp I'm working with templates, and in the template, I have putted bookmarks in this way: Within Microsoft Word - Insert - Bookmark. Then I write a name for the bookmark and finally clik on Insert. After that, the goal that I want to have is to put the data in those bookmarks.... Please can anyone tell me how can I ...Show All

• Windows Forms beep generates no sound

  the Beep method generates no sound, the volume is on i checked Remco ahmedilyas wrote: Is there a sound attached to (im unsure but maybe) the notify sound event in Windows I can not check because of the configiration policy here @ work remco ...Show All

• .NET Development using xmldocument

  Hi, How can i append elements to the root of a xmldocument using a method This was my previous method: public void WritingToXMLDoc(string elementString, string writeToXMLDoc) { this.writer.WriteElementString(elementString, writeToXMLDoc); } But now, im coverting everything to xmldocument. Thanks in advance! Hi, Thank you for your reply. Do you also happened to know how i can create an xml file in a specific directory and put a root and a child node in it This is as far as i got: string path = Path.GetDirectoryName(Assembly.GetExecutingAssembly().GetModules()[0].FullyQualifiedName); XmlDocument xmlDocument = null; XmlElement element = null; XmlText text = null; FileStream xmlFile = null; ...Show All