tomsmi's Q&A profile

• Visual Basic [VB6] excel into vb forms?

  Hi, I have some experience with VBA but I'm new in VB6. I'm looking for a way to include some Excel functionallity into VB forms: select multiple areas (like cells in Excel) by mouse-drag, assign a colour to them, translate the colours in values and store these values in a database. Once stored I must be able to call these values into the same form again. The simplest way about this seems to insert part of an excel worksheet (50x10 cells) into a VB form and to be able to at least select the cells and colour them. Is this possible or does someone have a suggestion What your asking for is completely ...Show All

• SQL Server SQL Server 2005 Service Pack 1 causes machine lock up

  When doing the service pack 1 install on a client side the machine is locking up on a specific file. The tech who tried it out doesn't remember the exact file name but he thinks it ended with an .msb or .msp I checked in the C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files directory and none of the files have been updated. Thoughts Shane Look under c:\Windows\Hotfix for log files. Your problem should be identified there. Paul ...Show All

• Windows Forms Hitting breakpoint in thread causes thread to exit

  If I create a standard C# Forms app, add a button, and inside the buttons onClick handler I put the following code: ... { // workerThread is a member of the form workerThread = new Thread(new ThreadStart( DoWork ) ); workerThread.Start(); } ... void DoWork() { while(true) { Debug.WriteLine("Hello"); // <-- put breakpoint here. It gets hit but VS hangs then thread exits. Form keeps running fine. Thread.Sleep(50); } } So long as I do not put a breakpoint in the DoWork it runs fine. If I put a breakpoint once it gets hit VS hangs for a couple of seconds then when it resumes it reports the thread has exited and the DoWo ...Show All

• Visual C# how to catch all exceptions with a single try... catch statement?

  I want to write a single try {} catch {} statement for my whole program, is this possible if it is, is it advisable Create a handler for the Application.ThreadException event. Look at the MSDN library for more info http://msdn2.microsoft.com/en-us/library/system.windows.forms.application.threadexception.aspx ...Show All

• Visual Studio Express Editions com and microcontroler

  I’m a beginner with Visual Basic. My final faculty project (assembly hardware and software) consists of driving microcontroller from PC. I have choused visual basic 2005 express edition to make graphic interface ( supervising controlling and data acquisition ) Argument: I ‘m using serial COM port for connection between devices. I my see lateral (ascii) on Hyper terminal; I have programmed my microcontroler to send me that data. And at first I would like to see number sent from microcontroller in TextBox tool. I have added serialport from toolbox to F ...Show All

• Visual Studio Express Editions Can I do this? ComboBox Question

  I am trying to use the selected value of a combobox in my code and I am sure I am doing it wrong because it does not work :) If cmbSize.SelectedValue = "6 X 9" And cmbPaper.SelectedValue = "60# Offset" Then Make a Milkshake (Just Joking) End if I tried adding Me.cmbSize and Me.cmbPaper but still no change, if I want to do something if cmbSize="6 X 9" and cmbPaper="60# Offset" how should I write the above line Thanks, Terry You can try this, I believe it will work: If cmbSize.Text = "6 X 9" And cmbPaper.Text = "60# Offset" Then   ...Show All

• Visual Studio Team System Setting up SMTP server after installation

  Can I still configure SMTP server on Team Foundation Server after installation If so, how can I do so http://geekswithblogs.net/pjhacker/archive/2006/03/17/72649.aspx ...Show All

• Smart Device Development Output window (printf)

  Sorry for the probably easy question. But where is the output of a printf statement going to I have the output window up and the "Show output for" set to debug. Is that the correct place Thanks Thanks Ayman that's easy and it works. I wish the printf statements were going to that window. But at least now I can add my own output to the legacy code I am working with. Thanks ...Show All

• Smart Device Development Visual Studio 2005 Standard or Professionl

  Hi all  Coming from J2ME and Symbian worlds, I would like to learn and develop apps in Windows Mobile. What are the differents between Standard and Professional version of Studio 2005 in regards with Windows mobile developments For mobile developments, are these two versions having similar deployment tools Many thanks in advance for the info For standalone mobile applications without deployment support Std is as good as Pro. Since it’s all subjective, consider getting evaluation copy (Beta 2 for now) of VS Std and see if it’s good enough for you before you buy. ...Show All

• Windows Forms datagrid tables styles mapping to properties of subclasses of a collection

  Hello, Could someone provide me a solution to the following problem I've made to object called A and B. B is one of the properties of object A. I'd like to define a tablestyle for a datagrid who's datasource is an array of A objects. I managed to do this, but the only problem is that i don't know what mappingname to use for the properties of my&nb ...Show All

• Visual C++ calling Activex methods from a static function--Dialog-based application

  i am using an Activex control in a dialog based applicaton(VC++). i created an member variable for that(myportcontroller). In an non-static function i am able to call the Activex control methods using the member variable and worked fine. But i need to call the activex control methods in an static function. Here i cannot use the member variable as it is a static function. So, i declared an object for Activex control class. Using that object i called the methods. I had no compile time error. But i am getting run time assertion error as "winocc.cpp line:345". Can anybody help I need very urgently. i will be very much thankful for the ...Show All

• SQL Server SSIS Requests...

  May be it's too late, but I think this requests could be scheduled at least for a SP1 if it's not possible for the RTM. 1) Execute Task without debugger: it would be very nice to be able to execute a single task without going in debugging mode. Just as you would ask "Start Without Debugging CTRL+F5" but for a single task 2) Customize default properties for task and component: when you drag a task on the package you get a default value for the properties that you could want to change; often I need to change the same property in the same way each time (for example I'd like to set the Batch Size for a OLE DB destination to 1000 instead than 0 ...Show All

• Visual C# How can I add a new row at top of a dataTable

  I intend to set datatable as datasoure of a combo box , add a row to datatable to have new item in the combo box , but its not work .Please help me , I would to have first Item value :Unknown Please help me, thank you   try { DataTable dt = new DataTable(); string sql = " Select distinct ID from TABLE"; SqlDataAdapter m_DataAdapter = new SqlDataAdapter(sql,Connection); m_DataAdapter.Fill(dt); DataRow m_datarow = dt.NewRow(); m_datarow[0] = "Unknown"; dt.ImportRow(m_datarow); // add a blank row to dataTable return dt; comboName.DataSource = dt; comboName.DisplayMember = "ID"; ...Show All

• SQL Server Another SSIS Package Validation Question

  We are going to be running a package repeatedly 24/7. The same package against the same data store, filtered using a "stageFlag" so as not to read rows previously processed. We have various timing statistics and have yet to fine tune; but on the surface it appears that it takes approximately three minutes to validate and another three minutes to run. If we have no additional data on the second run it still takes three minutes to complete - to do nothing but skip rows already processed. Is it possible to set this up to run repeatedly without the validation on each iteration Any ideas as to how this would be accomplished would ...Show All

• .NET Development Problem with Datetime type in MS Access

  When I want to find the records between a date range, there is a column 'Saledate' which type is Datetime, I always use below way to do that: Select * from Table1 where SaleDate >= #1/1/2001# and SaleDate <= #1/1/2002# It works fine in MS Access UI. But it doesn't work in my C# program. My program like:   private System.Data.OleDb.OleDbCommand oleDbSelectCommand1;   private System.Data.OleDb.OleDbCommand oleDbInsertCommand1;   private System.Data.OleDb.OleDbCommand oleDbUpdateCommand1;   private System.Data.OleDb.OleDbCommand oleDbDeleteCommand1;   private System.Data.OleDb.OleDbDataAda ...Show All