Monday, October 1, 2012

FULL OUTER JOIN into the SQL Server query

Full outer join is use full when we need following kind of result from tow individual queries

Result 1

IdColumn Data1
1 Hello1
2 Hello2
. .
. .
10 Hello10

Result 2

IdColumn Data2
1 Hi1
2 Hi2
. .
. .
10 Hi10

Final Result = Result 1 + Result 2

IdColumn Data1 Data2
1 Hello1 Hi1
2 Hello2 Hi2
. . .
. . .
10 Hello10 Hi10

{{ For Example }}

select isnull(A.Id,B.Id) as Id , A.*, B.*
( select IdColumn as Id,* from xyz ) A
full outer join
( select IdColumn as Id,* from abc ) B
on A.Id = B.Id

{{ NOTE }}
You have to care about null in the result set when there are no data in either table for the respected IDs.

Friday, September 21, 2012

Single Quote (') into the data control bind system <%# %>

Here is Tips to put single quote ( ' ) into the data bind control binding syntax that is <%# ... %>

For Example:

OnClientClick=<%# "xyz('" + Eval("DataColumn").ToString() "'); return false;" %>

Direct put the binder syntax after = of the property you want to bind, don't use single or double quote.  And put any string constant before and after your Eval("").

It is use full when we want to call javascript function on the click event of link,button,image etc controls.

Friday, September 14, 2012

SqlConnection from ObjectContext.Connection

Following is C# code to get the SqlConnection from ObjectContext.Connection.
This is usefully to run dynamically created query using ADO.NET using connection string specified into the EDMX ObjectContext object.

C# Code Example :

using (EntityContext context = new EntityContext())
EntityConnection ec = (EntityConnection)context.Connection;
SqlConnection sc = (SqlConnection)ec.StoreConnection;

SqlDataAdapter da = new SqlDataAdapter(strQuery, sc);
DataSet ds = new DataSet();

return ds.Tables[0];


Wednesday, May 9, 2012

Set focus on selection of date from jQuery datepicker to control it self

Following is the jQuery code to set focus on control after selecting the date from the jQuery Date Picker

jQuery.extend(jQuery.datepicker, { afterShow: function (event) {
    jQuery.datepicker._getInst('z-index', 99999999);

    $("#divGameQuestionPanel [datepicker]").datepicker({
        changeMonth: true,
        changeYear: true,
        yearRange: 'c-99:c+0',
        showOn: "button",
        buttonImage: calImageSrc,
        buttonImageOnly: true,
        dateFormat: 'dd/mm/yy',
        onSelect: function (dateText, inst) { $(this).focus(); }
    }).focus(function (event) {

Developer must have Browser Addons list

Google Chrom

1) Chrome - use full to select color and its different sades

Live website to use it without add into the browser