ritacse

var BindreportDataToHTML = function () {

    ReceiveSummary = _.chain(ReceiveSummary)
        .sortBy('companyID')
        .sortBy('purchaseIndentID')
        .sortBy('itemID')
        .value();

    var html = '';

ritacse

    SET NOCOUNT ON;
--It's often used at the beginning of stored procedures and triggers. 
--Benefits of SET NOCOUNT ON 
--1.Reduces network traffic:
--2.Reduces processing

--Example:
ALTER PROCEDURE [dbo].[CheckUserMenuPermission]
    @UserId INT,

ritacse

//https://www.geeksforgeeks.org/javascript-get-the-index-of-an-object-by-its-property/

let arrayObj = [{
    prop_1: 'val',
    prop_2: 'val_12',
    prop_3: 'val_13'
}, {
    prop_1: 'val',
    prop_2: 'val_22',
    prop_3: 'val_23'

ritacse

We couldn’t find that file to show.

ritacse

1. change SP as per requirment
2. Field Explorer >> Right click on "Database fields" >> Select "Verify Database"
3. provide database connection, password & click "Finish" [database will be uptodate]
4. expand "Database fields">> command>> get your new column here

ritacse

Convert.ToDouble("1234567.12345").ToString("N")

//If you want to control the decimal places you can do something like:

Convert.ToDouble("1234567.12345").ToString("N3") // 3decimal point
Convert.ToDouble("1234567.12345").ToString("N0") // int
or 
(Int32.Parse("78956258")).ToString("N0")

ritacse

// Read Web.Config Key from server end in C#

// add Key in Web.Config after ending:   </connectionStrings> tag
<appSettings>	
	  <add key="FileUploadedPath" value="~/PurchaseCSDocument/" />
		<add key="LiscenseExpireDate" value="2023-01-15" />
	</appSettings>
	
	// Declare global Variable in server end(controller or handler) & get value
	 private string LiscenseExpireDate = Convert.ToString(ConfigurationManager.AppSettings["LiscenseExpireDate"]);

ritacse

CREATE TABLE SECTION(
    c# int FOREIGN KEY REFERENCES Course(c#),
    se# int,
    emp# int FOREIGN KEY REFERENCES Professor(EMP#),
    class_time time,
    controlNumber int DEFAULT 20,
    CONSTRAINT pk_SectionID PRIMARY KEY (c#, se#),
    
    -----Adding Conditional constraint here ---
    CONSTRAINT chk_controlNumber CHECK (

ritacse

///in controller add version using any number:
public ActionResult Survey()
        {
            ViewBag.version = DateTime.Now.ToString("yymmddHH");
            return View();
        }


//// in html page add version with js file name:
<script src="~/Assets/lib/CommonUI/js/BIDA/[email protected]"></script>

ritacse

///in .cs page add version using any number:
 public partial class frmKPIWiseAchievementFinal : System.Web.UI.Page
    {
        public string version = DateTime.Now.ToString(); ///<- Just add this line
        protected void Page_Load(object sender, EventArgs e)
        {

        }
    }