Encrypt password in SQL Server

This post will show you how can you encrypt/decrypt the password in SQL server 2012 fully using SQL Server store procedure.

Encrypt

        INSERT INTO AdminMaster ( Name,  UserName, Password, Status)

        VALUES('Girfa', 'girfa',EncryptByPassPhrase('key', '123')  , 1)

Textbox jquery option

Textbox jquery option

Textbox enter keypress detection

$j('#txtDesignCode').keypress(function (event) {

    var keycode = (event.keyCode ? event.keyCode : event.which);

    if (keycode == '13') {

       alert('Enter key hit'); 

    }

});

Next Topic

Auto suggestion MVC C# ASP.Net

Auto Suggestion of names using C# MVC ASP.Net with Ajax

CSS

<style>

     .g-auto {

         position: absolute;       

        

         border: solid 1px #e3e2de;

         background-color: #ffffff;

         -webkit-box-shadow: 0px 3px 13px -1px rgba(0,0,0,0.75);

         -moz-box-shadow: 0px 3px 13px -1px rgba(0,0,0,0.75);

         box-shadow: 0px 3px 13px -1px rgba(0,0,0,0.75);

         padding:0px;

         display:none;

        

     }

Putting model data in Viewbag

Putting Model in viewbag is the easiest way to flow A model data controller to a view. Let see a case, Suppose You’re editing a student record, On the editing page, you need to fill student details in related textbox and different type of dropdown list, which data is coming from database i.e. course , session, etc.

Normally we bind one model control to a view at a time. But if you are putting the model in a viewbag then you can transfer any number of models to a view. The following code will show you, Getting course record from the controller and filling it in the drop-down list at the view 

Model

public class CourseModel

    {

        public string ID { get; set; }

        public string CourseName { get; set; }

        public string Description { get; set; }

    }

Answer: M1-R4: IT TOOLS & BUSINESS SYSTEMS Jan-2017

Answer: M1-R4: IT TOOLS & BUSINESS SYSTEMS Jan-2017

Multiple Choice

1.1 : C

1.2 : B

1.3 : B

1.4 : B

1.5 : A

1.6 : B

1.7 : B

1.8 : B

1.9 : C

1.10 : B

True/False

2.1 : T

2.2 : T

2.3 : T

2.4 : T

2.5 : F

2.6 : T

2.7 : T

2.8 : T

2.9 : T

2.10 : T

Multiple Choice

3.1 : D

3.2 : H

3.3 : B

3.4 : F

3.5 : C

3.6 : I
3.7 : H
3.8 : E
3.9 : J
3.10 : M

Multiple Choice

4.1 : J
4.2 : H
4.3 : L
4.4 : M
4.5 : A
4.6 ; E
4.7 : D
4.8 : C
4.9 : F
4.10 : J

Descriptive Question Answer

Solved : M1-R4: IT TOOLS & BUSINESS SYSTEMS Jan-2017

Solved : M1-R4: IT TOOLS & BUSINESS SYSTEMS Jan-2017

1. Each question below gives a multiple choice  of   answers.Choose the most answer sheet supplied with the question paper, following instructions therein. (1x10)

1.1 : computer system are:

A) Memory, Input/Output, DMA

B) ALU, CPU, Memory

C) Memory, Input/Output, CPU

D) Control Circuits, ALU, Registers

Answer

1.2 : Which one of the following is volatile?

A) Bubble Memory

B) RAM

C) ROM

D) Magnetic Disc
Answer

Answer : M4.1-R4: APPLICATION OF .NET TECHNOLOGY July 2016

Answer :  M4.1-R4: APPLICATION OF .NET TECHNOLOGY July 2016

Multiple Choice : 

1.1 : A
1.2 : A
1.3 : B
1.4 : C
1.5 : B
1.6 : D
1.7 : A
1.8 : B
1.9 : D
1.10 : D

Solved : M4.1-R4: APPLICATION OF .NET TECHNOLOGY July 2016

Solved : M4.1-R4: APPLICATION OF .NET TECHNOLOGY  July 2016

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “OMR” answer sheet supplied with the question paper, following instructions therein.

1.1 : Web.config file is used ...
A) To store the global information and variable definitions for the application
B) To configure the web server
C) To configure the web browser
D) To configure the time that the server-side code-behind module is called

Answer

1.2 : Which of the following method must be overridden in a custom control?

A) The Paint() method

B) The Control_Build() method

C) The default constructor

D) The Render() method
Answer

