echavez's Q&A profile

• .NET Development Getting Table Column Names

  I am looking for the best way to identify the column names of a database table at runtime, especially with using as little memory and time as possible because it is possible that this file will grow quite large. Ideally, I would get just the column names back with no data. I can do this using a datareader and filling a dataset- it occured to me to create a query that would return a single row and access the resulting dataset to get the column names. This still seems like a waste of steps, is it possible just to get these names directly Thanks all! you have a few different choices...if you need the data also I would just iterate through the datacolumns collection of the datatable....if all yo ...Show All

• Visual Basic How can i add/display Combobox in Datagridview in Edit mode

  Hello, Anybody can tell me how can i add/display ComboBox in DataGridView in Edit Mode Thanks, Jigar Jigar Patel wrote: Hello Richard, Please read my question again. I want to show combobox only when my focus goes to particular cell in Edit mode. Jigar Patel wrote: Hello, Anybody can tell me how can i add/display ComboBox in DataGridView in Edit Mode Thanks, Jigar Hmmm .. and still didn't pick up on the cell focus requirement. Good luck Richard ...Show All

• Visual Studio Express Editions Saving in ComboBox

  Hello! How do i do to update Item (Collection) Can't get it to work! This code put the text into ComboBox but it doesen't save it to Item Collection Combobox1.Item.Add(TextBox1.Text) TextBox1.ResetText() TextBox1.Focus() well yes it will lose the items because you did not save them to a storage format. you can save them to a file and reload them after. example: Dim theWriter as new StreamWriter(filename) for each curItem as string in me.theComboBox.Items theWriter.WriteLine(curItem) next theWriter.Close() Dim theReader as new StreamReader(filename) do while theReader.Peek() <> -1 Me.theComboBox.Items.Add(theReader.ReadLine()) ...Show All

• Windows Forms ProgressBar

  Hi All, I always collect the data from database and display in UI. But some times, it will takes long time to collect data from database and i would like to have a progress bar running in UI so that user know that there are processing running. Unfortunately, i did know the exact time of collect the data from database. So how can progress increase the value in it to the maximum. Hope u all understand what am i try to say. Thanks Kendy Set the ProgressBar's Style property to 'Marquee'. You'll see bars moving continously from left to right. ...Show All

• SQL Server SQL Profiler Scan:Stopped Event

  I am trying to improve the load performance of a data mart. It is setup with a standard 3 database ETL process (prestage, stage and mart). I am using Profiler to capture scan stops and identify any tables that may be having excessive full table/index scans. One table in the stage database has had 900,314 scan complete events in 37 minutes. This database has no user connections and the only process that is running is our ETL. All of the ETL is written in stored procedures which there are only 90 or so. The ETL process takes about 70 minutes so it has not completed and restarted during this time. The next closest event counts are in the 100,000 range, which still seems high. My question is what could be causing all of these tabl ...Show All

• Windows Live Developer Forums restrict max zoomlevel

  I have a project requirement to have a maximum zoom level of 11. What I'd like to do is trap the onstartzoom event and set some form of cancel if requestedView.zoomLevel>11 but I don't see a way to do it. I've returned false from the event and even set requestedView.zoomLevel=11. Right now I'm using the onendzoom event and calling SetZoomLevel(11), but the user sees a weird zoom in and out effect. function onZoom(evt) { if (map.GetZoomLevel()>11) { map.SetZoomLevel(11); } } Does anybody know a way to cancel an onstartzoom event It not just the dashboard as you can zoom with the keyboard or mouse also. There is no way i know of built in. You could try to hack the js but rememeber it will be a hack ...Show All

• Visual Studio Express Editions Picture Viewer

  I now have the Thumbnail Control working, after my last post it's a control that is fully independent, all you need on the form is a PictureBox, Panel and Button in the Buttons click event you place one line of code ShowThumbs.GenThumbs(DirectCast(pnlThumbs, ScrollableControl)) and that's it. So why am I here well it's because when the thumbs load they take a long time first each picbox loads in the panel one at a time then the pictures load.This isn't bad for a few Images but if there are 100 Images! What I want is to create the thumbs quicker. Any Ideas If you want to see the code let me know and I will post it. No, as usual you're bang on, it's the blue rectangle that I need to remove. Tried this ...Show All

• Visual Studio Tools for Office VSTO 2005 SE Beta documentation

  The download site for VSTO 2005 SE Beta states: "Documentation for VSTO 2005 SE Beta is installed as a whitepaper along with the software." Where can I find this whitepaper   It should be available on the Start menu. Open the "All Programs" menu and the VSTO 2005 SE submenu, and there should be "How to Use VSTO 2005 SE Beta." Cheers, Harry Miller Technical Editor http://blogs.msdn.com/harrymiller This posting is provided "AS IS" with no warranties, and confers no rights. ...Show All

