Convert from String to Datetime

DateTime dt= DateTime.ParseExact(value, "MM/dd/yyyy", System.Globalization.CultureInfo.InvariantCulture)

Read a comma separated file and populate a dictionary

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.IO;

namespace FileParsing
{
    class Program
    {
        static void Main(string[] args)
        {
            StreamReader reader = new StreamReader("D:/ID.txt");

            //Dictionary<string, string> dict = new Dictionary<string, string>();
            Dictionary<string, object> dict = new Dictionary<string, object>();

            Player player = new Player();
            while (reader.Peek() >= 0)
            {
                string line = reader.ReadLine();
                string[] data = line.Split(';');

                if (line != String.Empty)
                {
                    for (int i = 0; i < data.Length - 1; i++)
                    {
                        string key = data[i].Trim().Split('=')[0];
                        string value = data[i].Trim().Split('=')[1];
                        string dictKey=string.Empty;
                        switch (key)
                        {
                            case "FNAME": dictKey="FirstName"; break;
                            case "LNAME": dictKey = "LastName"; break;
                            case "MNAME": dictKey="MiddleName"; break;
                            case "ADD": dictKey="Add"; break;
                            case "CITY": dictKey="City"; break;
                            case "ST": dictKey="State"; break;
                            case "ZIP": dictKey="Zip"; break;
                            case "DOB": dictKey = "DOB"; break;
                            case "DOE": dictKey="DOE"; break;
                            case "DOI": dictKey="DOI"; break;
                            case "DLNO": dictKey="DLNo"; break;
                            case "SEX": dictKey="Sex"; break;
                            default:
                                break;
                        }
                        if(!dict.ContainsKey(dictKey))
                            dict.Add(dictKey, value);
                     
                    }
                   
                    //dict.Add(playerCount, player);
                }
            }
        }
    }

    class Player
    {
        public string FirstName { get; set; }
        public string LastName { get; set; }
        public string MiddleName { get; set; }
        public string Add { get; set; }
        public string City { get; set; }
        public string State { get; set; }
        public string Zip { get; set; }
        public DateTime DOB { get; set; }
        public string DOE { get; set; }
        public string DOI { get; set; }
        public string DLNo { get; set; }
        public string Sex { get; set; }
    }
}

Validate Number in MVC

function ValidateNumber(e) {
            var evt = (e) ? e : window.event;
            var charCode = (evt.keyCode) ? evt.keyCode : evt.which;
            if (charCode > 31 && (charCode < 48 || charCode > 57)) {
                return false;
            }
            return true;
        };


@Html.TextBoxFor(model => model.Vendor.FaxNumber, new { @class = "form-control", @maxlength = "15", onkeydown = "return ValidateNumber(event);" })

MVC numeric text box

<script>
function ValidateNumber(e) {
            var evt = (e) ? e : window.event;
            var charCode = (evt.keyCode) ? evt.keyCode : evt.which;
            if (charCode > 31 && (charCode < 48 || charCode > 57)) {
                return false;
            }
            return true;
        };
</script>

And to call the function in the text box
@Html.TextBoxFor(model => model.Vendor.Mobile, new { @class = "form-control", @maxlength = "10",onkeydown="return ValidateNumber(event);"})

3 dropdown list to choose the date of birth.

<%= Html.DropDownList("month", Enumerable.Range(1, 12).Select(i => new SelectListItem { Value = i.ToString(), Text = System.Globalization.CultureInfo.InvariantCulture.DateTimeFormat.GetMonthName(i)}), "-- Month --") %>

          <%= Html.DropDownList("day", Enumerable.Range(1, 31).Select(i => new SelectListItem { Value = i.ToString(), Text = i.ToString()}), "-- Day --") %>

                    <%= Html.DropDownList("year", Enumerable.Range(1920, n+1).Select(i => new SelectListItem { Value = i.ToString(), Text = i.ToString()}), "-- Year --")%>

Trigger Example

Create trigger [dbo].[trgDeleteStagingProducts]
on [dbo].[Vendor_Product]
after insert
as
begin
 DECLARE @VendorProductGUID varchar(50)    
   
    SELECT @VendorProductGUID = I.VendorProductGUID        
      FROM INSERTED I
Delete from Vendor_Product_Stagging where VendorProductGUID = @VendorProductGUID;
end

Saving List of Object in SqlServer by XML

CREATE proc [dbo].[BCKUP_usp_AddUserProducts]
@ProductXml xml

as

insert into dbo.Vendor_Product
(
VendorProductGUID
,ProductGUID
,ProductName
,MRP
,SellingPrice
,Description
,UnitValue
,UnitId
,BarCode
,VendorId
,AddedDate
,ProductImage
,Active
)

SELECT
   Product.value('(VendorProductGUID)[1]', 'varchar(50)') AS 'VendorProductGUID',
   Product.value('(ProductGUID)[1]', 'uniqueidentifier') AS 'ProductGUID',
   Product.value('(ProductName)[1]', 'varchar(50)') AS 'ProductName',
   Product.value('(MRP)[1]', 'money') AS 'MRP',
   Product.value('(SellingPrice)[1]', 'money') AS 'SellingPrice',
   Product.value('(Description)[1]', 'varchar(max)') AS 'Description',
   Product.value('(UnitValue)[1]', 'float') AS 'UnitValue',
   Product.value('(UnitId)[1]', 'tinyint') AS 'UnitId',
   Product.value('(BarCode)[1]', 'varchar(50)') AS 'BarCode',
   Product.value('(VendorId)[1]', 'uniqueidentifier') AS 'VendorId',
   Product.value('(AddedDate)[1]', 'DateTime') AS 'AddedDate',
   Product.value('(ProductImage)[1]', 'int') AS 'ProductImage',
   Product.value('(Active)[1]', 'bit') AS 'Active'
FROM
   @ProductXml.nodes('/ArrayOfVendorProduct/VendorProduct') AS AOC(Product)


/* Following statement is for removing entries from other table , not relevant*/

delete from Vendor_Product_Stagging where VendorProductGUID in
(
SELECT
  Product.value('(VendorProductGUID)[1]', 'varchar(50)') AS 'VendorProductGUID'
  FROM  @ProductXml.nodes('/ArrayOfVendorProduct/VendorProduct') AS AOC(Product)
)