C#

string istr = "insert into sheet1(Personnel_Area,EE_Grp,Employee_Group,ESgrp,Employee_Subgroup,Cost_ctr,Cos

t_Center,PSubarea,Personnel_Subarea,Peres_no,Personel_Number,Designation,D

esigna,Pos,Age_of_Employee,Birthdate,Complete_name)values('" + Convert.ToString(dataGridView1.Rows[i].Cells[0].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[1].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[2].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[3].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[4].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[5].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[6].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[7].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[8].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[9].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[10].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[11].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[12].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[13].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[14].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[17].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[18].Value.ToString()) + "')";

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        PageContentCollection pcc = new PageContentCollection(2,this.GetType().Name);  
        //...
    }
}

namespace Gake.Orchard.Business
{
    public class PageContentCollection : Gake.Orchard.Data.PageContentCollection<pagecontent>
    {
	//...
    }
}

namespace Gake.Orchard.Data
{
    public abstract class PageContentCollection<typpagecontent> : Gake.Data.Base.DataCollection<pagecontent> where typPageContent : PageContent
    {
        public PageContentCollection(int Panel, string Page)
        {
            //DataResult result = base.Retrieve("Panel = @1 and Page = @2", Panel, Page);
            DataResult result = base.Retrieve(typeof(typPageContent), "Panel = @1 and Page = @2", Panel, Page);
		//...
        }
    }
}

namespace Gake.Data.Base
{
    public abstract class DataCollection<typdataobject> : CollectionBase where typDataObject : DataObject//, new()
    {
        //public DataResult Retrieve(string Conditions, params object[] Values)
        public DataResult Retrieve(Type TypeOfChild, string Conditions, params object[] Values)
        {
		//...
		//typDataObject typObj = new typDataObject(); 
		Object objChild = Activator.CreateInstance(TypeOfChild);
		//...
        }
    }
}</typdataobject></pagecontent></typpagecontent></pagecontent>