Saturday, 28 November 2020
ASP.Net 404 page not found error handle
Tuesday, 10 November 2020
Google Captcha for C# ASP.Net MVC
reCAPTCHA uses an advanced risk analysis engine and adaptive challenges to keep malicious software from engaging in abusive activities on your website. Meanwhile, legitimate users will be able to login, make purchases, view pages, or create accounts and fake users will be blocked.
Saturday, 7 November 2020
HTML Table to Excel
jquery.table2excel.min.js
is jquery library which has inbuilt functionality to expert any HTML table to
Excel file by table id. This is one of the simplest solutions available on the internet totally
free of cost.
<html>
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Girfa HTML to Excel</title>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"> </script>
<script src="https://cdn.rawgit.com/rainabba/jquery-table2excel/1.1.0/dist/jquery.table2excel.min.js"> </script>
<script>
function tbltoexcel()
Monday, 5 October 2020
Form post ASP.Net | C# | MVC
HTTP GET and
HTTP Post is the most common method used by HTTP.
- HTTP Get the return response from the server to client.
- HTTP Post send data client (Browser to the server) .
ASP.Net MVC C# has a built-in model attached view for form data submission and validation, which is good but not good as for users who are using simple posts form the method. So I will show you different ways to send data to the server using form method post like PHP.
Demo Table Name (Student)
SN |
Field |
Data Type |
1 |
Roll |
Int |
2 |
Name |
Varchar(50) |
3 |
City |
Varchar(50) |
Store Procedure
Wednesday, 16 September 2020
Column to row transform in SQL Server
Q : In an organization, staff tasks had been assigned through CRM and task status (New, Complete, Pending) submitted to CRM back. Now Admin want to see the every staff task status New, Compare and pending order with staff name
Table Structure
Wednesday, 9 September 2020
Get Date dd/mm/yy format using format string C# | ASP.Net
DateTime dt = DateTime.Now;
string format = "ddmmyy";
string postfix = dt.ToString(format);
Output : 110920
Console.WriteLine(postfix);
Format string pattern
Saturday, 5 September 2020
Bind dynamic layout on a single view using C# | ASP.Net
ASP.Net MVC is a popular platform to design dynamic website
and CRM etc. One I was stuck in a situation when I want to use a common view
to different privileged users. So I had to bind multiple layouts on a single view
as per the related users menu or sidebar. This post will help you to bind
dynamic layouts on a single view.
public ActionResult
Task()
{
File Resizing C# | ASP.NET | MVC
You can resize your image as per your requirement by using
WebImage Class which implemented in System.Web.Helpers namespace and resizing is
done by Resize and save method.
Namespace : using System.Web.Helpers;
[HttpPost]
public JsonResult
UploadCommonImage(string fnm, string
pth,string w,string
h)
{
Sunday, 30 August 2020
Alter Table SQL Server
The ALTER TABLE statement
is used to add, delete, or modify columns in an existing table.
The ALTER TABLE statement
is also used to add and drop various constraints on an existing table.
ALTER TABLE - ADD
Column
To add a column in a table,
use the following syntax:
ALTER TABLE table_name
ADD column_name
datatype;
The following SQL adds an
"Email" column to the "Customers" table:
Example
ALTER TABLE Customers
ADD Email
varchar(255);
Tuesday, 25 August 2020
Zoom Anything on mouse over CSS
This post will help you to learn zoom something one your webpage like Image, div, table, or any HTML component in a simple way.
img
{
width: 100%;
transition: all 1s;
}
Wednesday, 19 August 2020
Descritive Answer : IT TOOLS & BUSINESS SYSTEMS Jan-2018 | NIELIT O Level
Q. 5 (A) : Write the comparison Between Dot Matrix Printers & Laser Printers with respect to Print Quality, Speed, Noise and cost parameters.
Answer
Print Quality
A typical laser printer has a resolution of 1,200 dots per
inch, or dpi. It achieves this level of detail through the use of microscopic
toner powder, high-performance electronics and precision optics. Many laser
printers have color capability at the same high resolution. Some dot matrix
printers achieve 240 dpi by making repeated passes over the same printed area,
though documents produced this way take at least twice as long to print as
those printed at normal quality. As a dot matrix printer's output color depends
on the ribbon, virtually none offer choices beyond black and red.
Speed
A typical desktop laser printer turns out about four full-color pages per minute; for black-and-white text, this rises to 25 pages per minute. Dot matrix printers are typically rated at between 200 and 600 characters per second, or about 50 pages per minute in draft mode. Some high-output dot matrix printers achieve 1,100 characters per second, or 100 pages per minute, although the print quality is low-resolution text.
Monday, 10 August 2020
Process N record from each group | SQL Server
ROW_NUMBER() function in SQL Server is very useful special in case when you want to process N records from a specific group. This function has been around since SQL Server 2005 and at its core, provides a way to provide sequential numbering for rows returned by a query.
As well as sequential numbering, ROW_NUMBER() provides a way to partition the results returned so this suited me just fine
Table Structure
Sunday, 2 August 2020
Descriptive Answer : NIELIT IT Tools and Business Systems (July 2018)
Q. 5 (A) : Write a short note on storage devices of computer.
Answer :
Examples of Storage Device
Friday, 31 July 2020
Answer : IT Tools and Business Systems (January 2019)
Q. 5 (A) : Explain about Multitasking operating system in detail.
Answer :
Multitasking, in an operating system, is allowing a user to perform more than one computer task (such as the operation of an application program) at a time. The operating system is able to keep track of where you are in these tasks and go from one to the other without losing information. Microsoft Windows 2000, IBM's OS/390, and Linux are examples of operating systems that can do multitasking (almost all of today's operating systems can). When you open your Web browser and then open Word at the same time, you are causing the operating system to do multitasking.
Saturday, 25 July 2020
Descriptive Question Answer NIELIT (O-Level ) IT Tools and Business Systems (July 2019)
Answer IT Tools and Business Systems (July 2019)
Q 5 (A) . Define Computer. Explain the main characteristics of Computer.
Answer :
Computer
Thursday, 23 July 2020
Dynamic Memory allocation | Input | Print Ascending Order program | C Language
Answer :
Wednesday, 22 July 2020
String Concatenation without library function | C Language
Q : Write a program to concatenate two strings. (Do not use inbuilt string function).
Answer :
Find Largest number from array using function program | C Language
Q : Write a program to input a set of numbers into an array. Pass the array to a function that finds and display the largest number.?
Answer :
Tuesday, 21 July 2020
Structure record input-read in file | C Langauge
Q : Write a program to write records of students in a file, where each record consists of student name, roll number, CGPA, and address. Read the records back from the file and display them.
#include<stdio.h>
#include<conio.h>
/*============================
Girfa Student Help
Structure write back to file
==============================*/
Full Pyramid program | C Language
Monday, 20 July 2020
Table multiplication of given number
Q : Write program to generate multiplication table for first ‘n’ number, where ‘n’ is a user input.
Answer :
Sunday, 19 July 2020
Extern Variable
Cookies PHP
Syntax
setcookie(name, value, expire, path, domain, secure, httponly);
- Name: It is used to set the name of the cookie.
- Value: It is used to set the value of the cookie.
- Expire: It is used to set the expiry timestamp of the cookie after which the cookie can’t be accessed.
- Path: It is used to specify the path on the server for which the cookie will be available.
- Domain: It is used to specify the domain for which the cookie is available.
- Security: It is used to indicate that the cookie should be sent only if a secure HTTPS connection exists.
Saturday, 18 July 2020
Macro C Language
What is macro? Define a macro to compute maximum of two arguments passed to it.
fseek demo program
Q : Write a file statement to place a file pointer (fp) at the beginning of the record number (say R), where record size is B bytes.
#include<stdio.h>
#include<conio.h>
/*============================
Girfa Student Help
fseek demo
==============================*/
Friday, 17 July 2020
Structure for Employee
Answer :
Difference and similarity between continue and break | C Language
Write down one similarity and one dissimilarity between break and continue statements.
Similarity
Thursday, 16 July 2020
Min Max find program 2d-array using function | C Language
Q : Write a function fnmat() which takes matrix, m, n as arguments where matrix is of size mXn with m as rows and n as columns. Function should return the maximum and minimum elements of the matrix. Elements of matrix are of integer type.
Answer :