Solved : M3-R4: PROGRAMMING & PROBLEM SOLVING THROUGH ‘C’ LANGUAGE , July-2016

1. Multiple Choice

1.1 : B
1.2 : A
1.3 : B
1.4 : A
1.5 : A
1.6 : C
1.7  : C
1.8 : C

Solved : M3-R4: PROGRAMMING & PROBLEM SOLVING THROUGH ‘C’ LANGUAGE , July-2016

Solved : M3-R4: PROGRAMMING & PROBLEM SOLVING THROUGH ‘C’ LANGUAGE , July-2016

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “OMR” answer sheet supplied with the question paper, following instructions therein.

1.1 How many times below for loop will be executed?

#include<stdio.h> 

int main()

{

int i=0; for(;;)

printf("%d",i); return 0;

}

A) 0 times

B) Infinite times

C) 10 times

D) 1 times
Answer

Answer : Internet Technology and Web Design Question Paper (July-16)

Answer : Internet Technology and Web Design Question Paper (July-16)

1. Multiple Choice

1.1 : B
1.2 : B
1.3 : C
1.4 : B
1.5 : A
1.6 : B
1.7 : D
1.8 : B

Solved : Internet Technology and Web Design Question Paper (July-16)

Solved : Internet Technology and Web Design Question Paper (July-16)

Q 1 : Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “OMR” answer sheet supplied with the question paper, following instructions therein. (1x10)

1.1 : FTP is

A) Server side encryption protocol

B) Control connection to remote computer to transfer files

C) User Datagram Protocol.

D) Authorization of a user through login and password verification.
Answer

Delete function using PHP Prepare statement using MySQL

Delete function using PHP Prepare statement using MySQL

function deleteBreaking($id)

{

ini_set('display_errors',1);

ini_set('display_startup_errors', 1);

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);

  $stmt = $this->conn->stmt_init();

  if ($stmt->prepare("delete from  breaking_news where id=?"))

  {

   $stmt->bind_param("i",$id);     

   $stmt->execute() or die("<h1>Error</h1>".mysqli_error($this->conn));       

   $stmt->close();   

   return "<span class='g-successMsg'>Breaking News Deleted Successfully</span>";;

  }

  else

  {

  

   return "<span class='errorMsg'>Oops ! Error in Deleting breaking news, Please try again later</span>";

  }  

}

Next Topic

Sloved : July, 2016 M1-R4: IT TOOLS AND BUSINESS SYSTEMS

Sloved : July, 2016 M1-R4: IT TOOLS AND BUSINESS SYSTEMS (NIELIT O Level)

Multiple Choice

1.1 :  A
1.2 : B
1.3 : A
1.4 : C

July, 2016 M1-R4: IT TOOLS AND BUSINESS SYSTEMS

July, 2016 M1-R4: IT TOOLS AND BUSINESS SYSTEMS Solve

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “OMR” answer sheet supplied with the question paper, following instructions therein. (1x10)

1.1 : The basic architecture of computer was developed by

A)           John Von Neumann

B)           Charles Babbage

C)           Blaise Pascal

D)           Gorden Moore
Answer : 

1.2 : Which protocol provides e-mail facility among different hosts?

A)           FTP

B)           SMTP

C)           TELNET

D)           SNMP
Answer :

Light Box Image Gallery

More than 50 percent light box gallery uses this.

<html>

<head>

    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.0/css/bootstrap.min.css">

    <link href="lightbox.min.css" rel="stylesheet" />

    <script src="lightbox-plus-jquery.min.js"></script>

    <title>Girfa Light Box</title

Update query | Prepare statement

MYSQL prepare query for update using PHP

function SavePaymentStatus($status,$refno)

{

$stmt = $this->conn->stmt_init();

if ($stmt->prepare("update rlss4 set id10=? where id2=?"))

{

$stmt->bind_param("ss", $status, $refno);

$stmt->execute() or die("<h1>Error</h1>".mysqli_error($this->conn));     

$stmt->close();

return true;

}

else

{

return false;

}

}

Next Topic

Google Recaptcha

What is reCAPTCHA?

reCAPTCHA is a free service that protects your website from spam and abuse. reCAPTCHA uses an advanced risk analysis engine and adaptive challenges to keep automated software from engaging in abusive activities on your site. It does this while letting your valid users pass through with ease.

Add image to server C#

this post will help you to upload a file to the server with a new name

HTML

