|
|
Message Closed
modified 28-Jul-21 7:49am.
|
|
|
|
|
|
I recently got this at the NY Times website.
|
|
|
|
|
|
|
I have a Idea for general problem solving of the people. I can not share it here in detail. but the functionality as similar OLA.
which Technology I should prefer ?
How much Time will be taken
Budget Also
|
|
|
|
|
In my thought, it's depend on client demand. Nowadays, lots of template code is existing and similar code is selling on Envato, you can check code and can pay for it.
|
|
|
|
|
There is no way to give a specific answer without knowing the details of the app.
1. Which Technology? The one that can handle what you need and are most familiar with.
2. How much time will be taken? How do you think we can answer that?
3. Again, you have given no details so how can we possibly answer any of these questions?
|
|
|
|
|
I am needing to import excel data into my program. I am using Visual Studio 2019 web development and my code behind runs VB.
I would like to load data into gridview and from there into sql. I have a lot of work to do to clean up the data before my final product is ready. So I am wiring a routing to clean up the data.
Anyone have an idea. I have been searching online but most of the options does not work. If you have the answer please also provide me with the imports statements I need.
|
|
|
|
|
It is not clear what your actual problem is, but importing from Excel is fairly painless in .NET. You just need to use the Microsoft.Office.Interop.Excel Namespace | Microsoft Docs[^]. Google will find you sample code.
[edit]
As @RichardDeeming points out below, you cannot do this in a web application. But you could do it offline if that is an option.
[/edit]
modified 19-May-21 4:03am.
|
|
|
|
|
You can't use Excel interop in a web application. 
Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, ASP.NET, DCOM, and NT Services), because Office may exhibit unstable behavior and/or deadlock when Office is run in this environment.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Do you ever find that someone unplugged your brain while you were asleep? 
TBH I missed the two key words.
|
|
|
|
|
THe only purpose in me doing this is to get my data in to sql so that I can start cleaning the old data up (It is a mess), and making the needed changes. The only time I would use this is a few times when I need to reupload data.
|
|
|
|
|
Michael Hinkle wrote: web development
You won't be able to use Excel automation to do this:
Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, ASP.NET, DCOM, and NT Services), because Office may exhibit unstable behavior and/or deadlock when Office is run in this environment.
Instead, use a library which supports reading Excel files without having Excel installed.
For Excel 2007 files (*.xlsx), any of the following should work:
If you need to support old-format files (*.xls), then you can use NPOI[^].
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Assuming SQL means SQl server the why not do the clean up in SSMS. My standard method was:
Import the data manually into SQL Server. I would load the data into a new table accepting whatever garbage is in the excel file. All data should be converted to strings on the way in.
Create and empty destination table matching your final destination (this is so you can repeat the process)
Write a stored procedure that:
loops each column and cleans and formats the data as required and inserts it into the temp table.
When you are confident the process works then change the destination to the final destination table.
If this works consistently between loads you can then turns the entire process into a Job which can then be launched by your application.
This method does require reasonable T-SQL skills but would also be an excellent learning exercise.
Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP
|
|
|
|
|
Here is something that I use in my web app ...
1) Define a connection string pointing to the Excel file
String.Format("Provider=Microsoft.ACE.OLEDB.12.0; Data Source = {0}; Extended Properties='Excel 12.0; HDR=Yes; IMEX=1;'", sFilename)
2) You can access some schema information from the Excel doc like this ...
DTschema = dbConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, Nothing)
3) Then get to the actual data in the spreadsheet like this ...
Using dbCmd As New OleDbCommand("SELECT * FROM [" & sSheet & "]", dbConn)
Using dbAdapter As New OleDbDataAdapter(dbCmd)
dbAdapter.Fill(DT)
End Using
It may not be pretty, but you get the data from the spreadsheet into a datatable which can then be bound to a Gridview.
See if it works for you.
|
|
|
|
|
|
Let say I have an existing MVC (Core/.NET5) app.. and I want to add a few new pages build with Blazor..
How will I proceed?
I am having a hard time making it work, or finding relevant links..
|
|
|
|
|
|
At work I am asked to do integrate our web app with some 3rd party authenticator app, say Microsoft Authenticator (they are really thinking Twilio, since MS Auth App seem expensive to use), so that some (specific) (web) page are protected with an additional level of security that would require to enter the web code from the authenticator app (not really standard MFA usage, anyway..)
At first sight this look impossible... However I noticed that in both MS and Google Authenticator there is a list of app that can be registered, not all from either MS or google... So there might be a way to use "some" well known 3rd party authenticator app with your login... Any link please?
|
|
|
|
|
Assuming you're using the standard code for generating the authenticator PIN, almost any app can be used. For example, I use Authy[^] so I can access the same set of codes on all of my computers and my mobile phone.
There are various references on how to generate the PIN from your own code. For example:
Implementing Two Factor Authentication in ASP.NET MVC with Google Authenticator[^]
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
thanks for the tip! going to investigate that!
|
|
|
|
|
Hello. I am at my wits' end trying to make this work. I have developed a website in Dreamweaver and it displays correctly. I have used custom fonts that have displayed correctly. When previewing it from Dreamweaver in Firefox, Chrome and Opera it all displays fine. When I upload to the remote server the website displays fine in Firefox but not in Chrome and Opera. I am not sure what is happening and I am stuck as I need it to display properly. Any guidance would be massively appreciated. Kind Regards
The website is siconlightning.solutions
🤯
|
|
|
|
|
Use the browser's developer tools (F12) to see if a file is not getting loaded or if css is not getting applied.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
