JQuery & MVC2 Example

Here i give an example for  binding the state to dropdown list  based on the country   by mvc & jquery

First we need to create the Controller called "Country"  & add a action called state .  and then i have given here  json  data to return in that action.



      public JsonResult State(string Country)
        {
            //items is your list what ever how you get it
            List State = new List();
            if (Country == "India")
            {
             
                State.Add("TN");
                State.Add("KA");
            }
            else if (Country == "US")
            {
                State.Add("CA");
                State.Add("NY");
            }

            var stateList = State;
            return Json(stateList, JsonRequestBehavior.AllowGet);
         
        }




now we talk about jquery part .   by using $.ajax() call ,  we need to post the request to Country controller for action  "State".  So url should be '/Country/State'.  we need to define the datatype  to json.  the parameter part should be done with data . if the ajax called request successfully , then sucess block gets executed .  we add anonymous function to bind the data as following one.  meanwhile if any exception are thrown,  ajax's error handle function added


 $(document).ready(function () {

          $.ajax({
              type: "POST",
              url: "/Country/State",
              datatype: 'json',
              data: {Country:'US'},
              success: function (data) {

                  $('#mes').html(data);
                  var items = '';
                  for (var i = 0; i < data.length; i++) {
                      items = data[i];
                      $("#Select1").append('' + data[i] + '');                  
                  }

              }
                ,
              error: function (request, status, error) {
                  alert(error);
              }
          });


      });


Regards
Guna seakran

Class inherits two interfaces with same method that class inherited by another class

A class  called One  which inherits two interface i1 & i2.  I1 has a method called method1().  I2 has a method called method1().  These two interface I1 & I2 have same method name called method1(). in it.

the class One implements the method method1() by  interface name with dot and method name like
 interface.method1()

again we come to access  part of those method in derived class called two.    create the object for base class and assign it to interface  declaration.  call method by using interface
The real example below



 class Program
    {
        static void Main(string[] args)
        {
            two obj = new two();
            obj.method2();
            Console.ReadLine();
        }
    }
    interface i1
    {
        void method1();
    }
    interface i2
    {
        void method1();
    }
    class one : i1, i2
    {
        void i1.method1()
        {
            Console.WriteLine("test i1");
        }
       void i2.method1()
        {
            Console.WriteLine("test i2");
        }
    }
    class two : one
    {

        internal void method2()
        {

            i1 obji1 = new one();
            obji1.method1();
            i2 obji2 = new one();
            obji2.method1();
           
          
        }
      
    }


Thanks
gunasekaran

HTML5 with Sql database

I have created the sql database in HTML5 page .  it supports latest browsers like ie ,chrome
It is very simple and useful

There are three core methods in the spec that I’m going to cover in this article:

openDatabase

transaction

executeSql

I’ve passed four arguments to the openDatabase method. These are:

Database name

Version number

Text description

Estimated size of database  -  size might be 5Mb to 500 Mb. it varies on browser

executeSql

This is the funnel of love for all your SQL goodness. executeSql is used for both read and write statements, includes SQL injection projection, and provides a callback method to process the results of any queries you may have written.

Once we have a transaction object, we can call executeSql:

var db = openDatabase('mydb', '1.0', 'my first database', 2 *1024 * 1024);
db.transaction(function (tx) {
  tx.executeSql('CREATE TABLE foo (id unique, text)');
});

Example is below

Status Message