Best "Back End" for C# web-based data wrangling?

  • Thread starter Thread starter C Sharp New Guy
  • Start date Start date
C

C Sharp New Guy

Guest
I have a utility i've made in Excel that uses VBA to automate lots of regression testing and calculations, then automates a web browser to log into a site and make sure new data has been published correctly. I wanted to try making this entirely web-based, partially to potentially improve on it and partially just to have something to work on to learn C#.

Is there some default most common best way to house data that a web browser will be displaying/working with? For instance, should I be using SQL or the Excel file as a back end database and just use browser to display resulting numbers after all the math is done?

I have tried even just a preliminary step to get started by "importing" an Excel spreadsheet and displaying the resulting numbers in a browser but am not seeing a lot of talk about doing this on the internets except for a datagrid view, which doesn't seem to involve identifying the areas or cells for values to use later.

Also, What type of project would I choose when using Visual Studio's "New Project" for this? I assume not a Console App.


I realize this is all very open ended newb question. I had a lot less trouble getting started with VBA, it seemed like there was more out there in terms of forums and starting points, perhaps because it is a less robust coding set and there are only so many things people would want to do with it. Or perhaps I'm going about what I'm trying to do with C# the wrong way and that's why I see so little about it out there.d

Continue reading...
 
Back
Top