JeffM's Q&A profile

• Visual Basic (NEWB) Using .split()?

  VB express '05 Beta I have a large string (about 40 pages worth of data) That I need to parcel into smaller chunks, there are repeating markers in the data that I want to use as delimiters.  txtimp is the large raw string, and hand() is the string array that I want to have the data chopped into. I'm using: stray()=txtimp.split("Data")   But, It is only searching for "D", not "Data".  There are frequent D's in the text, so It's giving me many smaller strings I dont want. In the IDE, when Inputting the string I want it to search for, it gives me a list of ten choices of versions of split to use.  I always select the ...Show All

• Windows Forms numericUpDown

  I use nud in databindings: numericUpDown.DataBindings.Add( "Value" , fbs, "Tamanho" , True ).NullValue = 0 When the Sql Server returns NullValue the nud not use the 0. The nud use the last value. Sample: Records Value in DataBase Value in numericUpDown when bindings (bindingnavigator) 1 121 121 2 20 20 3 Null 20 (repeat last) 4 Null 20 (repeat last) Any suggestion ...Show All

• Windows Forms How can I get IP address ?

  Get IP address C# code. using System.Net; IPHostEntry hostEntry = Dns.Resolve("www.windowsforms.com"); IPAddress address = hostEntry.AddressList[0]; ...Show All

• Visual Studio 2008 (Pre-release) Cascade delete support ?

  Hi, I've hit a problem concerning cascade deletes on foreign keys in SQL. I have in my 'noddy' app again a contact with many address emails . This is managed via a ContactAddressEmail table. This table has a unique PK and corresponding non-nullable FKs. Now I've marked the foreign key betwen Contact and ContactAddressEmail as 'Cascade' for the Delete Rule on the relation. Same for the AddressEmail and ContactAddressEmail relation. When testing in TSQL this is fine - any Contact I delete results in the associated ContactAddressEmail record being removed. Likewise for the AddressEmail record. Magic. However, in LINQ when I db.C ...Show All

• SQL Server Trial Upgrade to purchased version

  We started out with the trial version of sql2005 and we later purchased the full standard version I belive, I just realized our trial is going to expire which we have data we are using on it. Is it possible to enter our liscense number in the trial to continue using or do I have to detach all of the databases and install the new sql version and then reattach all of the databases and setup any maintence plans again. I think this can be done though a normal setup process with choosing the upgrade option. Anyway, I would backup my database first before I would try a inplace upgrade :-) HTH, Jens Suessmeyer. --- ...Show All

• SQL Server TYPE I SCD in SSIS

  I apologize for the lengthy posting. We recently converted our ETL architecture from DTS/Stored Procs to SSIS Beta, and now GA.  One of the main draws for using SSIS was the SCD transformer.  Throughout the various builds we have experienced anomalies in the SCD behavior. While most issues were mitigated by patching up to the next build or rebuilding the data flow from scratch, there is an issue with a specific data flow implementing  SCD - TYPE I. The data types, lengths are all the same between the dim and the incoming records but the SCD determines that all of the records should be updated regardless of any Deltas. I ...Show All

• Visual Basic [OTP] VBA transfering VB ActiveX control data to another file

  Howdy folks, I need to be able to transfer text data from an ActiveX control (a textbox) in one file to an ActiveX control in another file. Currently, I can move the textbox data to the spreadsheet in VB as follows: Range("k5").Value = TextBox1.Value and then I tie the TextBox LinkedCell property in the secondary file to the cell in the primary file: '[primaryfile.xls]'Worksheet1'!$K$5 I would like to be able to do this in one step in VB. I would be thankful for any ideas. tracy These forums are for VB.NET questions. The VB within Excel is Visual Basic for Application. VBA is a very di ...Show All

• Visual C# 'Exclude Files From Project' - Beta 2

  How do I 'Exclude Files From Project' in VS 2005   I have a solution that requires files to exists in the directory structure but not be compiled. Where has this functionality moved to   Also, what happened to the 'Show All Files' option Regards, I am having the same problem with the same tools. please let me know if you find a work around ...Show All

• Visual Studio Object reference not set to an instance of an object trying to save a change to an xsd

  I started getting this after copying and trying to modify an xsd from one box to another. One simple mod, setting a default value for a column. I'm on production VS2005. Can you try reporting a bug on the Microsoft Product Feedback Center Be sure to include the XSD that is having the problem. Regards David ...Show All

• SQL Server Transfer Access database into SQL Server 2005 Express

  Hi, A question regarding SQL Server 2005 Express edition. Is it possible to export Access databases into SQL databases without using programming (e.g. using SQL and programming languages) I understand you can do this with DTS, but the Express edition seems not have DTS. Many thanks Yuelin Yes, I was using the wrong sql server name. I assumed the server name that Access finds is correct. For instance, Access listed "WKS-C0" as the default sql server name. I wanted to use the local server so I assumed access had found the correct name and shortened it for some reason, but I c ...Show All

• Windows Forms How to use datasets across multiple forms?

  I'm having a hard time understanding what the method is to create a copy of the database within my application using a single dataconnection and data adapters   In other words, all of the examples you see regarding datasets, etc. show you dragging and dropping your table onto the form which creates a connection object, data adapter object, and finally  ...Show All

• SQL Server using TransactionOption in April CTP

  Hello. I am using April CTP. In the main package, i am setting the TransactionOption to Required whereas in the child packages to Supported. But i'm getting the following error: The DTS Runtime has failed to start the distributed transaction due to error 0x8004D01C "A connection with the transaction manager was lost.". The DTC transaction failed to start. This could occur because the MSDTC Service is not running. However the MSDTC service is running. What could be the cause Thanks Christina Hi Christina, I'm getting the same error. I know it happended to you a year ago, but do you st ...Show All

• SQL Server Failed to reinstall sql server 05

  Hi guys, I had sql server 05 RTM Developer installed on my laptop before and decided to remove and reinstall it. because i want it on a different drive. I went ahead and uninstalled everything that had to do SQL Server 2005. When I come to reinstall it, it throws me with an error saying, - Performance Monitor Counter Requirement (Error) Messages Performance Monitor Counter Requirement The System Configuration Check for Performance Monitor counter registry value has failed. For details, see How to: Increment the Counter Registry Key for Setup in SQL Server 2005, in the readme file or in SQL Server Books Online. I looked up the f ...Show All

• Visual C++ VC++ 2005 redistributable (vcredist_x86.exe etc.)

  Hi there, I noticed that the Beta 2 redistributable is hosted on the Microsoft download library, but the final ones seems not to be. Will it be hosted on microsoft.com (or is it already somewhere ). Also, it has been reported to me that on Windows 2000 the (RTM) redistributal gives an unuseful error message if Windows Installer 3.1 is not installed. The message is error 1723. "A DLL required for this install to complete could not be run." . It would be a lot more helpful to my users if this was a more informative error message - the solution of installing Windows Installer 3.1 was only found by trial and error. Thanks. ...Show All

• Smart Device Development Real Time audio recording

  Hi, I've made a program using w32 API to record audio using eVC++ 4.0. Actually I need audio frames to be processed in real time and those frames must be 30ms long so I calculated the size of the buffer (dwBufferSize in WAVEHDR structures) to be that long (ie., at 8Khz,16bits,1channel, buffer size should be 480 bytes). I also use double-buffering and pick the ready buffers when my callback function is called with the WIM_DONE message. First of all I tried the audio recording code in my PC (compiling it with VC++ 6.0) and it worked perfectly...I made a rough measure of the time between arriving frames (ie, between two WIM_DONE me ...Show All