App Development Reviewer
Message Digest Algorithm: Meaning of MD5
Report Definition Language Client Side: RDLC Meaning
Benefits:
- Runs on client side
- Run Based on only one Dataset
- Run Based on one Data Source
- No need to install any Reporting Service Instance
SQL Commands and definitions
LIKE: operator is used in a WHERE clause to search for a specified pattern in a column
UPDATE: The SQL update clause serves to update data in database table
DISTINCT: The SQL distinct clause works in conjunction with the SQL SELECT clause and
selects only distinct (unique) data from a database table(s).
DELETE: The SQL Delete clause is used to delete data from a database table
TRUNCATE: The SQL Truncate TABLE clause deletes all rows from a database table
ORDER BY: defines in what order to return a data set retrieved with a SQL Select
statement
aggregate functions: are used to sum, count, get the average, get the minimum and get
the maximum values from a column or from a sub-set of column values
GROUP BY: clause is used along with the SQL aggregate functions and specifies the
groups where selected rows are places. WHEN one or more aggregate functions are
presented in the SQL SELECT column list, the SQL GROUP BY clause calculates a
summary value for each group.
HAVING: provides a search condition for a group or aggregate.
JOIN: selects data from two or more tables tied together by matching table columns.
UNION: merges the results
Components of .NET Framework 3.5
Common Language Runtime or CLR - performs memory management, exception
handling, debugging, security checking, thread execution, code execution, code
safety, verification and compilation.
.Net Framework Class library - It contains a huge library of reusable types, classes,
interfaces, structures and enumerated values which are collectively called types
Common Language Specification: It contains the specifications for the .Net
supported languages and implementation of language integration
Common Type System: It provides guidelines for declaring, using and managing
types at runtime, and cross-language communication
Metadata and Assemblies: Metadata is the binary information describing the
program which is wither stored in a portable executable files (PE) or in the
memory. Assembly is a logical unit consisting of the assembly manifest, type
metadata, IL code and set of resources like image files etc.
Windows Forms: This contains the graphical representation of any window
displayed in the application
ASP.Net and ASP.Net AJAX: ASP.NET is the web development model and AJAX is
the extension of ASP.Net for developing and implementing AJAX functionality.
ADO.Net: It is the technology used for working with data and databases.
Windows Workflow Foundation (WF): Helps in building workflow based applications
in Windows. It contains activities, workflow runtime, workflow designer and rules
engine.
Windows Presentation Foundation: Provides a separation between the user
interface and the business logic. It helps in developing visually stunning interfaces
using documents, media, two and three dimensional graphics, animations and more
Windows Communication Foundation (WCF): It is the technology used for building
and running connected systems
Windows CardSpace: provides safety of accessing resources and sharing personal
information on the internet
LINQ: It imparts data querying capabilities to .Net languages using a syntax which is
similar to the tradition query language SQL
Page State: is the state of the client, i.e., the content of various input fields in the web
form
Master Pages: is an ASP.NET file with the extension .master with a predefined layout that
can include static text, HTML elements, and server controls
Subroutine keyword: stored procedure
Outputstream keyword: page rendering
asp.net app codes: c#, j#, jscript, visual basic.net
Languages applicable to asp.net: C#, F#, and Visual Basic Programming Languages
Stored Procedure: is a group of statements with a specific name, which are stored inside
a database
Active Server Pages Network Enabled Technologies: ASP.NET
Return statement of data encryption method
Checkfile: Checks the allocation and structural integrity of all tables and indexed views
in the specified filegroup of the current database**
getContentLength(): Returns the value of the content-length header field.
Validation Controls for ASP.NET
ValidationSummary
RegularExpressionValidator
EmailValidator
CustomValidator
RequiredFieldValidator
RangeValidator
Given the database structure fill-in the blank the correct answers
StudentID nvarchar 15
StudentName nvarchar 150
Gender nvarchar 10
Average decimal 10
Remark nvarchar 10
database name: StudentInfo
1. To Display All StudentID and StudentName
SELECT StudentID, StudentName
FROM StudentInfo
2. Display All Male whose remark is "Passed"
SELECT *
FROM Students
WHERE Gender = 'Male' AND Remark = 'Passed';
3. Display all Female Student with an average of 85 and Above
SELECT *
FROM Students
WHERE Gender = 'Female' AND Average >= 85;
4. Change the Average and Remark of student with "2014-1-12345" to 100 and
"PASSED"
Bonus Raw
In Web Authentication given the tag authorization below
deny users="?"
MD5CryptoServiceProvider mdHash = new MD5CryptoServiceProvider();
byte[ ] totalBytes = Encoding.ASCII.GetBytes(userPassWord);
byte[ ] hashBytes = mdHash.ComputeHash(totalBytes);
// String Builder
StringBuilder sb = new StringBuilder();
for (int generateChar = 0; generateChar < hashBytes.Length; generateChar++)
{
sb.AppendFormat("{0:x2}, hashBytes[generateChar]);
}
return sb.ToString();
}
public void SaveNewAccount(string userName, string userPassword)
{
myConn.Open();
encryptedUserPassword = EncryptedData(userPassword);
SqlCommand saveCmd = new SqlCommand("SaveNewAccount", myConn);
saveCmd. CommandType = CommandType.StoredProcedure;
saveCmd.Parameters.Add"@username", SqlDbType.NVarChar).Value = userName;
saveCmd.Parameters.Add"@userPassword", SqlDbType.NVarChar).Value =
encryptedUserPassword;
saveCmd.ExecuteNonQuery();
myConn.Close()
}
Fill the missing tag statements
authentication mode = "Forms"
forms defaultUrl = "Default.aspx" loginUrl = "MyLoginPage.aspx"
/authenticate
Gets a value indicating whether the FileUpload control contains a file: HasFile
Saves the contents of an uploaded file to a specified path on the Web server: SaveAs
Gets the size of an uploaded file, in bytes: ContentLength
Returns the file name and extension of the specified path string: GetFileName(String)
Maps the specified virtual path, either the absolute path on the current server to the path
relative to the current page, into a physical path: Server.MapPath
