How to set Header, Scrollable Content and Footer in Android?

In GUI, we want to show the content inside the header and footer layout.

Relative Layout is the best one for android to create and maintain the header,footer and scrollable content.

Here is the example code for the relative layout with header,footer and content.

<?xml version="1.0" encoding="utf-8"?>

<RelativeLayout       xmlns:android="http://schemas.android.com/apk/res/android"

      android:layout_width="wrap_content"

      android:layout_height="wrap_content"

      android:orientation="vertical">

      <RelativeLayout

            android:layout_width="fill_parent"

            android:layout_height="40dp"

            android:id="@+id/rlHeader"

            android:background="#2F5E7A">

            <TextView

                  android:layout_width="wrap_content"

                  android:layout_height="wrap_content"

                  android:layout_centerInParent="true"

                  android:textSize="16dp"

                  android:textColor="#ffffff"

                  android:textStyle="bold"

                  android:text="Header Item"/>

      </RelativeLayout>

     

      <LinearLayout

            android:id="@+id/llFooter"

            android:layout_width="fill_parent"

            android:layout_height="40dp"

            android:background="#2F5E7A"

            android:gravity="center"

            android:orientation="horizontal"

            android:layout_alignParentBottom="true">

            <TextView

                  android:layout_width="wrap_content"

                  android:layout_height="wrap_content"

                  android:layout_gravity="center"    

                  android:textSize="16dp"

                  android:textColor="#ffffff"

                  android:textStyle="bold"

                  android:text="Footer Item"/>       

      </LinearLayout>  

     

      <ScrollView

            android:layout_width="fill_parent"

            android:layout_height="wrap_content"

            android:layout_below="@id/rlHeader"

            android:layout_above="@id/llFooter"

          >

      <LinearLayout

            android:id="@android:id/empty"

            android:layout_width="wrap_content"

            android:layout_height="wrap_content"

            android:orientation="vertical"

            >

           

          <Button

                android:layout_width="fill_parent"

                android:layout_height="wrap_content"

                android:text="Content Item1"/>

         

          <Button

                  android:layout_width="fill_parent"

                  android:layout_height="wrap_content"

                  android:text="Content Item2" />

         

          <Button

                  android:layout_width="fill_parent"

                  android:layout_height="wrap_content"

                  android:text="Content Item3" />

         

          <Button

                  android:layout_width="fill_parent"

                  android:layout_height="wrap_content"

                  android:text="Content Item4"  />

         

          <Button

                  android:layout_width="fill_parent"

                  android:layout_height="wrap_content"

                  android:text="Content Item5"  />

           

           <Button

                  android:layout_width="fill_parent"

                  android:layout_height="wrap_content"

                  android:text="Content Item6"  />

         

          <Button

                  android:layout_width="fill_parent"

                  android:layout_height="wrap_content"

                  android:text="Content Item7" />

         

          <Button

                  android:layout_width="fill_parent"

                  android:layout_height="wrap_content"

                  android:text="Content Item8" />

         

           <Button

                  android:layout_width="fill_parent"

                  android:layout_height="wrap_content"

                  android:text="Content Item9" />

         

          <Button

                  android:layout_width="fill_parent"

                  android:layout_height="wrap_content"

                  android:text="Content Item10" />

         

          <Button

                  android:layout_width="fill_parent"

                  android:layout_height="wrap_content"

                  android:text="Content Item11" />

      </LinearLayout>

      </ScrollView>

</RelativeLayout>

 Here we would need to place the content layout inside the "ScroolView"

Thank you.

 

Insert record dynamically in sqlite using phonegap

Inserting the record into the SQLite table is very easy.
Some times when we try to dynamically insert the record(more than 100 records) into the table will cause some problems.
That time we can able to lose some records in database.

Then how can we avoid this problem?
Yes..It's also very easy., we can use the recursive functions. This function will take care of the problem to insert the record into the SQLite table.

Now we can assume that the data from the service response is as follows,

var response =

[

   { "stateId": 1, "stateName": "TamilNadu" },

   { "stateId": 2, "stateName": "Kerala" },

   { "stateId": 3, "stateName": "Karnataka" },

   { "stateId": 4, "stateName": "AndraPradesh" },

   { "stateId": 5, "stateName": "Maharastra" },

   { "stateId": 6, "stateName": "Orissa" },

   { "stateId": 7, "stateName": "MadyaPradesh" },

   { "stateId": 8, "stateName": "WestBengal" },

   { "stateId": 9, "stateName": "Assam" },

   { "stateId": 10, "stateName": "Gujarat" },

   { "stateId": 11, "stateName": "JammuKashmir" }

]

The above response will looks like JSON format. So we can conver the array format as,   

     var myObject = jQuery.parseJSON(response);

     myObject = eval(myObject);       

     fnStateInsert(myObject, 0);

The recursive function of inserting the record into the table are as follows,

function fnStateInsert(serviceResponse, i) {

    console.log("Service Length : " + serviceResponse.length + " i : " + i);

    var dbinsert = window.openDatabase("IVoteDB", "1.0", "IVoteDB", 1000000);

    if (i < serviceResponse.length) {

        var dbinsert = window.openDatabase("IVoteDB", "1.0", "IVoteDB", 1000000);

        insertQuery = "INSERT INTO STATEMASTER(STATEID,STATENAME) VALUES (" + "'" + serviceResponse[i].stateId + "','" + serviceResponse[i].stateName + "')";

        dbinsert.transaction(function insertUserPrefDB(tx) {

            tx.executeSql(insertQuery);

        }, errorCB, function successCB() {

            /* Recursive Function For Inserting the State in Local Db */

            fnStateInsert(serviceResponse, (i + 1));

        });

    }

    else {

        alert('State Inserted Successfully');

    }

}

