Ascii Values in Database

Assalamualaykum Wr Br…I was looking into one value in database for a table named Customer which have column as Gender. The value in column should be either M or F or Null, but cannot have any other value.System throws exception when there is a mismatch of the value specified above.
The data of the table is fed from file.Before Customer table, data is first stored in temporary table then certain validations then moved to customer table. My Client stated that Gender value in file was null and it is temporary table which is showing as null but does not go in Customer acutal table.
When I queried in data as
select * from customer_temp where gender is not null
gives me result set, if I use where gender is null then does not provide result.
Inorder to find the exact value in gender column, I used the following query:
select ASCII(gender) from customer_temp where gender is not null
The above query displayed the value as 13 which is value of carriage return(\n).

Advertisements

Asp.Net Ajax Accoridian Control

Assalamualaykum Wr Br…Today we explore the Asp.Net Ajax Accordian Control. Before we explore in to it, lets understand few points about Ajax. Ajax stand for:
A – Asynchronous
J – Javascript
A – And
X – Xml

The Accordion is a web control that allows you to provide multiple panes and display them one at a time. It is like having several CollapsiblePanels where only one can be expanded at a time. The Accordion is implemented as a web control that contains AccordionPane web controls. Each AccordionPane control has a template for its Header and its Content. We keep track of the selected pane so it stays visible across postbacks. Lets quickly start POC of it as shown below:

Drag drop the Script Manager from tool box of the Visual studio then drag and drop accordian control from ajax tool tab. Under tags of accordian control provide <panes&> tags and specify or drag and drop accordianpane controls and under which, you find header and contents tags where specify the header to be displayed and content to be displayed on click to header whose pocs are shown below:
aco
The output of the above pocs are shown:
accordian

accord