DeltaQ's Q&A profile
Visual Basic How to read and write text files?
My question is how to read the content of a text file into my programme, and write it into another text file created by the programme. Could anybody tell me the most common method of doing that Thanks in advance! By the way, where can I find a good online tutorial for VB6 Although VB6 is not supported: I hope I am not too late on answering this Private Sub TextFileHandling() 'To write to fi ...Show All
SQL Server Data integration challenge. Will SSIS help?
Hi, We have a requirement to do ETL on large EDI batch files into SQL Server. For this we have to map several X12 schemas - which are fairly complex - into relational schema. Right now they use Biztalk but that is not a good option for batch processing of large EDI files. Performance is really bad. Is this possible using SSIS Are there any 3rd party tools which might integrate with SSIS to make this easier or can do this as a stand-al ...Show All
Visual Basic how do i....textbox?
Well basically i want to know how i can write an IF...THEN decision structure based on the contents of a textbox. for example lets say i want to say something like IF textbox1.text (has no text in the field) THEN textbox1.text = 0 Also how do i write a code that only allows integers of a positive value to be typed and accepted into the textbox // IF textbox1.text (has no text in the field) THEN textbo ...Show All
Visual Basic DataSet Designer - Not able to use "GenerateDBDirectMethods" when using Stored Procedures problem
Hi! When using the dataset designer, I sometimes run into a relatively annoying problem. Scenario 1: I drop a datatable from the server explorer. In the wizard, I go back one step and tell it to generate the procedures for me. When I ge to the step where I can check "GenerateDBDirectMethods", I can do so. Everything works fine. Scenario 2: I have pre-prepared stored procedures. I drop a datatable from the server explorer. In the wizard I go bac ...Show All
Visual Studio Team System Error when creating new Team Project
I've worked through several resources onlnine to fix other errors in the project creation process and have just about got the New Team Project option working from Visula Studio, however I'm running into an error I can't find a solution for. In creating a project named Foo2, the creation process gets through the Currituck Module, handles some CSS and WorkItemType definitions and then throws an exception saying: ---begin Exception entry--- Time: ...Show All
Visual Studio Tools for Office problem with deploying VSTO applications
Hi, finally we have got a web page reporting a complete procedure for preparing End User computers to run Office Solutions. It's here: http://msdn2.microsoft.com/library/2ac08ee2(en-us,vs.80).aspx I had a problem when deploying my Excel project(made with VSTO in Visual Studio 2005 beta 2). I had installed .Net Framework 2.0 on the target machine, a PC with Excel 2003 installed. I had installed on the target machine the p ...Show All
SQL Server triggers and record data question
Hello, I have a need to do something in a trigger, I have read all the in's and out's of when to use or not to use a trigger, so I am not looking for an answer like that. What i am wondering is how to get the fields from a record that triggered the trigger. for example an on insert trigger...... Inserted record example: Field names: key field1 field2 field 2 field data 1 Jack filed baseball i want to do a trigg ...Show All
SQL Server Restore Analysis Backup to new DAtabase Name
I have backed up an AS database. Now I want to restore it to a new name so I have two copies to play with. How do I do this Thanks, Chris How do you get around the problem of credentials of multiple domains. Dev machine on one domain, server on anther (via VPN at client). I know I could problably copy all the files to the server and change the configs. Anybody researched this Thanks ...Show All
Visual Studio Express Editions Trouble with C++ Express Install
I have tried multiple times to instll the MSVE C++ package with no success.Everytime I try I get a MS .Net Framework 2.o installation errror, which in turn prevents the rest of the package from installing. I have/had none of the components that were not allowed to be on before I started. I even ran the vs_uninst_betas.exe to make sure I wasn't missing anything. I just do not know what to try next to get around this issue. I am running a Athlo ...Show All
Software Development for Windows Vista problems raising an event to a state machine WF from ASP.net
Hi I'm trying to use a state machine WF from ASP.net but the events are not reaching the WF instance. Here is the code that I use to load the runtime in the global.asax ManualWorkflowSchedulerService scheduler = new ManualWorkflowSchedulerService (); wr.AddService(scheduler); SqlWorkflowPersistenceService stateService = new SqlWorkflowPersistenceService ( System.Configuration. ConfigurationManager .AppSettings[ "C ...Show All
Software Development for Windows Vista i need Windows Vista how to download it
hello every one i wish u could help me to download or get the dvd of windows vista plz i need ur help Hi! I'm not really sure, but I think if you are a TechNet+ suscriber you can have a test copy: http://technet.microsoft.com/default.aspx Many regards. ...Show All
Visual Basic How can I copy an entire table row to the same table
I have to copy a table row to a new row in the same table, but with a different key. Since I have seven of these tables, each with many fields, I don't want to do it one field at a time - not just because of the work, but also the maintainability. Is there a simple way to copy a row Even a "for each field (or column )" approach would be preferable to explicit code, but I don't know how to do that in this environment. I'm using a Table Ad ...Show All
Visual Basic fontnames
Hello again How can i get the installed fontnames and add them into a combobox thnx Hello. You can use the System.Drawing.Text.InstalledFontCollection to list the installed fonts. Here is a really easy way to put these in a combobox. Hope it helps... Imports System.Drawing.Text Public Class Form1 Private Sub Form1_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load ...Show All
Smart Device Development how to remove "+" before a tree node
hi, My project is built on windows mobile 5.0 pocket pc,vs2005.I use the following code insert a tree node: TVINSERTSTRUCT InsertStruct; InsertStruct.hParent = hParent; InsertStruct.hInsertAfter = TVI_LAST; InsertStruct.item.mask = TVIF_TEXT |TVIF_IMAGE |TVIF_CHILDREN; &n ...Show All
Visual C# Collection was modified; enumeration operation may not execute
Hi there I'm trying to remove an hashtable that is inside another, that have ["OK"] = 0 for example. but i'm recieving the error: Collection was modified; enumeration operation may not execute." I'm using the following loop: foreach (string ikey in gridNum.Keys) { Hashtable aux = (Hashtable)gridNum[ikey]; if (aux["OK"].ToString().Trim() == "1") gridNumero.Remove(ikey); } gridNum is the Hashtable that have lik ...Show All
