Tuesday, November 29, 2011

Oracle 11g R2 x64 Client with ODAC Installation Guide


ref: http://devblog.rayonnant.net/2011/04/oracle-11g-r2-x64-client-with-odac.html?showComment=1322568025476#c9080251668350644709


when i run the command "OraProvCfg.exe /action:gac /providerpath:C:\Oracle\app\product\11.2.0\client_1\ODP.NET\bin\4\Oracle.DataAccess.dll"

the system says i need to install .net 4.0. when i had a quick look into the folder i found another one for 2.x so the logic is simple "4" is for .net framework 4 and "2.x" for earlier versions.

Hope this helps someone.

Wednesday, November 23, 2011

Combine multiple results in a subquery into a single comma-separated value

1. Create the UDF:

 
CREATE FUNCTION CombineValues(
@F_ID INT --The foreign key from TableA which is used to fetch corresponding records
)
RETURNS VARCHAR(8000)
AS
BEGIN
DECLARE @SomeColumnList VARCHAR(8000);
SELECT @SomeColumnList = COALESCE(@SomeColumnList + ', ', '') + CAST(SomeColumn AS varchar(20)) FROM TableB CWHERE C.FK_ID = @FK_ID;
RETURN (
SELECT @SomeColumnList)
END



2. Use in subquery:

SELECT ID, Name, dbo.CombineValues(FK_ID) FROM TableA


ref :http://stackoverflow.com/questions/111341/combine-multiple-results-in-a-subquery-into-a-single-comma-separated-value

Split CSV String into Table in SQL Server

ref :http://www.saqib-ansari.com/2010/04/split-csv-string-into-table-in-sql-server.html

Tuesday, November 8, 2011

My Design suggestions

 My Design suggestions

1. When showing validation error for pages which have multiple ( even collapsible) panels. specify the panel in which the control is present besides the error message.


2)Microsoft Inductive User Interface Guidelines

 

Colorful Expression for wide variaty of color themes for Silverlight

If you want to choose your own color theme I recommend to use Colorful Expression. Colorful Expression is a very useful design tool. It brings to you the wide variaty of color themes created by the Adobe Kular community. It is available as an add-in for Expression Blend and Expression Design or as a standalone tool. You can download Colorful Expression at codeplex.com.

ref:http://blogs.windowsclient.net/silverlaw/archive/2010/02/20/organizing-color-themes-for-a-styled-control-using-resourcedictionary-in-silverlight-3.aspx

Also has how to create themes for our SL pages 

Sunday, November 6, 2011

Tools to use for blog

1)Syntax highlighter to place your code
http://alexgorbatchev.com/SyntaxHighlighter/

Friday, November 4, 2011

Design suggestions

1) to get the mouse cursor image for the link which has the image in it.
    Sol: simply use the style="cursor:pointer" for that link

Thursday, November 3, 2011

test javascript online

http://www.w3schools.com/js/tryit.asp?filename=tryjs_function2

CollapsiblePanelExtender tips

1.Having multiple close\open buttons

   ref: a) http://stackoverflow.com/questions/744184/how-do-i-have-multiple-close-buttons-with-a-collapsiblepanelextender

b)http://stackoverflow.com/questions/6729999/asp-net-collapsiblepanelextender-two-expand-collapse-button-on-one-target

Devops links

  Build Versioning in Azure DevOps Pipelines