Hauchmahler's Q&A profile

• Visual Studio Express Editions Converting from Microsoft Access

  Some time ago i created a database using access 2k3 and until now i have started to use VB Express i never thought of a stand alone package so my Question is: Is it possible to import all the forms and talbe etc from my access database into VB Express or do i have to start over with the forms and create a new database and possibly import the data into that. Any help in the subject will come in handy as i am new to all this. Thanks in advance. Mike Thanks for all your help guy's I am going to give all options a try to see where i go from there but i have come across a problem straight away when starting to use VB Express: On opening the database explorer to Create New SQL Server Database ...Show All

• Windows Forms Making a TableLayoutPanel within a Form scrollable

  I currently have a TableLayoutPanel in my form in which hundreds of pictureboxes are programatically added to the panel. I set the AutoScroll of the TableLayoutPanel to 'false' and the AutoScroll of the form to 'true'. As of now, the scrollbar will appear since I have so many pictureboxes being rendered. However, I'm running into a little problem. Since the pictureboxes are added programatically, they are not painted instantaneously. It takes 2-3 seconds for a few hundred pictureboxes to appear. As a result, the scrollbar will automatically scroll down as more pictureboxes appear. I want to keep the position of the scrollbar at the top until I've finished loading all my pictureboxes. What's the best way to do this Or does someone ha ...Show All

• Visual Studio Express Editions Respond (trap) Windows Pop-up messages

  I have been trying to find an easy (if possible) way to get status on a Windows pop-up window. For example I am using .CopyFile to copy say 30 files (individually) from on directory to another. I run out of disk space after number 5 and I get a Windows Message "Destination Drive Full". I would like to trap that and jump out of the copying routine. Right now I would get another 25 messages of Disk Full. Any help would be apprciated. Hillimonster Pseudo COde: Try System . IO . File . Copy ( "Source" , "Dest" ) Catch IOEX As IO . IOException 'DO SOmething her to respond to error End Try 'COPY METHOD Exceptions: System.IO.DirectoryNotFoundException: The path ...Show All

