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
            dataTable.BeginLoadData();


         //  using (StreamReader reader = new StreamReader(NRFileUpload.FileContent

[Abhinav S]

You can allow the user to select a file using the FileUpload control. This will allow you to choose a file on the client machine. Try these tutorials - File Upload with ASP.NET[^] FileUpload Control[^]

Mobile Apps - Sound Meter | Color Analyzer | SMBC | Football Doodles

[Norris Chappell]

Hi, Thanks for the information. I was able to get the correct code but where do I put this in my code?

protected void UploadButton_Click(object sender, EventArgs e)
{
if (NRFileUploadControl.HasFile)
{
try
{
string filename = Path.GetFileName(NRFileUploadControl.FileName);
NRFileUploadControl.SaveAs(Server.MapPath("~/") + filename);
StatusLabel.Text = "Upload status: File uploaded!";
}
catch (Exception ex)
{
StatusLabel.Text = "Upload status: The file could not be uploaded. The following error occured: " + ex.Message;
}
}
}

It just runs this part and don't execute the rest of my code. Thanks, Norris

[Norris Chappell]

Abhinav, I want to thank you for provided those websites. If you have the time could you look at my code and let me know where I need to insert the new code?