Now you will insert  all records into the table without losing the data.

Thank you....

Get Data from JSONArray inside an array using JQuery

The service will return the JSONArray inside an Array, that time we would need to use the following method to get a particular data from the service response.

The JSONArray inside an array format service response will looks like as follows,

var response= {
    "Name":
     [
        [{"Key": "A", "Value": "Sample1" }],
        [{ "Key": "A","Value": "Sample2"}],
        [{"Key": "A","Value": "Sample3" }],
        [{"Key": "A","Value": "Sample4" }]
    ],
    "Title": "Office"
}


Now, we want to get the data as "Value" from the above response.

We will use the the following jquery, we would get the output.

$.each( response.Name, function( index, result ) {
  alert( index + ": " + result[0].Value );
  console.log( index + ": " + result[0].Value );
});

How to Place Span Inside Text Input Field

First Create a text box and Span.

Then you have to write a style for span.

In Position absolute property is important for placed the text inside the text box.

Based on our text box, we need to change the left and top property for the span.

For Example,

<input type="text" style="height:30px; width:300px;" >

<span style="position:absolute; left:285px;top:56px;color:#999999;">Test</span>

 

Split Function in Sql Server

We can write function in Sql Server,

CREATE FUNCTION Split

(

    @String nvarchar(4000),

    @Delimiter char(1)

)   

RETURNS

    @Results TABLE (Items nvarchar(4000))   

AS

    BEGIN   

    DECLARE @INDEX INT   

    DECLARE @SLICE nvarchar(600)   

    -- HAVE TO SET TO 1 SO IT DOESNT EQUAL Z   

    --     ERO FIRST TIME IN LOOP   

    SELECT @INDEX = 1   

    -- following line added 10/06/04 as null   

    --      values cause issues   

    IF @String IS NULL RETURN   

    WHILE @INDEX !=0    

        BEGIN    

         -- GET THE INDEX OF THE FIRST OCCURENCE OF THE SPLIT CHARACTER   

         SELECT @INDEX = CHARINDEX(@Delimiter,@STRING)   

         -- NOW PUSH EVERYTHING TO THE LEFT OF IT INTO THE SLICE VARIABLE   

         IF @INDEX !=0   

          SELECT @SLICE = LEFT(@STRING,@INDEX - 1)   

         ELSE   

          SELECT @SLICE = @STRING   

         -- PUT THE ITEM INTO THE RESULTS SET   

         INSERT INTO @Results(Items) VALUES(@SLICE)   

         -- CHOP THE ITEM REMOVED OFF THE MAIN STRING   

         SELECT @STRING = RIGHT(@STRING,LEN(@STRING) - @INDEX)   

         -- BREAK OUT IF WE ARE DONE   

         IF LEN(@STRING) = 0 BREAK   

    END   

    RETURN   

END

Then We can call that function from our stored procedure like,

Declare @input varchar(255)

Set @input = 'EMP101,EMP155,EMP199'

 --create table #Temp1 (sno int identity(1,1), empno varchar(100)) 

select ID= IDENTITY(int, 1,1),* into #Temp from dbo.Split(@input,',')

select * from #Temp

drop table #Temp 

 

ASP.Net Links

Get the current page name using JavaScript

 http://fuchangmiao.blogspot.in/2009/04/get-current-page-name-in-javascript.html

http://raghavanmohan.wordpress.com/2010/09/28/get-the-current-page-name-using-javascript/ 

 Differences Between WCF and ASP.NET Web Services

http://codebalance.blogspot.in/2011/01/10-differences-between-wcf-services-and.html 

 http://wcftutorial.net/Difference-between-WCF-and-Webservice.aspx

JavaScript Event Calendar | Ajax Scheduler

http://dhtmlx.com/docs/products/dhtmlxScheduler/index.shtml

 http://www.web-delicious.com/4-best-javascript-jquery-event-calendar-planner-scheduler/ 

.Net Connector

http://docs.dhtmlx.com/doku.php?id=dhtmlxconnectornet:toc 

Get Started With JSON
http://www.webmonkey.com/2010/02/get_started_with_json/ 

jQuery Mobile Events Diagram

http://bradbroulik.blogspot.com/2011/12/jquery-mobile-events-diagram.html

Creating Printer Friendly Pages

http://www.kirupa.com/html5/creating_printer_friendly_pages.htm

Hashtables vs. Arrays

http://www.kirupa.com/html5/hashtables_vs_arrays.htm

Advanced Random Numbers in JS

http://www.kirupa.com/html5/advanced_random_numbers_js.htm

Random Colors in JavaScript

http://www.kirupa.com/html5/random_colors_js.htm

Finding an Element's X, Y Position

http://www.kirupa.com/html5/finding_element_x_y_position.htm

Shuffling an Array in JavaScript

http://www.kirupa.com/html5/shuffling_array_js.htm

online photoshop

http://pixlr.com

Learn how to remove duplicate values from an array in #JavaScript

http://t.co/h2D5Fk0q