NET knowledge outline, net outline

NET knowledge outline, net outline
Part 1 C # programming Basics

1. (30) variables, operators (+,-, *,/, ++, --, Parentheses, = ,! =,>, <, >=, <=, &, |), Process control (if, while, for, switch case, break, continue, foreach), enumeration, array, function, function parameter, and overload.

2. (60) string: String immutable, common string functions (IsNullOrEmpty, ToLower (), ToUpper (), Format (), Join (), Split (), Replace, Substring, Contains, StartsWith, EndsWith ).

3. (90) optional function parameters, variable function parameters, function ref and out.

4. (30) class, field, attribute, method, inheritance, access level constraints (private, public, protected, internal), exception, static member and constant, static class, sealed, namespace, indexer usage

5. (60) value types and reference types, constructors, implicit and explicit conversions, polymorphism, interfaces, abstract classes, common data structures (List <T>, Dictionary <K, v>), can be empty data type.

6. (90) Compile the indexer and HashSet <T>.

Part 2 SQL

1. (30) tables, columns, and common data types (varchar, nvarchar, char, nchar, DateTime, int, identity, UniqueIdentity, primary key, foreign key) basic SQL statements (Insert, Delete, Update, Select), where filtering, Aggregate functions (Sum, count, max, min, avg), order by, like filtering, common functions (getdate (), newid ())

2. (60) group by, null value processing (is null), multi-value matching (in, between and), restricted result set (top, rownumer, and paging query), DISTINCT, index, transaction, Join (Left Join ).

3. (90) having, DML statements (Create table, alter table, drop table), UNION, function (DATEADD, DATEDIFF, DatePart, CAST, Convert, ISNULL, CASE when function), Join (Right Join, Inner Join), subquery, stored procedure, Trigger.

Part 3 ADO. Net

1. (30) SqlConnection, SqlCommand (ExecuteScalar, ExecuteNonQuery, ExecuteDataReader), SqlDataReader, DataSet, able, and DataRow.

2. (60) parameterized query and SQL Injection Vulnerabilities, compiling SqlHelper by yourself, using Sqlhelper to add, delete, modify, and query data, and reading connection strings from App. config and Web. config.

Part 4 WinForm Project

1. (60) write the code of the handwritten three-layer architecture and use ADO. net write Information Management Program, implement secure login Based on MD5 algorithm, use NPOI to read and write Excel to achieve data import and export, pinyin search, recursion and telephone management

2. (90) write the three-tier architecture code generator, use MD5 for file modification detection, and perform compound search.

3. (100) parameters, MDI, window Singleton, WinForm logon interface implementation, and reports are transferred between WinForm windows.

Part 5 HTML

1. (30) common labels (p, B, a, img, br, font, ul, table, input, select, textare)

2. (60) Escape Character (<>), relative path, absolute path, and advanced tag (div, span) style Sheets (directly written on elements, styles on pages, and styles defined in separate css files), common styles (width, height, background-color, border, display, cursor), style selector (id selector, label selector, class selector), positioning (Absolute, relative, static)

3. (90) Advanced tags (meta), Div + CSS layout, frameset, and iframe.

Part 6 Javascript

1. (30) variable declaration, function declaration, and for Loop

2. (60) Anonymous functions, Array objects, and parseInt functions.

3. (90) JavaScript object-oriented, string object, and extension method.

Part 7 JavaScript Dom

1. (30) alert, common events (onload, onclick, onblur, onfocus, onmousemove, onmouseenter, onmouseleave, onmouseout, onmouseover), and getElementById.

2. (60) setInterval, event object (window. event, clientX, clientY, offsetX, offsetY), getElementsByName, getElementsByTagName, dynamic Dom object creation, innerText, innerHTML, event bubbling, element style modification, and element size and position setting.

3. (90) confirm, navigate, setTimeout, showModalDialog, onbeforeunload event, screen object, clipboardData object, window. history. back (), window. history. forward (), document. write, browser compatibility issues, regular expressions, and JavaScript file compression.

Part 8 JQuery

1. (60) Common selector (id selector, label selector, class selector), common events (click, mousemove, mouseenter, mouseleave, mouseout, mouseover, focus, blur) common methods (html (), text (), attr ())

2. (90) dom object and jquery object, advanced selector (Multi-condition selector, hierarchical selector) implicit iteration and chain programming, node traversal (next, nextAll, prev, prevAll, siblings, children, parent), filter selector (: first,: last,: eq ,: lt,: gt,: odd,: even, attribute filter, form selector), style operations (hasClass, addClass, removeClass) dynamically create nodes ($, append, appendTo, prepend, prependTo, and remove), RadioButton operations, event objects, and jquery cookies.

3. (100) each, relative position of selector, replaceWith, wrap, animation, live, and JQueryUI.

Part 9. Net Advanced Technology

1. (60) delegate syntax, event syntax, GC, Dispose and close differences, differences between string and StringBuilder, shallow copy and deep copy, Singleton mode, template method mode, IO (File, Path, Directory common methods in the class, FileStream, Stream, StreamReader, and StreamWriter), XML read/write, custom fan type (generic class, generic method, generic interface, generic delegate, generic constraint), Assembly concept, Attribute Concept

2. (90) Relationship between delegates and events, linq, extension methods, and regular expressions (Common metacharacters, greedy and non-Greedy modes, matching, extraction, and replacement), struct, modifier mode, encrypted stream, compressed stream, serialization, source code management (VSS), reflection (reflection dynamic calling method, reflection implementation plug-in mechanism), custom Attribute, read Attribute through reflection,

3. (100) multi-thread, Socket, anonymous method, lambda, profiler optimization tool, string detention pool, pointer in C #, ADO. Net Access to Access database

Part 10 ASP. Net

1. (60) IHttpHandler can be used to develop simple addition, deletion, modification, and query pages, difference between Get and Post, principle of ViewState, and Http protocol (capable of reading Http packets, Http stateless, and common status codes), Request object, Response object, ASP. net read/write Cookie, Session, verification code, client verification and server verification, XSS principle and prevention, virtual path, MapPath, Redirect and Transfer, IsPostBack, ResolveClientUrl, control ClientID, OnClientClick, FileUpload controls, HTML server controls, and ASP. net Server Control, binding control (ListView, GridView, Repeater), efficient paging, the ability to use aspx to add, delete, modify, query pages, master pages (MasterPage), IIS deployment and configuration of websites, AJAX (using XMLHTTPRequest to implement AJAX, can be based on JQuery AJAX and Other lightweight AJAX packages implement AJAX effects such as refreshing new pages, refreshing new comments, and JSon ).

2. (90) Relationship between aspx and cs, FindControl, understanding of UpdatePanel principles, global files, custom error pages, UrlRewrite, ASP. net cache (page cache, HttpRuntime. cache, data source Cache), CKEditor.

3. (100) the complex events (ItemDataBound, ItemCommand, Inserting, Inserted, Deleting, Deleted, Updating, and Updated) of the bound control, and the verification control