JerryMcR's Q&A profile

• SQL Server DB2 Write Image to Blob field

  I need some help in SSIS Package I am trying to write a byte array to an image (blob) in DB2 destination. I am getting SQL code -290 Invalid Description, if i set the output column to a byte stream. If I set the output column to an Image data type then I get a different error the package will not at that time even process it errors out right away. At least using a byte stream datatype it errors out when it is about to write to the olebd destination. Anybody have success using BLOB fields in SSIS package data flow Thanks for any help. What provider you used for DB2 I have a memory that the Microsoft OLEDB provider for DB2 does not support retrieve LOB type columns, inside SSIS, yet. Please confirm with the ...Show All

• Visual C# Returning from finally block

  Why is it not possible to return from the finally clause of the try..catch block I tried writing a return statement in the finally block. The message I got while compiling was "Control cannot leave the body of a finally clause", but when I throw an exception from finally block, it compiles without any error. I guess throwing an exception and return both make the control leave the body of the finally block. Please suggest the reasons for the respective behaviours. Regards, Asim. Why would you want to return from within a finally block It exists so you can execute some code regardless of how a try block was exited. Normally you'd want to avoid throwing new exceptions there as well since if an ...Show All

• .NET Development RSA algorithm

  In RSA Algorithm public key is used to encrypt and private key to decrypt the message. RSACryptoServiceProvider RSA = new RSACryptoServiceProvider(); RSA.ExportParameters(true); true is passed as an argument to the method ExportParameters to get the private key parameters but when i run the code all the parameters(D,DQ,DP,Exponent,Modulus,InverseQ,P,Q)are returned. I want to know what are parameters related to the private key-which is used to decrpt the message. Here it is a method that I use to generate RSA public and private keys. After you call it you can see the xml. /// <summary> /// Generates 2 XML files (public and private key) /// </summary> / ...Show All

• Windows Forms To show an image in a cell of a table (but not as background)

  I want to add an image to a cell of a table that already has a date so that it goes out to the side. Since it is possible to do Again thank you; D Pd: My English is horrible, i know, i'm sorry Two ways: 1. Use e.Graphics.DrawImage() method to draw image when handling the cellPainting event. 2. Create a customized DataGridViewColumn which contains text and image. Here is a article teach you how to create a customrized DataGridView Column; ...Show All

• Visual Studio How to Add Reference Node in Custom Project VS2003

  Hi, I am novice user of VSIP and have created a new project type of my own with some ToolWindows etc in my custom project type. I looked into all the samples came with SDK but couldn't find a way of how to create Reference Node type in my project hierarchy. I first thought of adding a nested vb project to achieve this but don't think it as the right approach. Can anyone provide a sample code / suggestion to add reference node in custom project type. P.S: In MPF(2005 SDK) I found classes like ReferenceNodeContainer etc, but I have to achieve this functionality using VSIP 7.1 ( 2003 SDK ) as my package has to register with VS2003 IDE. Thanks, Nitin Hello Nitin, As you have pointed out yourself the MPF classes that sup ...Show All

• Visual Basic Capturing a section of the screen.

  I am trying to make a simple personal program and cannot figure out how to capture a section of the screen. I want it to work like prt scr does except it captures a specified rectangle instead of the entire screen. I am thinking I have to use Drawing.Graphics but am not sure. Thank you. Troy L in the exact same way. You create the size of the bitmap (dimensions) as you did above, then draw that image onto it and save it. I'm not an expert on graphics and stuff but its pretty much the same except you redefine what part you want to capture. I think the Graphics class as a method called DrawImage, you give it an image and give it the point you want to draw from/to http://msdn2.microsoft.com/en-us/library/system.drawing.graphics.drawi ...Show All

• Visual C++ MFC Toolbar Button Size Corruption

  Hi, I've just run into a problem porting an MFC application from VC++ 2003 to VC++2005. The application contains a toolbar. The toolbar has the extended style TBSTYLE_EX_DRAWDDARROWS One of the toolbar buttons has the style TBSTYLE_DROPDOWN. The toolbar is contained within a ReBar When a WM_SETTINGCHANGE message is received by the toolbar it seems to increase the size of all the buttons in the toolbar, causing parts of all button images to fall off the bottom and right edges of the toolbar. I've bugged this on connect.microsoft.com, ID229061. There is a code sample in the bug report Has anyone got workarounds for this Trapping and ignoring all WM_SETTINGCHANGE messages is not something I want to do. Steve. ...Show All