<form>

    <input type="file" id="filelogo" class="fileUpload" accept="image/x-png,image/jpeg" /><br /><br />

  <input type="button" value="Upload" onclick="UploadImage('filelogo','new name')" >

 </form>

Java Script

function UploadImage(fnm,newname)

{

        var data = new FormData();

        data.append("filename", $("#"+fnm)[0].fil

Solved : January, 2015 M4.3-R4: INTRODUCTION TO ICT RESOURCES

View Question

Answer : July, 2015 M4.3-R4 INTRODUCTION TO ICT RESOURCES

Multiple Choice

1.1 : C
1.2 : B
1.3 : D
1.4 : A
1.5 : A
1.6 : C
1.7 : A
1.8 : B
1.9 : C
1.10 : B

True/Fase

2.1 : F
2.2 : T
2.3 : F
2.4 : T
2.5 : T
2.6 : F
2.7 : F
2.8 : T
2.9 : T
2.10 : F

Match the columns

3.1 : C
3.2 : E
3.3 : D
3.4 : B
3.5 : F
3.6 : K
3.7 : J
3.8 : L
3.9 : M
3.10 : I

Fill in the Blanks

4.1 : G
4.2 : E
4.3 : C
4.4 : J
4.5  : K
4.6 : M
4.7 : B
4.8 : D
4.9 : A
4.10 : F

View Question

Copy Current url to clipboard using Javascript

function copyLinkWhatsup()

    {

        var dummy = document.createElement('input'),

          text = window.location.href;

        document.body.appendCh

Put links in head section of view

When you work in ASP.Net MVC and you want to put links in head section but it appears after many links this is because head section code comes from shared layout. 

So if you want to add some links at the top in a view head section you need to make a render point in shared layout with a unique name and put your links inside of given name section.

Layout section 

@RenderSection("GCSS", required: false)

@RenderSection("og", required: false)

Razor/View Section

Show Serial number for Table column

Some time we retrieve data from the database and render in the table and we want to show serial number, then this article will help you to show the serial number using foreach loop  using razor.

<table class="table table-bordered table-hover">

    <thead>

Display DB Error message php

By default PHP doesn’t show run time error. You will have to set error method as follows

// first set general PHP error reporting
// in order to be sure we will see every error in the scriptini_set('display_errors',1);error_reporting(E_ALL);
/*** THIS! ***/mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);/*** ^^^^^ ***/$db = $mysqli = new mysqli($host, $user, $pass, $database);
$res = $db->query("apparently not valid SQL string");$res->fetch_assoc();

File preview before upload : HTML

<html>

<head>

     <title>File upload preview</title>

     <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.0/css/bootstrap.min.css">

     <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>

     <style>

     .fileUpload {

        position: relative;

        overflow: hidden;

        margin: 10px;

        margin-top: 0px;

    }

    .fileUpload input.upload {

           position: absolute;

           top: 0;

Check empty file using jquery

When you use file control from the input tag then for validation purpose you need to check the file name. if no file is selected then an error message should be displayed. This post will help you to achieve the same. When a user doesn’t select a file and an attempt is made to read file name then JS engines throw an exception which must be caught otherwise you will not be able to read and validate the empty file.

Sketch effect to a picture using photoshop

1. open a picture in photoshop and make a duplicate layer by pressing Cntl+J
   
   
2. Select huge saturation from create or adjustment layer tool 

Website Login Page HTML

HTML

<!DOCTYPE html>

<html>

<head>

    <meta charset="utf-8" />

 

Insert record in Database

This post will help you to learn the basics of inserting the record in the database using ci framework.

Table Structure

Culumn_Name	Data_type
Id	Auto number(int)
Name	Varchar(50)
Email	Varchar(50)
Phone	Varchar(15)
Msg	Varchar(255)

Configure Database

Goto App (Application in older CI) folder then open Config folder then Database.php file change db parameter as per your configuration. 

Database.php 

$db['default'] = array(
       'dsn' => '',
       'hostname' => 'localhost',
       'username' => 'username',
       'password' => 'password',
       'database' => 'db_name',
       'dbdriver' => 'mysqli',
       'dbprefix' => '',
       'pconnect' => FALSE,
       'db_debug' => (ENVIRONMENT !== 'production') ,
       'cache_on' => FALSE,
       'cachedir' => '',
       'char_set' => 'utf8',
       'dbcollat' => 'utf8_general_ci',
       'swap_pre' => '',
       'encrypt' => FALSE,
       'compress' => FALSE,
       'stricton' => FALSE,