How to attach a Android Device for debugging in Ubuntu ?

     If you do any Android development in Ubuntu it is much better to test your android application on a real device rather than just relying on the emulator.

    There are following steps to attach your Android device to Ubuntu :

$ /path of adb/adb devices

List of devices attached
???????????? no permissions

     Now :

$ lsusb

As Shown in Image Bus 002 Device 021: ID 0bb4:0c8b High Tech Computer Corp.

In this Vender ID is "0bb4" and Product Id is "0c8b" .

Now :
create/edit file /etc/udev/rules.d/51-android.rules

$sudo gedit /etc/udev/rules.d/51-android.rules

Then enter your log in password.

Now a File will open and wirte in file :

SUBSYSTEMS==”usb”, ATTRS{idVendor}==”0bb4″, ATTRS{idProduct}==”0c8b″, MODE=”0666″

Change Your Vender Id and Product id.
and Save & close File 51-android.rules.

Now run these commands.

$ sudo restart udev

$ /path of adb/adb devices

$ /path of adb/adb kill-server

$ /path of adb/adb start-server

Images Matching Game for Kids

Here are Images For Matching Game for Kids android application by anthem infotech we just want to guide how to play match game for kids so we upload some pics with help of this pic you can play match game easily. So see the pics and play your game.

Matching Game for Kids

Anthem Infotech Provides top android application to their user after huge success of Max Math Magic Anthem Infotech presents Matching Game For Kids. Matching Game is latest Advanced featured game.This matching game provides a fun and easy way to learn alphabets, numbers, colors and shapes and also associate objects with them.Be it matching 'A' with an 'Apple' or 'Green' with 'Leaf' In Matching Game , Match the objects from one side to another side. there are two sides , you Drag the Object to its Matching ,

Matching Game Have following Categories
* Match Objects
* Match Animal and Their Places
* Match Colors
* Match Alphabets

Best SEO Service In Zirakpur

Anthem Infotech Provides Best SEO Service In Zirakpur Where Anthem Infotech Work In On Page And Off Page SEO. We Rank Your Website In Google Serch Engine. Search Engine Optimization Is That process Where We Improving The visibility of Your Website.

Without SEO You Cannot Find your Website in Google Search Easilly So If You Want That Your Website Search In Goole Easilly So You Need SEO Service For Your Website. For a Perfect SEO Service You Can Choose Anthem Infotech For Best SEO Service In Zirakpur.

CTE(Common Table Expression)

CTE(Common Table Expressions) : 
                                                            CTEs are used to make the query more readable. CTE is a named  temporary result set that can be referenced within a select, insert,update,delete statement.
 CTE starts with the with clause.  CTE is defined by placing with clause before the insert,update, delete statement.
Here is the Syntax:

<expression name>  is the CTE  name which can be any valid identifier. It can be same as that of the base object name, but should be different from the other CTE name within same with clause.

The number of <column name> should be equal to the number of columns in the result set of  the <cte-defination-query>. If the column names in  <cte-defination-query> are identical then <column names> can be omitted.
 SQL SERVER supports two types of CTE
1.NON-RECURSIVE

2.RECURSIVE

1. NON-RECURSIVE:-  
A nonrecursive CTE is one that does not reference to itself within the CTE. These are simpler than recursive CTEs

e.g.

is a sample cte query on AdventureWorks database which inbuilt in sqlserver. 

2.   RECURSIVE CTE:-

                                         A recursive CTE is a CTE which reference to itself in the CTE.

e.g.

In the example we will write a CTE for printing counting from 1-10.

  We define a CTE NumberSequence which calls itself inside the definition. 

and the result will be:

Access Viewstate Value On Different aspx Page

Viewstate is used for state management in asp.net on same page. We can also access the Viewstate on other aspx page. For this we need to use server.transfer() method instead of response.redirect() method to redirect to the other page.

Let us have an aspx page named passviewstate.aspx . We will store two viewstates here as follow:

And use server.transfer to redirect to another page named readviewstate.aspx .  We need to place a fuction of statebag class.

Now we will read these viewstate values on the page  readviewstate.aspx . For this we will create a function to read the the previous page's viewstate.

After creating the above function we will write code to show the viewstate values.

And we are done. Now we the values of two viewstate variables Name and Organisation in the labels lblMessage and lablOrganisation.

Max Maths Magic For Kids

Max Math Magic Application is our attempt to make learning maths to be fun for kids who have just been introduced to numbers and helps them grasp simple concept easily while making it fun for them.

Max Math Magic Application is very simple play and install into you Android phones its very entertaining game for everyone its give so much Excitement when you are playing Max Math Magic game. For Kids Its Very Enjoyable Game because kids love to solve problem by playing this game.

So its very attractive game Specially for kids its makes mind sharp and give Refreshment to the mind. You Can play Max Math Magic game anytime and anywhere you never feel bored. So if wants that your kids Learn math problem Easy by playing this Max Math Magic game Install Today and see the results.

ASP.NET: Setting Key Values In Reference Config File

We can set the keys values of <appSetting>  in a reference file. The procedure is:

Add a new item i.e. web configuration file from solution explorer name it keys.config(you can name it our own).
write the following code in keys.config:-

In the web.config file set the reference of the keys.config file as follows:-