• SQL Server exporing a table from one dattabse to another

  I have a database which is on a network and I want to transfer a table form this databse onto my local machine. Is this possible as in Access they have an export function but I can't find such a thing on sql server expresss. I have tried copying and pasting the data across but there are over 200,000 rows so I imagine it will take me for ever. As anyone any suggestions Cheers hi, SSMSE does not provide SSIS (SQL Server Integration Service) features to allow a task like that, but you can perform the very same activity via standard Transact-SQL code... SET NOCOUNT ON; USE tempdb; GO CREATE TABLE dbo.originalTB ( Id int NOT NULL PRIMARY KEY, data varchar(10) NULL ); GO PRINT 'populate it with some data'; ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Advanced shader question

  There is a sample that comes with Nvidia's SDK that produces a texture from a Generate Noise function. The function is not part of any output of any technique for the effect. The sample works within FX Composer. Can anyone point out to me how I can do the same from an XNA project I'm thinking that FX Composer is auto-generating a shader, but I'm hoping the answer isn't as complicated as that. /* Volumetric flame effect based on Yury Uralsky's "Volumetric Fire" http://www.cgshaders.org/shaders/show.php id=39 This revolves a cross section of a flame image around the Y axis to produce a cylindrical volume, and then perturbs the texture coordinates with 4 octaves of animated 3D procedural noise to produce the flame eff ...Show All

• Smart Device Development Selecting items in Listview

  I am trying to select items in a listview. The Listview is enabled but when I add "msgbox "hello" into the "click" event of the listview nothing happens The listview is enabled, just can't understand it I also need to get the selected "text" from the item that is "clicked", how is this done Thanks is advance. ListView.Items[ListViewName.SelectedIndexes[0]].SubItems[IndexOfSubItemInListViewHoldingRequiredText].Text; For example, this is what I have... lstQuestionTree.Items[lstQuestionTree.SelectedIndices[0]].SubItems[1].Text; Hope this helps. ...Show All

• Visual Studio Tools for Office Current Profile Name

  Hi, Just wondered if anyone knew how to get the current Profile name from within an Outlook Addin using VSTO I need to be able to configure different options for different profiles, but I'm at a loss as to how to detect which profile a user is using. Any ideas Cheers, Dino Phil, Thanx for that - I should have said Outlook 2003 initially. I have found this works from VB if CDO is installed: Dim objSession As Object objSession = CreateObject("MAPI.Session") ' Use the existing Outlook session objSession.Logon("", "", False, False) Return objSession.Name Dino ...Show All

• Visual Studio Express Editions Error in List<>

  Hello I have written this method but It doesnt work Can anybody help me public void ReceiveTransfer( List < Transaction > lstTransactionList, decimal fCash, decimal iAcNum) { balance += fCash; lstTransactionList.Add( DateTime.Now.ToString() + "\n\t\t" + "u$s" + fCash.ToString() + " were RECEIVED from ACCOUNT #" + iAcNum.ToString() + "." ); } the error is in the greenpart . well what is the error to me you need to make an object of "Transaction" and then add that to the generic list collection. you cannot add a string object as you have done like this in the strongly typed collection as soon as you do: lstTransactionLi ...Show All

• SQL Server Calling Reporting Services from SSIS

  Hi I have created a packages which pull and push the data to SAP server. I want to create a report every day and send that report to the manager. For the same i want to call reporting services in my SSIS package. I know i can write a SQL script and export the report in excel but i want to use Reporting services. Have any one call reporting services from ssis. i want to run MS Reporting Services file from SSIS Task and subscribe the reportfile.rdl.data file to a local or network folder. ...Show All

• SQL Server temp table naming

  I have a procedure that creates temp tables. I made the temp tables local - using # instead of ## - but I still get a 'table exists' error, when I run it from 2 qa sessions at the same time. I am deleting tables at the begining of the proc and again at the end - using IF EXISTS(SELECT name FROM tempdb.dbo.sysobjects where name = '#Archive_In')DROP TABLE #Archive_In Is this expected behaviour   I thought using # would make it local to the connection If this is expected, how do I make it work   I thought SQL used the spid or something, appended to the end of the table, and maintained that reference The table isn't being dropped because there is no table in tempdb named #Archive_In. As you already said, the tabl ...Show All

• Smart Device Development Installed custom Windows CE 5.0 device SDK does not show up in Visual Studio 2005

  I am trying to build a native C++ application using Visual Studio 2005 Service Pack 1 for a custom Windows CE 5.0 device. I installed the SDK for our device on a machine running Windows XP. But the installed SDK does not show up in the 'Installed SDKs' list in Visual Studio 2005. Would anybody have any ideas as to what could be going wrong I would greatly appreciate your advice. I know a video in which Mick Hall(Senior Technical Product Manager) has a brilliant introduce about: Using Visual Studio 2005 to write native applications for Windows CE 5.0 based devices good luck :) ...Show All

• SQL Server Paging issue on conditionally set second table visibility

  Hi. I am having a problem with a 2005 report that has two tables and is designed thru visual studio. The second table is set to page break before printing and also to repeater headers on new pages. It works fine just like that. However, if I place a condition on the visibilty of the table based on an input report parameter it does not page break before rendering the table. In fact it does not page break at all leaving me with an extremely long last page. The visiblity parameter does properly toggle. This is all occurring when rendering the report to the screen using the windows reportviewer. When I export to PDF it looks fine. Any help would be great. Yeah, I would consider really hard changing that ...Show All

• Visual C++ System.Timers.Timer not elapsing

  I have a two timers in my service that will be reset after some work gets completed. The problem comes in if the service is left running for a few days, the timers will reset but then not elapse. The problem is that without the timers elapsing no work gets accomplished. Any ideas Basically, I have a service that looks for work on a queue. The timer is started at startup, when the timer elapses the timer is disabled the queue is checked for work and upon completion of the work the timer is enabled. Occasionally, the timer is enabled after work is complete but then it never elapses and there is nothing special that happens before it it just stops working usually after it has run successfully for several day ...Show All

• SQL Server Data Migration Oracle 7.16 to SQL Server 2000

  Hi, I have been asked to look at optimising a Data Migration Strategy for one of our clients. I am quite new to Data Migration (I'm actually a system designer!). The migration is from a legacy Oracle 7.16 Db to a SQL Server 2000 environment. The legacy Db has some large tables - 30 Million+ rows Table/column Mapping is 1:1 At present we are using DTS to import into the SQL environment. My question is: Is there any way to leverage the Oracle 7.16 export to speed up the migration process Any advice would be appreciated. Many thanks Mike this forum is for sql server 2005 integration services...not sql server 2000 data transformation services. i suggest that you post your questi ...Show All

• Windows Forms RowFilter property of the RelatedDataView

  Hi! Good day Why is it that the RowFilter property of the RelatedDataView class does not filter the records Is this a bug or not Here is my code snippet: CType(Ctype(Me.BindingContext(Me.GridView.DataSource,"MyRelation"),CurrencyManager).List,DataView).RowFilter="Amount>100" It does not filter anything on the RelatedDataView. Hoping for a positive response. :-) CostingDataSet . Inv_CostTypesDataTable dt = new CostingDataSet . Inv_CostTypesDataTable (); CostingDataSetTableAdapters. Inv_CostTypesTableAdapter da = new CostingDataSetTableAdapters. Inv_CostTypesTableAdapter (); da.Fill(dt); DataView dv = new DataView (dt); dv.RowFilter = "CostType = 'bank' " ; dataGri ...Show All