Shirdi Sai Theatre list

anonymous datatype in .net

we can declare anonymous datatype using var
var a=10;
 declaring arrays using var

integer array
var a =new int[]{1,2,3,4,5}

console.writeline(a[2].tostring())
O/P
3
string array

 var a=new string[]{"hi","hello"}

console.writeline(a[1].tostring())

O/P

 hello

we can also copy methods into anonymous datatype also

ex:

func method1 = delegate (int a,int b) { return a+b;};

Now we can copy this method into Anonymous

Var d= new { meth=methode1}

console.writeline(d.meth(1,2));

O/P

3

Sending dataset from controller to View in MVC3

In this example i used Access database as backend so worked with oledb client..if ur backend is SQL just change the connection string and Oledb with SQL remaing code ie same.

In your controller

   public ViewResult Index()
        {
            OleDbConnection cn = new OleDbConnection("provider=microsoft.ace.oledb.12.0;data source=e:/database1.accdb;");
            OleDbDataAdapter  DA = new OleDbDataAdapter ("select * from emp",cn);
          
            cn.Open();
         
            DataSet ds = new DataSet();
            DA.Fill(ds);
            cn.Close();
         
            return View(ds);
           
        }

In your View


   

        @model  System .Data .DataSet (this is very important ,tha purpose of this is ..it will tell to Model that recieved data is dataset)

               @foreach (System .Data .DataRow row  in Model .Tables [0].Rows )
               {
                 //It will give result based on no of rowcloumns we added. Below we added 2 columns
                   @(row[0]+"  "+row[1])
                  

                 
                  
                 // it will give result all columns automatically
                   for (int i = 0; i < row.ItemArray.Length; i++)
                   {
                       @(row [i]+" ")
                 
                   }
                   

               }