bil54321's Q&A profile

• SQL Server SQL2005 equivalent of the data import task in SQL2000

  I had to upgrade to SQL2005 when my customer did so. Everything went OK until I had to load additional data to the datamart. The SQL2000 task to load data from flat text files was straight forward and literally took me seconds tyo set up and execute and has never given me problems. I have now spent 3 days straight trying to do the same in SQL2005 going in ever wider circles. I have got SSIS up and going, I saved a dtsx package that won't run without a multitude of errors ranging from truncation errors (which I tried to avoid by meticulously ensuring all field definitions on the import and export side are defined and correct) to errors relati ...Show All

• Visual Studio Express Editions How do I round a number to nearest .5

  I have a formula in my program which returns values such as 4.67. I would like it to round that value to the nearest .5. In this example, I would like a return value of 4.5. Does anyone know how to do this I am not very familiar with the Round functions. Thanks a bunch. Melissa CY = (TextBoxDepth.Text / 12) * (TextBoxLength.Text * TextBoxWidth.Text) / 27 CYR = Math.Round(CY, 1) - not sure what to put here Melissa, I don't think Math.Round will get you the answer that you want. First the variable CY must be typed as Decimal. Then the second parameter will round the number to a number of decimal ...Show All

• Visual Basic Creating Tables with sql express

  I know this deals with ms sql express more so than vb.net but it correlates b/c I want to edit the database with vb.net express. On to my question... I'm trying to learn how to use ms sql express using the SQL Express Manager. However, I can't seem to figure out how to create tables. I'm reading http://msdn.microsoft.com/SQL/2005/getstarted/default.aspx pull=/msdnmag/issues/04/09/expresseditions/toc.asp  but it seems outdated and I can't replicate what he's doing in the tutorial. I'm not a total novice when it comes to programming, but SQL Express Manager isn't as intuitive as one might think, there's no "Create Table" context menu. Can ...Show All

• Visual Studio Express Editions Crystal Report and VB 2005 express

  I have download the VB 2005 Express.  But I can not find the crystal report.  How Can I upgrade my project Thank you.   The crystal reports system does not come with the express products, you need to have the professional or team systems. Have a lok at the product line for the Visual Studio systems ...Show All

• Visual Studio Express Editions Problem reclaiming memory when resizing dynamic arrays

  The following code throws an OutOfMemory exception under Win2K using VB Express 2005. The same code works perfectly unfer WinXP and Visual Studio 2005. After experimentation I've narrowed the problem down to dynamic arrays that remain inscope during the resize. It seems memory isn't completely reclaimed with each resize and slowly (or very quickly in this example) the OutOfMemory exception is thrown. I'm guessing this is a bug in the particular build of VB used in Express Is there a fix other than my workaround shown in the code Thanks :-) Option Explicit On Option Strict On 'When resizing dynamic arrays memory is not fully reclaimed until ...Show All

• Visual Studio Help with Scatter chart

  I need to plot a point on a graph and I am using XY Scatter chart. I have the following questions regarding this. 1. I can set the data range for the y-axis, but how do I set this for the x-axis My range is static (30 - 110) and there is no need for me to change this dynamically during run time. 2. Is there a way for me to set the background of my chart to an image Hello, 1. If you right click on the chart to get the context menu and then select Format Chart|Grid you should get the Numeric Axis Grids and Scales dialog.  From here select the X Axis tab on the left and then Scales tab on the top.  Th ...Show All

• Windows Forms Close button not responding

  Hi, I'm writing a C# windows forms application.  I've a strange problem in this.  Some times, I'm not able to close my appl in the following ways : 1. by clicking on the close button of the form. 2. by clicking on the tool bar button, which calls this.Close(); 3. by clicking on the Close option on the menu which you get when you right cl ...Show All

• Visual Studio Custom Editor

  I am currently trying to integrate a custom editor (for an in house scripting language) within visual studio. The editor itself has been build as a seperate windows application. However, i wanted to convert it into a VSPackage. I have read whatever is available in the VSIP sdk, but that's not much! I have also looked into the basic edit sample (provided with the VSIP sdk), but i somehow feel that it might not be the best way of getting things done! Is there any other information available online, if possible, the source code of a well designed package Thanks in advance. For an example of a well designed package have a look at the new ...Show All