• Visual Basic A few n00b questions

  I have a few questions to ask, so i'll ask them all here. :P I'm building a program that will get a string like (010305060405 e.t.c.). They are co-ordinates in the form of XXYYXXYY e.t.c. how can i split them to 4 characters and then their respective XX and YY co-ordinates to be added to an array I've researched string.split and couldn't find anything that helped me. Also, what would be the best way of showing images for these values in a grid I want to show them as images in a grid that could be up to 99 x 99 cells (maximum, bare basic is something like 50 x 50 or 60 x 40 or 70 x 30 [default sizes]). And how would i go about doing that And would it be possible to see if a usr has clicked on a cell and to then perform an event, like ...Show All

• Visual C++ Shallow Copy , Deep Copy , Memberwise Copy ,Bitwise copy

  hello ppl, i searched thru google but i didnt find the exact explanation for constructors. Shallow Copy , Deep Copy , Memberwise Copy ,Bitwise copy i got some conflicting answers.. and what is the difference between them.. .pls help me.. manish      When you pass an object by value if you haven't made provision for a copy constructor the compiler assumes a bit copy. That means the object is copied bit by bit without considering the (for lack of a better word) "semantics" of the object. Shallow copy and bitwise copy are the same thing.   Regards  Sahir ...Show All

• Visual Studio 2008 (Pre-release) System.ServiceModel.FaultException in a certificate service

  I've created an wcf service hosted as a managed Windows Service . The service was configured to use netTcpBinding , message security mode , and Certificate authentication . I'm running the client and service on the same machine, and so the client and server certificates are installed on the same machine as well. The CertificateValidationMode is set to PeerOrChainTrust in both, the client and the service. When I try to run one of the operation contracts from the client, I got the following exception: System.ServiceModel.Security.MessageSecurityException : An unsecured or incorrectly secured fault was received from the other party. See the inner FaultException for the fault code and detail. The inner FaultException return this... ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Methods to check 2D rectangle collision?

  I enjoyed Win32's IntersectRect() before for this kind of work. Is there a similar method for 2D collision I just need something like this... Rectangle r1 = new Rectangle(0,0,50,50); Rectangle r2 = new Rectangle(10, 0, 50, 50); if (r1.Intersects(r2)) { ... } I believe I remember System.Drawing.Rectangle having a similar method but it is not part of GSE exclusively - in fact, it has its own Rectangle structure. Maybe i should just include the System.Drawing reference and do something like using Drawing = System.Drawing; just to avoid name collision. It'd be nice if XNA had something like this though because BoundingBox was meant for 3D purposes last time I looked at the documentation. ...Show All

• Smart Device Development stream audio file & send via serial port!!!!!

  anow i can record , save as a file and play sound by Waves class (i use C#.NET) . but i don't know how to stream it and send it via serial port of bluetooth. i found that serialport class has a write method ,but i'm not sure that can i write sound via serial port . can you advice me this is my code. using System; using System.Drawing; using System.Collections; using System.Windows.Forms; using System.Data; using System.IO; namespace MWORecord { /// <summary> /// Summary description for MWORecord. /// </summary> public class MWORecord : System.Windows.Forms.Form { private System.Windows.Forms.Button btnPlay; private System.Windows.Forms.Timer timer; private System.Wind ...Show All

• Visual C++ VS .Net 2005, how to disable intellisense...

  Hi I am really frustrated with the performance of VS .Net 2005. This is because I always see at the bottom "updating intellisense..." and it uses 60% to 70% of CPU. How to disable this updating of intellisense... Please this is making Visual studio unusable. Thanks Chandra Chandra, i've moved this into the "Visual C++ General" forum from the "Visual C# IDE" forum as you appear to only be using C++ and not C#. ...Show All

• SQL Server BCP task and Dynamic import and export of a file via package variables

  I have a requirement to create many SSIS packages and no datatransform is required so the BCP task looks a good contender providing it can do both import & export is it possible to parse the values in bold as package variables into the BCP task. If so how BULK INSERT ipcs_wvg.dbo.extract FROM 'D:\IPCS\extract.csv' WITH (FORMATFILE = 'D:\ipcs\query\extract.xml' ); Thanks in advance Dave I have a global database called ETL Configuration for all my SSIS packages that uses a single table. So I can create three global variables USE [ETLConfiguration] CREATE TABLE [dbo].[SSIS Configurations]( [ConfigurationFilter] [nvarchar](255) COLLATE Latin1_General_CI_AS NOT NULL, [ConfiguredValue] [nvarchar](255) COLLATE Latin1_Gener ...Show All