c# Questions

Timeout when Connecting to MongoDB Atlas from Azure App Service

March 15, 2023
muttley91
2 Answers

I'm trying to connect to my MongoDB database using the following setup: public ReplybotServiceLayer(MongoDbSettings databaseSettings) { var connectionString = $"mongodb+srv://{databaseSettings.User}:{databaseSettings.Password}@{databaseSettings.Cluster}.mongodb.net/{DatabaseName}?w=majority&connect=replicaSet"; var client = new MongoClient(connectionString); var database = client.GetDatabase(DatabaseName); _guildResponsesCollection = database.GetCollection<GuildResponseEntity>("responses"); _guildConfigurationsCollection = database.GetCollection<GuildConfigurationEntity>("configuration"); } public async Task<IList<TriggerResponse>?> GetResponsesForGuild(ulong…

VIEW QUESTION

How can I manpulate how the JSON file displays its data?

March 14, 2023
Ruben
2 Answers

So far I can read a excel spreadsheet and convert it to JSON but I'm struggling to manipulate what data i want from the spreadsheet and how I want it displayed. this is how I read the sheet and add…

VIEW QUESTION

Warning while using gcc compiler -Wimplicit-int – Ubuntu

March 14, 2023
Cornelius Ngure
2 Answers

I'm just starting out on C language and I'm getting stuck on a seemingly very basic code. Now, I'm using gcc to compile on ubuntu terminal and I keep getting this warning: return type defaults to 'int' [-Wimplicit-int] NOTE: the…

VIEW QUESTION

Postgres Interval with Dapper & npgsql not working – Postgresql

March 14, 2023
jason.kaisersmith
2 Answers

I am using Dapper with Postgres npgsql and I am having trouble executing an SQL command using INTERVAL. The command works fine outside my code. I get the error Npgsql.PostgresException: '42601: syntax error at or near "$1" POSITION: 85' Position…

VIEW QUESTION

Deserialize JSON with comma-separated values

March 14, 2023
CodeLearner
3 Answers

I want to de-serialize a JSON where a node contains values which comma-separated. But the object which contains the comma returns null when deserializing. Input JSON: { "SolutionTabletSubSectionUId": "3fa85f64-5717-4562-b3fc-2c963f66afa6", "SolutionTabletSubSectionId": 1, "SolutionTabletUId": "3fa85f64-5717-4562-b3fc-2c963f66afa6", "Title": "string", "SubTitle": "string", "Description": "string", "Link":…

VIEW QUESTION

how to pass float type to url in c#? – Asp.net

March 14, 2023
kaziveh
3 Answers

in client side : <script type="text/javascript"> function ShowDetailPopup(FPS_Code, PhaseNo) { popup.SetContentUrl("test4.aspx?id=" + FPS_Code + "&PhaseNo=" + PhaseNo); popup.Show(); } </script> in server side: using (SqlConnection con = new SqlConnection(strcon1)) { SqlCommand cmd = new SqlCommand("SELECT ID,DocumentNo,ReleaseNo,PhaseNo,FPS_Code,DrawingNo FROM Project1 WHERE FPS_Code=@FPS_Code…

VIEW QUESTION

Visual Studio Code – Trying to alter .NET 6 configuration class in .ConfigureServices

March 13, 2023
furman87
2 Answers

Here is my situation -- my development team must get its connection strings and other sensitive values like passwords from machine-level environment variables on Windows servers. I have a .NET 6 Console App using Generic Host, and in my appsettings.json…

VIEW QUESTION

How would I update the Textboxes in this multi-tiered program in order to properly display the values which are gotten by each method? C# ASP.NET

March 13, 2023
Simply
2 Answers

I have been asked to write a multi-tiered program that loads and parses 24 student grades from an xml file, and then display all grades, the lowest grade, the highest grade, and the average grade to the web form using…

VIEW QUESTION

How to pass JSON array in body of web api c#

March 13, 2023
BlackCat
3 Answers

I am trying to capture a JSON array of string from POST Request in web api. [HttpPost] [Route("")] public async Task<IHttpActionResult> CancelItems([FromBody] List<string> items) { //codes } But I am getting null in items. Post Body: { "items":[ "1034908029943809497", "1034908029943809494"…

VIEW QUESTION

Visual Studio Code – Azure Devops REST API with .NET 6 C#. Push a zipped folder to a repo

March 13, 2023
Neeraj
2 Answers

I am trying to push a zipped folder contents to a azure repo using REST API call. I am using visual studio 2022 version with .NET6 C# code. below is the code piece: var fileContent = await new HttpClient().GetByteArrayAsync(folderZipUrl); var…

VIEW QUESTION