22:34
Merbin Joe
Telerik Grid Values
Telerik is the third party tool for binding grid, date, time, calendar and etc. In telerik grid we can access the data while bind using "OnRowDataBound " command and when we do a action like page number or other that time the "OnCommand" function is executed.If want to access the Telerik data after bind, refer the below example
14:34
Merbin Joe
Dynamically change the Title bar using javascript / jQuery
The following example will teach you to change your title bar text dynamically, for example in facebook, linkedin and etc website are shown, new updates count in title bar. If you want to do this same on your website, grab the following code.Notes
Your HTML page should contain title tag already, then only we can access the title bar and change the value dynamically.
12:54
Merbin Joe
SQL query to get week start date and end date from Given Date
If you want to find the start and end of the week for given date, you can use the following query.Sunday-Saturday
select dateadd(day, (1-datepart(dw, getdate())), getdate()) CurrentWeekStart select DateADD(DAY,6,dateadd(day, (1-datepart(dw, getdate())), getdate())) CurrentWeekEnd
Output
00:00
Merbin Joe
SQL pagination example
When we are bind the grid with pagination should we need to control both side (client side and server side).For example if we have 100 rows and need to display 20 rows per page, so we should calculate the pagination from total count and limit, total count will get from procedure. Like below
select * from( select row_number() over(order by RegisterNumber desc) as RowNum,* from( select COUNT(*) over() as Totalcount,EmployeeName,RegisterNumber from clg_tb_student )x)xx where xx.RowNum>@startIndex and xx.RowNum<=@endIndex
In the above procedure, If the @startIndex is 0 and @endIndex is 10 then the procedure will return only 10 records and the count column field will tell you the total count of your records.
Easy method to applying your existing procedure
consider the below is your existing procedure
select * from .............
Remove the select and just copy and paste the following code to above of your existing code.
select * from( select row_number() over(order by RegisterNumber desc) as RowNum,* from( select COUNT(*) over() as count,
select * from( select row_number() over(order by RegisterNumber desc) as RowNum,* from( select COUNT(*) over() as count, * from .............
Copy and paste the following code to below of the modified code
)x)xx where xx.RowNum>@startIndex and xx.RowNum<=@endIndex
select * from( select row_number() over(order by RegisterNumber desc) as RowNum,* from( select COUNT(*) over() as count, * from ............. )x)xx where xx.RowNum>@startIndex and xx.RowNum<=@endIndex
22:20
Merbin Joe
Transparent Image Converter
This software is used to convert your Image to transparent (*. png) image, so you no need spend more time in Photoshop or other software, here you can easily to create the transparent background.Features
- Select the color and convert it to transparent background.
- Manually adjust the Threshold level
- You can covert two different color to transparent using Reconvert option.
- Change the original size to any size.
- Fixed option is convert the image to exactly you given size.
Download Transparent Image Converter 1.0
Download Transparent Image Converter 1.1
Download Using Softpedia
Download Using Freewarefiles
Step 1:
Install the downloaded application and open, this will appear like below. In there many options are in disabled mode, because avoid confusions. First you load a image after only the disabled controls will enable depend on your action.
Step 2:
Select your image, drag to window or select your image using Select Image button
Step 3:
After select the image you need to select the color, which want to remove. In the given below image we are choosing blue color for convert to transparent area, also we are show the Hex value of the color under the selected color title.
Step 4:
Now just press the preview button, or adjust the Threshold level slider bar, this will increase the color mode so when we increase the slider bar, it will select and convert the most possible selected color.
Step 5:
If you want to remove the yellow color again, just press the <<Reconvert button, so the converted image will appear in the first box, now you can select the yellow color and adjust the Threshold level.
Step 6:
You can customize the size.
If you want to customize the size just enable the Custom Size button, and specify your width and height of the image (If you checked the Fixed button, exact size or max width and max height).
Step 7:
Finally save your image.
Freeware Transparent Image Converter 1.0 Download
Abroad Customer | Indian Customer |
---|---|
Developed By
This software was developed by Merbin Joe T, and I am from India. Now I am working as asp.net developer in Technopark. This Transparent Image Converter 1.0 is totally freeware, anyone can use without a license and the next version will publish with more features and it will be paid version.
23:42
Merbin Joe
Get Day Name / DATENAME in SQL
DateName is mainly used to get the Name of the date for the given Date like (Sunday, Monday,...), also this is used to following purpose.1. Get the Day Name
2. Get the Month Name
3. Get the Week of the year
4. Get the Quarter of the Year
5. Get the Day of the Year
1) Get the Day Name
This is used to get the day name from the given date (Sunday, Monday, Tuesday,...).
Example
SELECT DATENAME(DW,'01/7/2013') as DayName
00:38
Merbin Joe
Find Datedifference in SQL
Datediff is used to find the difference between two dates.
Syntax
Example
Interval
datediff(Interval,convert(date,Date1),convert(date,Date2)) as DiffDay
Example
select datediff(DAY,convert(date,'2014-05-28 16:07:54.647'),convert(date,'2014-07-29 16:07:54.647')) as DiffDay
Interval
- HOUR
- SECOND
- MINUTE
- DAY
- MONTH
- YEAR
Hour
Second
Minute
Day
Month
Year
Show the difference in Hour.
select datediff(HOUR,convert(date,'2014-05-28 16:07:54.647'),convert(date,'2014-07-29 16:07:54.647')) as DiffDay
Second
Show the difference in Seonds.
select datediff(SECOND,convert(date,'2014-05-28 16:07:54.647'),convert(date,'2014-07-29 16:07:54.647')) as DiffDay
Minute
Show the difference in Minutes.
datediff(MINUTE,convert(date,Date1),convert(date,Date2)) as DiffDay
Show the difference in Day.
select datediff(DAY,convert(date,'2014-05-28 16:07:54.647'),convert(date,'2014-07-29 16:07:54.647')) as DiffDay
Show the difference in Month.
select datediff(MONTH,convert(date,'2014-05-28 16:07:54.647'),convert(date,'2014-07-29 16:07:54.647')) as DiffDay
Show the difference in Year.
select datediff(YEAR,convert(date,'2014-05-28 16:07:54.647'),convert(date,'2014-07-29 16:07:54.647')) as DiffDay
00:15
Merbin Joe
Physical abuse suffered by children
Home is a place where each person feels secure. A place where one feels the warmth of love from his/her family members. Or in other words, a heaven. But what happens, when this same heaven turns into a living hell?? When the same caregivers turn into cruel tormentors?? What happens when the mother who is supposed to be the one who loves you unconditionally, turns into a serious alcoholic and to meet her needs, sells you for some bucks?? When your father, whom you always look upto, the person who is supposed to protect you all the time, the person whom you trust infinitely, sexually assaults?? These are some of the harsh truths and issues, which need to be addressed and talked about.
Everyday we read innumerable stories, where many girls and boys as young as 3 and 4-year-old are beaten and raped brutally by their own family members or extended family members like cousins, uncles or aunts.Many have committed suicide, many ran away and feel into wrong hands, and many died as result of this torture.
Most of the times, children are forced to keep their mouths shut because they are threatened with death or similar punishment. They are made to feel that, they are responsible for what ever is happening with them and so they are afraid that they will be ashamed in front of everyone if the news leaks out. Children are forced to stay with their tormentors as they have nowhere to go and also they are unaware of their rights and help lines. Most of the times, children are rescued when the neighbors become suspicious or they run away and by sheer chance of luck, they reach the right persons. Today, the stress-levels are skyrocketing and this is affecting the sanity of working people and since children are the easiest way to take out one’s frustrations, it results in physical violence.
I would like to share a poem which is written by a girl, who was sexually assaulted by her own father after he became widower. He felt that, she was responsible for his wife’s death and that was his way of punishing her. This poem pulled my heart-strings.
00:09
Merbin Joe
The land which gave me my identity
How can one define a country which gave that person his identity? Any number of words is less to express one’s deep love towards one’s motherland,. India – a country which gave birth to many civilizations, a land which is known for its infinite traditions, languages, cultures and faiths. A melting pot, where one can meet people from all walks of life. A land where many religions took root and spread out into world like Buddhism and Jainism, the religions which spoke volumes of non-violence.A land which attracted travelers from all parts of the world from as far as Europe. It was the seat of learning, the land which had ancient universities like Taxila and nalanda universities, the country which gave the world 0, without which today, studying mathematics is unimaginable. The land which gave birth to legendary and courageous heroes like Rani Lakshmi Bai, who proved that nothing is impossible for a woman, Mahatma Gandhi, who showed the world that violence will not remove violence just like darkness cannot remove darkness, hatred won’t erase hatred, Tantya Tope, Shivaji and many more who fought till the last breath to save their motherland. ? Any number of words is less to express one’s deep love towards one’s motherland, to describe this land of science, beauty, honor and culture.
22:44
Merbin Joe
Two List Boxes in html
Mostly we are used the <select> tag for drop down but we can also used in list box, to enable this feature just add the "size=?" attribute and If you want to allow user to select more than one list item from the list box again you need to put the "multiple" attribute.
Subscribe to:
Posts (Atom)
Labels
- javascript
- JQuery
- javascript Beginner
- materializecss
- HTML
- Tips
- Animation Program
- css
- AngularJS
- blogger
- Application
- Game
- RGraph
- SQL
- Php
- .net
- Other
- Tools
- Article
- Android
- Button
- Software
- puzzle
- asp.net
- Theme
- telerik
- Flash
- Cordova
- Website
- c#
- Java
- College
- Hardware
- Maths
- Physicsjs
- Chrome Extension
- DOS
- Naturals
- SQLite
- xml
- Batch
- CarRace
- Image
- MVC
- Networking
- Typing
- WebView
- Xara 3D