You searched for the word(s): userid:730331

More Search Options

RSS Available

• join two aggregated results to a newly table with the simplest method

  Dear experts, I want to have the simplest method to join two aggregated results to a newly table. But I don't want to use stored procedure or function, don't want to use temporary tables to do so. Do you have any method to join two result sets with a simplest method? table 1. ==== select distinct a.CProduct_IDM + '-' + CProduct_IDC + '-' + CProduct_IDS as CProduct_ID, Packing_ID from tabWarehouseCCProduct a go table 2. ======= select b.CProduct_IDM + '-' + b.CProduct_IDC

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by manpakhong on 9/17/2009
  Filed under: "SQL Server", "SQL Select and Update Where "

• Re: join two aggregated results to a newly table with the simplest method

  Thanks, you are right. Thanks for your help. select a1.CProduct_ID, b1.WHC_ID, b1.WHCCP_Qty_TTL, a1.Packing_ID from (select distinct a.CProduct_IDM + '-' + CProduct_IDC + '-' + CProduct_IDS as CProduct_ID, Packing_ID from tabWarehouseCCProduct a) A1 INNER JOIN ( select b.CProduct_IDM + '-' + b.CProduct_IDC + '-' + b.CProduct_IDS as CProduct_ID, WHC_ID, sum(b.WHCCP_Qty) as WHCCP_Qty_TTL from tabWarehouseCCProduct b group by b.CProduct_IDM + '-' + b.CProduct_IDC

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by manpakhong on 9/17/2009
  Filed under: "SQL Server", "T-SQL", "SQL Select and Update Where ", "manpakhong@hotmail.com", "manpakhong"

• Re: AjaxControlToolkits Popup items always show on IE8 undesignedly

  ^^, just share my find out. Man Pak Hong, Dave manpakhong@hotmail.com Analyst Programmer @ Hong Kong

  Posted to ASP.NET AJAX Control Toolkit (Forum) by manpakhong on 7/6/2009

• Re: PopupcontrolExtender doesn't work in IE 8

  OH, Dear, I have found a very very simple method to solve it. just to put the code as follows: at the Page_Load() Method: For example, i have the following panels within the aspx. pnlBrand.Style.Add("visibility", "hidden"); pnlCUAddress.Style.Add("visibility", "hidden"); pnlCUPersonCUFax.Style.Add("visibility", "hidden"); pnlCUPersonCUPhone.Style.Add("visibility", "hidden"); pnlCustomerCUFax.Style.Add("visibility"

  Posted to ASP.NET AJAX Control Toolkit (Forum) by manpakhong on 7/2/2009

• AjaxControlToolkits Popup items always show on IE8 undesignedly

  Problem: AjaxControlToolkits pop up items will have problem ON IE8. It always show visible that is not designed to show up by you. As I notify, PopUpControlExtend, HoverMenuExtender will be affected. Solution: Using html, css format to solved it. Code example: (please aware of gray-colour highlight) Normal 0 false false false EN-US ZH-TW X-NONE MicrosoftInternetExplorer4 =================================== aspx file ===================================================================== <% @ Page

  Posted to ASP.NET AJAX Control Toolkit (Forum) by manpakhong on 7/2/2009
  Filed under: "AJAX .NET 2.0", "AJAX .NET 2.0" " "Ajax Control Toolkit" not displayed., "AJAX .NET 2.0" "Any AJAx Extender" + "positioning", "AJAX .NET 2.0" "Ajax Control Toolkit", "manpakhong@hotmail.com", "manpakhong", "Ajax control toolkits IE 8.0 Problem", "c# Ajax Control Toolkits Problem in IE8", "PopUpControlExtender problem in IE8", "HoverMenuExtender problem in IE8"

• Re: PopupcontrolExtender doesn't work in IE 8

  Dear all experts, I have confronted the problem too. I am using the javascript trying to handling the solution, but with some weakness. Problem: While using Ajax Control Tool Kits's control, popupcontrolExtender with GridView control within a panel, IE 8 will always show the panel that we are not designed the Panels to be visible. My Solution: I am using javascript to hide the panel Weakness: after select the item within any gridview that are popped up by popupcontrolExtender, the unwanted panels

  Posted to ASP.NET AJAX Control Toolkit (Forum) by manpakhong on 6/29/2009
  Filed under: ajax modalpopupextender targetcontrolID, "AJAX .NET 2.0", "AJAX .NET 3.5" "Ajax Control Toolkit", ASP .net ... c# Error, Ajax .NET 3.5, "AJAX .NET 3.5" "Ajax Control Toolkit" "CollapsiblePanelExtender" "Minimum Height", accordion control c# pane header content, .NET2.0, "manpakhong@hotmail.com", "IE 8 Ajax Problem", "manpakhong"

• Re: crystal reports adding custom paper size

  Thanks, i do the same code in c#. actually, i want to use some code to add a customized paper size to the printer (print form). e.g. A4, A3, customized_Label_size. Man Pak Hong, Dave manpakhong@hotmail.com Analyst Programmer

  Posted to Crystal Reports (Forum) by manpakhong on 6/22/2009

• Ajax "AsyncPostBackError" for ScriptManager, JScript error problem in .NetFramework 3.5 SP1

  Dear all, I migrated my company web applications from Visual Studio 2005, .NetFramework 2.0, ASP.net, Ajax extensions 1.0 to Visual Studio 2008 SP1, .NetFramework 3.5 SP1. I find that the code that contained AsyncPostBackError, when it is triggered. It will have JScript error. ======HTML Parts===================================== I simplified the code as follows: <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default3.aspx.cs" Inherits="Default3"

  Posted to ASP.NET AJAX Discussion and Suggestions (Forum) by manpakhong on 6/19/2009
  Filed under: c#.net, ajax, c# 2008 LINQ, <C#>, .net Compact framework 3.5, c# 3.5

• Re: Crystal report 2008 - Object reference not set to an instance of an object. on windows 2003

  dear qwe123kinds, thank you for you remind. i solve the problem eventually. I found out that the code that is compiled and run well at Windows Vista, with visual studio 2008 with crystal report 2008, it may have error occur at windows 2003 with visual studio 2008 with crystal report 2008. I type for sharing my code that is running well at Windows Vista with the forum. Windows Vista version: protected void Page_UnLoad(object sender, EventArgs e) { mb_objcryRptDoc.Close(); mb_objcryRptDoc.Dispose(

  Posted to Crystal Reports (Forum) by manpakhong on 6/12/2009

• Re: Crystal report 2008 - Object reference not set to an instance of an object. on windows 2003

  Thanks, I try it first. The problem only exists in windows 2003 server, i have tested it even i have fresh installation of windows 2003 server with the only components that my appliations need to run. e.g. vs 2008 crystal report 2008 ...... The problem exists. manpakhong@hotmail.com Man Pak Hong, Dave

  Posted to Crystal Reports (Forum) by manpakhong on 6/11/2009