gharryh's Q&A profile

• Windows Forms bind to combobox

  hi, i have at this dataset that has a table(BankMaintenance), it contains two columns(BankCode and BankName). My question is that how can i place the contents of the two columns in a single combox  every row will be an item in the combox... thanks. You can use the following select statement to get the data from the database. "SELECT BankC ...Show All

• .NET Development Is gacutil.exe redistributable

  I am producing a bespoke software system in C#/C++ for Windows 2000 that uses the Office XP Primary Interop Assemblies (PIAs) to talk to MS Access. I am required to provide our customer with both the executable system and full soure code on CD for full system installation & recovery as well as post-development by the customer. I believe the Office XP PIAs are redistributable so we should be allowed to include them on our delivery CD. However, in order to install them, we need to use gacutil.exe (Global Assembly Cache Utility) which come with the .NET Framework 2.0 SDK but this does not appear to be redistributable. The ...Show All

• .NET Development Removing nulls

  is it possible, and if so how, to when excel data is loaded into a datagrid to stop empty cells from showing up as nulls in run time thank you Hi, you could define styles for your columns in a DataGrid and specify text to display instead of NULL values. Check DataGridTextBoxColumn class and NullText property inside of it ...Show All

• .NET Development Cannot unload assemblies that you create and load by using script in XSLT

  This "design limitation" of .NET framework 1.0 causes huge memory leaks when using script in xsl stylesheets because the framework creates an assembly that it can't unload without complete recycle of the application. Anyway, this is well described and documented in article http://support.microsoft.com/ id=316775 The question I have is: Does anyone know if this has been fixed in .NET framework 2.0 Thank-you for your consideration of this matter. Unfortunately, .NET Framework 2.0 is still affected by this issue. We recommend using extension objects instead of scripts, if possible. If ...Show All

• SQL Server SQL Express license for hosting

  Can SQL Express used in a web hosting scenarion... Does that require any extra license or is free Yes. SQL Express can be used in web hosting scenarios with no extra licences required as long as SQL Express is not connecting to a higher SQL Server Edition. ...Show All

• SQL Server Where to color Line Graph lines?

  Re: SQL Svr 2000 VS.NET 2003, with SQL Reporting Services (RS) I have a graph which depicts total counts for a "Tier 1, 2, 3, and total". I would like to choose their colors. Where is the coloring of the graph (data) lines (not the graph object box) Thanks. ...Show All

• Visual Studio How to identify the difference bwteen non-defined property and empty property?

  Experts,    The the following blue scripts can work well. -----------------------------------------------------------------------------        <PropertyGroup>           <My1></My1>          .....     </PropertyGroup>          <PropertyGroup Condition="'$(My1)' == ''">          <My1>Default defined</My1>          ....    ...Show All

• .NET Development Disappearing updates in local SQL Server Express database

  Hi, I created a SQL Server Express database and added it to my project by using "Project|Add New Item" and selecting "SQL Database". I then added a single table to the database and added a single text column to the table. I dragged the table to an empty form which prompted the UI to automatically add a datagridview, a binding source and a dataset, configured and ready to go. When I run the program, I can add data to the dataset (apparently), but the next time I run the program, the data from the previous session is gone. I have tried all sorts of things including adding an "update" button to invoke the &qu ...Show All

• Windows Forms beta 1 versus beta 2 diffs

  Anyone know if there is a doc somewhere that describes beta 1 versus beta 2 differences in the framework and windows forms app code Keep a watch out for an update to this page on GotDotNet: http://www.gotdotnet.com/team/changeinfo/default.aspx This typically contains the breaking changes between Betas and RTM versions. However it has yet to be updated to Beta 2. Perhaps you could forward an email onto the contact at GotDotNet asking for an update. ...Show All

• SQL Server Using Partitioned Views in SQL Server 2005 Standard Edition

  We currently use partitioned views (over horizontally partitioned tables) in SQL Server 2000. The tables are partitioned by month. This works extremely well for our needs. In evaluating SQL Server 2005 Standard Edition, we are finding some issues trying to get this to work properly. A select against the view results in a table scan. Does anyone know if partitioned views have any issues in 2005 SE We are not doing anything different in 2005 SE than we currently do in 2000 SE. StephanG, Would you please post your query and the query plan by the following commands set showplan_text on <run your quer ...Show All

• Visual Studio An article about VSS remote access

  I’ve got a good article on internet to share with all of you. A comparison among six third-party VSS remote access tools Hi Shirley, The authenticity of this article and the comparison results needs to be looked with skepticism, at least until more information will be available. It seems that the author of the article has some connection to Dynamsoft, which sells S ourceAnyWhere (the product praised in the article). Robert Cowham posted the following investigation at http://groups.google.com/group/comp.software.config-mgmt/browse_thread/thread/41705480a6741604/a946d2e149113d7f lnk=st&q=%22A+comparison+among+six+VSS+remote+acce ...Show All

• Smart Device Development Hook keybord for pocket pc and smart phone of version 2003, 2005

  Hi all expert, I looked everywhere in MSDN to find how i can intercept the key "phone" (green key). I am a loser cos i can't know how i can do that. I want that when i click the key "phone" in the device, it will runs my application instead of phone application. Can you give me some instruction. I am impatient to hear from you. JulienT There is another way to intercept the Talk button that should work better for you.  See http://blogs.msdn.com/windowsmobile/archive/2005/09/02/460327.aspx  . ...Show All

• SQL Server Take Id-s From returned rows, and make a new SELECT

  Hello, I have a question on sql stored procedures. I have such a procedure, which returnes me rows with ID-s. Then in my asp.net page I make from that Id-s a string like SELECT * FROM [eai.Documents] WHERE CategoryId=11 OR CategoryId=16 OR CategoryId=18. My question is: Can I do the same in my stored procedure (without sending it to page) Here is it: Basically you would just put your ASP.NET side select statement ( SELECT * FROM [eai.Documents] WHERE CategoryId=11 OR CategoryId=16 OR CategoryId=18 ) into the stored procedure. Then change the WHERE clause to something like this (i left out the conditions): WHERE CategoryId In (Se ...Show All

• Visual Studio Team System Team Project Creation Failed (Error Log attached..)

  Hi there, While creating a Team Project, I am getting the following error: Initialization for plugin "Microsoft.Pcw.wss" failed with error: "Client found response content type of 'text/html', but expected 'text/xml'. Can anyone help on this Just to mention: I have already tested my setup with the required permission for SharePoint and SQL Reporting. And It is working as expected. Would appreciate your help. Thanks. Regards, Keyur. 05/12/2005 06:01:37.362 | Module: ELeadServiceMediator | URL for eLead web service retrieved as " http://rac154:8080/bisserver/EleadWebService.asmx " from the registration service | Completion time: 0 secon ...Show All

• Visual Studio Express Editions VB6 to Express query

  Hi, Visual Studio Express has upgraded a VB6 app for me with the following error: >> Name 'controlcm1' is not declared. File Form1.vb Line 13 Column 9 Project 1. Here is the code for Form1.vb Option Strict Off Option Explicit On Imports Axcm11a Imports Microsoft Imports Project1 Imports System Friend Class Form1 Inherits System.Windows.Forms.Form Private Sub ButClrCM11_Click( ByVal eventSender As System.Object, ByVal eventArgs As System.EventArgs) Handles ButClrCM11.Click controlcm1.ClearMem() End Sub Private Sub Command2_Click( ByVal eventSende ...Show All