Joel Harris's Q&A profile

• Visual Basic My.Settings and Hashtable

  Does someone have an example of using a hashtable datatype in VS2005 my.settings In the VS settings designer, the field, ScreenLayout is defined with a datatype of hashtable. I created a test application to do this. see the following code: My .Settings.ScreenLayout = New Hashtable My .Settings.ScreenLayout.Add( "one" , "one in hash" ) My .Settings.ScreenLayout.Add( "two" , "two in hash" ) My .Settings.ScreenLayout.Add( "three" , "three in hash" ) My .Settings.Save() When I run the application the first time, I can access the values from the hashtable in my.settings. Yet when run the application the second time and examine my.settings.ScreenLayout ...Show All

• Commerce Server Starter Site problemos

  Hi Guys, I have finally walked through the entire installation guide, concluding all the post-install steps. I then tried to install the Commerce Server "Starter Site" [1]. When I access my commerce server site, I get the following Unable to cast COM object of type 'Microsoft.CommerceServer.Interop.PooledPipelineClass' to interface type 'Microsoft.CommerceServer.Interop.IPipeline'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{07D62D90-1E56-11D1-B888-00C04FD7A0F9}' failed due to the following error: Interface not registered (Exception from HRESULT: 0x80040155). Does anyone have any idea where I can start searching Did the installation not register something I ...Show All

• Visual Basic Number to an array.

  How would i send a number a digit at a time to an array like so: 123456789 to an array dim number(8) number(0) = 1 number(1) = 2 number(2) = 3 number(3) = 4 number(4) = 5 number(5) = 6 number(6) = 7 number(7) = 8 number(8) = 9 Thank you for your help. One way is      Dim st As String = "123"         If st.Length > 0 Then             Dim number(st.Length - 1) as integer             Dim i As Integer = 0             For i = 0 To st.Length - 1       &n ...Show All

• Visual C# textbox issues

  Hello. I got a little program that requires a user to enter in a charicter name. Using an if statement, I got it so the user cannot just simply press the accept button and bypass entering something. The problem is that I found out that I can just simply put in a space of two and my whole if idea gets bypassed. I though about using the validating feature, but I beleave that would force me to have the user enter a name that is X charicters long and contains no spaces. Is there a way to force the user to enter something in other than just spaces works but I get one undesired result. When I press the accept button (button1), it still closes the form and opens the next form. Here's what I have: private void button1_Click( obje ...Show All

• SQL Server How to exeute dmx query?

  hi, I am using CLR stored procedure having my dmx query.I need to exeute that Query and get the resultset as dataset how to do this Here is my code sample namespace PredictPerformance { class perf { public static dataset getPredict(int StudID) { ---- return ds; } } } Execute the proc: SELECT PredictPerformance.getPredict(1) FROM [Stud_Model] how to get the result Thanks, Karthik. If your dataset contains a single table, then it is much better to change your stored procedure to return a DataTable object rather than a dataset. If you really need a data set (i.e. with the current syntax), the stored procedure will return a single text cell containing the XML serialization of t ...Show All

• Visual C# Convert VB to C#

  Well, i have tried at least 3 apps, to convert the code, but neither of them worked! VB CODE: For Each queryObj As ManagementObject in searcher.Get() Dim arrVendorSpecific As Byte() = queryObj("VendorSpecific") MsgBox("Temperature = " & arrVendorSpecific(101)) C# CODE: foreach (ManagementObject queryObj in searcher.Get()) { Byte[] arrVendorSpecific = (byte[])(queryObj["VendorSpecific"]); Console.WriteLine("Temperature = " + arrVendorSpecific(101)); } This ir the error i get with the C# code: 'arrVendorSpecific' is a 'variable' but is used like a 'method' ps: the VB code works fine! Which 3 did you try Any converter that misses the square brackets on ...Show All

• Visual Studio Tools for Office Smart tag development not part of the vsto.

  Hello, I would like to develop a smart tag project which will deploy to all the office application as : word, excel and outlook, not just part of a specific word development. In version 1.1 smart tag were register in the registry and all the office document word, xl and outlook identify the smart tag automatically and behave as expected. Now when I develop a smart tag it must be part of word or excel application and its not what we need, Can you please solve this issue and send us a link or an example how to develop a smart tag and catch all the office documents bye regards Yaron karni. www.attunity.com - InFocus - Workplace application yaronkarni@attunity.com Hi, I already watched the linked y ...Show All

• Visual Studio Express Editions Toolstrip Combo Box Problem

  Hey all, I am creating a web browser with an address toolbar that closely resembles the address toolbar in Internet Explorer 6:  Label that says "Address", Address combo box, and the Go button.  On my address toolbar, I cannot make the size of the address box (combo box) the length of the window minus the length of the label and button.  Basically I am wanting the combo box to be between the address label and the go button and to be the size of the length of the window.  Any suggestions   Thanks. By the way... anybody know where I can get a bunch of icons like the ones in Windows and Office 2003   I need an icon for the Go button, Open, Save, Print, etc.  Thanks again. Hi, take a look at ...Show All

