ASP.NET

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using Interface_Project.Presenter.PresenterAdmin;
using Interface_Project.Model.ModelAdmin;

namespace Interface_Project
{
    public partial class ManageCity : System.Web.UI.Page
    {
        ModelCityDetails modelObjCity = null;
        protected void Page_Load(object sender, EventArgs e)
        {
            modelObjCity = new ModelCityDetails(this);
        }

        protected void btnAdd_Click(object sender, EventArgs e)
        {
            if(modelObjCity.insertCityDetails())
            {
                ClientScript.RegisterStartupScript(this.GetType(),"alert","<script>alert('City details inserted successfully.')</script>");
            }
            else
                ClientScript.RegisterStartupScript(this.GetType(),"alert","<script>alert('Error in inserting city details.')</script>");

        }
    }

    public partial class ManageCity : Interface_Project.Presenter.PresenterAdmin.ManageCity.IManageCity
    {
        public int cityid
        {
            get
            {
                return 0;
                //return int.Parse(hdnCityId.Value);
            }
            set
            {
                //hdnCityId.Value = value.ToString();
            }
        }

        public string cityname
        {
            get
            {
                return txtCity.Text;
            }
            set
            {
                txtCity.Text = value;
            }
        }
    }
}

step 1: i took a web site application

step 2: i took a master page (.master) and 2 content pages (.aspx), of that are inherited from master page.

Step 3: i took both master page and content pages of same hierarchy in solution explorer of my application.

Step 4: when i run the application it works fine in my local system.

Step 5: when i run the application, it throws an error related to parsing kind of stuff.

as i thought:

1) either my application is not compiled properly
2) or my application thinks that the site master is located in different folder.
3) i did tried with master page virtual and type name properties, but no progress in this error.

any help would be appreciated.

using System;
using System.Configuration;
using System.Data;
using System.IO;
using System.Data.Common;
using System.Data.SqlClient;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Globalization;
 
namespace StaffingWebParts.VisualWebPart1
{
    public partial class VisualWebPart1UserControl : UserControl
    {
 

        protected void Page_Load(object sender, EventArgs e)
        {
 
            if (!Page.IsPostBack)
            {
          //      this.QueryStaff();
                gvNewResource.DataSource = QueryStaff();
                gvNewResource.DataBind();
 

            }
        }
 
        private static char[] Colon = new char[] { ',' };
        private DataTable QueryStaff()
 
        {
            const int nameColumnIndex = 1;
            const int hoursColumnIndex = 9;
 

 
            using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["SQLStaffingConn"].ConnectionString))
            using (var cmd = new SqlCommand("", conn))
            using (var dataAdapter = new SqlDataAdapter(cmd))
            using (var cmdBuilder = new SqlCommandBuilder(dataAdapter))
            {
                // create temporary table in database
               conn.Open();
               cmd.CommandText = "CREATE TABLE #TempTable(Name nvarchar(100) NOT NULL, Hours decimal(6, 2) NOT NULL);";
               cmd.ExecuteNonQuery();
 
                // create a DataTable and let the DataAdapter create appropriate columns for it
                DataTable dataTable = new DataTable();
                cmd.CommandText = "SELECT * FROM #TempTable;";
                dataAdapter.Fill(dataTable);
 
                // read the CSV-records into the DataTable
                dataTable.BeginLoadData();
 

             //  using (StreamReader reader = new StreamReader(NRFileUpload.FileContent))
               using (StreamReader reader = File.OpenText(@"c:\Users\pzd74f\Downloads\FinalLabor2015.csv"))
                {
                    string line;
                    if (reader.ReadLine() != null) // skip first line (headers)
                    {
                        while ((line = reader.ReadLine()) != null)
                        {
                            string[] columns = line.Split(Colon, StringSplitOptions.None);
 
                            DataRow row = dataTable.NewRow();
                            row["Name"] = columns[nameColumnIndex];
                            row["Hours"] = Decimal.Parse(columns[hoursColumnIndex], NumberFormatInfo.InvariantInfo);
                            dataTable.Rows.Add(row);
 
                        }
 
                    }
                }
                dataTable.EndLoadData();
 
                // insert the records from the DataTable into the temporary table
                dataAdapter.Update(dataTable);
 
                // load the result of the "main purpose" query into the DataTable
                dataTable.Clear();
                cmd.CommandText = "SELECT Tmp.Name, SUM(Tmp.Hours) as Hours FROM #TempTable AS Tmp  WHERE NOT EXISTS (SELECT * FROM StaffTracking AS ST WHERE Tmp.Name = ST.ResourceName)GROUP BY Tmp.Name;";
                dataAdapter.Fill(dataTable);
 

                return dataTable;
 
            }
 
        }
 
    }
}