Jeanvo's Q&A profile

• Microsoft ISV Community Center Forums String parsing in Express VB

  New to VB. Simply trying to parse the zip code out of a string and placing the zip code into a new string. Looking at the Split method, but unable to get code working w/o errors. Sample string I am trying to parse is: 'Bakersfield,A CAA 93309 Any suggestions on the code snippet to remove the zip out of this string Thanks in advance. CT Thank you for the quick response. I just figured out that I am actually inside the VBA 6.3 IDE launched from Excel. It seems the variable declaration is not as advanced in VBA as VB Express edition. Would you know how to do this string extraction inside VBA 6.3 using a module This way I am already 'inside' my Excel worksheet. Thanks CT ...Show All

• Windows Forms DataGridView vs DataGrid vs VB6 DataGrid

  I have a project that I am upgrading from a VB6 application. In VB6 I used a datagrid to display my recordset: Set DataGrid1.DataSource = rsTB Now I am using VB.NET I am trying to do something similar I can call this line using a DataGridView dgvMain.DataSource = rsTB But nothing is displayed. I have even tried to use a DataGrid but get the following error: 'Complex Data Binding accepts as a data source either an IList or an IListSource' Does anyone have any pointers to get me going Thanks .NET uses an entirely different data architecture from that of VB6. Instead of connected recordsets, ADO.NET (usually) uses disconnected DataSets populated (most often) by DataAdapters. Check out one of the many helpful ...Show All

• Visual C# Capturing text from input

  Hi, I'm new to C# so please, bear with me! I'm trying to write a program which will respond to input from an IRC channel with a response based on that input. This is the start of my else-if statement. else if (inputLine.EndsWith( ":!test" )) What I would like is to be able to capture a word (or more than one word) typed after the "!test" and store t as a string to be used in the message sent back to the IRC channel. I've got all of the sending and recieving of message sorted - it's just this bit which I'm struggling with - is Regex the answer Thanks, Martin Hi again It turns out that that didn't work - I program now takes a long time to parse the Match m=reg.M ...Show All

• Visual Studio Tools for Office excel crashes with system.io.fileloadexception when running vsto application

  Excel loads the vsto application and customization assemly. The XLS and DLL are deployed locally in the same folder. When I run some functions of the VSTO application - particularly where it opens the database connection (via Sybase ASE Client), it crashes excel with the following error logged into event viewer: EventType clr20r3, P1 excel.exe, P2 11.0.8105.0, P3 44ed0d35, P4 mscorlib, P5 2.0.0.0, P6 4333ab80, P7 3aef, P8 ae, P9 system.io.fileloadexception, P10 NIL. Also when I delpoy the assembly via http, the IIS log shows that Excel is trying to load the .resources assembly but is not able to: 23:19:39 161.15.204.77 GET /vsto/MyAssembly.dll.config 200 23:19:39 161.15.204.77 GET /vsto/en-US/MyAssembly.resources.DLL 404 23:19 ...Show All

• SQL Server CONDITIONAL SPLIT and Bulk load Insert Error

  i need to use a conditional split transformation to find missing column and direct the output of conditional split to my destination. I have the following columns PatientId, Allergycode, SeverityCode My requirement is to check whether value of a particular column is null or not null. Please help. Ronald When i use case12 (MedicineCode) as an output to the Data conversion. When i execute the package, it writes 57 rows to the destination table instead of 58 rows. Ronald SSIS package "Conditional.dtsx" starting. Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning. Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning. Info ...Show All

• Visual Studio 2008 (Pre-release) Difference between SQLMetal and DLinq Designer

  I have just gotten into using Dlinq and am not sure of the difference between SQLMetal and the Desinger...at first they seem to do the same thing...which looks like to create the class's for the tables. Correct Thanks Harold Technically speaking, they do the same thing. They generate entity classes to manage your database. But, there are few differences: 1) DLinq designer generates code different from the SQLMetal tool. Moreover, it contains at least a bug (see http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=443175&SiteID=1 ). 2) SQLMetal doesn't provide table selection, it will create entity classes for each database table found in the target DB. Dlinq allows you to select single tables. ...Show All

• .NET Development help needed in pixel operation

  hi, I want to know the difference of the below, 1. Doing image operation with the manipulation of getPixel() and setPixel() methods. 2. getting the address of the first pixel data in the bitmap using the code, BitmapData bmData = b.LockBits(new Rectangle(0, 0, b.Width, b.Height), ImageLockMode.ReadWrite, PixelFormat.Format24bppRgb); int stride = bmData.Stride; System.IntPtr Scan0 = bmData.Scan0; How these two differ thanks in advance. Uvaraj T I am using unsafe block and pointers to change the pixel value. Other way to do the same operaion is using setpixel without using the pointer. Which one is efficent and how the two differs ...Show All

