Amos Soma's Q&A profile

• SQL Server using a text editor to open a SQL Database

  is there some way to access a corrupted database with a text editor so that I can copy over my text database to a new database file I apparently have corrupted my file headers of both the online database and my backup copy. Thanks in advance for your help I've tried to add users with the Web Admin tool and also I created an aspx page on the site to add users thinking that perhaps that would reset the problem. It is still reading an error message. If you'd like to try that out it is located at http://nappap.org/newuser.aspx thanks, any insights will prove helpful, I'm tapped out. ...Show All

• SQL Server Excel extraction issue

  I have a spreadsheet that's designed to look like a form. Does anyone know how I would create a SSIS package to extract specific cell values TIA Have you tried using the Excel Source Adapter ( http://msdn2.microsoft.com/en-us/library/ms181175.aspx ) Thanks Anjan. ...Show All

• Visual FoxPro VFP - Word Integration - Updating Existing Word Macros

  I have been updating our word integration as we port our application from fp2.6 to visual foxpro. This means that I need to develop a conversion program that will update all the old template documents that users have. The approach I am researching is that I will create new template documents and then copy the contents of the old template into the new template. Has anyone programmically copies the contents of one word document into the other. This would include text, merge fields, pictures etc. A code snippet would be greatly appreciated. thanks, Stuart That normally doesn't need automation. You can copy in many ways like copy file, filetorstr() etc. ie: StrToFile( FileToStr( getfile(&quo ...Show All

• Windows Forms How to .Save(...) a Bitmap Object in 16-bit?

  Hi all, not sure if this is the right place to post this question, couldn't find a more suitable category (GDI+ ) i have the following piece of code: Bitmap bitmap = new Bitmap(640, 480, PixelFormat.Format16bppRgb555); bitmap.Save("test.bmp"); bitmap.Dispose(); but when i looked at the properties of test.bmp (using Windows Explorer), it says "Bit Depth - 32". Also, when i re-opened the bitmap programmatically to check the PixelFormat, i.e., Bitmap bitmap = new Bitmap("test.bmp"); Console.WriteLine(bitmap.PixelFormat); bitmap.Dispose(); It says: "Format32bppArgb". How can i force the bitmap to be saved in 16-bit, i.e. "Format16bppRgb555" TIA and Regards, Edwin ...Show All

• Commerce Server Commerce Server 2007 catalogwebservice and bizTalk 2006

  Hello, I would like to update stock items in Commerce Server 2007 using BizTalk 2006. What I can see so far is that I should be using the Commerce Server Inventory BizTalk Adapter. I am not sure how you would use this Adpater to update the quantity and query the quantity of Products in the Commerce Server catalog Can anyone shed any light on this issue Thanks Dom Hey Dom, The status field is required and represents the following: Status = 1 ==> Inventory Sku is enabled Status = 0 ==> Inventory Sku is disabled. Product is always out of stock. Status = 2 ==> Inventory is ignored. Product is always in stock. When updating the Quantity for a Inventory Sku, you must indicate the Produc ...Show All

• SQL Server Cast - differences between SQL2000 and SQL2005

  I came across a problem when migrating from SQL2000 to SQL2005. Table1 - large table with multiple columns including columns (X21 varchar(50), Start datetime, Complete datetime) View1 - Only returns integer values into the dwpId column SELECT X21 AS dwpId, Start AS startDate, Complete AS endDate FROM Table1 WHERE (X21 IS NOT NULL) AND (X21 LIKE '[0-9]%') AND (ProjectID NOT LIKE '%_WI') View2 SELECT cast(dwpId as int) as dwpId, startDate, endDate FROM View1 In SQL2005, when selecting values from View2 an error is returned indicating that the statement failed when converting a varchar value to a data type int. In SQL2000, this same statement would return the appropriate rows from the view. ...Show All

• Software Development for Windows Vista Binding of reference type property to activity/workflow member.

  I'm looking for a way to bind a property of a class which is a type used by a dependencyproperty on an activity to a property on a workflow. Say I have an activity that has a DependencyProperty that is an array of type MyClass. Using the default collection editor I'm able to add MyClass items to the array and set values for MyName property. However, what I need to be able to do is bind the MyName property of the MyClass item to a existing member of my workflow. I've tried deriving MyClass from DependencyObject and making the MyName property a DependencyProperty but have not have any success in doing so. Ideally I would like to be able to enter a value for MyName or have the Binding Dialog pop up so the user can select an existing memb ...Show All

