Skip to main content

Add data to GridView and Export GridView data to Excel sheet

Suppose , you have data stored in a array of structure.

let us say,
   public struct myData
   {
      string name;
      int age;
      string city;

     public myData(string pName,int pAge,string pCity)
        {
          name=pName;
          age=pAge;
          city=pCity;
        }

    }


...............

public void dataTableData()
{
       List<myData> items=new List<myData>();
       ...add name,age,city of each person to the object 'data'.

   //Now you need to add data present in the object 'items' to the GridView
DataTable table=new DataTable();

DataRow row=null;
//Create three columns 'Name','Age','City'

table.Columns.Add(new DataColumn("Name",typeOf(string));
table.Columns.Add(new DataColumn("Age",typeOf(int));
table.Columns.Add(new DataColumn("City",typeOf(string));

//Now loop through the items present in the object 'items'

foreach(myData item in items)
{
    row=table.NewRow();
    row["Name"]=item.name;
    row["Age"]=item.age;
    row["City"]=item.city;
    table.Rows.Add(row);
}































//'DataView1' is 'Name'  of the DataGridView. see the above  attached snapshot


DataView1.DataSource=table;





}

Comments

Popular posts from this blog

error occurred in deployment step 'recycle iis application pool' :object reference not set to an instance of an object

While deploying using Visual studio, we may get an error "error occurred in deployment step 'recycle iis application pool' :object reference not set to an instance of an object" Solution:  Don't get  panic ..Simply restart the visual studio with the solution which you wanted to deploy on to the site This may help some one. -cheers pradeepa achar

The server was unable to process the request due to an internal error. For more information about the error, either turn on IncludeExceptionDetailInFaults

Hi Guys,   I came across this issue  today. I was totally blank. Later i started observing the issue and realised that, this issue is caused just because of  mismatch of assembly version or any attribute  in Security token service's web.config file (C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\WebServices\SecurityToken). Actual issue was i upgraded the assembly version and didn't do changes in web.config file of security token service This blog helped me to fix my issue http://underthehood.ironworks.com/2011/05/sharepoint-2010-an-exception-occurred-when-trying-to-issue-security-token-the-server-was-unable-to-p-1.html thanks pradeepa achar

Setting Up the Development Environment for SharePoint 2010 on Windows Vista, Windows 7, and Windows Server 2008

 Usually we can install microsoft Shapoint foundation on servers OS such as windows server 2008 .You might have tried to instal sharepoint foundation software on your client OS such as Vista,Windows7,etc.Here i have got a msdn link .You can follow the steps they have mentioned and you can successfully install the SharePoint Foundation on your client OS.    Follow this Post Cheers Pradeepa