• SQL Server error code 0xC0202025

  i need to export the contents of a sql server 2005 table to excel in ssis. there are two nvarchar(max) colums in my table. the data flow task in my package fails unless i remove these two columns from the table, then it works fine. the error code being returned is 0xC0202025. HELP! http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=412859&SiteID=1 ...Show All

• Internet Explorer Development How to determine the version of IE

  I have been writing a BHO. How can I determine which version of IE is hosting the control http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=929174&SiteID=1 ...Show All

• SQL Server sqlexpress sa connection

  I am having the same problem described in the previous posts. Everything was working fine, then I got up one morning and everything was haywire. I am working on a web site and when I try to login in I get the error message Login failed for user 'SA' because the account is currently locked out . I went to my SQL Server and was able to log in using my windows authentication. 1. My Server was set up for Sql Server and Windows Authentication mode 2. Most of the database permissions for sa were gone. When I tried to adder use SA to any database role I got the error message Cannot use the special Principal SA (Sql Server Error message 15405) 3. I logged on to the server as SA and got the same results listed above. 4. I ...Show All

• Visual Studio How to make CompleteWord feature to be called by CTRL+Space?

  How to make CompleteWord feature to be called by CTRL+Space shortcut Hi there, I have implemented Word Complete feature for my custom MPF based language service. But I can only to show my combo with the set of possible completions by CTRL +K,W shortcut. It’s very inconvenient. The more habitual way for me is to press CTRL+Space shortcut when I want to see a list of possible completions. Does anybody know how to make Word Complete feature to be called by CTRL+Space shortcut Any help will be much appreciated. Thanks! Hi slush_puppy, Thanks for the tip! It works great. But I'd like to assign it programmatically (e.g. on first package initialization). I have never deal with assigning ...Show All

• SQL Server Connection Issues To Report Services

  Hello all, I just installed the SQL 2k5 standard suite of services on a w2k3 enterprise edition server. All went well except for the connection to the reporting server. I get the error below. "No connection could be made because the target machine actively refused it" I can't seem to find any information on this error and have no clue where to even start. I've done 10+ installations of this software on various machines and have not encountered this error on any of them. I have uninstalled, then reinstalled the reporting services and still no solution. All connection attempts are being made on the actual server, not from a desktop. sp1 for sql 2k5 is also installed, if that helps. Windows Firewall is off. What w ...Show All

• Software Development for Windows Vista How to call webservices in a workflow in an asynchronous way

  Hi, I am doing R&D on the features of Windows Workflow Foundation which we are going to apply for our project after release of WWF. we are using SOA Architecture. So I need to call services based on the rules. I have succeded in doing them practically using Sequential and State Machine Workflow. So, now I want to achieve Asynchronous way of calling webservices. I don't know whether this can be possible with WWF or not. If it is possible, can any body please help me in doing this. Thanks in advance. Hi Satya, All workflow instances are asynchronous since their lifetime is managed by the workflow runtime. Hence the caller starts them using the InvokeWebservice Activity and carry on with the other work. Use the Webservi ...Show All

• Software Development for Windows Vista What concretely meaning is "DocumentBannerSheetSource"?

  In regard to "DocumentBannerSheetSource", as follows it is in the explanation of SDK. - Specifies the source for a custom banner sheet. What do you concretely call " source " - Is it a name of the setting - Is it URI that refers to something - Is it InputBin It doesn't understand similarly well for the following. - xxxCoverBackSource - xxxCoverFrontSource - xxxBannerSheetSource - xxxErrorSheetSource I hope the explanation about which someone is well informed. There were the following comments in the explanation of following URL. http://msdn2.microsoft.com/en-us/library/ms716429.aspx <psf:Feature name="psk:DocumentBannerSheet">   <psf:Property name="psf: ...Show All

• SQL Server Timeout error while executing procedure

  Hi, I have written a stored procedure that i then execute in a loop within a wrapper procedure: WHILE somecondition BEGIN EXEC dbo.PROC1 END If i run the procedure manually i can run it time after time with no error. However if i execute the procedure above i get a timeout error after about 2 or 3 loops. How can i avoid this I have been reading everywhere and i dont seem to be able to find a solution... It is not clear where you are seeing the timeout error. If the procedure indeed takes long then you will have to increase the timeout value on the client side or optimize the SP. The command timeout is typically 30 seconds on the client side for most data access API. Alternat ...Show All