• SQL Server Problems running SQL Agent Jobs & SSIS Packages

  I'm having some difficulties with the SQL Agent and running my SSIS packages. At present, I have several packages that import data from Oracle, a few that use a JODBC connection and several more that transfer data from other SQL servers (2000) I originally had the SQL Agent log in as a System Account, and although the pacages run fine if I manually right click and execute them, if I add them to a Job they fail with a login error. I then changed the login details to my domain account and the Jobs that run accross the SQL servers run fine. However the others that use Oracle and JODBC still fail with login errors. I've tried creating Credenti ...Show All

• Visual Studio Team System Change of Team Explorer User

  Hi, I have TFS Beta 3 client installed. For the first time I tried to connect to TFS, it prompted me for user/pass. I entered and also checked "remember me" checkbox. Now everytime i connect to the TFS, it doesn't ask user/pass to me. Now I want to change the user to connect to same TFS. How can I change that I'm new to TFS, please guide. Regards, Hi, I noticed the following behavior with TFS RTM version. I guess there are some differences between Beta3 and RTM 1) Every time I open VS (if Team Explorer was open while closing previous VS session) I get a login prompt also there is no &q ...Show All

• .NET Development Cryptography custom sink

  Hello! For my thesis i would like to contruct a custom sink wich encryptes my data. I tried with tcp, binary formatter and Rijndael as crypto algorithm.. but it doesn’t work. Here ist my encrypting code: public Stream Encrypt(Stream source) {    try {           RijndaelManaged myRijndael = new RijndaelManaged();           byte [] toEncrypt = new byte [( int )source.Length];           ICryptoTransform encryptor=myRijndael.CreateEncryptor(key,IV);        &n ...Show All

• Visual FoxPro VFP 9.0 SQL worthless under a non client server network?

  Hello everyone; I have posted this problem here and also on UT and no solution yet. I have a small network with a 2003 server, and XP pros. I am running vfp 9 select * from products where status = "S0000" takes apx 10 seconds when run over the network. When running this locally, it takes only a fraction of a second. The product table contains 100,000 records, and the result of the SQL command is just a few hundred records. I have checked sys(2023) and my temp files are on my c: drive. Does this mean that VFP has to run in a client-server environment in order for SQL commands to be performing reasonably ...Show All

• Visual Basic Time being lost when storing DateTime.Now to Access Database

  I'm using a VB.NET 2003 front end to an Access database. One field in the database is of typpe Date/Time. When I add a record to the database in my application (using DateTime.Now to fill this field) everything seems to be fine - both time and date are displayed. Yet once I have existed my application and look at the Access database directly, I find the record is added correctly, but the Date/Time field contains only the date. When I run my application again the time will be missing from this entry, too. Is it a problem with my UpdateCommand or InsertCommand strings Or perhaps a problem with the way I have structured the Access database Very ...Show All

• Windows Forms Cancel Selected Index change ListView

  I have a ListView, for each item from listView I have a collection of data that I display, and the user can change. If one item is selected and the user change any information into the form then on change current selected index I whant to ask the user if he whant's to save with YesNoCancel option, I implemented Yes and No but for Cancel I didn't find a way. The ListView is in Detail View, with fullrowselect, single selection. Thanks This is a Windows Forms question. Therefore I'm moving it to the Windows Forms area where you may find a better answer to your question. Please reserve this section for qu ...Show All

• Visual Basic How to get Stings of 8 bit Chars from Comm Port

  I am using an MSDN RS232 sample VB code in VSTS2005 to read and write from/to the Com1 port. But the example uses System.Text.ASCIIEncoding.GetString which only handles 7-bit ASCII characters, not 8-bit. I don't see any Encoding format that will return strings of simple 8 bit bytes of characters from the Serial port unmodified. What Encoding code can I use for simple strings of 8-bit bytes so that I can handle 8-bit binary data from the COM1 port properly How can I convert Byte Array into Strings of 8 bit characters Thanks for your Help. No, that's not quite what I need. I don't want to convert th ...Show All