How do I access a csv file without hardcoding it in my code?

[Norris Chappell]

I want to use: using (StreamReader reader = new StreamReader(NRFileUpload.FileContent)) instead of using (StreamReader reader = File.OpenText(@"c:\Users\pzd74f\Downloads\FinalLabor2015.csv")) However when I try to insert this code: protected void ImportButton_Click(object sender, EventArgs e) { if (this.FileUpload.HasFile) { var extension = Path.GetExtension(FileUpload.FileName); if (extension == ".csv") { using StreamReader reader = new StreamReader(FileUpload.FileContent)) } } } It just imports the file and the rest of my code is not executed. Here is my code:

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