We are finished with the reference stuff. Now we can access the values for key value1 and value2 in the code file by following code lines:-

ASP.NET:Set Constants In Web.Config File And Access Them In Code File

Sometimes we need to use the constants in different parts of our project.  We can simply use constant values. But what if after a span of time (months or years) the constant value changes?  Then the programmer need to change the constant value on every place where he had used the constant.

 One solution to this problem is to set the value of constant in web.config file in the <appSettings> tag.

Then we can access this value at code file wherever we require.Let me explain it with example.

Put the following code inside your web.config file:-

Now to access this values inside the code file write the following code:-

Now wherever you use the value1 and value2 values will be changed whenever you change the value attribute of the key inside <appSettings>   tag of the web.config file. You can place the keys and values in separate file and reference it in web.config file Click Here for code.

ASP.NET: Ajax Call To Server Side Function

To call the server side function we will use the ajax call. For this we need to call the server side function by a ajax call. To explain this we will have an example.
       Let us have a page named ajaxcall.aspx .  We will take a div with id myDiv and put its text  "Before ajax call when server side function is not called." Now place a button with id Button1 .

There is a method named ServerSideMethod defined on ajaxcall.aspx.cs page.  This method returns the text  "After ajax call when server side function is  called".

Now we want to call the  method ServerSideMethod   on the click of button Button1   and change the text of div myDiv to the message returned by ServerSideMethod. To do this we will make the ajax call to the method by following code:

Firstly add the reference:-

After that write the code:

  

Now when we run the program we have the initial screen:

And after click on the Check button output will be:-

The text of the paragraph has been replaced by the message returned by the method  ServerSideMethod.

Sql: Window Functions(ROW_NUMBER, RANK, DENSE_RANK)

Window functions are the functions which operates on the window(set of  rows). Window refers to the  set of rows obtained as a result of some function.

1.ROW_NUMBER :-The ROW_NUMBER function is used to generate a sequence of numbers based in a set in a specific order, in easy words, it returns the sequence number of each row inside a set in the order that you specify.
Let us have the records in table:

Query:-

Output:-

2. Rank:-  rank()  returns a rank of each row within the partition of a result set.The ranking is calculated by 1 plus the number of previous  rows.The function RANK returns the result with a GAP after a tie,Let  us have a  sampleForRankingFunctions table of database emp with following records:-

Query:-

Output:- After we run the query we will get the output as follows.

As mentioned in the definition in a group it continue to rank from previous row count therefore we get a gap and after 1 rank becomes 4 because there is a gap of three records. for designer group. Similarly for developer group we have a gap between 2 and 4 . Click for detail on rank().

DENSE_RANK :- 
Returns a rank of each row within the partition of a result set. But in this case there is no gap between the ranks. Let us use the DENSE_RANK  for above case.

Query:- 

Output:-

We can clearly notice in this case the rank continues from the  last rank. It is not affected by the row count.

We have same rank 1 for three records for the group designer but next rank is 2 instead of 4 which we get in case of rank(). Same can be be noticed for the developer group.

Sql: Over And Partition By Clause

Over(): Over() looks over the result set rows of the aggregation functions.Hence  OVER() is implemented in the aggregation functions, it allow-us to access the details of the rows that have been aggregated by the aggregate functions.

Partition by: Over and partition by clause is used to wire up the result on the basis of particular field value.
e.g.
We have a table sample For Ranking Functions with the following records.

Now we want to show the sum of salary by grouping them by salary. We have four records with salary 14 therefore sum is 56 and in second group we have two records with salary 20 hence sum is 40. The query will be:

The output of the above query will be as:

Sql: Use Of Ranking Function rank()

Ranking functions are used with the over clause.
Before we continue to work with the ranking functions we must have knowledge of the partition.by

 rank():
Returns the rank of each row within the partition of a result set.
The syntax for using rank functions is

select * from(select *, rank() over(partition by <fieldname>order by <fieldname> asc) as ranking from table_name)testing where ranking<3

Above query will return two records for each group with the all fields.

To understand the use of rank function let us take the an example:-
                Let us have a table named sampleForRankingFunctions having the following records

Now we want to show first two records of each group then we can write the query as:

The output of the query will be:

• rank() returns a rank of each row within the partition of a result set. Another example of the rank use is when you want to show top n records having two records at final position, now question is that which record will be displayed out of the two records. rank() will rank the rows of  result set and show the record at last according the condition of rank.

Web Designing Service in Zirakpur

Anthem Infotech Provides best Web Designing Services in zirakpur anthem Infotech offer web designing services either as part of a big picture solution or as standalone services, if you wish. You can either ask us to design your website for you as per your needs, or you may ask us to solve a particular problem for you through the design of your website. Solving this problem may need one or more of our web designing Zirakpur find web designing company in zirakpur now.

Anthem Unit Converter

        Unit Converter free tool Features

• Easy to use conversion of units
• Support Temperature,Length,Mass,Speed,Volume,Area,Fuel consumption,Time and Digital Storage Conversion of Units .
• auto output on change option for conversion.
• 1-click operation.
• you can copy resulted value.
• more than 100 conversion parameters.
• all operations you can perform on one page.
• choose options for conversion from drop down.
• It will work offline.