Search

'2011/11'에 해당되는 글 2건

  1. 2011/11/23 Execute Oracle Procedure Test
  2. 2011/11/10 [MVC3]ImageActionLink

Execute Oracle Procedure Test

개발/기타 2011/11/23 11:49 Posted by xwing
sample 1)
VARIABLE csr REFCURSOR;
EXEC Proc_Test('2011-11-09', :csr);
PRINT csr;
 
sample 2)
DECLARE
  A varchar(10);
  B varchar(10);
  C number(4);
   
  -- sys_refcursor is weakly typed
  refcsr  SYS_REFCURSOR;
  
BEGIN

  -- call procedure
  PROC_TEST('2011-11-09', refcsr);

   -- loop through the results  
   LOOP
      -- gets one row at a time
      FETCH refcsr INTO A, B, C;
      -- if the fetch doesn't find any more rows exit the loop
      EXIT WHEN refcsr%NOTFOUND;
      
      DBMS_OUTPUT.PUT_LINE(A || '   ' || B || '  ' || C);
      
    END LOOP;

END; 
저작자 표시 비영리 변경 금지

'개발 > 기타' 카테고리의 다른 글

NavigationController에 ad@m 광고  (0) 2012/02/28
Execute Oracle Procedure Test  (0) 2011/11/23
MSSQL varchar vs nvarchar  (0) 2011/04/27
MS SQL 2008 Express 설치 중 오류  (0) 2011/03/17
TAG Oracle, Procedure
Tracback 0 Comment 0

[MVC3]ImageActionLink

개발/C# / ASP.NET 2011/11/10 12:35 Posted by xwing
ImageActionLink

  
public static MvcHtmlString ImageActionLink(this HtmlHelper htmlHelper, string imageUrl, string altText, string actionName, object routeValues)
        {
            TagBuilder imgBuilder = new TagBuilder("img");
            imgBuilder.MergeAttribute("src", imageUrl);
            imgBuilder.MergeAttribute("alt", altText);

            var urlHelper = new UrlHelper(htmlHelper.ViewContext.RequestContext, htmlHelper.RouteCollection);
            TagBuilder linkBuilder = new TagBuilder("a");
            linkBuilder.MergeAttribute("href", urlHelper.Action(actionName, routeValues));

            var text = linkBuilder.ToString(TagRenderMode.StartTag);
            text += imgBuilder.ToString(TagRenderMode.SelfClosing);
            text += linkBuilder.ToString(TagRenderMode.EndTag);

            return MvcHtmlString.Create(text);
        }

..

저작자 표시 비영리 변경 금지

'개발 > C# / ASP.NET' 카테고리의 다른 글

[MVC3]ImageActionLink  (0) 2011/11/10
[MVC] DropDownList에 Enum 바인딩  (0) 2011/09/21
C# machine key 생성하기  (0) 2011/07/05
[MVC] EnumDropDownList  (0) 2011/06/22
TAG ImageActionLink, MVC3
Tracback 0 Comment 0