I am trying to perform this Query and this is the result that I get from that: SELECT dbo.Show.ShowId, dbo.Show.Name, dbo.Cast.CastId, dbo.Cast.Name, dbo.Cast.Birthday FROM dbo.Show INNER JOIN dbo.Cast ON dbo.Cast.ShowId = dbo.Show.ShowId WHERE dbo.Cast.ShowId=1; This is the output of this…
Trying to create a controller in order to add an instance of a class to a SQL database However, I keep getting a 415 error whenever I try to do. The error specifically shows the following -> Unhandled exception rendering…
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…
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…
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…
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…
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":…
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…
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…
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…