I'm trying to create an API server, and I need to have access to MySQL database. I have this piece of code: public static class Database { private const string ConnectionString = "Server=localhost;Port=3306;Database=contoso_inc;Uid=root;Pwd=f6e527xp;"; public static IEnumerable<User> Execute(string query) { using…
I want to add validation to my date property to my class in my c# class. public class Item { [Required] public DateTime RecDate { get; set; } } But RecDate property sholud only accept the format "yyyyDDmm". For example…
my problem is this: I have a table in SQL Server that have a NOT NULL Column that uses a SEQUENCE as default (NEXT VALUE FOR SeqDefa), that column is not the PK from the table. I building a web…
Please consider this scenario: I have a simple page and I want to log all controls causing postback. I create this simple page. It contains a grid to show some URLs and when user click on an icon a new…
Have a Solution with 2 Projects, Report and Web developed in .net core 2.1 using AlanJudenMvcReportViewer which is working ok on about a dozen SSRS server reports. Decided to use Microsoft.DotNet.UpgradeAssistant to migrate to net 5.0. Struck many errors which…
var result = db.SETUP_MASTER_LOGIN .Where(x => x.DELETED == false) .Select(s => new MasterLoginResp { resource_name = s.RESOURCE_NAME, user_name = x.USER_NAME, created_by = x.CREATED_BY }) .ToList() How to get distinct values from selected three columns? I have tried all the given…
I'm fairly new to C# an dotnet and I'm struggling a bit with the environment. I'm working on Windows 10 Professional. I have Visual Studio Community 2019 installed with Development .NET Desktop ticked. I then installed successfully both .NET 5.0…
I have below list view , how can i hide column by code behind ? <asp:ListView ID="AuditLogListView" runat="server" OnItemCreated="AuditLogListView_ItemCreated"> <LayoutTemplate> <table class="table table-striped table-bordered small"> <tr class="table-secondary"> <th id="BlockHeader" runat="server" style="white-space: normal;"> <asp:Literal ID="BlockHeaderLiteral" runat="server" Text="<%$ Resources:AppResources, AuditInformationBlockHeader %>" />…
using System; using System.Linq; using System.Collections.Generic; public class Program { public static void Main() { // Customer collection IList<Customer> CustomertList = new List<Customer>() { new Customer() { CustomerID = 1, CustomerName = "John", OrderID = 04 } , new Customer()…
using namespace std; class Animal{ public: virtual void cry() = 0; void eat(); }; class Cat:public Animal { public: virtual void cry(); void grooming(); }; class Dog:public Animal { public: virtual void cry(); void lash(); }; main() { Animal* animal…