title: How can I read the Uploaded CSV file without saving it to Server?
body: <p>Hi all, I have CSV files which are in this format:</p>
  
  <pre><code>**CSV Format1**
  
    ||OrderGUID||OrderItemID||Qty||SKUID||TrackingNumber||TotalWeight||DateShipped||DateDelivered||ShippingStatusId||OrderShippingAddressId
    ||5        ||3          ||2  ||12312||aasdasd       ||24         ||2012-12-2010||            || 10025          ||10028
    ||5        ||4          ||3  ||113123||adadasdasd   ||22         ||2012-12-2012||            ||10026           ||10028
  
  
  
  **CSV Format2**
  
      ||"OrderGUID"||"OrderItemID"||"Qty"||"SKUID"||"TrackingNumber"||"TotalWeight"||"DateShipped"||"DateDelivered"||"ShippingStatusId"||"OrderShippingAddressId"||
      ||"5"        ||"3"          ||"2"  ||"12312"||"aasdasd"       ||"24"         ||"2012-12-2010"||""            || "10025"          ||"10028"||
      ||"5"        ||"4"          ||"3"  ||"113123"||"adadasdasd"   ||"22"         ||"2012-12-2012"|| "2012-12-2010" ||"10026"           ||"10028"||
  </code></pre>
  
  <p>I have to read these files without saving them on the server. Can anyone help me? How can I read this files and insert in my db? How can I trim the special characters from the files?</p>
  
  <p>This is what I am trying to do for the file upload:</p>
  
  <pre><code>[AcceptVerbs(HttpVerbs.Post)]
  public ActionResult ImportTrackingNumber(FormCollection form,HttpPostedFileBase UploadedFile,TrackingNumbersModel Trackingnumbers)
  {
      if (UploadedFile != null)
      {
          var allowedExtensions = new[] {".xlsx", ".csv"};
          if (UploadedFile.ContentLength &gt; 0)
          {                   
              var extension = Path.GetExtension(UploadedFile.FileName);
              if (extension == ".xlsx")
              {
                  //Need To code For Excel Files Reading
              }
              else if (extension == ".csv")
              {
                  //string filename = Path.GetFileName(UploadedFile.PostedFile.InputStream);
                  StreamReader csvreader = new StreamReader(UploadedFile.FileName);
                  DataTable dt;        
              }
          }
      }
      return View();
  }
  </code></pre>