how to write Api To Upload A text file and Create a datatable in c#

To write an API that can upload a text file and create a datatable in C#, you can follow these steps:

1. Create a new C# Web API project in Visual Studio.
2. Define a POST method in your controller to handle file uploads. This method should accept a file as input and return a response indicating success or failure.
3. Inside the POST method, read the contents of the uploaded file and convert it into a string.
4. Parse the string to create a datatable using the System.Data.DataTable class in C#.
5. Return the datatable as the response from the API.

Here is a sample code that demonstrates the above steps:

[HttpPost]
public IHttpActionResult UploadFile()
{
    var httpRequest = HttpContext.Current.Request;
    if (httpRequest.Files.Count < 1)
    {
        return BadRequest("No file uploaded.");
    }

    var file = httpRequest.Files[0];
    var fileContent = new StreamReader(file.InputStream).ReadToEnd();
    var dataTable = ConvertToDataTable(fileContent);

    return Ok(dataTable);
}

private DataTable ConvertToDataTable(string fileContent)
{
    var lines = fileContent.Split(new[] { '\r', '\n' }, StringSplitOptions.RemoveEmptyEntries);
    var dataTable = new DataTable();
    var headers = lines[0].Split(',');
    foreach (var header in headers)
    {
        dataTable.Columns.Add(header);
    }

    for (int i = 1; i < lines.Length; i++)
    {
        var values = lines[i].Split(',');
        var row = dataTable.NewRow();
        for (int j = 0; j < headers.Length; j++)
        {
            row[j] = values[j];
        }

        dataTable.Rows.Add(row);
    }

    return dataTable;
}

Thanks

Naimish Makwana

how can u do this via normal  in  c#

Hello,

You can create below controller and post method to upload file, and do call from UI using ajax,

using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
using System.Data;
using System.IO;
using System.Threading.Tasks;

namespace YourNamespace.Controllers
{
    [ApiController]
    [Route("api/[controller]")]
    public class FileUploadController : ControllerBase
    {
        [HttpPost("upload")]
        public async Task UploadFile(IFormFile file)
        {
            if (file == null || file.Length == 0)
            {
                return BadRequest("Please select a file to upload");
            }

            string fileContent;
            using (var reader = new StreamReader(file.OpenReadStream()))
            {
                fileContent = await reader.ReadToEndAsync();
            }

            DataTable dataTable = new DataTable();
            string[] lines = fileContent.Split("\n");

            // create columns
            string[] headers = lines[0].Split(";");
            foreach (string header in headers)
            {
                dataTable.Columns.Add(header.Trim());
            }

            // add rows
            for (int i = 1; i < lines.Length; i++)
            {
                string[] values = lines[i].Split(";");
                DataRow row = dataTable.NewRow();
                for (int j = 0; j < headers.Length; j++)
                {
                    row[j] = values[j].Trim();
                }
                dataTable.Rows.Add(row);
            }

            return Ok(dataTable);
        }
    }
}