Fill SQL Column with one of three values according to a Row Number
Once again experiments and tests. I added a new column to the existing table and needed to fill it with different values. Read more»
Once again experiments and tests. I added a new column to the existing table and needed to fill it with different values. Read more»
Its’s more and more complicated to find information about SharePoint. I don’t really know why it’s so. That’s why I often write down the references and examples. Today I tried to remember how to create a SharePoint list with PNPJS and there’s a parameter which template you will use. Read more»
DataGrid looks like a table, but it’s another component, it consists of multiple div-elements. But for a user it’s a table and common table attributes are often required. One of them is striped rows. Below there’s an example how to implement it. Read more»
I had to update the date values in the MSSQL database table for tests and demo. I needed to set random Dates from the specific range. Read more»
When you execute your Web Api and at Swagger Page you can see Swagger error ‘Failed to load API definition’, you can’t really determine, where the error is. It is in one of the controllers. But do you want to check all of them? Read more»
There’s a data type ‘uniqueidentifier’ in SQL. If you need to feed this field with random value, you can use NEWID(). The ‘uniqueidentifier’ value in SQL looks like this: ‘234779E5-996F-45AC-90C3-21631AF4A08D’. Read more»
If you use a Pro version of Material UI, then you have a tool, how to switch the cells in the DataGrid table. But if you work with a wide table and you just want to make it more comfortable to work with it, there are some tricks for that. The first thing is to […] Read more»
In one Web Api Net Core solition I used Microsoft.AspNetCore.Identity.EntityFrameworkCore for Authentication. It’s really comfortable to work with this package because you a free from the implementation of all the methods and don’t spare much time. It also returns the text of errors, for example, that password is to short or special character is required. […] Read more»
Obviously, it’s an ordinary case, when you get an array of objects and you need to create for the reply the array of other Objects, but you need to initialize it on load. For React developers it can be often used with useEffect or componentDidMount. Read more»
To modify the size of the TextField component in Material UI, you can make several things. The basic modification is obvious, but other ones are not so. By default, the component TextField is rather big and it’s really a common task to make it less. Read more»