• Smart Device Development Start menu popup window

  Hello, I've googled and searched on these forums but without luck. Does anyone know how to get access to the 'Start Menu popup window' on a WM5 device I know how to get access to the taskbar using FindWindow("HHTaskBar", ""), but we would really like to get an hwnd for the window that pops up after using the start button. Thanks in advance, Peter Vrenken. The taskbar and it's start menu are owned by the Windows Mobile team. You may be able to get an answer to your question on one of their forums. Windows Mobile API : microsoft.public.pocketpc.developer microsoft.public.smartphone.developer Windows CE API : microsoft.public.windowsce.embedded General programming (not VisualStudio related) ...Show All

• Visual Studio A couple of Context Menu CTC questions

  Hello, I have a couple of questions around the context menu and ctc file entries. We have successfully placed items on the context menu in some areas but are having difficulties getting our context menu to show up in one area in specific.  We have a command that we are putting in the solution explorer context menu for the "Add" group and it is working properly.  Our CTC entry is as follows in the BUTTONS area: guidMyCmdSet:cmdidMyNewCommand, guidSHLMainMenu:IDG_VS_CTXT_PROJECT_ADD, 0x0500, guidMyCmdSet:bmpPic5, BUTTON, DYNAMICVISIBILITY, "Add My Thing..." ; Now we are also trying to add the same command for when the user right clicks on the "References" node in the project.  From our research and according to this ...Show All

• Visual C# events.

  hi all I have a method like following.. public void something() { string label1 = "myname"; string label2 = "myplace"; I have a checkbox p in here. p.CheckedChanged + = new EventHandler(pBox_Changed); } public void pBox_Changed(Object sender, System.EventArgs e) { I want to access the values of label1 and label 2 HERE. } As I said above I want to access the values of label1 and label two inside the event.. Could you pass these to the eventhandler Thank you in advance, cheers, prasad.. No, the event args are passed by the code firing the event, which exists in the CheckBox class. Your best bet is to move the declarations of label1 and label2 out of the something method and make them ...Show All

• .NET Development DataTable.Load() Generates InvalidOperationException

  Hello All: I am having a problem with the following code generating a "InvalidOperationException". The exception is thrown sometime, but not all the times. Does anyone have any idea why this code may be causing DataTable.Load() to throw that exception Thank you kindly. Jerry... p.s. Please forgive the cross-post. I must have inadvertantly posted this to WindowsForms. ***** Start Here ***** public partial class CollectionDetailStatusDataTable { public event TableFillingEvent TableFilling = null; private EventWaitHandle tableFilledWaitHandle = new ManualResetEvent(false); private CollectionDetailStatusTableAdapter tableAdapter = null; public CollectionDetailStatusTableAdapter Adapter { get { if (tableAdapter == nu ...Show All

• Visual C++ In vc2005, if I can not see .cpp file in the solution explorer, but I do open that .cpp file for editing, how can I compile thi

  In vc2005, if I can not see .cpp file in the solution explorer, but I do open that .cpp file for editing, how can I compile this cpp file,I mean the entry button for this. I appreciate your help. In Visual C++ 2005 a *.cpp file needs to be part of a solution in order to be compiled. The only way to compile a single *.cpp file without a project/solution is to do it from a command prompt. ...Show All

• Visual Studio Team System Data Scrambling

  Hi, I am trying to scramble the existing data from existing database and creating a new database with meaning ful data. But as of I know, DB professionals is allowing us to generate data which is not at all related to the existing data of the existing database. Is anybody aware of the way to do it Ok, let's just assume you want to apply a formular on the existing data and generate new data into the column. Without implementing a custom generator, you can use Data Bound Generator to pull the existing data from another data source, apply a formular on the data and generate new data into the column that is using the Data Bound Generator. In the following forum thread http://forums.microsoft.com/MSDN/Sh ...Show All

• Visual C# How can I move the focus to particular Tab Page in Tab Control?

  I have tried to move the focus to particular tab page in tab control at run time. It can not get the focus to the specified page. Here is the code that I had tested this issue. this .tabControl1.TabPages[2].Focus(); Thanks in advance. hi, you have to use the selectedindex property to switch between the tab pages.   this.tabControl1.SelectedIndex = <Tab Page Index to be focused> (e.g.) this.tabControl1.SelectedIndex = 1; i think it would help you. Regards, Perumal.R ...Show All

• Visual Basic Program Error HELP !!!!

  I am using VB.Net 2003 and an Access dB All of a sudden my app has develooped an error in a place where I wasn't making any changes. (So I think) My problem is happening when I am trying to fill a dataset. I have two tables. Part Numbers and Serial Numbers. I also created a dataset that contains both tables and a connection object. In my code I have the following: PNAdapter.SelectCommand.CommandText = " SELECT Batched, [Expiry Date ], Location, Notes, [Part Description], [Part Number], QOH, Serialized, [Time Lifed] FROM Parts" PNAdapter.Fill(Join, "Parts") SNAdapter.Fill(Join, "Serials") the program is bombing on the first line, saying An unhandled exception of type 'System.NullRefere ...Show All