Errors in asp.net database

See also questions close to this topic

• C# Recorded Macro run

  I want to run an Excel macro code, but I don't know how to get started. The point would be:

  • "xy" .csv gets the macro (I choose the path ) -Where should I store the macro? In the C# code or idk...

  Can I rewrite the macro or can we run it in C#? Could you give me an idea of ​​what i should do?

  There is a macro what I recorded in Excel Thx in advance!

  Sub Macro1()
  

  ' ' Macro1 Makró '

  ' ActiveWorkbook.Queries.Add Name:="stat_cipolla_e0c8", Formula:= _ "let" & Chr(13) & "" & Chr(10) & " Forrás = Csv.Document(File.Contents(""C:\Users\Feri\source\repos\stat_cipolla_e0c8.csv""),[Delimiter="","", Columns=17, Encoding=65001, QuoteStyle=QuoteStyle.Csv])," & Chr(13) & "" & Chr(10) & " #""Első sor használata fejlécként"" = Table.PromoteHeaders(Forrás, [PromoteAllScalars=true])," & Chr(13) & "" & Chr(10) & " #""Típus módosítása"" = Table.TransformColumnTypes(#""Első sor használata fejlécként"",{{" & _ """Tippmester"", type text}, {""Tipster Group"", type text}, {""Sportág"", type text}, {""Ország"", type text}, {""Template"", type text}, {""Esemény"", type text}, {""Típus"", type text}, {""Kezdés"", type datetime}, {""Tipp"", type text}, {""Odds"", type text}, {""Eddig éri meg"", type text}, {""Tét"", Int64.Type}, {""Profit"", type text}, {""Eredmény"", type text}" & _ ", {""Fogadóiroda"", type text}, {""Description En"", type text}, {""Description HU"", type text}})" & Chr(13) & "" & Chr(10) & "in" & Chr(13) & "" & Chr(10) & " #""Típus módosítása""" ActiveWorkbook.Worksheets.Add With ActiveSheet.ListObjects.Add(SourceType:=0, Source:= _ "OLEDB;Provider=Microsoft.Mashup.OleDb.1;Data Source=$Workbook$;Location=stat_cipolla_e0c8;Extended Properties=""""" _ , Destination:=Range("$A$1")).QueryTable .CommandType = xlCmdSql .CommandText = Array("SELECT * FROM [stat_cipolla_e0c8]") .RowNumbers = False .FillAdjacentFormulas = False .PreserveFormatting = True .RefreshOnFileOpen = False .BackgroundQuery = True .RefreshStyle = xlInsertDeleteCells .SavePassword = False .SaveData = True .AdjustColumnWidth = True .RefreshPeriod = 0 .PreserveColumnInfo = True .ListObject.DisplayName = "stat_cipolla_e0c8" .Refresh BackgroundQuery:=False End With Application.CommandBars("Queries and Connections").Visible = False Columns("O:Q").Select Range("stat_cipolla_e0c8[[#Headers],[Description HU]]").Activate Selection.Delete Shift:=xlToLeft Columns("M:M").Select Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove ActiveCell.FormulaR1C1 = "Tet1" Range("M2").Select ActiveCell.FormulaR1C1 = "1000" Selection.AutoFill Destination:=Range("stat_cipolla_e0c8[Tet1]") Range("stat_cipolla_e0c8[Tet1]").Select Columns("O:O").Select Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove ActiveCell.FormulaR1C1 = "Profit1" Range("O2").Select Application.CutCopyMode = False ActiveCell.FormulaR1C1 = "=[@Tet1]*[@Odds]" Columns("J:J").Select Selection.Replace What:=".", Replacement:=",", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False, FormulaVersion:=xlReplaceFormula2 End Sub
• Create an application to return detail about how many result I fould using API, ASP.net Core

  Well I'm trying to find out about web API And i just found an test to do just to practice and the test is, create a simple application using web API to return numbers of result about an URL on google but my I'm new in development and need help to get on the track, could someone help out.

  Test description:

  The CEO from InfoTrack is very interested in SEO and how this can improve Sales. Every morning he searches the keyword “land registry searches” in Google and counts down to see where and how many times their company, www.infotrack.co.uk sits on the list. Seeing the CEO do this every day, a smart software developer at InfoTrack decides to write a small application for him that will automatically perform this operation and return the result to the screen. They design and code some software that receives a string of keywords, and a string URL. This is then processed to return a string of numbers for where the resulting URL is found in Google. For example “1, 10, 33” or “0”. The CEO is only interested if their URL appears in the first 100 results.
• Custom generic json converter not called

  I have a custom JsonConverter for a Dictionary with abstract keys and values:

  public class DictionaryJsonConverter<TKey, TValue> : JsonConverter<Dictionary<TKey, TValue>>
  

  I use it as follows:

  [JsonConverter(typeof(DictionaryJsonConverter<ServerDevice, long>))]
  public static Dictionary<ServerDevice, long> KnownServers { get; set; }
  

  But neither the read nor the write method is called. Am I missing something?

  Error reproduction example: https://dotnetfiddle.net/2VakI3 (Does not compile in DotNetFiddle)
  I do not guarantee that the read or write methods are correct because I never saw a result.
• twilio api sending whatsapp messages with c#

  pleas help I'm working in WinForms form app and I'm trying to send whatsapp messages to client. I installed twilio api package in my project but when i'm trying to import twilio name space I can't

  using System;
  using System.Collections.Generic;
  using Twilio;// but i can import this name space
  using Twilio.Rest.Api.V2010.Account;//I can't import this name space
  using Twilio.Types;//I can't import this name space
  

  pleas help me to know what to do i'm using vs2015 asp.net and installed twilio v 5.8.3
• Deploy asp. net 5 to netlify

  Recentlly I started using netlify and I have a feeling that I know it a little. So, right to my question. I have asp.net 5 project, Am I able to publish it onto netlify? If so, how effective is it? Is there some other hosting service that is "free" and without much limitations like offline time per day?