• .NET Development Alter table on access database...?

  How can I aply sql command Alter table on access database I found this but I think it isn't VB 2005 Sub Create_Table_Script() Dim db As Database Set db = OpenDatabase(" yourcustomers .mdb") 'alter employees table to add foreign key reference as above db.Execute " ALTER TABLE M_Employees ADD CONSTRAINT fk_Employee_Dept FOREIGN KEY (Dept_ID) REFERENCES L_Departments (Dept_ID);" db.Close End Sub Thank you. If you're wanting to use VB.NET 2005, then you need to do something along the following lines: Dim strConnectionString As String strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Sou ...Show All

• Visual Studio 2008 (Pre-release) Implementing IErrorHandler

  I have a design decision involving how to go about implementing the IErrorHandler interface for a WCF service that includes about 40 seperate service implementations. Each implementation may throw a number of common fault exceptions. Of course, my goal is to avoid implementing try/catch blocks repetitively through the service operation code I have researched this and found three methods for doing this: Implement the IErrorHandler interface on each service. While repetitive, this allows me to only handle Fault Contracts specifically defined for a particular service. Implement the IErrorHandler interface in a base class for the 40 service classes. The biggest downside of this is that it will need to handle all the possible Fault Contracts d ...Show All

• SQL Server run SSIS package with ODBC connection via SQL agent

  It seems there a lot of problems running SSIS packages under the sql agent. I have read the knowledgebase articles regarding permission issues etc but I still can't get my job to run. I can run any package as a job apart from a package that connects to an external database via an odbc connection. Has anyone had any luck with this and can let me in on the secret. Hi Andy, FYI: The problem was solved. What I did are list as below: A. We created a new web app pool and pointed the both web application and web service to this web app pool (which was configured not use default identity - Predefined: Network Service but use Configurable - created a new use name). B. Under SQL server , added this new use ...Show All

• SQL Server Import errors from Excel to SQL 2005 DB Table

  How frustrating is this, all I want to peform is a one column to one column Import here! Why am I getting this error when simply trying to import from my excel workbook to my table  I know excel has a 255 char cell, but I specified to only account for 100 characters during the SSIS Import wizard in Management Studio.  This is using SQL 2005. See the setup here http: / / www. webfound. net/ excel_ import. jpg Then I get this error during the import:  Validating (Error) Messages Warning 0x802092a7: Data Flow Task: Truncation may occur due to inserting data from data flow column "F1" with a length of 255 to database column "Name" with a length of 100.  (SQL Server Import and Export Wizard)   Warning 0x8004707 ...Show All

• Windows Forms Window class name is not valid.

  I get this error about 75% of the time I try to debug in Visual Studio 2005.  I have reinstalled VS and applied the latest service pack with no relief.  It never happens if I run without debugging, only when I try to debug.   It happens with every project I create, it's not isolated to a single project or solution.  Any help is greatly appreciated. It’s always thrown on this line (or equivalent): public static void Main( string [] args) { Application .Run( new MainForm ()); } System.ComponentModel.Win32Exception was unhandled   Message="Window class name is not valid."   Source="System.Windows.Forms"   ErrorCode=-2147467259   NativeErrorCode=0 &nbs ...Show All

• SQL Server how to use the OLEDB command to call a oracle function?

  HI, I want to use the OLEDB command to call a oracle function, but i havnt found any materials about how to do that, my oracle function is as below: CREATE OR REPLACE function GET_ZONEID_FROM_SYFZ(ycz varchar2,xc varchar2,strat_id varchar2) return varchar2 IS  zone_id_result varchar2(10) ; begin  PKG_DM_DQ.GET_ZONEID_FROM_SYFZ(ycz,xc,strat_id,zone_id_result);  return zone_id_result; end; In OLEDB command transformation component, i fill the sql command with "select GET_ZONEID_FROM_SYFZ( , , ) from dual", but i dont have it worked. The error message is :provider can not derive parameter information and setparameterinfo has not been called. Who have any idea about how to make it work Thanks ~~   ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Do render targets have to be the same size as the back buffer?

  Hi, I have a render target set up as: screenBuffer = new Texture2D(graphics.GraphicsDevice, 1280, 720, 1, ResourceUsage.RenderTarget, SurfaceFormat.Color, ResourcePool.Default); When the back buffer is set to 1280,720 (the same size as the render target) the code below works and the screen displays a blue background as expected. //Set device to render target graphics.GraphicsDevice.SetRenderTarget(0, screenBuffer.GetSurfaceLevel(0)); graphics.GraphicsDevice.Clear(Color.Blue); //Set the render target to the back buffer graphics.GraphicsDevice.SetRenderTarget(0, graphics.GraphicsDevice.GetBackBuffer(0, 0)); graphics.GraphicsDevice.Clear(Color.Gray); //copy the (scaled) screen buff ...Show All