Click here to Skip to main content
15,898,588 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
C#
using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Collections;
using System .Collections.Generic ;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.IO;
using System.Data.OleDb;
using System.ComponentModel;

public partial class _Default : System.Web.UI.Page
{
    class Point { double X, Y; }
    DataTable dt = new DataTable();
    int X, Y;
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        string connectionString = "";
        if (FileUpload1.HasFile)
        {
            string fileName = Path.GetFileName(FileUpload1.PostedFile.FileName);
            string fileExtension = Path.GetExtension(FileUpload1.PostedFile.FileName);
            string fileLocation = Server.MapPath("~/App_Data/" + fileName);
            FileUpload1.SaveAs(fileLocation);
            if (fileExtension == ".xls")
            {
                connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileLocation + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=2\"";
            }
            else if (fileExtension == ".xlsx")
            {
                connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileLocation + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\"";
            }
            OleDbConnection con = new OleDbConnection(connectionString);
            OleDbCommand cmd = new OleDbCommand();
            ArrayList List = new ArrayList();
            cmd.CommandType = System.Data.CommandType.Text;
            cmd.Connection = con;
            OleDbDataAdapter dAdapter = new OleDbDataAdapter(cmd);
            DataTable dtExcelRecords = new DataTable();
            con.Open();
            DataTable dtExcelSheetName = con.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
            string getExcelSheetName = dtExcelSheetName.Rows[0]["Table_Name"].ToString();
            cmd.CommandText = "SELECT * FROM [" + getExcelSheetName + "]";
            dAdapter.SelectCommand = cmd;
            dAdapter.Fill(dtExcelRecords);
            if (Session["dtInSession"] != null)
            {
                dt = (DataTable)Session["dtInSession"];
            }
            for (int i = 0; i < dtExcelRecords.Rows.Count; i++)
            {
                //if you want to get the string
                DataRow thisRow = (DataRow)dtExcelRecords.Rows[i];
                X = Convert.ToInt32(thisRow["X"]);
                Y = Convert.ToInt32(thisRow["Y"]);
                //double Length = Convert.ToDouble(Y);
                //double X1 = Convert.ToDouble(X);
                DataRow dr = dt.NewRow();
                polygonArea();
            }

        }
    }

    private Double polygonArea(int[] X,int[] Y)
    {
        Double area = 0.0;
        int j = X.Length - 1;
   for (int i=0; i < X.Length; i++) 
   {
    area=area+(X[j]+X[i]*(Y[j]-Y[i])); 
           j=i;    
   }
   area =area/ 2;
        if (area < 0)
        area = area * -1;
    return area;
}
    
}  
Posted
Updated 30-Sep-13 21:11pm
v3
Comments
Kornfeld Eliyahu Peter 1-Oct-13 3:01am    
You call polygonArea with no params, but the only polygonArea function has a signature of double f(int, int)...
[no name] 1-Oct-13 3:03am    
k what can i pass here help me
because am begning learner
Alexander Dymshyts 1-Oct-13 3:02am    
create default constructor for polygon area.
[no name] 1-Oct-13 3:04am    
how
[no name] 1-Oct-13 3:05am    
please give me the total solution for that problem

1 solution

I strongly recommend you to refer these links

Functions in C#[^]

Methods (C# Programming Guide)[^]

Regards..
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900