I am trying to get top 3 safety data row according to equipment and plant selection from database. Now I could get top 3 safety value from database with equipment and plant selection and insert to textbox. When I wrote “‘ or Safety ‘” + textbox.text + it is getting other plant and equi…
Tag: c#
Can’t save multiple selections in select list – asp.net core web app razor pages
Here I am able to bind the multi-select select list on the create page. The biggest problem I’m having is that I am trying to edit/post values and there’s no direct field to bind to in my model. I have found a good example here, but it only shows you how to save 1 selection. https://www.learnrazor…
“Could not find stored procedure” error when called from C# application
I created a stored procedure in SQL Server and tried calling it from my C# application but I am getting a message Could not find stored procedure I have already tried all possible solutions from &…
HTML1300: Navigation occurred
I have my website that I have deployed in IIS 7 and run it in IE10. All tabs of this website working fine except one . When I click on that tab, it took me to log in page that is my default page. And …
Filter and Match Column on a List of Substrings
I am attempting to filter a table of user actions on a list of specific actions. For example, given the following data I want all rows where the UserAction contains the strings “Account Creation” or “Attempt to create duplicate account”. I was able to achieve this with the following Li…
How to Use Dates in Where Clause in EF Core?
I need to filter my queries by dates but I don’t care in this case about time portion of it that is stored in SQL Database. I first tried to something like var now = DateTime.Now.Date; Where(x => …
How to add parameters to a query when query is unknown length
I am working on a project where multiple rows are needed to be added to a MySQL table, due to the high latency of the connection I am trying to add all the values in one command to save time. So far I have a SQL query that is determined by a string array(each string being a “token”), this, being
SQLDateTime OverFlow with Correct DateTime Format
below is my code snippet where I insert a DateTime value to SQL database and encountered the following error: System.Data.SqlTypes.SqlTypeException: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. May I know if there is a format to be used? when converting the value of r…
Add child note above node
Am trying to get from SQL to XML however have to format this correctly or it will not work. I am using C# to insert my sql between the QBXML This is what I get This is what I need ”’ ”’ I am not sure how to add the “CustomerAddRq” over each “CustomerAdd” Answer …
Charting the data from database and merging row with the same value
I want to create chart that read the category column in my database.. I have repeating category because its general term and i notice this. I have many “short” slice: I dont have any idea how to …