Friday 28 June 2019

MVC - WCF - Create and consume WCF Service with data from EF

Watch this example on YouTube


1. SQL 

USE [Company]
GO
/****** Object:  Table [dbo].[Product]    Script Date: 2019-06-28 9:34:42 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Product](
    [ProductID] [int] IDENTITY(1,1) NOT NULL,
    [Name] [varchar](50) NULL
) ON [PRIMARY]

GO
SET IDENTITY_INSERT [dbo].[Product] ON

GO
INSERT [dbo].[Product] ([ProductID], [Name]) VALUES (1, N'Table')
GO
INSERT [dbo].[Product] ([ProductID], [Name]) VALUES (2, N'Something Else')
GO
INSERT [dbo].[Product] ([ProductID], [Name]) VALUES (3, N'Sofa')
GO
INSERT [dbo].[Product] ([ProductID], [Name]) VALUES (4, N'Chair')
GO
INSERT [dbo].[Product] ([ProductID], [Name]) VALUES (5, N'Laptop')
GO
INSERT [dbo].[Product] ([ProductID], [Name]) VALUES (6, N'Mouse')
GO
INSERT [dbo].[Product] ([ProductID], [Name]) VALUES (7, N'Keyboard')
GO
INSERT [dbo].[Product] ([ProductID], [Name]) VALUES (8, N'Monitor')
GO
SET IDENTITY_INSERT [dbo].[Product] OFF
GO

2. IService1.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Runtime.Serialization;
using System.ServiceModel;
using System.ServiceModel.Web;
using System.Text;

namespace WcfService2
{
    // NOTE: You can use the "Rename" command on the "Refactor" menu to change the interface name "IService1" in both code and config file together.
    [ServiceContract]
    public interface IService1
    {

        [OperationContract]
        string GetData(int value);

        [OperationContract]
        CompositeType GetDataUsingDataContract(CompositeType composite);

        [OperationContract]
        List<Product> GetAllProducts();
        [OperationContract]
        string GetSomething();
    }


    // Use a data contract as illustrated in the sample below to add composite types to service operations.
    [DataContract]
    public class CompositeType
    {
        bool boolValue = true;
        string stringValue = "Hello ";

        [DataMember]
        public bool BoolValue
        {
            get { return boolValue; }
            set { boolValue = value; }
        }

        [DataMember]
        public string StringValue
        {
            get { return stringValue; }
            set { stringValue = value; }
        }
    }
}
3. Service1.svc
using System;
using System.Collections.Generic;
using System.Linq;
using System.Runtime.Serialization;
using System.ServiceModel;
using System.ServiceModel.Web;
using System.Text;

namespace WcfService2
{
    // NOTE: You can use the "Rename" command on the "Refactor" menu to change the class name "Service1" in code, svc and config file together.
    // NOTE: In order to launch WCF Test Client for testing this service, please select Service1.svc or Service1.svc.cs at the Solution Explorer and start debugging.
    public class Service1 : IService1
    {
        public string GetSomething()
        {
            return "something";
        }
        public List<Product> GetAllProducts()
        {
            List<Product> prodList = new List<Product>();
            CompanyEntities db = new CompanyEntities();
            var res = from p in db.Products select p;
            foreach(var item in res)
            {
                Product pr = new Product();
                pr.Name = item.Name;
                pr.ProductID = item.ProductID;
                prodList.Add(pr);

            }
            return prodList;
        }
        public string GetData(int value)
        {
            return string.Format("You entered: {0}", value);
        }

        public CompositeType GetDataUsingDataContract(CompositeType composite)
        {
            if (composite == null)
            {
                throw new ArgumentNullException("composite");
            }
            if (composite.BoolValue)
            {
                composite.StringValue += "Suffix";
            }
            return composite;
        }
    }
}
4. Consumer (home controller)

        public ActionResult Index()
        {
            List<Product> lstProd = new List<Product>();
            ServiceReference1.Service1Client s = new ServiceReference1.Service1Client();
            var res2 = s.GetSomething();
            var res = s.GetAllProducts();
            foreach(var item in res)
            {
                Product pr = new Product();
                pr.ProductID = item.ProductID;
                pr.Name = item.Name;
                lstProd.Add(pr);
            }
            return View(lstProd);
        }

Thursday 20 June 2019

MVC - Consume Web Service (Service Reference, WCF)

Watch this example on YouTube


1. Services:
http://www.dneonline.com/calculator.asmx
http://services.aonaware.com/DictService/DictService.asmx

2. Home Controller

  MyServiceRefrence.CalculatorSoapClient ws = new MyServiceRefrence.CalculatorSoapClient();
            var res = ws.Add(2, 4);

Microsoft Internet Explorer - Fix Issue with XML not showing in proper format or not showing all data

Watch this example on YouTube

to fix it replace

<root>
<name>
    <first>Bob</first>
    <last>Doe</last>
</name>
<name>
    <first>John</first>
    <last>Lennon</last>
</name>
<name>
    <first>Bob</first>
    <last>Doe</last>
</name>
<name>
    <first>John</first>
    <last>Lennon</last>
</name>
</root>

with

<root>
<name>
    <first>Bob</first>
    <last>Doe</last>
</name>
<name>
    <first>John</first>
    <last>Lennon</last>
</name>
<name>
    <first>Bob</first>
    <last>Doe</last>
</name>
<name>
    <first>John</first>
    <last>Lennon</last>
</name>
</root>

Wednesday 19 June 2019

Opera - Fix error - Extra content at the end of the document Below is a rendering of the page up to the first error.


Watch this example on YouTube

This page contains the following errors:

error on line 5 at column 1: Extra content at the end of the document

Below is a rendering of the page up to the first error.

 

To fix it replace


<name>
<first>Bob</first>
<last>Doe</last>
</name>
<name>
<first>John</first>
<last>Lennon</last>
</name>

 

with

 <root>
<name>
<first>Bob</first>
<last>Doe</last>
</name>
<name>
<first>John</first>
<last>Lennon</last>
</name>

</root>

C# - Fix Error - Guid.NewGuid()' is a method, which is not valid in the given context


Watch this example on YouTube


Guid.NewGuid()' is a method, which is not valid in the given context
also
The name 'guid' does not exist in the current context

To fix it replace

string test = guid.NewGuid.ToString();
wtih
string test = Guid.NewGuid().ToString();

Tuesday 18 June 2019

Mozilla Firefox - Fix Error - XML Parsing Error junk after document element with comments

Watch this example on YouTube


 
to fix it replace

<name>
    <first>Bob</first>
    <last>Doe</last>
</name>
<name>
    <first>John</first>
    <last>Lennon</last>
</name>

with

<root>
<name>
    <first>Bob</first>
    <last>Doe</last>
</name>
<name>
    <first>John</first>
    <last>Lennon</last>
</name>
</root>

Friday 14 June 2019

MVC - Web Service - Create Web Service - Pass XML file (not string) as Parameter and Receive XML file (not string) in Web Service

Watch this example on YouTube



1. Web Service

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Xml;

namespace WebApplication15
{
    /// <summary>
    /// Summary description for WebService1
    /// </summary>
    [WebService(Namespace = "http://tempuri.org/")]
    [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
    [System.ComponentModel.ToolboxItem(false)]
    // To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.
    // [System.Web.Script.Services.ScriptService]
    public class WebService1 : System.Web.Services.WebService
    {

        [WebMethod]
        public string HelloWorld()
        {
            return "Hello World";
        }

        [WebMethod]
        public string XMLTest(XmlDocument doc)
        {
            var xmlString = doc.InnerText;
            return "success";
        }

    }
}

2. Consumer

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using System.Xml;

namespace WebApplication16.Controllers
{
    public class HomeController : Controller
    {
        public ActionResult Index()
        {
            XmlDocument doc = new XmlDocument();
            XmlNode docNode = doc.CreateXmlDeclaration("1.0", "UTF-8", null);
            doc.AppendChild(docNode);

            XmlNode usersNode = doc.CreateElement("Users");
            doc.AppendChild(usersNode);

            XmlNode userNode = doc.CreateElement("User");
            XmlAttribute userAttribute = doc.CreateAttribute("ID");
            userAttribute.Value = "1";
            userNode.Attributes.Append(userAttribute);
            usersNode.AppendChild(userNode);

            XmlNode nameNode = doc.CreateElement("Name");
            nameNode.AppendChild(doc.CreateTextNode("Frank"));
            userNode.AppendChild(nameNode);
            XmlNode addressNode = doc.CreateElement("Address");
            addressNode.AppendChild(doc.CreateTextNode("1 Main St."));
            userNode.AppendChild(addressNode);

            localhost.WebService1 testService = new localhost.WebService1();
            var res = testService.XMLTest(doc);

            return View();
        }

MVC - Add simple java script to MVC View

Watch this example on YouTube


@{
    ViewBag.Title = "Home Page";
}

<div class="jumbotron">
    <h1>ASP.NET</h1>
    <p class="lead">ASP.NET is a free web framework for building great Web sites and Web applications using HTML, CSS and JavaScript.</p>
    <p><a href="http://asp.net" class="btn btn-primary btn-lg">Learn more &raquo;</a></p>
</div>

<div class="row">
    <div class="col-md-4">
        <h2>Getting started</h2>
        <p>
            ASP.NET MVC gives you a powerful, patterns-based way to build dynamic websites that
            enables a clean separation of concerns and gives you full control over markup
            for enjoyable, agile development.
        </p>
        <p><a class="btn btn-default" href="http://go.microsoft.com/fwlink/?LinkId=301865">Learn more &raquo;</a></p>
    </div>
    <div class="col-md-4">
        <h2>Get more libraries</h2>
        <p>NuGet is a free Visual Studio extension that makes it easy to add, remove, and update libraries and tools in Visual Studio projects.</p>
        <p><a class="btn btn-default" href="http://go.microsoft.com/fwlink/?LinkId=301866">Learn more &raquo;</a></p>
    </div>
    <div class="col-md-4">
        <h2>Web Hosting</h2>
        <p>You can easily find a web hosting company that offers the right mix of features and price for your applications.</p>
        <p><a class="btn btn-default" href="http://go.microsoft.com/fwlink/?LinkId=301867">Learn more &raquo;</a></p>
    </div>
</div>

@section Scripts{
    <script type="text/javascript">
        $(document).ready(function () {
            alert("here you go!!!");
        });

    </script>   
}

MVC - Web Service - Catch Timeout exception

Watch this example on YouTube


 

  localhost.WebService1 test = new localhost.WebService1();
            test.Timeout = 1000;
            try
            {
                var res = test.HelloWorld();
            }
            catch (System.Net.WebException e) when (e.Status == System.Net.WebExceptionStatus.SecureChannelFailure)
            {
                string error = e.Message;
            }

            catch(Exception e)
            {
                string error = e.Message;
            }

MVC - Web Service - Increase time limit on response from a web service


Watch this example on YouTube

  

            localhost.WebService1 test = new localhost.WebService1();
            test.Timeout = 4000;
            var res = test.TestMethod("Some String");

            return View();

Thursday 13 June 2019

MVC - Web Service - Create Web Service - Pass XML as Parameter and Receive XML in Web Service


Pass xml file (created on the fly) to web service

Watch this example on YouTube


 
1. Publisher

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Xml;

namespace WebApplication13
{
    /// <summary>
    /// Summary description for WebService1
    /// </summary>
    [WebService(Namespace = "http://tempuri.org/")]
    [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
    [System.ComponentModel.ToolboxItem(false)]
    // To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.
    // [System.Web.Script.Services.ScriptService]
    public class WebService1 : System.Web.Services.WebService
    {

        [WebMethod]
        public string HelloWorld()
        {
            return "Hello World";
        }
        [WebMethod]
        public string TextXML(string xmlFile)
        {
            XmlDocument doc = new XmlDocument();
            doc.LoadXml(xmlFile);
            // here do whatever you want with xml file
            return "success";
        }
    }
}

2. Subscriber

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using System.Xml;

namespace WebApplication14.Controllers
{
    public class HomeController : Controller
    {
        public ActionResult Index()
        {
            XmlDocument doc = new XmlDocument();
            XmlNode docNode = doc.CreateXmlDeclaration("1.0", "UTF-8", null);
            doc.AppendChild(docNode);

            XmlNode usersNode = doc.CreateElement("Users");
            doc.AppendChild(usersNode);
            XmlNode userNode = doc.CreateElement("User");
            XmlAttribute userAttribute = doc.CreateAttribute("ID");
            userAttribute.Value = "1";
            usersNode.AppendChild(userNode);

            XmlNode nameNode = doc.CreateElement("Name");
            nameNode.AppendChild(doc.CreateTextNode("Frank"));
            userNode.AppendChild(nameNode);
            XmlNode addressNode = doc.CreateElement("Address");
            addressNode.AppendChild(doc.CreateTextNode("1 Main St."));
            userNode.AppendChild(addressNode);

            var XMLString = doc.InnerXml;

            localhost.WebService1 test = new localhost.WebService1();
            var res = test.TextXML(XMLString);

            return View();
        }

MVC - Simple Web Service Example - Create and Consume web service in less then 4 minutes

Watch this example on YouTube



1. Publisher

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;

namespace WebApplication11
{
    /// <summary>
    /// Summary description for WebService1
    /// </summary>
    [WebService(Namespace = "http://tempuri.org/")]
    [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
    [System.ComponentModel.ToolboxItem(false)]
    // To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.
    // [System.Web.Script.Services.ScriptService]
    public class WebService1 : System.Web.Services.WebService
    {

        [WebMethod]
        public string HelloWorld()
        {
            return "Hello World";
        }
        [WebMethod]
        public int Add2Numbers(int n1, int n2)
        {
            return n1 + n2;
        }
    }
}
2. Consumer
{
    public class HomeController : Controller
    {
        public ActionResult Index()
        {
            localhost.WebService1 test = new localhost.WebService1();
            var res = test.Add2Numbers(2, 5);
            return View();
        }

Wednesday 12 June 2019

C# - Remove all commas

Watch this example on YouTube

       


string a = "a,a a,,d,";
            a = a.Replace(",", "");

Tuesday 11 June 2019

Visual Studio - Find empty lines

Watch this solution on YouTube


 
 
Select Regular expressions and search for: 
^(?([^\r\n])\s)*\r?$\r?\n

ASP.NET - JavaScript - Fix Error - JavaScript runtime error: Unable to set property 'IsValid' of undefined or null reference

0x800a138f - JavaScript runtime error: Unable to set property 'IsValid' of undefined or null reference

Watch this example on YouTube




to fix it replace

   <asp:Button ID="Button1" runat="server" Text="Button" OnClientClick="Validate();" />

with

   <asp:Button ID="Button1" runat="server" Text="Button" />

Whole code:

<%@ Page Title="Home Page" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="ASPApplication._Default" %>

<asp:Content ID="BodyContent" ContentPlaceHolderID="MainContent" runat="server">
    <asp:DropDownList ID="DropDownList1" runat="server">
        <asp:ListItem>Test 1</asp:ListItem>
        <asp:ListItem>Test 2</asp:ListItem>
    </asp:DropDownList>
    <asp:Button ID="Button1" runat="server" Text="Button" OnClientClick="Validate();" />

    <asp:ValidationSummary runat="server" HeaderText="Fix the following:" ShowMessageBox="true"
         ValidationGroup="MyValidationGroup" />
    <asp:CustomValidator runat="server" ErrorMessage="Something went wrong"
         ClientValidationFunction="Validate" ValidationGroup="MyValidationGroup" >

    </asp:CustomValidator>

    <script lang="javascript" type="text/javascript">
        function Validate(source, args) {
            var e = document.getElementById('<%= DropDownList1.ClientID %>')
            var str = e.options[e.selectedIndex].text;
            if (str != "") {
                args.IsValid = true;
            }
            else {
                args.IsValid = false;
            }
        }
    </script>
</asp:Content>

Monday 10 June 2019

C# - Check if string is an integer and if yes - assign it's value to int variable

Watch this example on YouTube

     

  string SomeValue = "33";
            int Result;
            string Message;
            if (int.TryParse(SomeValue, out Result))
            {
                Message = "it is integer";
            }
            else
            {
                Message = "no it is not";
            }

ASP.NET - Javascript - Fix Error 'Page_ClientValidate' is undefined

Watch this example on YouTube




To fix it replace

   <script lang="javascript" type="text/javascript">
        function Validate() {
            debugger;
            try {
                var result = Page_ClientValidate('Test');
                return result;
            }
            catch (Error) {
                return true;
            }
        }
    </script>

with


    <title></title>
        <script lang="javascript" type="text/javascript">
        function Validate() {
            debugger;
            try {
                if (typeof (Page_ClientValidate) === 'function') {
                    var result = Page_ClientValidate('Test');
                    return result;
                }
                else {
                    return true;
                }

            }
            catch (Error) {
                return true;
            }
        }
    </script>


whole code

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="ASPApplication.WebForm1" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
        <script lang="javascript" type="text/javascript">
        function Validate() {
            debugger;
            try {
                if (typeof (Page_ClientValidate) === 'function') {
                    var result = Page_ClientValidate('Test');
                    return result;
                }
                else {
                    return true;
                }
            }
            catch (Error) {
                return true;
            }
        }
    </script>
</head>
<body>
    <form id="form1" runat="server" onsubmit="return Validate();">
    <div>
        <asp:Button ID="Button1" runat="server" Text="Button" />
   
    </div>
    </form>
</body>
</html>

MSSQL - Fix Error - ALTER TABLE only allows columns to be added that can contain nulls, or have a DEFAULT definition specified, or the column being added is an identity or timestamp column, or alternatively if none of the previous conditions are satisfied the table must be empty to allow addition of this column. Column 'SomeNewColumn' cannot be added to non-empty table 'Product' because it does not satisfy these conditions.

Msg 4901, Level 16, State 1, Line 1
ALTER TABLE only allows columns to be added that can contain nulls, or have a DEFAULT definition specified, or the column being added is an identity or timestamp column, or alternatively if none of the previous conditions are satisfied the table must be empty to allow addition of this column. Column 'SomeNewColumn' cannot be added to non-empty table 'Product' because it does not satisfy these conditions.


Watch this example on YouTube

 


To fix it replace

Alter Table [Product]
ADD SomeNewColumn bit Not Null
GO


with

Alter Table [Product]
ADD SomeNewColumn bit Not Null Default 0
GO 

Saturday 8 June 2019

MVC - Chart.js - Create Simple Bar Chart

Watch this example on YouTube

 


1. Download Chart.min.js from

https://www.jsdelivr.com/package/npm/chart.js


2. Common.js

jQuery.extend({
    getValues: function (url) {
        var result = null;
        $.ajax({
            url: url,
            type: 'post',
            contentType: "application/json; charset=utf-8",
            dataType: "json",
            async: false,
            success: function (data) {
                result = data;
            }
        });
        return result;
    }
});

3. Add to _Layout

<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8" />
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>@ViewBag.Title - My ASP.NET Application</title>
    @Styles.Render("~/Content/css")
    @Scripts.Render("~/bundles/modernizr")
    @Scripts.Render("~/Scripts/jquery-1.10.2.min.js")
    @Scripts.Render("~/Scripts/Chart.min.js")
    @Scripts.Render("~/Scripts/Common.js")
</head>

4. Chart Model

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace MVCChart.Models
{
    public class Chart
    {
        public string[] labels { get; set; }
        public List<Datasets> datasets { get; set; }
    }
    public class Datasets
    {
        public string label { get; set; }
        public string[] backgroundColor { get; set; }
        public string[] borderColor { get; set; }
        public string borderWidth { get; set; }
        public int[] data { get; set; }
    }
}

5. Home Controller

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using MVCChart.Models;

namespace MVCChart.Controllers
{
    public class HomeController : Controller
    {
        public JsonResult BarChartData()
        {
            Chart _chart = new Chart();
            _chart.labels = new string[] { "Jan", "Feb", "Mar" };
            _chart.datasets = new List<Datasets>();
            List<Datasets> _dataSet = new List<Datasets>();
            _dataSet.Add(new Datasets()
            {
                label = "This Year",
                data = new int[] { 40, 60, 20 },
                backgroundColor = new string[] { "800000", "#E9967C", "#FF0000" },
                borderColor = new string[] { "800000", "#E9967C", "#FF0000" },
                borderWidth = "1"
            });
            _chart.datasets = _dataSet;
            return Json(_chart, JsonRequestBehavior.AllowGet);
        }

6. Index.cshtml

@{
    ViewBag.Title = "Home Page";
}

<canvas id="barChart" width="300" height="100"></canvas>

<script>
    var c = document.getElementById("barChart");
    var ctx = c.getContext("2d");
    var tData = $.getValues("/Home/BarChartData");
    var myBarChart = new Chart(ctx, {
        type: 'bar',
        data: tData
    });
</script>

C# - DropDownList - Get selected value in code behind


Watch this example on YouTube


1. HTML

   <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="true"
        OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged">
        <asp:ListItem> Test 1</asp:ListItem>
        <asp:ListItem> Test 2</asp:ListItem>
    </asp:DropDownList>

2. Code Behind

string selectedValue = DropDownList1.SelectedValue.ToString();

Thursday 6 June 2019

Visual Studio - Find double empty lines

 
Watch on YouTube
 
 
 
 
Select Regular expressions and search for: 
^(?([^\r\n])\s)*\r?\n(?([^\r\n])\s)*\r?\n

MSSQL - Join the same table multiple times in one simple query

Watch this example on YouTube



1. Table

USE [Company]
GO
/****** Object:  Table [dbo].[TestJoin]    Script Date: 2019-06-06 7:02:25 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TestJoin](
    [Name] [varchar](50) NULL,
    [Manager] [varchar](50) NULL
) ON [PRIMARY]

GO
INSERT [dbo].[TestJoin] ([Name], [Manager]) VALUES (N'Bob', NULL)
GO
INSERT [dbo].[TestJoin] ([Name], [Manager]) VALUES (N'Frank', N'Bob')
GO
INSERT [dbo].[TestJoin] ([Name], [Manager]) VALUES (N'Ann', N'Bob')
GO
INSERT [dbo].[TestJoin] ([Name], [Manager]) VALUES (N'Rob', N'Frank')
GO
INSERT [dbo].[TestJoin] ([Name], [Manager]) VALUES (N'Eddy', N'Frank')
GO
INSERT [dbo].[TestJoin] ([Name], [Manager]) VALUES (N'John', N'Rob')
GO

2. Query

Select TestJoin.Name As Boss ,
TestJoin2.Name As Director,
TestJoin3.Name As Manager,
TestJoin4.Name As Nobody


From TestJoin
Left Outer Join TestJoin As TestJoin2 On TestJoin.Name = TestJoin2.Manager
Left Outer Join TestJoin As TestJoin3 On TestJoin2.Name = TestJoin3.Manager
Left Outer Join TestJoin As TestJoin4 On TestJoin3.Name = TestJoin4.Manager

Where TestJoin.Name = 'Bob'

C# - Fix Error - There is no argument given that corresponds to the required formal parameter

  There is no argument given that corresponds to the required formal parameter 'r'

watch solution on YouTube

Wednesday 5 June 2019

C# - Check if string is double and if yes assign value to variable


Watch this example on YouTube

           

double test;
            string SomeValue = "333";
            bool res = false;
            if(Double.TryParse(SomeValue, out test))
            {
                res = true;
            }

C# - Check if string is palindrome - if it reads the same backward as forward


watch this example on YouTube


string Test = "ANNA";
bool res = Test.SequenceEqual(Test.Reverse());

ASP.NET - JavaScript - OK/Cancel example in one line in button code

Watch this example on YouTube



 <asp:Button ID="Button1" runat="server" Text="Button" OnClick="Button1_Click"
        OnClientClick="return confirm('Please Confirm you want to proceed');" />

ASP NET Fix Drop Down List Selected Index Changed not executed

Watch this example on YouTube


To fix it replace

    <asp:DropDownList ID="DropDownList1" runat="server" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged">
        <asp:ListItem> Test 1</asp:ListItem>
        <asp:ListItem> Test 2</asp:ListItem>
    </asp:DropDownList>

wtih

    <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="true" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged">
        <asp:ListItem> Test 1</asp:ListItem>
        <asp:ListItem> Test 2</asp:ListItem>
    </asp:DropDownList>

Saturday 1 June 2019

C# - Form Application - Show console window in forms application


Watch this example on YouTube


1. Go to Project Properties -> Application -> Output Type -> Console Application

2. then the following code will be executed:
Console.WriteLine("button clicked");

C# - Convert Decimal? to 0 (zero) if null


Watch this example on YouTube

           

Decimal? z;
z = null;
Decimal zz = Convert.ToDecimal(z);