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

How to get the SharePoint central admin url programmaticaly via C#?

I had come across a situation where i had to get the sharepoint central admin's url.. You can follow the following snippet of the code. At the begining add the namespace  using Microsoft.SharePoint.Administration; SPAdministrationWebApplication centralAdminFarmUrl =  Microsoft.SharePoint.Administration.SPAdministrationWebApplication.Local ; String  centralAdminUrl = centralAdminFarmUrl.Sites[0].Url;  This may help someone -Cheers Pradeepa Achar

Programmatically read the value from web.config file

Here is a situation where you need to keep a key value pair element in the web.config file and read them during the run time. I suggest, better keep key /value pair under <appSettings> element and read it programmatically . <appSettings>   <add key=" LicenseKey " value=" 987jKouterhsk " /> </appSettings> Assume , you have added a license key as above in the web.config file. You need the license key during run time. You can access the license key class named "ConfigurationManager". write a property  called getLicenseKey and return the corresponding license key. public string GetLicenseKey {    get{   return  ConfigurationManager.AppSettings[" LicenseKey "]; } } Now the property GetLicenseKey will have the value 987jKouterhsk. Use this value as per your requirement. -Cheers Pradeepa Achar