Shulou(Shulou.com)06/02 Report--

This article mainly shows you "what are the knowledge points of C#". The content is simple and clear. I hope it can help you solve your doubts. Let the editor lead you to study and learn the article "what are the knowledge points of C#".

One of the C # knowledge points: when judging the relationship between a parameter and a field in a stored procedure, the select statement must have parentheses, for example

IF @ Price

This includes the whole page.

This is a pop-up div.

-this is the pop-up layer.

Empty and stand-alone div

-this is the cover layer.

The three div are independent of each other and are not nested with each other. When you click the button to pop up, the last two div will set the css of the cover layer to OK.

/ / prompt message function ShowTip (div1,div2) {div1 = = getObject (div1); div2 = = getObject (div2); Member_Main = = getObject (Member_Main); div1.style.display= "block"; div1.style.width=document.body.scrollWidth; div1.style.height=document.body.scrollHeight Div2.style.display= "block"; div2.style.left = (document.body.clientWidth / 2)-(div2.offsetWidth / 2); div2.style.top = (document.body.clientHeight / 2 + document.body.scrollTop)-(div2.offsetHeight / 2) Member_Main.className = "Member_hide"} function CloseTip (div1,div2) {div1 = = getObject (div1); div2 = = getObject (div2); div1.style.display= "none"; div2.style.display= "none"; Member_Main.className = "" } function getObject (objectId) {if (document.getElementById & & document.getElementById (objectId)) {/ / W3C DOM return document.getElementById (objectId);} else if (document.all & & document.all (objectId)) {/ / MSIE 4 DOM return document.all (objectId) } else if (document.layers & & document.layers [objectId]) {/ / NN 4 DOM.. Note: this won't find nested layers return document.layers [objectId];} else {return false;}}

/ * concealment layer * / .layover {position:absolute; top:0px; FILTER: alpha (opacity=20);-moz-opacity:.2; opacity:0.2; background-color:#999999; ZMY indexVROX 101; left: 0px; display:none;}

The style of the pop-up layer can be defined by yourself.

C # knowledge point 3: in order to prevent others from stealing your Iframe, you can add a script at the top

If (top.location! = location) {top.location.href = http://www.9588.com/;}

C # knowledge point 4: in stored procedures, dynamically spell sql statements, in addition to want to return a subresult set, sometimes also need some sum,cout of the original result set and so on

Then assign it to the out parameter and pass out the value

Declare @ sql nvarchar 4000

Declare @ SumOperateFee money

Set @ sql=' select * from orders where reservationtime > '2009-7-22 sql-simple sql, which is much more complicated in practice.

Set @ sql='select @ SumOperateFee=sum (a.pricedue) from ('+ @ sql+') as a'

EXECUTE sp_executesql

@ sql

N'@SumOperateFee money output'

@ SumOperateFee output

This assigns the result of exec execution to the variable, which is of type out and can be taken on the c # side

But I made a serious mistake, a very low-level mistake.

When executing the sql statement, I was confused for a long time by prompting "the procedure requires the parameter'@ statement' to be of type 'ntext/nchar/nvarchar'".

As a result, google for a while, only to know that it refers to this @ sql type, and I actually defined varchar, regret, wasted a lot of time.

The above is all the contents of this article "what are the knowledge points of C#". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.