Skip to content
Advertisement

Tag: c#

Taking same column but different values from database in C#

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 equipment selections Answer Keep your sql been

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 Linq, but the query’s performance caused the webpage to timeout and

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 row.DeliveryDate? Answer actually the problem is SQL DateTime =/= C# Datetime you

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 Try xml linq. I took

Advertisement