Thursday, 26 December 2019

Encrypt password in SQL Server

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

Encrypt



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

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

Sunday, 15 December 2019

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'); 
    }

});

Thursday, 21 November 2019

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;
        
     }

Tuesday, 19 November 2019

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; }
    }

Saturday, 9 November 2019

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

Friday, 8 November 2019

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
1.2 : Which one of the following is volatile?
A) Bubble Memory
B) RAM
C) ROM
D) Magnetic Disc
Answer

Saturday, 2 November 2019

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

Sunday, 20 October 2019

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
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

Monday, 14 October 2019

Thursday, 10 October 2019

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

Sunday, 6 October 2019

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

Thursday, 3 October 2019

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>";
  }  
}

Sunday, 29 September 2019

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

Monday, 23 September 2019

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 :

Monday, 9 September 2019

Light Box Image Gallery


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

Friday, 6 September 2019

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;
}
}

Sunday, 25 August 2019

Google Recaptcha

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.

Tuesday, 2 July 2019

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

Saturday, 15 June 2019

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

Wednesday, 5 June 2019

Copy Current url to clipboard using Javascript


function copyLinkWhatsup()
    {

        var dummy = document.createElement('input'),
          text = window.location.href;
        document.body.appendCh

Monday, 3 June 2019

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

Tuesday, 7 May 2019

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>

Sunday, 21 April 2019

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();

Sunday, 31 March 2019

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;

Friday, 29 March 2019

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.

Wednesday, 27 March 2019

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 

Sunday, 24 March 2019

Friday, 22 March 2019

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)

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,