How to change cell color with NPOI

``` using NPOI.XSSF.UserModel; using NPOI.XSSF.Model; using NPOI.HSSF.UserModel; using NPOI.HSSF.Model; using NPOI.SS.UserModel; using NPOI.SS.Util; (...) XSSFWorkbook hssfwb; using (FileStream ...

c#npoi
5 May at 14:35

Why use It.is<> or It.IsAny<> if I could just define a variable?

Hi I've been using moq for a while when I see this code. I have to setup a return in one of my repo. ``` mockIRole.Setup(r => r.GetSomething(It.IsAny<Guid>(), It.IsAny<Guid>(), It...

c#unit-testingtestingmockingmoq
26 Sep at 23:54

UserPrincipal.FindByIdentity() always returns null

I am using LdapAuthentication to log a user into Active Directory. I want to find all the groups that the user belongs to. I am using the following code: string adPath = "LDAP://OU=HR Controlled Use...

c#asp.netactive-directoryldapprincipalcontext
16 May at 18:43

Mock.Of<Object> VS Mock<Object>()

I'm currently confuse on how to mock. I'm using Moq. To mock objects I usually write this way ``` var mockIRepo = new Mock<IRepo>(); ``` However, I need to create mock object for my setup. Is it...

c#unit-testingtestingmockingmoq
5 May at 04:53

async/await and opening a FileStream?

I came across the following question when trying to determine if I was using the `Stream` methods such as `ReadAsync` and `CopyToAsync` correctly: [C# 4.5 file read performance sync vs async](https://...

c#.netasync-await.net-4.5
23 May at 12:8

Null conditional operator to "nullify" array element existence

The new C# 6.0 null-conditional operator is a handy vehicle for writing more concise and less convoluted code. Assuming one has an array of customers, then you could get null instead of a length if `c...

c#arraysnullc#-6.0null-propagation-operator
5 May at 00:33

C# Download all files and subdirectories through FTP

I'm still in the process of learning C#. To help myself out, I'm trying to create a program that will automatically synchronise all of my local projects with a folder on my FTP server. This so that w...

c#.netftpftpwebrequest
4 Nov at 20:37

Mock IAuthSession.GetOAuthTokens

I have a Service Stack Service that uses the following code ``` public MyResponse Get(MyRequest request){ var authSession = GetSession(); var tokens = authSession.GetOAuthTokens("somekey"); ...

c#unit-testingnunitservicestackmoq
4 May at 19:50

How to remove ContentType requirement from NServiceKit request

I am trying to make a RESTful web service using NServiceKit version 1.0.43. I want this to work without an outside service that is not including a ContentType in their header request. My web service i...

servicestackcontent-type
4 May at 18:54

Web API Controller convert MemoryStream into StreamContent

I have a large collection of images stored on a secured server some of which need to be displayed on a world facing portal. The portal's server is inside a DMZ which allows requests in but prevents di...

c#asp.netstreamasp.net-web-api2
24 Jun at 01:46

Best practice for constant string for implementations to use

Say I have an interface: ``` public interface IFeature { Task execFeature(); } ``` and two implementations: ``` public class FirstFeature : IFeature { private IWebApi webApi; public F...

c#stringoopdesign-patternsinterface
6 Jul at 19:1

How can I create an X509Certificate2 object from an Azure Key Vault KeyBundle

I am using Azure Key Vault to protect our keys and secrets, but I am unsure how I can use the KeyBundle I retrieve using the .net SDK. How can I create an X509Certificate2 object?

c#.netazurex509azure-keyvault
4 May at 16:17

ServiceStack RedisServerEvents must start RedisPubSub server even for a client component

[ServiceStack RedisServerEvents](https://github.com/ServiceStack/ServiceStack/blob/master/src/ServiceStack.Server/RedisServerEvents.cs) implementation ties the server component with the client compone...

servicestackservicestack.redis
4 May at 16:11

Adding new namespace in C# Project

I want to add a new namespace to C# project, also number of classes are to be added in that newly created namespace. When I right-click Solution of Project, I didn't find any link to add a new namesp...

c#namespacesprojectaddition
7 May at 02:16

WPF - Columns don't hide properly when GridSplitter is moved

I'm trying to hide a column in a `Grid` with a `GridSplitter` when a button is clicked (the button sets the visibility of all items in the third column to collapsed). If I don't move the `GridSplitter...

c#wpfmvvmgridgridsplitter
4 May at 14:27

Servicestack License for Redis framework

I am using AWS Redis (Elastic Cache) for my web site, which is developed using ASP.NET MVC. To connect with Redis i am using ServiceStack.Redis framework. I have moved this to production. But unfortun...

asp.netredisservicestackservicestack.redis
4 May at 07:25

create zip file in .net with password

I'm working on a project that I need to create zip with password protected from file content in c#. Before I've use System.IO.Compression.GZipStream for creating gzip content. Does .net have any func...

c#.netpasswordszipdotnetzip
19 Jan at 07:35

ServiceStack OrmLite multiple references of same type load

In my ServiceStack app I'm implementing a simple chat where 2 users can have a dialogue. For simplicity, I've just created a TextMessages table, which contains the following Fields: ``` public class ...

c#.netservicestackormlite-servicestack
3 May at 23:53

ScriptingOptions sql smo does not support scripting data

I'm generating sql database script using c# code. following code works fine for `create table` but when I try to use `scriptOptions.ScriptData = true;` it is throwing following exception. > An unhan...

c#sqlsql-serversql-server-2008smo
16 Nov at 15:50

How can I add an IEnumerable<T> to an existing ICollection<T>

Given an existing `ICollection<T>` instance (e.g. `dest`) what is the most efficient and readable way to add items from an `IEnumerable<T>`? In my use case, I have some kind of utility method `Collec...

c#linqgenericsienumerable
3 May at 17:39

Column missing from excel spreedshet

I have a list of invoices that and I transferred them to an Excel spreadsheet. [](https://i.stack.imgur.com/yxQpi.png) All the columns are created into the spreadsheet except for the Job Date colum...

c#excelworksheet-function
10 May at 14:0

What does ==$0 (double equals dollar zero) mean in Chrome Developer Tools?

In Google Chrome's developer tools, when I select an element, I see `==$0` next to the selected element. What does that mean? [](https://i.stack.imgur.com/C2eGI.jpg)

google-chromegoogle-chrome-devtoolscode-inspection
2 Sep at 18:3

How to install only "devDependencies" using npm

I am trying to install ONLY the "devDependencies" listed in my package.json file. But none of the following commands work as I expect. All of the following commands install the production dependencies...

node.jsnpmnpm-installpackage.json
3 May at 08:41

How can one tell the version of React running at runtime in the browser?

Is there a way to know the runtime version of React in the browser?

javascriptreactjs
3 May at 02:22

Dictionaries and Functions

I have recently begun working with C# and there is something I used to do easily in Python that I would like to achieve in C#. For example, I have a function like: ``` def my_func(): return "Do som...

c#dictionary
3 May at 03:55

Sponsored Byservicestack.net

from the blog
Analyzing Voting Methods
Generating the PvQ Leaderboard
Getting Help in the Age of LLMs