WebForms UnobtrusiveValidationMode requires a ScriptResourceMapping for ‘jquery’. Please add a ScriptResourceMapping named jquery(case-sensitive).

Specifies how ASP.NET globally enables the built-in validator controls to use unobtrusive JavaScript for client-side validation logic.

Type: UnobtrusiveValidationMode

Default value: None

Remarks: If this key value is set to “None” [default], the ASP.NET application will use the pre-4.5 behavior (JavaScript inline in the pages) for client-side validation logic. If this key value is set to “WebForms”, ASP.NET uses HTML5 data-attributes and late bound JavaScript from an added script reference for client-side validation logic.

Example:

<appSettings>
<add key=”ValidationSettings:UnobtrusiveValidationMode” value=”None” />
</appSettings>

How to concatenate row data by comma in sql?

How to concatenate row data by “,” in sql?

DECLARE @Account_Num VARCHAR(7500) = ”

CREATE TABLE #tempData
(
AccountNo VARCHAR(20)
)

INSERT INTO #tempData
SELECT ‘123456’
UNION
SELECT ‘89105’
UNION
SELECT ‘32587’
UNION
SELECT ‘98587’

SELECT @Account_Num += COALESCE(‘,’, @Account_Num) + AccountNo FROM #tempData
SET @Account_Num = SUBSTRING(@Account_Num, 2, LEN(@Account_Num)) SELECT @Account_Num

Result:

123456,89105,32587,98587

how to copy directory using sql server

DECLARE @Query VARCHAR(8000)
SET @Query = ‘xcopy “{Source  Directory Path}\*.*” “{Destination Directory Path}\” /e /i /h /y ‘
PRINT @Query
EXEC master.dbo.xp_cmdshell @Query

Where

  1. “*.*” Copy all directory and file in source path.
  2. “/e” Copies directories and sub directories, including empty ones. Same as /S /E. May be used to modify /T.
  3. “/i” If destination does not exist and copying more than one file, assumes that destination must be a directory.
  4. “/h” Copies hidden and system files also.
  5. “/y” Overwrites existing files without prompting.

Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)).

Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)).

  1. Open Run
  2. Enter DCOMCNFG
  3. Append Component Service
  4. Then Computers
  5. Then My Computers
  6. Then DCOM Config
  7. Then From the DCOM Config List right click on “Microsoft Excel Application”
  8. Go to Security Tab
  9. Clink on Customize Property from “Launch and Activation Permission”
  10. 1
  11. Then add “IIS_IUSR” and Allow “Local Launch” and “Local Activation”.
  12. 2
  13. Repeat same procedure of Access permission.