Posts

Create Table with primary key In SQL

creating a table with a primary key to store the pdf path and some of the details.  Here is a query to create a table in SQL and oracle CREATE TABLE TBL_ITG_PDF_DOCUMENT_LIBRARY   (    ID int NOT NULL PRIMARY KEY ,    PolicyName varchar ( 500 ) ,     Description varchar ( max ),      DocumentPath nvarchar ( max ),      UploadedBy varchar ( 100 ),    UploadedDate date ,     );

how to delete specific columns from multidimensional array

delete specific columns or chnage column name from multidimensional array varData = varData.map(function (obj) { obj['JIRA_ID'] = obj['JIRA_ID']; obj['Application'] = obj['Application']; delete obj['JiraIssue_Summary']; return obj; });

highlight selected row In html table jquery

Highlight row on row click   $(document).ready( function () { }).on( 'click' , '#Data_TBL tr' , function () {   var all_tr = $( 'tr' ); all_tr.removeClass( 'selected' ); $( this ).closest( 'tr' ).addClass( 'selected' );   //alert(id); });

Filter Array example in jquery

Simple example of filtering  array with value let Cities = cities1.filter(function (e) {     return e.population == 3000000; }); console.log( Cities ); Ask for more examples.

Create Login With Role Using Thee Tire Architecture In Asp.Net C#

Image
1) Create table CREATE TABLE  `dbname`.`login` (   `id` int(11) NOT NULL auto_increment,   `userid` varchar(50) default NULL,   `password` varchar(50) default NULL,   `Role` varchar(200) default NULL,   KEY `id` (`id`) ) 2) Insert Values into table ID USER-ID PASSWORD ROLE 1 Admin Admin@123456 Admin 2 Pratibha pratibha@123 Agent 3 Rohan rohan@123 Agent 4 User User@123 Customer

EBS Payment Gateway Integration In ASP.net C#

Full code of EBS payment Gateway Integration in .net Create Page name as pay.aspx and paste code