Click here to Skip to main content
15,890,123 members
Home / Discussions / Web Development
   

Web Development

 
AnswerRe: Website Deployment Pin
Member 150787164-Jul-22 18:53
Member 150787164-Jul-22 18:53 
QuestionHow to place text over an image using HTML/CSS? Pin
Alex Dunlop21-Jul-21 7:52
Alex Dunlop21-Jul-21 7:52 
AnswerRe: How to place text over an image using HTML/CSS? Pin
Member 1529865622-Jul-21 21:43
Member 1529865622-Jul-21 21:43 
GeneralRe: How to place text over an image using HTML/CSS? Pin
Alex Dunlop23-Jul-21 7:44
Alex Dunlop23-Jul-21 7:44 
GeneralMessage Closed Pin
23-Jul-21 18:28
Member 1529865623-Jul-21 18:28 
GeneralRe: How to place text over an image using HTML/CSS? Pin
Alex Dunlop24-Jul-21 4:21
Alex Dunlop24-Jul-21 4:21 
QuestionWhat does an "Error 503 first byte timeout" mean? Pin
swampwiz1-Jul-21 19:15
swampwiz1-Jul-21 19:15 
AnswerRe: What does an "Error 503 first byte timeout" mean? Pin
Richard MacCutchan1-Jul-21 21:02
mveRichard MacCutchan1-Jul-21 21:02 
QuestionMessage Closed Pin
30-Jun-21 23:43
Member 1527182330-Jun-21 23:43 
QuestionHow Much the Budget should be for a website like OLA and UBER Pin
Ali Salman Jun14-Jun-21 1:52
Ali Salman Jun14-Jun-21 1:52 
AnswerRe: How Much the Budget should be for a website like OLA and UBER Pin
Member 1346058222-Jun-21 23:36
Member 1346058222-Jun-21 23:36 
AnswerRe: How Much the Budget should be for a website like OLA and UBER Pin
SeeSharp214-Jul-21 10:41
SeeSharp214-Jul-21 10:41 
QuestionImport Excel sheet into Gridview and SQL Pin
Michael Hinkle18-May-21 16:41
Michael Hinkle18-May-21 16:41 
AnswerRe: Import Excel sheet into Gridview and SQL Pin
Richard MacCutchan18-May-21 21:15
mveRichard MacCutchan18-May-21 21:15 
GeneralRe: Import Excel sheet into Gridview and SQL Pin
Richard Deeming18-May-21 21:39
mveRichard Deeming18-May-21 21:39 
GeneralRe: Import Excel sheet into Gridview and SQL Pin
Richard MacCutchan18-May-21 22:01
mveRichard MacCutchan18-May-21 22:01 
GeneralRe: Import Excel sheet into Gridview and SQL Pin
Michael Hinkle19-May-21 17:27
Michael Hinkle19-May-21 17:27 
AnswerRe: Import Excel sheet into Gridview and SQL Pin
Richard Deeming18-May-21 21:42
mveRichard Deeming18-May-21 21:42 
AnswerRe: Import Excel sheet into Gridview and SQL Pin
Mycroft Holmes20-May-21 12:55
professionalMycroft Holmes20-May-21 12:55 
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

AnswerRe: Import Excel sheet into Gridview and SQL Pin
David Mujica21-May-21 5:26
David Mujica21-May-21 5:26 
AnswerRe: Import Excel sheet into Gridview and SQL Pin
SeeSharp214-Jul-21 10:41
SeeSharp214-Jul-21 10:41 
QuestionBlazor + MVC Pin
Super Lloyd11-May-21 4:37
Super Lloyd11-May-21 4:37 
AnswerRe: Blazor + MVC Pin
Super Lloyd11-May-21 4:58
Super Lloyd11-May-21 4:58 
QuestionIntegrate 3rd party Authenticator app Pin
Super Lloyd10-May-21 13:47
Super Lloyd10-May-21 13:47 
AnswerRe: Integrate 3rd party Authenticator app Pin
Richard Deeming18-May-21 4:06
mveRichard Deeming18-May-21 4:06 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.