I’m working in a C# SQLite library (SQLite-net) that doesn’t seem to support row value comparisons like this: I get an error message at the first comma. Is there a long form way of doing the same comparison that could be compatible with older SQLite implementations? I’m no expert in SQL but …
Tag: c#
How to copy Access table to SQL table in C#?
As title says I’ve used odbcconnection to sqlconnection and for the life of me cant get it to work.. Copied a bunch of code from this site but cant get them both to work. The program just hangs so …
C# BulkCopy.WriteToServer Changing Values
I have a datatable that is created from and excel sheet. I am trying to SqlBulkCopy.WriteToServer. When I do so it converts my “Percent” value to 0 when my tables schema has type Decimal(38,0) for the “Percent” column. However, it inserts correctly when I have the Data Type as Float. I…
SQL output parameter of varbinary to use as image on ASPX web form
I am trying to retrieve the logo stored into my table and display the image from the database to my aspx web page. I have output parameters in a SQL stored procedure which output the name and a …
Select data from Datagridview using checkedlistbox [closed]
I’ve got a datagridview in my form and also a checkedlistbox. I’ve written some code so that I can filter the datagridview with whatever is checked in the checkedlistbox. Although, it will only filter …
Linq tolist() count returns different value from translated sql
I have a situation where the translated sql direct form Visual Studio is returning a different number of records from the Linq. I am expecting 4 items but in the count() of the resulting list I only have 1. This is the case despite creating more records – it always returns 1. Strange thing is I have the…
Random Time Distribution using SQL Server
I have a table in SQL Server (current data) Total Over Time of EmpId 1001 in January-2020 is 3hrs 24 min I want to distribute/add 3hrs 24min randomly between 1-jan-20 to 31-jan-20 to OutTime column …
Having trouble with adding one property to an object inside a list after assigning the rest of them
I’ve been having trouble (again) with some object-oriented code. Currently I have a piece of code that populates a list with objects and its properties that goes like this: What I need is to add the baseID property to each of the objects. This is what I have currently: I want this loop to take the value…
Drag and Drop not working with external monitor [closed]
Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this question? Update the question so it focuses on one problem only by editing this post. Closed 2 years ago. Improve this question I’m working on a small project for my studies. It’s the first …
T-SQL Equivalent of regular expression ‘b’
I’m in the process of converting a CLR function that utilizes regex to a SQL function. I know that SQL Server does not fully support regex, but i just need one case to work which is a word search. Search Field Value: {“Id”:1234, “Title”: “The quick brown”} Regex Patte…