|
For a start, you'll need to make your method async to use the HttpClient class. Which unfortunately means you'll need to make the calling method async, and so on - it's async all the way down.
At the basic level, your code would look something like this:
public async Task<ToProgModel> ProgCsvAsync(Uri webSiteProg, ToProgModel prog, string complextProg)
{
HttpClient client = new HttpClient();
SetBasicAuthHeader(client.DefaultRequestHeaders, AuthorisatorProg, PasswordProg);
using (HttpResponseMessage response = await client.GetAsync(webSiteProg))
{
if (!response.IsSuccessStatusCode)
{
prog.Ret = $"Http response EX: {response.StatusCode}";
return null;
}
string progTextString = await response.Content.ReadAsStringAsync();
...
return prog;
}
}
public void SetBasicAuthHeader(HttpRequestHeaders headers, string userName, string userPassword)
{
string authInfo = userName + ":" + userPassword;
authInfo = Convert.ToBase64String(Encoding.Default.GetBytes(authInfo));
headers.Authorization = new AuthenticationHeaderValue("Basic", authInfo);
} There are several improvements you can make to this - for example, using IHttpClientFactory[^] to manage the HttpClient instances.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Hi Homer, thanks for your response. But I don't see in IHttpClientFactory how to implement "Http Basic Authentication"
So as in my source "
SetBasicAuthHeader(webrequest, AuthorisatorProg, PasswordProg); "
|
|
|
|
|
I included an updated version of that method in my answer.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Sorry Richard,
I had mist in the first moment your update, only see your phrase from Homer.
But now I need to give you many thanks for your UPDATE on my program.
I have installed your update and every thing works nice.
Thank you very much en best regards Ger
|
|
|
|
|
Hi, please pretty much new to web development, I recently developed a little e-commerce website using Node js, express for the backend, and plain HTML and CSS for the front-end. Can anyone help me with a guide on how to take this site to production?
|
|
|
|
|
Choose a web host that has been around for at least 15 or 20 years and contact them and ask them how to get this started. You should get your own dot com and start with the MINIMUM setup that the web host will allow. Then work with the site (your own dot com) for at least 30 days so that you have forced yourself to not rush into it and you have some experience watching the results of your choices.
Do NOT spend a lot of money on options at the web host. Almost everything that they offer to you for money: you can probably do yourself. Except things like getting an SSL certificate, do that after 30 days and pay for it.
Thank you for asking.
|
|
|
|
|
I have pairs of images and their related texts in my web application. My images are small rounded photos that the user can click on each of them to enter a new page. I want to place their specified texts at the center of those thumbnails.
I wrote these codes:
<html lang="fa">
<head>
<title>Information System</title>
<style>
#main-image{
display: block;
margin-left: auto;
margin-right: auto;
max-width: 100%;
max-height: auto;
}
b{
font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;
color: blue;
}
.sub-image{
border-radius: 5%;
}
.container{
position: relative;
text-align: center;
}
</style>
</head>
<body bgcolor="white">
<div>
<img id="main-image" src="Images/IT.jpg" width="1600" alt="Intro">
</div>
<hr>
<div class="container">
<img class="sub-image" src="Images/repair.jpg" width="300">
<div class="image-text">
Failures
</div>
</div>
<div class="container">
<img class="sub-image" src="Images/Equipment.jpg" width="300">
<div class="image-text">
Equipments
</div>
</div>
</body>
</html>
Please help me.
modified 21-Jul-21 14:01pm.
|
|
|
|
|
Hey you have to write these css code to make text appear over the image and center .
.image-text{position:absolute; top:50%; left:0; width:100%; z-index:10; text-align:center; transform:translateY(-50%);}
You can keep you css as it is.. just paste above css and your text will be over and center. let me know if it work for you.
|
|
|
|
|
|
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.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
