SQl Xml和C# Xml数据的一点操作总结

ASP.Net中用C#实现站点计数器用户控件

asax文件：
　　<%@ Control Language="c#" AutoEventWireup="false" Codebehind="counter.ascx.cs" Inherits="JiAnWeb.counter" TargetSchema="http://schemas.microsoft.com/intellisense/ie5"%>
　　<LINK href="css.css" rel="stylesheet">
　　<FONT face="宋体">
　　<TABLE id="table_coun ......

sql语言

select *from customers

select *from orders

select customers.cust_id, orders.order_num from customers inner join orders on customers.cust_id=orders.cust_id

select customers.cust_id, orders.order_num from customers left outer join orders on customers.cust_id=orde ......

抓SQL执行语句时间的脚本

select sql_text, spid, v$session.program, process
from v$sqltext, v$session, v$process
where v$sqltext.address = v$session.sql_address
and v$sqltext.hash_value = v$session.sql_hash_value
and v$session.paddr = v$process.addr
and v$process.spid in (4335);
注� ......

Sql helper使用方法

    public List<FirmAttachmentModel> LoadFirmAttachmentByFirmId(int FirmId, int pageIndex, int pageSize)
        {
            List<FirmAttachmentModel> result = new List<FirmAtt ......