• .NET Development deleting dataset.table[0] row

  Is there a way to delete a row in the dataset and it actually removes the row and shifts the others down: DataSet looks like: dsTemp.Tables[0].Rows[0][0] dsTemp.Tables[0].Rows[1][0] dsTemp.Tables[0].Rows[2][0] dsTemp.Tables[0].Rows[3][0] Remove a row dsTemp.Tables[0].Rows.Remove(1); DataSet should look like: dsTemp.Tables[0].Rows[0][0] dsTemp.Tables[0].Rows[1][0] dsTemp.Tables[0].Rows[2][0] hi try the datarow.Delete method http://msdn2.microsoft.com/en-us/library/system.data.datarow.delete.aspx Hope this helps you out, please close the thread if it does ...Show All

• SQL Server Two report parameters: "Please select a value for the parameter...."

  I’ve build a report with Report Design. On this report I want to show the items customers bought. In this report I added a Report Parameter so the user can select a specific customer. I made an extra dataset and use the filter =@customer and this parameter works fine. Then I want to ad a second Report Parameter: the salesperson. When I leave one of the parameters blank, I get an error "Please select a value for the parameter....". Even if I choose the options allow blank or null values, I get this error. What I want is de possibility to get all the records, to filter records from one specific customer or to filter records from a specific salesperson. This is a common misconception with setting ...Show All

• Windows Forms about datagridview to show total at footer

  hi all i have windows application in which a form containing datagridview is there. in that datagridview i want to show total of values of one column at bottom. i dont know how to do that can anyone help me Hi, It would be Great if i have that Total value in the footer of the datagrid and through the client side scripting, we want to show the total value on the onBlur event of the Text Boxes (Inside onr of the columns of the datagrid). regards, Imtiyaz (.Net Developer) ...Show All

• SQL Server Help!

  Message cannot be sent whith Outlook Express! Why Do you use Outlook Express stand alone or do you try to send mails from within SQL Server What did you configure how What error did you get -- SvenC ...Show All

• Visual Studio Team System Schema Compare Problem #6

  I just did a schema compare where the source is a database and the target is my project. There should have been one difference detected (in a stored proc that needed to be updated in my project). However, the schema compare did not detect this difference. After a bit of snooping I think I've discovered the following: When a schema compare is done and the target is a project, the compare does not compare the actual source files in the project but uses the design time database. In theory, the design time database should match exactly the source files in the project. However, somehow, in my case, this isn't true. I have a stored proc in my project that is older than the version in the design time database. My questions are this. ...Show All

• Visual Studio Team System How to create AreaPath dropdown in winforms?

  Hello all! When creating a new bug in Team Explorer, you have an Area: field that holds a nice dropdown that includes a look-a-like treeview. I believe the type is called "TreePath". Anyway...I'm currently creating a winform application and would like to re-create this Area dropdown. For example purposes, when creating a bug in VSTS, the Area field looks like this: Vince Test Project -item 1 -item 2 -item 3 So far I've manage to do the following inside my winform application: NOTE: _store.Projects[9]...project 9 is the ID of the project I'm interested in. Its hardcoded for now Begin form_load --------------------------------------------------------------------------- _store = ( WorkItemStore )_currentTFS.GetService( ...Show All

• Windows Forms How to improve performance of datagridview

  Hi All, In my project i have made one monitor for showing current price and all market,its related to share bazar, for that i used datagridview and i m binding data with datagridview every second. but i faced problem with flikering in datagridview. so plz help me who to remove flikering. I used Datasource property for binding data Hi ahmedilyas at a time i am tring to bind 200 to 300 records I have called following method every 1 second private void BindRecords() { try { //Call method for get records dstOrderRecords = objOrderMonitor.GetRecord(); if (dstOrderRecords.Tables.Count != 0) { this .MonitorRowCount = dstOrderRecords.Tables[0].Rows.Count; ...Show All

• SQL Server SQL 2005 upgrade Problem - In place upgrade

  Hi, We are running a test upgrade form sql 2000 standard edition 32 bit to sql 2005 developer edition 32bit. Followed through all the steps and specified the account(SA priveleges and currently used by the 2000 version) and is the local admin on the box for the services and the setup seemed to move fine, except for when it got to the point of installing database services - This is the error message that I got: MSSQLServer could not be started. Verify you have sufficient priveleges to start system services. The was no choice but to hit cancel and then the set up progressed with a final message of 'SEtup failed'. Here is a portion of the error log: Attempting to recover in-doubt distributed transactions involving Micros ...Show All