锘??xml version="1.0" encoding="utf-8" standalone="yes"?>BlogJava-bobhttp://www.8634070.com/keweibo/zh-cnTue, 07 May 2019 06:18:50 GMTTue, 07 May 2019 06:18:50 GMT60Sqoop&Hive锛岃鍐矱RROR hive.HiveConfig: Could not load org.apache.hadoop.hive.conf.HiveConf. Make sure HIVE_CONF_DIR is set correctly. http://www.8634070.com/keweibo/articles/433143.htmlKeKeTue, 03 Apr 2018 08:56:00 GMThttp://www.8634070.com/keweibo/articles/433143.htmlhttp://www.8634070.com/keweibo/comments/433143.htmlhttp://www.8634070.com/keweibo/articles/433143.html#Feedback0http://www.8634070.com/keweibo/comments/commentRss/433143.htmlhttp://www.8634070.com/keweibo/services/trackbacks/433143.html鍦?$SQOOP_HOME/lib鐩綍涓嬫墽琛屼互涓嬪懡浠?br />
ln -s  /app/soft/apache-hive-2.3.2-bin/lib/hive-exec-2.3.2.jar   hive-exec-2.3.2.jar


Ke 2018-04-03 16:56 鍙?#29723;?#29831;勮
]]>
鏃堕棿鍒楄浆鍖?amp;&鍔?#37804;佹寚瀹?#37714;?#37718;篒nsert鏁版嵁http://www.8634070.com/keweibo/articles/433141.htmlKeKeMon, 02 Apr 2018 08:47:00 GMThttp://www.8634070.com/keweibo/articles/433141.htmlhttp://www.8634070.com/keweibo/comments/433141.htmlhttp://www.8634070.com/keweibo/articles/433141.html#Feedback0http://www.8634070.com/keweibo/comments/commentRss/433141.htmlhttp://www.8634070.com/keweibo/services/trackbacks/433141.html--鐒跺悗鍐岻nsert琛?#38171;?#37716;?#37804;佹寚瀹?#37714;?#37718;?br />
insert overwrite table partition_user_table partition (dt) select id, account, name, create_time,  from_unixtime(unix_timestamp(create_time,'yyyy/mm/dd'),'yyyymmdd') as dt from external_user_table;


Ke 2018-04-02 16:47 鍙?#29723;?#29831;勮
]]>
hadoop鎴杊base闆嗙兢閲嶅惎澶?#37825;?#38010;傜偣http://www.8634070.com/keweibo/articles/433135.htmlKeKeFri, 30 Mar 2018 02:44:00 GMThttp://www.8634070.com/keweibo/articles/433135.htmlhttp://www.8634070.com/keweibo/comments/433135.htmlhttp://www.8634070.com/keweibo/articles/433135.html#Feedback0http://www.8634070.com/keweibo/comments/commentRss/433135.htmlhttp://www.8634070.com/keweibo/services/trackbacks/433135.html鏈?#37827;跺檋adoop鎴杊base闆嗙兢杩?#29723;?#37827;堕棿涔呬簡?#24727;锛?#37836;愪簺鑺傜偣灏变?#27692;鏁?#38171;岃繖涓?#37827;跺欏鏋?#28051;嶆兂閲嶅惎鏁?#28051;?#38342;嗙兢锛?#26473;欑鎯?#37712;?#37734;緢澶?#37807;?#37712;?#28051;嬪?#33580;粡涓嶈鍏佽锛?#38171;岃繖涓?#37827;跺?#37721;互?#23839;鐙?#38322;嶅惎澶?#37825;?#38010;傜偣銆?/span>
HADOOP锛?br style="box-sizing: border-box;" />
hadoop涓?#38322;嶅惎?#23839;鑺傜偣?#27537;鏂规硶鍜?#28583;?#37716;?#37826;?#38010;傜偣鍏?#28729;炴槸涓鏍风殑銆?/div>
閲嶅惎鎴栨坊鍔?#38010;傜偣

$bin/hadoop-daemon.sh start datanode 
褰?#37906;?#38171;屾坊鍔犵殑璇濋渶瑕乧opy閰嶇疆鏂?#28000;?#37714;?#37826;?#38010;傜偣銆?#38322;嶅惎?#27537;璇?#37711;?/span>  $bin/hadoop-daemon.sh stop datanode

閲?#37826;balancer(鍙?#38315;?
$bin/hadoop balancer
鍏?#28729;?#38342;嗙兢鑷?#23480;变細balancer锛?#35120;?#37906;?#28052;?#37721;互鍍?#28051;?#38344;偅鏍锋?#23338;姩balancer锛?#28051;?#37906;?#37734;?#32507;佸繖鏃舵鏈濂介伩鍏?#37510;?/span>

HBASE锛?/strong>
閲嶅惎
$bin/hbase-daemon.sh stop regionserver
$bin/hbase-daemon.sh start regionserver

涔?#37721;互?#22346;鍔?#37826;扮殑master锛堥粯璁?#37721;?#37832;?#28051;涓猰aster锛?#38171;?br />$bin/hbase-daemon.sh start master


Ke 2018-03-30 10:44 鍙?#29723;?#29831;勮
]]>windows涓?#28003;跨敤IDEA寮鍙?spark SQL渚嬪?#24877;IllegalArgumentException: java.net.URISyntaxException: Relative path in absolute URIhttp://www.8634070.com/keweibo/articles/433116.htmlKeKeWed, 21 Mar 2018 03:31:00 GMThttp://www.8634070.com/keweibo/articles/433116.htmlhttp://www.8634070.com/keweibo/comments/433116.htmlhttp://www.8634070.com/keweibo/articles/433116.html#Feedback0http://www.8634070.com/keweibo/comments/commentRss/433116.htmlhttp://www.8634070.com/keweibo/services/trackbacks/433116.html
public class FirstSparkSql {
public static void main(String[] args) {


String masterMode = "local";//spark://master:7077

SparkConf conf = new SparkConf();
//conf.set("spark.executor.memory", "1024m");
conf.setAppName("First Spark SQL");
conf.setMaster(masterMode);
//瑙?#37712;?#23534;傚父锛?/span>IllegalArgumentException: java.net.URISyntaxException: Relative path in absolute URI
conf.set("spark.sql.warehouse.dir","D:\\temp_files");

JavaSparkContext sc = new JavaSparkContext(conf);

SparkSession spark = SparkSession.builder().config(conf).getOrCreate();
Dataset<Row> df = spark.read().json("hdfs://master:9000/user/spark/input/persons.txt");
df.show();
sc.stop();
}
}


Ke 2018-03-21 11:31 鍙?#29723;?#29831;勮
]]>
ORA-54033 瑕佷慨鏀圭殑鍒?#37922;辨煇涓?#38095;氭嫙琛揪?#32033;浣跨敤http://www.8634070.com/keweibo/articles/427353.htmlKeKeWed, 16 Sep 2015 06:30:00 GMThttp://www.8634070.com/keweibo/articles/427353.htmlhttp://www.8634070.com/keweibo/comments/427353.htmlhttp://www.8634070.com/keweibo/articles/427353.html#Feedback0http://www.8634070.com/keweibo/comments/commentRss/427353.htmlhttp://www.8634070.com/keweibo/services/trackbacks/427353.html鍘?#37826;?/em>  http://blogs.oracle.com/sql/entry/ora_54033_and_the_hidden

A colleague recently asked me a question:

"I'm modifying the data type of a column. When doing so I get the following error:

ORA-54033: column to be modified is used in a virtual column expression

But there's no virtual columns defined on the table! What on earth's going on?!"

This was exceptionally confusing. Looking at the table definition we couldn't see any virtual columns defined: 

create table tab (
  x integer, 
  y date, 
  z varchar2(30)
);

Sure enough, when we tried to change the data type of y we got the exception:

alter table tab modify (y timestamp);

ORA-54033: column to be modified is used in a virtual column expression

How could this be? 

Perhaps there was a column defined that we couldn't see. Querying user_tab_cols revealed something interesting:

select column_name, data_default, hidden_column 
from   user_tab_cols
where  table_name = 'TAB';

COLUMN_NAME 			DATA_DEFAULT 			HID
------------------------------ 	-----------------------------   ---
SYS_STUYPW88OE302TFVBNC6$MMQXE	SYS_OP_COMBINED_HASH("X","Y")	YES
Z		                                                NO
Y								NO
X								NO

The SYS_... column isn't in the table DDL! Where does it come from? And what's SYS_OP_COMBINED_HASH all about? Has someone been mucking around with the database?

The SYS_ prefix is a sign that the column is system generated. So something's happened that's caused Oracle to create this on our behalf.

SYS_OP_COMBINED_HASH is an undocumented feature. The name implies Oracle is merging the arguments together to form a hash.

Is there a feature where we want to capture information about a group of columns?

Indeed there is -extended statistics!This feature enables to Oracle calculate statistics on a group of columns. It uses this information to improve row estimates. This is useful when there's a correlation between the values of two (or more) columns in a table.

Someone had created extended stats on this table for (x, y).

Now we've identified the problem, how do we get around it?

Simple: drop and recreate the extended stats:

exec dbms_stats.drop_extended_stats(user, 'tab', '(x, y)');

alter table tab modify (y timestamp);

select dbms_stats.create_extended_stats(user, 'tab', '(x, y)')
from   dual;

DBMS_STATS.CREATE_EXTENDED_STATS(USER,'TAB','(X,Y)')                           
--------------------------------------------------------------------------------
SYS_STUYPW88OE302TFVBNC6$MMQXE  

Success!

Extended stats are a great way to improve the optimizer's row estimates. If you need to create these, I recommend you also do the following:

  • Apply the extended stats to all environments
  • Put a comment on the columns explaining what you've done, e.g. 
    • comment on column tab.x is 'part of extended stats. To modify data type drop and recreate stats';
These actions will help prevent future developers getting stuck tracking down the cause of "missing" virtual columns!


Ke 2015-09-16 14:30 鍙?#29723;?#29831;勮
]]>
JQuery EasyUI combobox鍔?#37804;佹坊鍔爋ption(?#27974;)http://www.8634070.com/keweibo/articles/418124.htmlKeKeSat, 20 Sep 2014 07:59:00 GMThttp://www.8634070.com/keweibo/articles/418124.htmlhttp://www.8634070.com/keweibo/comments/418124.htmlhttp://www.8634070.com/keweibo/articles/418124.html#Feedback0http://www.8634070.com/keweibo/comments/commentRss/418124.htmlhttp://www.8634070.com/keweibo/services/trackbacks/418124.html
<input class="easyui-combobox" id="rwlb" name="rwlb" style="width:435px" data-options="valueField:'id', textField:'text', panelHeight:'auto'" >  

鏂规硶涓锛?/p>

1 var data, json;
2 json = '[{"id":"骞?#29825;?#37714;?,"text":"骞?#29825;?#37714;?,"selected":true}]';
3 data = $.parseJSON(json);
4 $("#rwlb").combobox("loadData", data);

鏂规硶浜?#38171;?/p>

1 var data,json;
2 data = [];
3 data.push({ "text": "娴?#29831;?, "id": 100 });
4 $("#rwlb").combobox("loadData", data);
?#27974;鑷?#38171;?a href="http://www.cnblogs.com/easypass/archive/2012/12/29/2838329.html">http://www.cnblogs.com/easypass/archive/2012/12/29/2838329.html

Ke 2014-09-20 15:59 鍙?#29723;?#29831;勮
]]>
?#27974;锛Easyui Tree鏂规硶鎵睍 - getLevel(鑾?#37721;?#38010;傜偣绾?#37714;?http://www.8634070.com/keweibo/articles/417899.htmlKeKeSat, 13 Sep 2014 08:12:00 GMThttp://www.8634070.com/keweibo/articles/417899.htmlhttp://www.8634070.com/keweibo/comments/417899.htmlhttp://www.8634070.com/keweibo/articles/417899.html#Feedback0http://www.8634070.com/keweibo/comments/commentRss/417899.htmlhttp://www.8634070.com/keweibo/services/trackbacks/417899.html


Easyui Tree涓鐩?#28751;辨病鏈夋?#24874;緵杩?#28051;?#37826;规硶,?#20114;鍓嶆病鏈夌敤鍒?鎵?#20114;涓鐩?#23052;?#37804;?#28052;?#37734;剰,杩欐鑷?#23480;辩敤鍒颁簡,椤?#28186;?#37813;睍?#31777;涓涓?#37826;规硶,鍒?#27996;?#32513;?#28598;?#28729;?

1 $.extend($.fn.tree.methods, {
2     getLevel:function(jq,target){
3         var l = $(target).parentsUntil("ul.tree","ul");
4         return l.length+1;
5     }
6 });
?#25956;?#30838;:
1 var node = $().tree("getSelected");
2 var lv =  $().tree("getLevel",node.target);


Ke 2014-09-13 16:12 鍙?#29723;?#29831;勮
]]>
oracle 鍗?#26473;?#37714;?#28051;?#37719;?#37711;?#26473;?#37714;?#37928;勮浆鎹?/title><link>http://www.8634070.com/keweibo/articles/416374.html</link><dc:creator>Ke</dc:creator><author>Ke</author><pubDate>Wed, 30 Jul 2014 09:35:00 GMT</pubDate><guid>http://www.8634070.com/keweibo/articles/416374.html</guid><wfw:comment>http://www.8634070.com/keweibo/comments/416374.html</wfw:comment><comments>http://www.8634070.com/keweibo/articles/416374.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.8634070.com/keweibo/comments/commentRss/416374.html</wfw:commentRss><trackback:ping>http://www.8634070.com/keweibo/services/trackbacks/416374.html</trackback:ping><description><![CDATA[<p style="widows: 2; text-transform: none; background-color: rgb(255,255,255); text-indent: 0px; margin: 10px auto; font: 13px/20px georgia, verdana, Arial, helvetica, sans-seriff; white-space: normal; orphans: 2; letter-spacing: normal; color: rgb(75,75,75); word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px">鍗?#26473;?#37714;?#28051;?#37719;?#37711;?#26473;?#37714;?#37928;勮浆鎹?br />8i?#20114;涓?#37911;?#37832;?#38171;?/p> <p style="widows: 2; text-transform: none; background-color: rgb(255,255,255); text-indent: 0px; margin: 10px auto; font: 13px/20px georgia, verdana, Arial, helvetica, sans-seriff; white-space: normal; orphans: 2; letter-spacing: normal; color: rgb(75,75,75); word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px">鍗?#26473;?#37714;?->鍗?#37711;?#26473;?#37714;?nbsp;<br />select to_char(100,'XX') from dual;</p> <p style="widows: 2; text-transform: none; background-color: rgb(255,255,255); text-indent: 0px; margin: 10px auto; font: 13px/20px georgia, verdana, Arial, helvetica, sans-seriff; white-space: normal; orphans: 2; letter-spacing: normal; color: rgb(75,75,75); word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px">鍗?#37711;?#26473;?#37714;?->鍗?#26473;?#37714;?br />select to_number('7D','XX') from dual;</p><br /><span style="color: red">鍏?#28051;XX涓?#37837;煎紡锛?#23049;剰XX?#27537;浣?#37825;?#28051;嶈兘灏忎簬</span>浼?#37711;殑鍙?#37825;?#37510;?br /><img src ="http://www.8634070.com/keweibo/aggbug/416374.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.8634070.com/keweibo/" target="_blank">Ke</a> 2014-07-30 17:35 <a href="http://www.8634070.com/keweibo/articles/416374.html#Feedback" target="_blank" style="text-decoration:none;">鍙?#29723;?#29831;勮</a></div>]]></description></item><item><title>JavaScript涓?#28729;?#37916;板嚱鏁?#38322;?#26462;?#37724;?#37721;?#37825;伴粯璁?#37706;??#27974;)http://www.8634070.com/keweibo/articles/416152.htmlKeKeThu, 24 Jul 2014 01:22:00 GMThttp://www.8634070.com/keweibo/articles/416152.htmlhttp://www.8634070.com/keweibo/comments/416152.htmlhttp://www.8634070.com/keweibo/articles/416152.html#Feedback0http://www.8634070.com/keweibo/comments/commentRss/416152.htmlhttp://www.8634070.com/keweibo/services/trackbacks/416152.html?#27974;鑷?#38171;?a href="http://www.2cto.com/kf/201208/149413.html">http://www.2cto.com/kf/201208/149413.html

鍙?#37825;伴粯璁?#37706;兼槸?#23514;鍦?#29835;冪敤?#22193;鏁?#37827;?#38171;岃嫢鐪佺浜嗘煇涓?#28729;?#37721;?#38171;屽嚱鏁颁細鑷?#37716;?#28051;?#29831;?#37721;?#37825;?#37714;?#38320;?#28051;涓粯璁?#37706;?#38171;屼娇寰楀嚱鏁拌?#20906;敤?#27537;鏂?#28186;?#37804;?#37724;?#37903;垫椿鎬?#28598;?#28598;?#37819;?#26946;?#37510;?/p>

涓?#28051;?#28186;嬪瓙锛屾瘮濡?a style="color: rgb(51,51,51); font-size: 14px; text-decoration: none" class="keylink" href="http://www.2cto.com/kf/web/php/" target="_blank">PHP涓殑瀛楃涓?#37812;?#37721;栧嚱鏁皊ubstr(string,start,length)锛?#35120;?#28051;嶆寚瀹歭ength鏃?#38171;屽嚱鏁?#28751;嗛粯璁?#37812;?#37721;?#28699;楃涓?#28051;璼tart浣嶇疆鍒板?#26947;涓茬?#25780;潫锛岃屽鏋滄寚瀹氫簡length锛?#37714;?#37812;?#37721;?#28000;巗tart浣嶇疆寮濮嬬殑?#20114;length涓洪?#22446;害?#27537;瀛楃涓?#38171;屾墍?#20114;濡?#37835;?#29835;冪敤?#27537;?#27128;substr('http://www.hualai.net.cn',11,6)锛?#37714;?#26473;斿洖?#27537;?#27128;hualai锛涘鏋滅?#20346;?#24064;鏈?#24727;涓涓?#37721;?#37825;?#38171;substr('http://www.hualai.net.cn',11)锛?#37714;?#26473;斿洖hualai.net.cn銆?/p>

鍐嶆瘮濡俲Query妗嗘灦涓?#38171;?(selector).html()鏂规硶?#27128;鑾?#37721;?#29831;?#37711;冪礌鍐呯殑HTML浠爜锛岃?(selector).html(content)鍒欐槸璁剧疆璇?#37711;冪礌鍐呯殑HTML銆?#37812;?#28000;煡閬?#38171;?#37734;C璇言涓?#38171;?#37812;?#28000;?#37721;互閫?#26473;囧涓嬪Ş?#32033;鏉?#28051;哄嚱鏁?#37721;?#37825;拌?#21095;疆?#31919;璁?#37706;?#38171;?/p>

[cpp] 
void foo(int a, int b = 1, bool c = false);   
鍦?a style="color: rgb(51,51,51); font-size: 14px; text-decoration: none" class="keylink" href="http://www.2cto.com/kf/ware/Java/" target="_blank">Java涓?#38171;?#37714;?#37721;互閫?#26473;囧嚱鏁?#38322;?#26462;芥潵璁剧疆?#22193;鏁?#37721;?#37825;伴粯璁?#37706;?#38171;?/p>

[java]
public void foo(int a){   
    foo(a, 1);   
}   
public void foo(int a, int b){   
    foo(a, b, false);   
}   
public void foo(int a, int b, bool c){   
    //?#22193;鏁?#37712;?#28729;?nbsp;  
}   
鑰?#37734;?a style="color: rgb(51,51,51); font-size: 14px; text-decoration: none" class="keylink" href="http://www.2cto.com/kf/qianduan/JS/" target="_blank">JavaScript涓?#38171;屽?#20633;綍鍍廽Query?#20549;鏍?#29825;剧疆?#22193;鏁?#37721;?#37825;伴粯璁?#37706;煎憿锛烰avaScript涓?#39582;舵病鏈?#37709;廋璇言涓?#28729;?#28052;夊嚱鏁?#37827;?#37929;存帴鍦?#37721;?#37825;板悗闈?#29863;嬪肩殑鏂规硶锛屼篃娌?#37832;?#37709;廕ava閲岄偅鏍风殑?#22193;鏁?#38322;?#26462;?#38171;屼?#21976;垜浠?#37721;互閫?#26473;JavaScript鏂规硶涓殑涓涓猘rguments鍙?#29831;?#37721;?#38322;?#37825;?#32513;勬潵瀹?#37916;?#38171;?#37711;?#28003;?#28641;?#28051;?#38171;?/p>

[js] 
function foo(){   
    var a = arguments[0] ? arguments[0] : 1;   
    var b = arguments[1] ? arguments[1] : false;   
    //?#22193;鏁?#37712;?#28729;?nbsp;  
}   
?#20114;涓婃槸閫?#26473;?#37714;?#37826;?#37721;?#37825;版槸鍚?#28699;?#37734;?#38171;岃嫢涓嶅瓨鍦?#37714;?#28751;嗛粯璁?#37706;奸檮缁?#37721;?#38322;?#38171;岃?#37812;?#28000;?#37721;互閫?#26473;?#37714;?#37826;?#37721;?#37825;扮殑?#34987;鍨嬫潵瀹?#37916;?#38322;?#26462;?#38171;?/p>

[js] 
function foo(){   
    if(typeof arguments[0] == 'string')    
        alert('鍙?#37825;扮被鍨?#28051;?#28699;楃涓?);    
    else if(typeof arguments[0] == 'number')    
        alert('鍙?#37825;扮被鍨?#28051;?#37825;?#37706;?);    
}   
鎴栬?#38171;?/p>

[js] 
function foo(){   
    if(arguments[0].constructor == String)    
        alert('鍙?#37825;扮被鍨?#28051;?#28699;楃涓?);    
    else if(arguments[0].constructor == Number)    
        alert('鍙?#37825;扮被鍨?#28051;?#37825;?#37706;?);    
}   



Ke 2014-07-24 09:22 鍙?#29723;?#29831;勮
]]>
SQL Server 2005涓殑CTE閫?#35120;?#37836;?#29831;?#23536;?#37714;?#28051;妫?#37837;?(?#27974;)http://www.8634070.com/keweibo/articles/415936.htmlKeKeThu, 17 Jul 2014 06:46:00 GMThttp://www.8634070.com/keweibo/articles/415936.htmlhttp://www.8634070.com/keweibo/comments/415936.htmlhttp://www.8634070.com/keweibo/articles/415936.html#Feedback0http://www.8634070.com/keweibo/comments/commentRss/415936.htmlhttp://www.8634070.com/keweibo/services/trackbacks/415936.htmlhttp://blog.csdn.net/bin_520_yan/article/details/5998349

鎰?#29785;?#26473;?#28051;CTE閫?#35120;?#37836;?#29831;?#38100;?#28610;界敤?#27537;锛?#37711;?#28051;?#28051;?#28186;嬪瓙锛?/p>

 

  1. use City;  
  2. go  
  3. create table Tree  
  4. (  
  5.   ID int identity(1,1) primary key not null,  
  6.   Name varchar(20) not null,  
  7.   Parent varchar(20) null  
  8. )  
  9. go  
  10. insert Tree values('澶?#28699;?,null)  
  11. insert Tree values('瀛櫌','澶?#28699;?)  
  12. insert Tree values('璁畻鏈?#28699;櫌','瀛櫌')  
  13. insert Tree values('缃?#32513;?#23480;?#32459;?,'璁畻鏈?#28699;櫌')  
  14. insert Tree values('淇伅绠悊','璁畻鏈?#28699;櫌')  
  15. insert Tree values('鐢典俊瀛櫌','瀛櫌')  
  16. insert Tree values('鏁?#37716;?#28598;?,'澶?#28699;?)  
  17. insert Tree values('鏉?#37826;欑','鏁?#37716;?#28598;?)  
  18. insert Tree values('鎷?#37922;?#37716;?,'澶?#28699;?)  
  19. go  
  20. with CTE as  
  21. (  
  22. -->Begin 涓涓?#28729;?#28003;?#37904;规?#24876;憳  
  23.  select ID, Name,Parent,cast(Name as nvarchar(max)) as TE,0 as Levle from Tree where Parent is null  
  24. -->End   
  25. union all  
  26. -->Begin涓涓?#38315;?#35120;?#37812;愬憳  
  27.  select Tree.ID, Tree.Name,Tree.Parent,cast(replicate(' ',len(CTE.TE))+'|_'+Tree.name as nvarchar(MAX)) as TE,Levle+1 as Levle  
  28.         from Tree inner join CTE  
  29.         on Tree.Parent=CTE.Name  
  30. -->End  
  31. )  
  32. select * from CTE order by ID  
  33. --1.灏?nbsp;CTE 琛揪?#32033;鎷?#37714;?#28051;?#28729;?#28003;?#37904;规?#24876;憳鍜?#38315;?#35120;?#37812;愬憳銆?nbsp; 
  34. --2.杩?#29723;?#28729;?#28003;?#37904;规?#24876;憳锛?#37714;涘缓绗?#28051;涓?#29835;冪敤鎴栧鍑嗙粨鏋?#38342;?nbsp;(T0)銆?nbsp; 
  35. --3.杩?#29723;?#38315;?#35120;?#37812;愬憳锛?#28751;?nbsp;Ti 浣?#28051;鸿緭鍏?杩?#38322;?#37721;?#37832;?#28051;鏉?#29825;板綍)锛?#28751;?nbsp;Ti+1 浣?#28051;鸿緭鍑?#37510;?nbsp; 
  36. --4.閲嶅?#23942;楠?nbsp;3锛?#37929;?#37714;?#26473;斿洖绌?#38342;?#37510;?nbsp; 
  37. --5.杩斿洖缁?#37835;?#38342;?#37510;?#26473;欐槸瀵?nbsp;T0 鍒?nbsp;Tn ?#22717;琛?nbsp;UNION ALL ?#27537;缁?#37835;?#37510;?nbsp; 

 

涓?#38344;殑SQL璇?#37721;?#37712;嶆鎻?#37711;?#28051;鏉?#37825;版嵁锛?/p>

insert Tree values('缃?#32513;?鐝?,'缃?#32513;?#23480;?#32459;?)

     杩?#29723;?#32513;?#37835;?#28641;?#28051;嬪锛?/p>

鍥? 杩?#29723;?#32513;?#37835;?/p>

     娉剰?#20579;锛氳?#23676;技鍦?#38315;?#35120;?#37812;愬憳澶勬墍閫夋嫨?#27537;瀛?#23048;甸?#34249;?#21620;Tree琛殑鏁版嵁锛岃?#28051;嶈?#33445;槸CTE缁?#37835;?#38342;?#28051;殑闄簡Tree涓?#23052;?#37832;?#38000;孋TE涓?#37832;夌殑瀛?#23048;?#37734;?#26473;?#38322;屾墠鍙互寮曠敤锛屾瘮濡傚瓧娈TE銆?/p>

    棣?#37711;?#37930;?#28051;?#38171;?#38316;嶅?#21977;殑绗?鏉?#29825;板綍?#27537;SQL璇?#37721;?#38171;?/p>

  1. select ID, Name,Parent,cast(Name as nvarchar(max)) as TE,0 as Levle from Tree where Parent is null  

 

   鑾?#37721;栫殑缁?#37835;?#28051;?#38171;?/p>

   Name  Parent   TE    Levle

-------------------------------------

     澶?#28699;?nbsp;   NULL   澶?#28699;?nbsp;    0

   閫?#35120;?#32471;?娆?#37813;鑾?#37721;栫殑缁?#37835;?#38342;?#37722;堢殑?#34987;SQL璇?#37721;?#28051;?#38171;?/p>

  1. select Tree.ID, Tree.Name,Tree.Parent,cast(replicate(' ',len(CTE.TE))+'|_'+Tree.name as nvarchar(MAX)) as TE,Levle+1 as Levle  
  2. from Tree inner join  
  3.    (select ID, Name,Parent,cast(Name as nvarchar(max)) as TE,0 as Levle from Tree where Parent is null)  
  4. as CTE  
  5. on Tree.Parent=CTE.Name  

 

   涓?#38344;殑CTE瀛愭煡璇殑缁?#37835;?#28751;辨槸绗?#28051;娆?#38315;?#35120;?#37836;?#29831;殑缁?#37835;?#38342;?#38171;?#28051;?#38344;SQL杩?#29723;?#32513;?#37835;?#28051;?#38171;?/p>

   鍚?#37837;风殑锛?#28751;嗙浜屾閫?#35120;?#37836;?#29831;殑涓?#38344;?#28051;夋潯璁板綍浣?#28051;?#32471;?#28051;夋鏌?#29831;殑‘瀹?#28003;?#37812;愬憳’锛?/p>

  銆?#26473;?#38322;岃?#20345;敞?#21104;锛?#28051;?#38344;殑涓夋潯璁板綍?#27128;浠?#37832;?#24727;涓鏉?#23534;濮嬩緷娆?#28003;?#28051;?#32471;?#28051;夋閫?#35120;?#37928;勮緭鍏殑锛屽嵆绗?#28051;鏉槸ID=9鐨勮?#26495;綍锛屾帴涓嬫潵?#27128;7鍜?锛?#37711;?#27996;?#32471;?#37733;?#23046;?#38315;?#35120;?#28052;熺被浼?#37510;?/p>

   绗?#28051;夋閫?#35120;掔被SQL璇?#37721;?/p>

  1. select Tree.ID, Tree.Name,Tree.Parent,cast(replicate(' ',len(CTE.TE))+'|_'+Tree.name as nvarchar(MAX)) as TE,Levle+1 as Levle  
  2. from Tree inner join  
  3. (绗?#27996;屾閫?#35120;?#37836;?#29831;殑SQL璇?#37721;?as CTE  
  4. on Tree.Parent=CTE.Name  

 

   缁?#37835;?#28641;?#28051;?#38171;?/p>

鍏?#28729;炴?#24532;閫?#35120;掔殑?#34987;SQL鍙?#28051;?#28641;?#28051;嬫墍绀?#38171;?/p>

  1. select Tree.ID, Tree.Name,Tree.Parent,cast(replicate(' ',len(CTE.TE))+'|_'+Tree.name as nvarchar(MAX)) as TE,Levle+1 as Levle  
  2. from Tree inner join  
  3. (涓?#23046;?#38315;?#35120;?#37836;?#29831;殑缁?#37835;?#38342;?#38171;屼粎浠呮槸涓?#23046;偅涓娆殑锛岃?#28051;嶆槸?#20114;鍓嶇殑鎬?#37724;?#32513;?#37835;?#38342;?  
  4. as CTE  
  5. on Tree.Parent=CTE.Name  

 

 绗?#37733;?#23046;?#38315;?#35120;?#28051;娆被鎺?#38171;?#37832;?#24727;鎵鏌?#29831;殑缁?#37835;?#28051;?#28051;?#38344;?#37813;鏈?#38315;?#35120;掔殑union銆?/p>

 缁?#38171;?#37734;?#28051;?#38344;殑SQ璇?#37721;?#37836;?#29831;?#32513;?#37835;?#28051;?#38171;ID涓?0鐨勮?#26495;綍搴?#29831;?#29781;佹斁鍦ID涓??#27537;?#24727;闈?#37510;?/p>

 寰鏁版嵁琛?#28051;?#37712;嶆?#22346;鍔?#28051;?#37833;?#29825;板綍锛?/p>

insert Tree values('璁?#32457;?,'璁畻鏈?#28699;櫌')
insert Tree values('鎴?,'缃?#32513;?鐝?) 

鍐嶆?#24936;鏀?#28051;?#38344;殑SQL璇?#37721;?#38171;?/p>

  1. with CTE as    
  2. (     
  3. -->Begin 涓涓?#28729;?#28003;?#37904;规?#24876;憳     
  4.  select ID, Name,Parent,cast(Name as nvarchar(max)) as TE,  
  5.         ROW_NUMBER()over(order by getdate()) as OrderID  
  6.         --鏈鍏抽敭?#27128;涓?#38344;?#26473;?#28051;?#28699;?#23048;?#38171;岃?#20349;幏鍙栨帓搴?#28699;?#23048;?#38171;屾寜瀛楃涓叉潵鎺?#25652;?#37510;?nbsp; 
  7.         --鍏?#28051;?#32464;?#37721;嚱鏁板?#21620;瑕?#28003;跨敤order by锛屼?#21976;槸涓嶈兘?#25956;鏁村瀷锛岄偅灏辩敤鏃堕棿鍚?nbsp; 
  8.         from Tree where Parent is null    
  9. -->End      
  10. union all     
  11. -->Begin涓涓?#38315;?#35120;?#37812;愬憳     
  12.  select Tree.ID, Tree.Name,Tree.Parent,cast(replicate(' ',len(CTE.TE))+'|_'+Tree.name as nvarchar(MAX)) as TE,  
  13.         CTE.OrderID*100+ROW_NUMBER()over(Order by GETDATE()) as OrderID  
  14.         from Tree inner join CTE     
  15.         on Tree.Parent=CTE.Name     
  16. -->End     
  17. )     
  18. select * from CTE  
  19. order by LTRIM(OrderID)--鏈?#24727;灏?#26473;?#28051;?#37825;村?#23339;?#29256;嵁?#27974;鎹?#28051;?#28699;楃涓?#37736;?#37928;勮繘琛屾帓搴?nbsp; 
  20.   
  21. --鏈?#37827;跺?#37825;村?#23338;彲?#20114;?#30254;澶?#28751;?#38171;屽?#26947;涓?#28052;?#37721;互锛屽?#26947;涓叉瘮?#27537;澶?#28751;忔槸涓浣?#28051;浣?#26473;?#29723;屽?#26947;?#30254;杈冪殑  
  22. --鏁村瀷+瀛楃涓?=鏁村瀷锛?#37721;?#37832;?#28699;楃涓?瀛楃涓?=涓?#28051;?#28699;楃涓茬殑骞?#37724;?nbsp; 
  23. --閫?#35120;?#37836;?#29831;?#28051;?#38171;?#32471;?#27996;屾潯璁板綍鍙互寮曠敤绗?#28051;鏉?#29825;板綍?#27537;鍊?nbsp; 
  24. --鍔?#37804;?#37716;?#26462;?#29825;板綍鏃?#38171;?#37722;?#28051;涓瓑绾?#37928;勮?#26495;綍璇?#37714;?#32471;?#38171;RowNumber()over(order by getdate())  
  25. --?#27426;浼?#38171;?#37721;互鍔?#37804;佽幏鍙?#37836;?#28051;儴闂?#28051;嬬殑鎵?#20114;?#29913;?#20788;闂?#37510;?#28052;?#37721;互鑾?#37721;?#29831;儴闂?#28051;?#32510;殑鎵?#20114;?#20788;闂?nbsp; 
  26.   
  27. --鎬?#32513;?#38171;?#26851;?#37711;?#29781;佹?#29006;噾鍑?#28051;涓?#37825;村?#23339;?#29256;嵁锛?#37906;跺悗?#27974;鎹?#28051;?#28699;楃涓?#38171;?#37832;?#24727;?#27128;杩?#29723;屽?#26947;涓茬殑order锛岃?#28051;嶆槸鏁村?#23339;?#29256;嵁?#27537;order锛?nbsp; 

 

鏈?#24727;?#27537;缁?#37835;?#28051;?#38171;?/p>

鍥? 杩?#29723;?#32513;?#37835;?/p>

杩?#37837;?#38171;?#37827;犺?#34425;敤鎴锋彃鍏?#28598;氬鏉?#29825;板綍?#20824;鍙互杩?#29723;屾?#22800;儴闂?#38171;屾寜瑙?#23536;?#26473;?#29723;?#37836;?#29831;?#37510;?/p>

Ke 2014-07-17 14:46 鍙?#29723;?#29831;勮
]]>
DataTable?#27967;鏂?#37825;版嵁鎿?#28003;??#27974;)http://www.8634070.com/keweibo/articles/415278.htmlKeKeMon, 30 Jun 2014 07:49:00 GMThttp://www.8634070.com/keweibo/articles/415278.htmlhttp://www.8634070.com/keweibo/comments/415278.htmlhttp://www.8634070.com/keweibo/articles/415278.html#Feedback0http://www.8634070.com/keweibo/comments/commentRss/415278.htmlhttp://www.8634070.com/keweibo/services/trackbacks/415278.html

BLL灞?nbsp;     

  public void Update(DataTable dt)
        {
            foreach (DataRow dr in dt.Rows)
            {
                if (dr.RowState == DataRowState.Deleted)
                    continue;
                if (dr.RowState == DataRowState.Modified || dr.RowState == DataRowState.Added)
                {
                    if (dr["usr_id"] == DBNull.Value)
                    {
                        throw new Exception("?#25956;鎴?#28000;爜涓嶈兘涓虹");
                    }                }
            }

            dal.Update(dt);
        }

       

DAL灞?/p>

 public void Update(DataTable dt)
        {
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlConnection conn = new SqlConnection(SqlHelper.ConnectionString);
            conn.Open();

            adapter.InsertCommand = new SqlCommand("INSERT INTO dbo.t6( com_id ,usr_id ) VALUES( @com_id ,@usr_id)", conn);
            adapter.InsertCommand.CommandType = CommandType.Text;
            adapter.InsertCommand.Parameters.Add("@com_id", SqlDbType.VarChar, 4, "com_id");
            adapter.InsertCommand.Parameters.Add("@usr_id", SqlDbType.VarChar, 8, "usr_id");

            adapter.UpdateCommand = new SqlCommand("update t6 setwhereand usr_id", conn);
            adapter.UpdateCommand.CommandType = CommandType.Text;
            adapter.UpdateCommand.Parameters.Add("@com_id", SqlDbType.VarChar, 4, "com_id");
            adapter.UpdateCommand.Parameters.Add("@usr_id", SqlDbType.VarChar, 8, "usr_id");
            adapter.UpdateCommand.Parameters.Add("@usr_id1", SqlDbType.VarChar, 8, "usr_id");
            adapter.UpdateCommand.Parameters["@usr_id1"].SourceVersion = DataRowVersion.Original;

            adapter.DeleteCommand = new SqlCommand("delete from t6 whereand usr_id", conn);
            adapter.DeleteCommand.CommandType = CommandType.Text;
            adapter.DeleteCommand.Parameters.Add("@com_id", SqlDbType.VarChar, 4, "com_id");
            adapter.DeleteCommand.Parameters.Add("@usr_id", SqlDbType.VarChar, 8, "usr_id");

            adapter.DeleteCommand.Parameters["@com_id"].SourceVersion = DataRowVersion.Original;
            adapter.DeleteCommand.Parameters["@usr_id"].SourceVersion = DataRowVersion.Original;

            adapter.Update(dt);
        }

 

?#22688;鍙?/p>

    public partial class DataTableUpdate : Form
    {

        public BLL.Users Bu = new BLL.Users();
        public DataTable dtUsr = new DataTable();
        public MOD.Users modObject = new MOD.Users();

        public string _UserId = "";

        public DataTableUpdate()
        {
            InitializeComponent();
            dataGridView1.AutoGenerateColumns = false;
        }

//绐?#37721;?#37716;?#26462;?/p>

        private void Form1_Load(object sender, EventArgs e)
        {
            dtUsr = Bu.GetList();
            dataGridView1.DataSource = dtUsr;
            BindValue();
        }

        private void BindValue()
        {
            tb_com_id.DataBindings.Add("Text", dataGridView1.DataSource, "com_id");
            tb_UsrId.DataBindings.Add("Text", dataGridView1.DataSource, "usr_id");

            //鎵嬪姩?#24936;鏀?#37721;互; 浠?#37934;佽?#23338;奸渶瑕佺敤涓?#38344;?#26473;?#37721;?#29831;?br />            tb_UsrId.DataBindings[0].DataSourceUpdateMode = DataSourceUpdateMode.OnPropertyChanged;
        }

        private void 淇濆瓨_Click(object sender, EventArgs e)
        {
            foreach (DataRow dr in dtUsr.Rows)
            {
                dr.EndEdit();
            }
            try
            {
                Bu.Update(dtUsr);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                return;
            }
            MessageBox.Show("淇濆瓨鎴?#37716;?#38171;?, "绯?#32513;熸彁绀?);
        }

        private void 鍒?#38340;_Click(object sender, EventArgs e)
        {
            if (MessageBox.Show("鎮?#32429;?#29825;?#29781;?#37714;?#38340;敤鎴?#38171;? + tb_UsrName.Text.Trim()+" ?", "鎻?#32448;?, MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.No)
                return;

            if (dataGridView1.CurrentCell == null)
                return;

            try
            {
                dataGridView1.Rows.Remove(dataGridView1.CurrentRow);
                Bu.Update(dtUsr);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                return;
            }
            MessageBox.Show("鍒?#38340;?#37812;?#37716;?#38171;?, "绯?#32513;熸彁绀?);
           
        }

        private void 澧?#37716;_Click(object sender, EventArgs e)
        {
            DataRow dr = dtUsr.NewRow();
            dr["usr_id"] = _UserId;
            dtUsr.Rows.Add(dr);
            dataGridView1.CurrentCell = dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells[0];
        }

        private void 鍙栨秷_Click(object sender, EventArgs e)
        {
            dtUsr.RejectChanges();
        }
鐗涢搧锛?a style="color: rgb(63,167,203); text-decoration: underline" href="http://blog.csdn.net/fangxinggood/archive/2008/04/18/2304047.aspx">http://blog.csdn.net/fangxinggood/archive/2008/04/18/2304047.aspx



Ke 2014-06-30 15:49 鍙?#29723;?#29831;勮
]]>
鍦?#37825;版嵁琛?DataTable)涓?#37823;?#28003;?#37825;版嵁(?#27974;)http://www.8634070.com/keweibo/articles/415272.htmlKeKeMon, 30 Jun 2014 03:08:00 GMThttp://www.8634070.com/keweibo/articles/415272.htmlhttp://www.8634070.com/keweibo/comments/415272.htmlhttp://www.8634070.com/keweibo/articles/415272.html#Feedback0http://www.8634070.com/keweibo/comments/commentRss/415272.htmlhttp://www.8634070.com/keweibo/services/trackbacks/415272.html?#27974;鑷?#38171;?a href="http://blog.csdn.net/cui55/article/details/1371411">http://blog.csdn.net/cui55/article/details/1371411

鍦?span class="Apple-converted-space"> DataSet 涓?#37714;涘缓 DataTable 涔嬪悗锛屾偍?#22717;琛岀殑?#26943;鍔?#37721;互涓?#28003;跨敤鏁版嵁搴?#28051;殑琛?#37827;舵墽琛岀殑?#26943;鍔?#37929;?#37722;?#37510;傛偍鍙互?#22346;鍔?#37510;佹煡鐪?#37510;佺?#26668;緫鍜?#37714;?#38340;?#29723;?#28051;殑鏁版嵁锛?#37721;互鐩?#29785;嗛敊璇?#37724;屼簨浠?#38171;?#39582;?#28051;?#37721;互鏌?#29831;?#29723;?#28051;殑鏁版嵁銆?#37734;慨鏀?span class="Apple-converted-space"> DataTable 涓殑鏁版嵁鏃?#38171;屾偍涔?#37721;互楠岃?#20345;洿鏀规槸鍚?#23005;?#32429;?#38171;屽苟鍐?#28729;氭槸鍚互?#32042;绋?#37826;瑰紡?#24116;鍙楁洿鏀规?#26664;嫆缁濇洿鏀广?/p>

鏈?#38010;?#37712;?#28729;?/p>

灏?#37825;版嵁?#22346;鑷?#29723;?#28051;?/font>:璇存槑濡備綍鍒涘缓鏂?#29723;屽苟灏?#37711;舵坊鑷?#29723;?#28051;?#37510;?/p>
鍦?#37714;涘缓 DataTable 骞?#28003;跨敤鍒?#37724;?#32510;潫瀹?#28052;?#37711;?#32513;?#37835;?#28052;嬪悗锛屾偍鍙互灏?#37826;扮殑鏁版嵁琛屾坊鑷?#29723;?#28051;?#37510;?#29781;佹坊鍔?#37826;?#29723;?#38171;?#37721;?#28751;?#28051;涓?#37826;?#37721;?#38322;忓?#29256;槑涓?span class="Apple-converted-space"> DataRow ?#34987;鍨?#37510;?#29835;冪敤 NewRow 鏂规硶鏃?#38171;?#28751;?#26473;斿洖鏂扮殑 DataRow 瀵硅薄銆?#37906;跺悗锛?strong>DataTable ?#32048;鏍规嵁琛殑缁?#37835;勬寜 DataColumnCollection ?#27537;瀹?#28052;?#37714;涘缓 DataRow 瀵硅薄銆?

?#20114;涓嬬渚嬫紨绀轰簡濡備綍閫?#26473;?#29835;冪敤 NewRow 鏂规硶鏉?#37714;涘缓鏂?#29723;?#37510;?/p>

DataRow workRow = workTable.NewRow();

鐒跺悗鎮?#37721;互浣跨敤绱?#23534;?#37812;?#37714;?#37722;嶆潵鎿?#28003;?#37826;版坊鍔犵殑琛?#38171;屽涓嬩?#23339;墍绀?#37510;?/p>

workRow["CustLName"] = "Smith";
workRow[1] = "Smith";

鍦?#28751;?#37825;版嵁鎻?#37711;?#37826;?#29723;屽悗锛?strong>Add 鏂规硶鍙敤浜?#28751;?#29723;屾坊鑷?span class="Apple-converted-space"> DataRowCollection锛屽?#20633;互涓?#28000;?#37934;佹墍绀?#37510;?/p>

workTable.Rows.Add(workRow);

鎮?#28052;?#37721;互閫?#26473;囦紶鍏?#37706;肩殑鏁?#32513;?#38171;堢被鍨嬪寲涓?span class="Apple-converted-space"> Object锛?#38171;岃?#20906;敤 Add 鏂规硶鏉坊鍔?#37826;?#29723;?#38171;屽涓嬩?#23339;墍绀?#37510;?/p>

workTable.Rows.Add(new Object[] {1, "Smith"});

灏嗙被鍨嬪寲涓?span class="Apple-converted-space"> Object ?#27537;鍊肩殑鏁?#32513;?#28028;?#38315;?#37714;?span class="Apple-converted-space"> Add 鏂规硶锛?#37721;?#37734;?#29723;?#37712;?#37714;涘缓鏂?#29723;屽苟灏?#37711;?#37714;?#37706;?#29825;剧疆涓哄?#30789;薄鏁?#32513;?#28051;殑鍊?#37510;?#29831;?#23049;剰锛?#37825;?#32513;?#28051;殑鍊间細鏍规嵁瀹?#28000;?#37734;?#29723;?#28051;?#37713;?#37916;扮殑椤?#25652;?#37929;?#32513;?#28051;?#37722;?#37714;?#37718;?#38320;?#37510;?/p>

?#20114;涓嬬渚嬪皢鍗?#29723;屾坊鑷?#37826;板缓?#27537; Customers 琛?#28051;?#37510;?/p>

DataRow workRow;

for (int i = 0; i <= 9; i++) 
{
  workRow = workTable.NewRow();
  workRow[0] = i;
  workRow[1] = "CustName" + i.ToString();
  workTable.Rows.Add(workRow);
}

鏌?#37930;?#29723;?#28051;?#37825;版嵁:璇存槑濡備綍璁?#38338;?#29723;?#28051;殑鏁版嵁锛?#37718;?#37815;?#37825;版嵁?#27537;鍘熷鐗?#37832;?#37724;?#35120;撳?#23943;増鏈?#37510;?/p>
鍙互浣跨敤 DataTable ?#27537; Rows 鍜?span class="Apple-converted-space"> Columns 闆?#37722;堟潵璁?#38338;?span class="Apple-converted-space"> DataTable 涓殑鍐?#28729;广?#28052;?#37721;互鏍规嵁鍖?#37815;?#37820;滅储鏍囧噯銆佹帓搴?#26916;?#25652;?#37724;岃?#23680;?#33333;佺瓑鐗?#28729;?#37837;囧噯锛屼?#36328;敤 DataTable.Select 鏂规硶杩斿洖 DataTable 涓?#37825;版嵁?#27537;?#29913;闆?#37510;傛澶?#38171;岀敤涓婚敭鍊兼?#28357;储鐗?#28729;?#29723;?#37827;?#38171;岃繕鍙?#28003;跨敤 DataRowCollection ?#27537; Find 鏂规硶銆?

DataTable 瀵硅薄?#27537; Select 鏂规硶杩斿洖涓缁?#28051;庢寚瀹氭潯浠?#37718;?#38320;嶇殑 DataRow 瀵硅薄銆?strong>Select 閲囩敤绛?#38315;?#29723;揪?#32033;銆佹帓搴?#29723;揪?#32033;鍜?span class="Apple-converted-space"> DataViewRowState ?#27537;鍙?#38315;?#37721;?#37825;?#37510;傜瓫閫?#29723;揪?#32033;鏍规嵁 DataColumn 鍊?#38171;?#28186;嬪 LastName = 'Smith'銆傛帓搴?#29723;揪?#32033;閬?#23536;敤浜?#28051;?#37714;楁帓搴忕殑鏍囧噯 SQL 绾?#28729;?#38171;屼?#23338; LastName ASC, FirstName ASC銆?#37832;?#37711;崇紪鍐?#29723;揪?#32033;?#27537;瑙?#37714;?#38171;岃鍙傞槄DataColumn ?#34987;?#27537; Expression 灞炴?#37510;?/p>

鎻?#32448;?/strong> 濡?#37835;滄偍灏嗗 DataTable ?#27537; Select 鏂规硶?#22717;琛?#28598;氭璋冪敤锛?#37721;?#38315;?#26473;?#37711;?#28051;?span class="Apple-converted-space"> DataTable 鍒涘缓 DataView鏉?#37819;?#26946;?#37804;?#38003;?#37510;?#37714;涘缓 DataView ?#32048;涓?#29723;?#28051;殑琛岀紪鍒?#32497;?#23534;?#37510;?#37906;跺悗锛?strong>Select 鏂规硶?#32048;浣跨敤璇?#32497;?#23534;?#38171;岃繖鏍?#28751;嗘?#25424;?#26947;?#29037;鐢?#37812;愭煡璇?#32513;?#37835;滅殑鏃堕棿銆?#37832;?#37711;?#28051;?span class="Apple-converted-space"> DataTable 鍒涘缓 DataView ?#27537;淇伅锛岃鍙傞槄鍒涘缓鍜屼?#36328;敤 DataView銆?/blockquote>

Select 鏂规硶鍩?#27996;?span class="Apple-converted-space"> DataViewRowState 纭?#28729;?#29781;佹煡鐪嬫?#26664;搷浣滅殑琛岀殑鐗?#37832;?#37510;?#28051;?#29723;?#29831;存?#24221;簡鍙?#38003;界殑 DataViewRowState 鏋?#28051;?#37706;?#37510;?/p>

鎴愬憳鍚嶇 璇存槑
CurrentRows 褰撳墠琛?#38171;?#37718;?#37815;?#37832;洿鏀圭殑琛?#37510;?#23480;叉坊鍔犵殑琛?#37724;?#23480;慨鏀圭殑琛?#37510;?/td>
Deleted 宸?#37714;?#38340;殑琛?#37510;?/td>
ModifiedCurrent 褰撳?#23943;増鏈?#38171;?#28729;冩槸鍘熷?#23339;?#29256;嵁?#27537;?#24936;鏀圭増鏈?#38171;?#29831;?#37721;傞槄ModifiedOriginal锛?#37510;?/td>
ModifiedOriginal 鎵鏈?#23480;慨鏀?#29723;岀殑鍘熷鐗?#37832;?#37510;?#28003;跨敤 ModifiedCurrent 鏃?#38171;?#35120;撳?#23943;増鏈?#37721;敤銆?/td>
Added 鏂?#29723;?#37510;?/td>
None 鏃?#37510;?/td>
OriginalRows 鍘熷琛?#38171;?#37718;?#37815;?#37832;洿鏀圭殑琛?#37724;?#23480;?#37714;?#38340;殑琛?#37510;?/td>
Unchanged 鏈洿鏀圭殑琛?#37510;?/td>

鍦?#28051;?#38344;殑绀?#28186;?#28051;?#38171;?strong>DataSet 瀵硅薄宸茬粡杩囩瓫閫?#38171;岃繖鏍?#38171;屾偍鍙互鍙?#28003;跨敤鍏?span class="Apple-converted-space"> DataViewRowState 璁剧疆涓?span class="Apple-converted-space"> CurrentRows?#27537;琛?#37510;?/p>

DataRow[] currRows = workTable.Select(null, null, DataViewRowState.CurrentRows);

if (currRows.Length < 1 )
  Console.WriteLine("No Current Rows Found");
else
{
  foreach (DataColumn myCol in workTable.Columns)
    Console.Write("/t{0}", myCol.ColumnName);

  Console.WriteLine("/tRowState");

  foreach (DataRow myRow in currRows)
  {
    foreach (DataColumn myCol in workTable.Columns)
      Console.Write("/t{0}", myRow[myCol]);

    Console.WriteLine("/t" + myRow.RowState);
  }
}

Select 鏂规硶鍙敤浜?#26473;斿洖鍏?#37832;?#28051;嶅悓 RowState 鍊?#37812;?#28699;?#23048;?#37706;肩殑琛?#37510;備互涓嬬渚?#26473;斿洖涓涓?#23534;曠敤鎵鏈?#23480;?#37714;?#38340;?#29723;岀殑 DataRow鏁?#32513;?#38171;屽苟杩斿洖鍙?#28051;涓?#23534;曠敤鎵鏈?#23480;叉帓搴?#29723;?#38171;堟寜?#21454; CustLName 鎺?#25652;?#38171;?#37711;?#28051;?span class="Apple-converted-space"> CustID 鍒?#28598;?#27996;?5锛夌殑 DataRow 鏁?#32513;?#37510;?/p>

// Retrieve all deleted rows.
DataRow[] delRows = workTable.Select(null, null, DataViewRowState.Deleted);

// Retrieve rows where CustID > 5, and order by CustLName.
DataRow[] custRows = workTable.Select("CustID > 5", "CustLName ASC");

缂栬緫琛?#28051;殑鏁版嵁:璇存槑濡備綍?#24936;鏀?#29723;?#28051;殑鏁版嵁锛?#37718;?#37815;?#37816;傝?#23792;琛岀殑?#27967;鏀?#38171;?#37929;?#38007;抽?#23683;?#20344;?#33333;帴鍙椾簡?#32531;璁殑?#27967;鏀广?/p>
褰撴偍鍦?span class="Apple-converted-space"> DataRow 涓洿鏀?#37714;?#37706;?#37827;?#38171;屾墍鍋氭洿鏀逛細绔嬪嵆?#30086;浜?#29723;岀殑 Current 鐘舵?#28051;?#37510;?#37906;跺悗锛?strong>RowState ?#32048;璁剧疆涓?strong>Modified锛屽苟浣跨敤 DataRow ?#27537; AcceptChanges 鎴?span class="Apple-converted-space"> RejectChanges 鏂规硶鏉帴鍙?#37812;栨嫆缁?#37813;鍋氭洿鏀广?strong>DataRow杩?#37819;愪緵?#31777;涓?#32457;?#37721;敤浜?#37734;?#32514;栬緫琛?#37827;?#28751;?#29723;岀殑鐘舵佹?#20637;?#39118;殑鏂规硶銆?#26473;欎簺鏂规硶?#27128; BeginEdit銆?strong>EndEdit 鍜?span class="Apple-converted-space"> CancelEdit銆?

褰撴偍鐩存帴鍦?span class="Apple-converted-space"> DataRow 涓慨鏀?#37714;?#37706;?#37827;?#38171;?strong>DataRow ?#32048;浣跨敤 Current銆?strong>Default 鍜?span class="Apple-converted-space"> Original 琛?#37911;?#37832;?#37833;?#32480;悊鍒?#37706;?#37510;傞櫎杩欎簺琛?#37911;?#37832;互澶?#38171;?strong>BeginEdit銆?strong>EndEdit 鍜?span class="Apple-converted-space"> CancelEdit 鏂规硶杩?#28003;跨敤绗?#37733;?#28051;?#29723;?#37911;?#37832;?#38171;?strong>Proposed銆?/p>

鍦墽琛岀?#26668;?#25118;搷浣?#38171;堥?#26473;?#29835;冪敤 BeginEdit 寮濮?#38171;屽苟涓?#38315;?#26473;?#28003;跨敤 EndEdit 鎴?span class="Apple-converted-space"> CancelEdit 鎴栬呴?#26473;?#29835;冪敤AcceptChanges 鎴?span class="Apple-converted-space"> RejectChanges 缁撴潫锛?#37928;勮繃绋?#28051;?#38171;?strong>Proposed 琛?#37911;?#37832;?#28028;氬瓨鍦?#37510;?/p>

鍦?#32514;栬?#25118;搷浣?#26473;?#32459;?#28051;?#38171;屾偍鍙互閫?#26473;?#29825;畻 DataTable ?#27537; ColumnChanged 浜?#28000;?#28051;殑 ProposedValue 鏉?#28751;嗛?#23683;瘉閫?#26440;?#25652;旂敤浜?#37722;?#37714;?#37510;?strong>ColumnChanged 浜?#28000;朵?#28614;瓨 DataColumnChangeEventArgs锛?#37721;?#28103;?#37816;佸?#35268;鍦洿鏀圭殑鍒?#37724;?strong>ProposedValue ?#27537;寮曠敤銆?#29825;畻?#31777;?#32531;璁?#37706;煎悗锛?#37721;互瀵?#37711;?#26473;?#29723;屼慨鏀规垨鍙栨?#22562;?#26668;緫銆傜?#26668;緫缁撴潫鏃?#38171;岃?#23676;粠 Proposed 鐘舵?#28051;?#32457;?#37713;?#37510;?/p>

鎮?#37721;互閫?#26473;?#29835;冪敤 EndEdit 鏉?#32429;?#29825;?#32514;栬緫锛屼篃鍙互閫?#26473;?#29835;冪敤 CancelEdit 鏉?#37721;栨?#22562;?#26668;緫銆?#29831;?#23049;剰锛?#28751;?#32480;?span class="Apple-converted-space"> EndEdit 纭?#28729;?#23480;茬璁?#37806;?#37813;鍋氱殑缂栬緫锛屼絾鍦?#29835;冪敤 AcceptChanges 涔嬪墠锛?strong>DataSet 骞舵病鏈?#28729;?#38340;呮帴鍙楁洿鏀广?#37721;?#28598;?#29831;?#23049;剰锛屽鏋?#37734;?strong>EndEdit 鎴?span class="Apple-converted-space"> CancelEdit 缂栬緫缁撴潫涔嬪?#23944;?#20906;敤 AcceptChanges锛岀?#26668;緫灏嗕細缁堟锛屽?#33333;帴鍙?span class="Apple-converted-space"> Current 鍜?span class="Apple-converted-space"> Original 琛?#37911;?#37832;殑 Proposed 琛?#37706;?#37510;?#29835;冪敤 RejectChanges ?#32048;?#20114;鍚?#37837;风殑鏂瑰紡缁撴潫缂栬緫锛屽?#33333;斁寮?span class="Apple-converted-space"> Current 鍜?span class="Apple-converted-space"> Proposed 琛?#37911;?#37832;?#37510;?#37734;?#29835;冪敤 AcceptChanges 鎴?span class="Apple-converted-space"> RejectChanges 涔嬪悗璋冪敤 EndEdit 鎴?span class="Apple-converted-space"> CancelEdit 涓嶄細璧?#28003;滅敤锛屽洜涓虹?#26668;緫宸茬粡缁撴潫銆?/p>

?#20114;涓嬬渚嬫紨绀轰簡濡備綍灏?span class="Apple-converted-space"> BeginEdit 涓?span class="Apple-converted-space"> EndEdit 鍜?span class="Apple-converted-space"> CancelEdit 涓璧?#28003;跨敤銆?#37832;?#32448;?#28186;?#28052;熶細妫鏌?span class="Apple-converted-space"> ColumnChanged 浜?#28000;?#28051;殑 ProposedValue锛屽苟鍐?#28729;氭槸鍚?#37721;栨?#22562;?#26668;緫銆?/p>

DataTable  workTable  = new DataTable();
workTable.Columns.Add("LastName", typeof(String));

workTable.ColumnChanged += new DataColumnChangeEventHandler(OnColumnChanged);

DataRow workRow = workTable.NewRow();
workRow[0] = "Smith";
workTable.Rows.Add(workRow);

workRow.BeginEdit();
// Causes the ColumnChanged event to write a message and cancel the edit.
workRow[0] = "";     
workRow.EndEdit();

// Displays "Smith, New".
Console.WriteLine("{0}, {1}", workRow[0], workRow.RowState);  


protected static void OnColumnChanged(Object sender, DataColumnChangeEventArgs args)
{
  if (args.Column.ColumnName == "LastName")
    if (args.ProposedValue.ToString() == "")
    {
      Console.WriteLine("Last Name cannot be blank. Edit canceled.");
      args.Row.CancelEdit();
    }
}

琛岀?#33333;?#28051;?#29723;?#37911;?#37832;?/font>:鎻愪緵鏈?#37711;?#29723;岀殑涓嶅?#23680;?#33333;佺殑淇伅銆?/p>
ADO.NET ?#25956;琛岀?#33333;?#37724;?#37911;?#37832;?#32480;悊琛?#28051;殑琛?#37510;?#29723;岀?#33333;?#29723;?#32448;?#29723;岀殑鐘舵?#37510;?#35120;撲慨鏀?#29723;?#37827;?#38171;岃鐗?#37832;細缁?#37814;?#28699;樺偍浜?#29723;?#28051;殑鍊?#38171;?#37718;?#37815;?#35120;撳?#23941;?#37510;佸?#29111;?#23338;?#37724;岄粯璁?#37706;?#37510;?#28186;嬪锛屼慨鏀?#27996;嗘煇琛?#28051;殑涓鍒楀悗锛岃琛屼細鏈?#28051;涓?span class="Apple-converted-space"> Modified ?#27537;琛岀?#33333;?#38171;屽苟涓?#28028;氬瓨鍦?#28051;?#28051;?#29723;?#37911;?#37832;?#38171;?strong>Current锛?#37718;?#37722;?#35120;撳墠琛?#37706;?#38171;?#37724;?span class="Apple-converted-space"> Original锛?#37718;?#37722;慨鏀?#29831;?#37714;楀?#23943;殑琛?#37706;?#38171;?#37510;?

姣?#28051;?span class="Apple-converted-space"> DataRow 瀵硅薄?#20824;鍏?#37832;?span class="Apple-converted-space"> RowState 灞炴?#38171;屾偍鍙互妫鏌?#23005;?#28766;炴?#37833;?#32429;?#28729;?#29723;岀殑褰撳?#23943;?#33333;?#37510;?#28051;?#29723;?#32513;欏?#36720;簡瀵?#37722;?strong>RowState 鏋?#28051;?#37706;肩殑绠瑕?#29831;存槑銆?/p>

RowState 璇存槑
Unchanged 鑷?#28051;?#23046;?#29835;冪敤 AcceptChanges 涔嬪悗锛?#37812;?#38007;?span class="Apple-converted-space"> DataAdapter.Fill 鍒涘?#36720;簡琛屼?#23338;悗锛?#37832;?#37707;氬嚭杩?#28000;讳綍?#27967;鏀广?/td>
Added 宸?#28751;?#29723;屾坊鑷?#29723;?#28051;?#38171;屼絾灏?#37832;?#29835;冪敤 AcceptChanges銆?/td>
Modified 宸叉洿鏀逛簡琛岀殑涓?#31802;鍏冪礌銆?/td>
Deleted 宸?#28751;?#29831;?#29723;屼粠琛?#28051;?#37714;?#38340;?#38171;屽苟涓?#28751;?#37832;?#29835;冪敤 AcceptChanges銆?/td>
Detached 瀵?#27996;?#23480;茬粡鍒涘缓浣?#28051;嶅睘浜?#28000;讳綍 DataRowCollection ?#27537;琛?#38171;岃?#21095;疆涓?span class="Apple-converted-space"> Detached銆?#37826;板缓琛岀殑 RowState璁剧疆涓?span class="Apple-converted-space"> Detached銆傞?#26473;?#29835;冪敤 Add 鏂规硶灏?#37826;扮殑 DataRow ?#22346;鑷?span class="Apple-converted-space"> DataRowCollection 涔嬪悗锛?strong>RowState 灞炴殑鍊?#29825;剧疆涓?span class="Apple-converted-space"> Added銆?

瀵?#27996;?#23480;茬粡浣跨敤 Remove 鏂规硶锛?#37812;栨槸鍦?#28003;跨敤 Delete 鏂规硶涔嬪悗浣跨敤?#31777; AcceptChanges 鏂规硶锛?#28000;?strong>DataRowCollection 涓?#32457;?#38340;殑琛?#38171;屼篃璁剧疆涓?span class="Apple-converted-space"> Detached銆?/p>

鍦?span class="Apple-converted-space"> DataSet銆?strong>DataTable 鎴?span class="Apple-converted-space"> DataRow 涓?#29835;冪敤 AcceptChanges 鏃?#38171;屼細绉?#38340;?#29723;岀?#33333;?#28051;?span class="Apple-converted-space"> Deleted ?#27537;鎵鏈?#29723;?#37510;傚墿浣欑殑琛屼細琚?#29863;嬩 Unchanged 琛岀?#33333;?#38171;屽苟涓?span class="Apple-converted-space"> Original 琛?#37911;?#37832;?#28051;殑鍊间細鏀?#37712;?#28051;?span class="Apple-converted-space"> Current 琛?#37911;?#37832;?#37706;?#37510;?#29835;冪敤RejectChanges 鏃?#38171;屼細绉?#38340;?#29723;岀?#33333;?#28051;?span class="Apple-converted-space"> Added ?#27537;鎵鏈?#29723;?#37510;傚墿浣欑殑琛屼細琚?#29863;嬩 Unchanged ?#27537;琛岀?#33333;?#38171;屽苟涓?strong>Current 琛?#37911;?#37832;?#28051;殑鍊间細鏀?#37712;?#28051;?span class="Apple-converted-space"> Original 琛?#37911;?#37832;?#37706;?#37510;?/p>

閫?#26473;囩敤鍒?#23534;曠敤鏉?#28028;?#38315;?span class="Apple-converted-space"> DataRowVersion 鍙?#37825;?#38171;屾偍鍙互鏌?#37930;?#29723;岀殑涓嶅?#23683;鐗?#37832;?#38171;屽涓嬩?#23339;墍绀?#37510;?/p>

DataRow custRow = custTable.Rows[0];
string custID = custRow["CustomerID", DataRowVersion.Original].ToString();

涓?#29723;?#32513;欏?#36720;簡鍚?span class="Apple-converted-space"> DataRowVersion 鏋?#28051;?#37706;肩殑绠瑕?#29831;存槑銆?/p>

DataRowVersion 璇存槑
Current 琛岀殑褰撳?#23941;?#37510;傚鏋滄槸鏈?span class="Apple-converted-space"> Deleted ?#27537; RowState ?#27537;琛?#38171;?#37714;?#28051;嶅瓨鍦?#23005;?#29723;?#37911;?#37832;?#37510;?/td>
Default 鐗?#28729;?#29723;岀殑?#31919;璁?#29723;?#37911;?#37832;?#37510;?strong>Added銆?strong>Modified 鎴?span class="Apple-converted-space"> Unchanged 琛岀殑?#31919;璁?#29723;?#37911;?#37832;槸Current銆?strong>Deleted 琛岀殑?#31919;璁?#29723;?#37911;?#37832;槸 Original銆?strong>Detached 琛岀殑?#31919;璁?#29723;?#37911;?#37832;槸 Proposed銆?/td>
Original 琛岀殑鍘熷?#23338;?#37510;傚鏋滄槸鏈?span class="Apple-converted-space"> Added ?#27537; RowState ?#27537;琛?#38171;?#37714;?#28051;嶅瓨鍦?#23005;?#29723;?#37911;?#37832;?#37510;?/td>
Proposed 琛岀殑?#32531;璁?#37706;?#37510;?#37734;?#28725;?#29723;岃繘琛岀?#26668;?#25118;搷浣?#37832;熼棿锛?#37812;栧浜?#28051;嶅睘浜?span class="Apple-converted-space"> DataRowCollection ?#27537;琛?#38171;屽瓨鍦?#23005;?#29723;?#37911;?#37832;?#37510;?/td>

閫?#26473;?#29835;冪敤 HasVersion 鏂规硶骞?#28751;?span class="Apple-converted-space"> DataRowVersion 浣?#28051;?#37721;?#37825;?#28028;?#38315;?#38171;屾偍鍙互娴?#29831;?span class="Apple-converted-space"> DataRow ?#27128;鍚?#37711;?#37832;?#37911;?#28729;氱殑琛?#37911;?#37832;?#37510;?#28186;嬪锛?#37734;?#29835;冪敤 AcceptChanges 涔嬪墠锛?code class="ce">DataRow.HasVersion(DataRowVersion.Original) 瀵?#37826;版坊鍔犵殑琛?#28751;?#26473;斿洖 false銆?/p>

渚嬪锛屼互涓?#28000;?#37934;佺渚嬫?#21095;?#36720;簡琛?#28051;?#37813;鏈?#23480;?#37714;?#38340;?#29723;岀殑鍊?#37510;?#23480;?#37714;?#38340;殑琛屾病鏈?span class="Apple-converted-space"> Current 琛?#37911;?#37832;?#38171;屽?#29363;鍦?#29825;?#38338;?#37714;?#37706;?#37827;跺?#21620;浼?#38315;?span class="Apple-converted-space"> DataRowVersion.Original銆?/p>

DataTable catTable = catDS.Tables["Categories"];

DataRow[] delRows = catTable.Select(null, null, DataViewRowState.Deleted);

Console.WriteLine("Deleted rows:/n");

foreach (DataColumn catCol in catTable.Columns)
  Console.Write(catCol.ColumnName + "/t");
Console.WriteLine();

foreach (DataRow delRow in delRows)
{
  foreach (DataColumn catCol in catTable.Columns)
    Console.Write(delRow[catCol, DataRowVersion.Original] + "/t");
  Console.WriteLine();
}

浠?#29723;?#28051;?#37714;?#38340;?#29723;?/font>:璇存槑濡備綍浠?#29723;?#28051;?#32457;?#38340;?#29723;?#37510;?/p>
?#25956;浜?#28000;?span class="Apple-converted-space"> DataTable 瀵硅薄涓?#37714;?#38340;?span class="Apple-converted-space"> DataRow 瀵硅薄?#27537;鏂规硶鏈?#28051;?#32457;?#38171;?strong>DataRowCollection 瀵硅薄?#27537; Remove 鏂规硶鍜?strong>DataRow 瀵硅薄?#27537; Delete 鏂规硶銆?strong>Remove 鏂规硶浠?span class="Apple-converted-space"> DataRowCollection 涓?#37714;?#38340;?span class="Apple-converted-space"> DataRow锛岃?span class="Apple-converted-space"> Delete 鏂规硶鍙?#28751;?#29723;?#37837;?#29825;?#28051;?#37714;?#38340;?#37510;?#35120;?#25652;旂敤绋嬪簭璋冪敤 AcceptChanges 鏂规硶鏃?#38171;屾墠?#32048;鍙?#37922;?#28729;?#38340;呯殑鍒?#38340;?#37510;傞?#26473;?#28003;跨敤 Delete锛屾偍鍙互鍦?#28729;?#38340;?#37714;?#38340;?#28052;嬪?#23941;厛?#20114;?#32042;绋?#37826;瑰紡妫鏌摢?#31802;琛?#37837;?#29825;?#28051;?#37714;?#38340;?#37510;傚鏋?#28751;?#29723;?#37837;?#29825;?#28051;?#37714;?#38340;?#38171;?#37711;?span class="Apple-converted-space"> RowState 灞炴細璁剧疆涓?span class="Apple-converted-space"> Deleted銆?

鍦?#28751;?span class="Apple-converted-space"> DataSet 鎴?span class="Apple-converted-space"> DataTable 涓?span class="Apple-converted-space"> DataAdapter 鍜?#37711;?#32495;?#37736;嬫?#29256;嵁婧?#28051;璧?#28003;跨敤鏃?#38171;岀敤 DataRow ?#27537; Delete 鏂规硶绉?#38340;?#29723;?#37510;?strong>Delete 鏂规硶鍙槸鍦?span class="Apple-converted-space"> DataSet 鎴?span class="Apple-converted-space"> DataTable 涓?#28751;?#29723;?#37837;?#29825;?#28051;?span class="Apple-converted-space"> Deleted锛岃?#28051;嶄細绉?#38340;?#28729;?#37510;?#38000;?span class="Apple-converted-space"> DataAdapter 鍦?#38316;?#37714;版爣璁?#28051;?span class="Apple-converted-space"> Deleted ?#27537;琛?#37827;?#38171;屼細?#22717;琛?#37711;?span class="Apple-converted-space"> DeleteCommand ?#20114;鍦?#37825;版嵁婧?#28051;?#37714;?#38340;?#29831;?#29723;?#37510;?#37906;跺悗锛?#28751;?#37721;互?#25956;AcceptChanges 鏂规硶姘?#28052;呯闄?#29831;?#29723;?#37510;傚鏋?#28003;跨敤 Remove 鍒?#38340;?#29831;?#29723;?#38171;?#37714;?#29831;?#29723;?#28751;?#28000;?#29723;?#28051;?#28729;?#37711;?#32457;?#38340;?#38171;屼絾DataAdapter 涓嶄細鍦?#37825;版嵁婧?#28051;?#37714;?#38340;?#29831;?#29723;?#37510;?/p>

DataRowCollection ?#27537; Remove 鏂规硶閲囩敤 DataRow 浣?#28051;?#37721;?#37825;?#38171;屽苟灏?#37711;?#28000;?#38342;?#37722;?#28051;?#32457;?#38340;?#38171;屽涓嬩?#23339;墍绀?#37510;?/p>

workTable.Rows.Remove(workRow);

浣?#28051;哄?#35268;瘮锛屼互涓嬬渚嬫紨绀轰簡濡備綍璋冪敤 DataRow 涓婄殑 Delete 鏂规硶鏉?#28751;?#37711;?span class="Apple-converted-space"> RowState 鏀?#28051;?span class="Apple-converted-space"> Deleted銆?/p>

workRow.Delete();

濡?#37835;?#28751;?#29723;?#37837;?#29825;?#28051;?#37714;?#38340;?#38171;屽苟涓?#29835;冪敤 DataTable 瀵硅薄?#27537; AcceptChanges 鏂规硶锛岃琛?#28751;变細浠?span class="Apple-converted-space"> DataTable 涓?#32457;?#38340;?#37510;?#37929;告瘮涔?#28051;?#38171;屽鏋?#29835;冪敤 RejectChanges锛岃?#23680;殑 RowState 灏变細鎭?#28598;?#37714;拌鏍?#29825;?#28051;?span class="Apple-converted-space"> Deleted 涔嬪?#23943;殑鐘舵?#37510;?/p>

娉剰 濡?#37835;?span class="Apple-converted-space"> DataRow ?#27537; RowState ?#27128; Added锛?#37714;欐剰鍛崇宸?#28751;?#37711;舵坊鑷?#29723;?#28051;?#38171;?#37906;跺悗灏?#37711;?#37837;?#29825;?#28051;?strong>Deleted锛屼粠琛?#28051;?#32457;?#38340;?#37510;?/blockquote>

?#22346;鍔?#37724;岃鍙?#29723;岄敊璇?#28103;伅:璇存槑濡備綍鎸?#29723;屾彃鍏?#38335;?#29831;?#28103;伅锛屼互?#25956;浜?#29785;?#37712;?#37832;?#37711;?#25652;旂敤绋嬪簭鍐?#29723;?#28051;?#37825;版嵁?#27537;闂?#26864;?#37510;?/p>
涓轰簡?#20265;鍏?#37734;?#32514;栬緫 DataTable 涓殑鍊?#37827;舵?#24532;鍙?#37922;?#29723;岄敊璇?#38318;藉?#21620;?#35826;?#23941;簲锛?#37721;?#28751;嗛敊璇?#28103;伅?#22346;鑷?#29723;?#28051;?#38171;屼互渚互?#24727;浣跨敤銆?strong>DataRow 瀵硅薄閫?#26473;囧鍚?#29723;屾?#24874;緵 RowError 灞炴?#37833;?#37824;?#37816;佹鍔?#38003;?#37510;?#28751;?#37825;版嵁?#22346;鑷?span class="Apple-converted-space"> DataRow ?#27537; RowError 灞炴?#28028;氬皢DataRow ?#27537; HasErrors 灞炴?#37837;?#29825;?#28051;?span class="Apple-converted-space"> true銆傚鏋?span class="Apple-converted-space"> DataRow ?#27128; DataTable ?#27537;缁?#37812;愰儴鍒?#38171;?#28051;?span class="Apple-converted-space"> DataRow.HasErrors?#27128; true锛?#37714;?span class="Apple-converted-space"> DataTable.HasErrors 灞炴?#28052;熸槸 true銆?#26473;?#28052;?#38315;傜敤浜?span class="Apple-converted-space"> DataTable 鎵灞炵殑 DataSet銆?#28051;洪敊璇?#37707;氭祴璇?#37827;?#38171;?#37721;互妫鏌?span class="Apple-converted-space"> HasErrors 灞炴互纭?#28729;氶敊璇?#28103;伅?#27128;鍚?#23480;叉坊鑷?#37813;鏈?#29723;?#37510;傚鏋?span class="Apple-converted-space"> HasErrors 涓?span class="Apple-converted-space"> true锛?#37714;?#37721;?#28003;跨敤 DataTable ?#27537;GetErrors 鏂规硶?#20114;渚?#37721;?#26473;斿洖鍜屾鏌?#37832;夐敊璇殑琛?#38171;屽涓嬩?#23339;墍绀?#37510;?

DataTable  workTable = new DataTable("Customers");
workTable.Columns.Add("CustID", typeof(Int32));
workTable.Columns.Add("Total", typeof(Double));

workTable.RowChanged += new DataRowChangeEventHandler(OnRowChanged);

for (int i = 0; i < 10; i++)
  workTable.Rows.Add(new Object[] {i, i*100});

if (workTable.HasErrors)
{
  Console.WriteLine("Errors In Table " + workTable.TableName);

  foreach (DataRow myRow in workTable.GetErrors())
  {
    Console.WriteLine("CustID = " + myRow["CustID"]);
    Console.WriteLine(" Error = " + myRow.RowError + "/n");
  }
}

protected static void OnRowChanged(Object sender, DataRowChangeEventArgs args)
{
  // Check for zero values.
  if (args.Row["Total"].Equals(0D))
    args.Row.RowError = "Total cannot be 0.";
}

?#24116;鍙?#37812;栨嫆缁濆琛岀殑?#27967;鏀?/font>:璇存槑濡備綍?#24116;鍙?#37812;栨嫆缁濆琛岀殑?#27967;鏀广?/p>
鍦?#22955;楠岃?#22247; DataTable 涓殑鏁版嵁鎵鍋氭洿鏀圭殑鍑嗙鎬?#28052;嬪悗锛?#37721;?#28003;跨敤 DataRow銆?strong>DataTable 鎴?span class="Apple-converted-space"> DataSet ?#27537;AcceptChanges 鏂规硶鏉帴鍙楁洿鏀?#38171;屾鏂规硶浼氬皢 Current 琛?#37706;?#29825;剧疆涓?span class="Apple-converted-space"> Original 鍊?#38171;屽苟浼氬皢 RowState 灞炴?#29825;剧疆涓?span class="Apple-converted-space"> Unchanged銆傛帴鍙?#37812;栨嫆缁濇洿鏀逛細娓呴櫎鎵鏈?span class="Apple-converted-space"> RowError 淇伅锛屽苟灏?span class="Apple-converted-space"> HasErrors 灞炴?#29825;剧疆涓?span class="Apple-converted-space"> false銆傛帴鍙?#37812;栨嫆缁濇洿鏀?#26473;?#37721;互褰卞搷鍦?#37825;版嵁婧?#28051;洿鏂?#37825;版嵁銆?#37832;?#37711;?#37831;村?#27691;俊?#20229;锛岃鍙傞槄浣跨敤 DataAdapter 鍜?DataSet ?#27967;鏂?#37825;版嵁搴?/a>銆?

濡?#37835;?span class="Apple-converted-space"> DataTable 涓?#28699;?#37734;?#28598;敭绾潫锛屼?#36328;敤 AcceptChanges 鍜?span class="Apple-converted-space"> RejectChanges ?#24116;鍙?#37812;栨嫆缁濈殑?#27967;鏀?#28751;变細鏍规嵁ForeignKeyConstraint.AcceptRejectRule 浼犳挱鑷?span class="Apple-converted-space"> DataRow ?#27537;?#29913;琛?#37510;?/p>

?#20114;涓嬬渚嬫鏌?#37832;夐敊璇殑琛?#38171;?#37734;?#38315;傜敤涔嬪瑙?#37712;抽敊璇?#38171;屾嫆缁?#37827;犳硶瑙?#37712;抽敊璇殑琛?#37510;?#29831;?#23049;剰锛屽浜?#29785;?#37712;崇殑閿?#29831;?#38171;?strong>RowError鍊间細閲嶇疆涓虹瀛楃涓?#38171;屽鑷?#28751;?span class="Apple-converted-space"> HasErrors 灞炴?#29825;剧疆涓?span class="Apple-converted-space"> false銆?#35120;?#29785;?#37712;?#37812;栨嫆缁?#27996;嗘墍鏈夌殑鏈夐敊璇殑琛?#37827;?#38171;?#28751;变細璋冪敤AcceptChanges 鏉帴鍙楀?#35268;暣涓?span class="Apple-converted-space"> DataTable ?#27537;鎵鏈夋洿鏀广?/p>

if (workTable.HasErrors)
{

  foreach (DataRow errRow in workTable.GetErrors())
  {
    if (errRow.RowError == "Total cannot exceed 1000.")
    {
      errRow["Total"] = 1000;
      errRow.RowError = "";    // Clear the error.
    }
    else
      errRow.RejectChanges();
  }
}

workTable.AcceptChanges();

澶勭悊 DataTable 浜?#28000;?/font>:鎻愪緵鍙敤浜?span class="Apple-converted-space"> DataTable ?#27537;浜?#28000;剁殑鐩?#37711;?#28103;伅锛?#37718;?#37815;慨鏀?#37714;?#37706;?#37724;屾坊鍔?#37812;?#37714;?#38340;?#29723;?#37827;剁殑浜?#28000;?#37510;?/p>
DataTable 瀵硅薄鎻愪緵涓绯?#37714;?#37721;?#37922;?#25652;旂敤绋嬪簭澶勭?#21977;殑浜?#28000;?#37510;?#28051;?#29723;?#29831;存?#24221;簡 DataTable 浜?#28000;?#37510;?
浜?#28000;?/th> 璇存槑
ColumnChanged 鍦?#37706;煎凡鎴?#37716;熸彃鍏?#37714;?#37827;?#37721;?#37922;?#37510;?/td>
ColumnChanging 鍦?#23480;?#37819;愪氦鍒?#37706;?#37827;?#37721;?#37922;?#37510;?/td>
RowChanged 鍦?#23480;?#37812;?#37716;熺?#26668;緫琛?#28051;殑琛屽悗鍙?#37922;?#37510;?/td>
RowChanging 褰撴鍦洿鏀?#29723;?#28051;殑琛?#37827;?#37721;?#37922;?#37510;?/td>
RowDeleted 鍦?#29723;?#28051;殑鏌?#29723;?#23480;?#29722;?#37837;?#29825;?#28051;?span class="Apple-converted-space"> Deleted 涔嬪悗鍙?#37922;?#37510;?/td>
RowDeleting 鍦?#29723;?#28051;殑鏌?#29723;岃鏍?#29825;?#28051;?span class="Apple-converted-space"> Deleted 涔嬪墠鍙?#37922;?#37510;?/td>

?#20114;涓嬬渚嬪?#28056;缓 4 涓?#27996;?#28000;?#38171;?strong>OnColumnChanged銆?strong>OnColumnChanging銆?strong>OnRowChanged 鍜?strong>OnRowChanging銆?#26473;欎簺浜?#28000;?#28051;殑姣?#28051;涓兘鍦?#37714;?#37812;?#29723;屾洿鏀规椂鍙?#37922;?#37510;?/p>

workTable.ColumnChanged  += new DataColumnChangeEventHandler(OnColumnChanged);
workTable.ColumnChanging += new DataColumnChangeEventHandler(OnColumnChanging);
workTable.RowChanged     += new DataRowChangeEventHandler(OnRowChanged);
workTable.RowChanging    += new DataRowChangeEventHandler(OnRowChanging);

protected static void OnColumnChanged(object sender, DataColumnChangeEventArgs args)
{
  Console.Write(" ColumnChanged: ");
  Console.Write(args.Column.ColumnName + " changed to '" + args.ProposedValue + "'/n");
}

protected static void OnColumnChanging(object sender, DataColumnChangeEventArgs args)
{
  Console.Write("ColumnChanging: ");
  Console.Write(args.Column.ColumnName + " equals '" + args.Row[args.Column] + 
                    "', changing to '" + args.ProposedValue + "'/n");    
}

protected static void OnRowChanging(object sender, DataRowChangeEventArgs args)
{
  if (args.Action != DataRowAction.Nothing)
    Console.WriteLine("   RowChanging: Action = " + args.Action + ", CustID = " + args.Row["CustID"]);
}

protected static void OnRowChanged(object sender, DataRowChangeEventArgs args)
{
  if (args.Action != DataRowAction.Nothing)
    Console.WriteLine("    RowChanged: Action = " + args.Action + ", CustID = " + args.Row["CustID"]);
}



Ke 2014-06-30 11:08 鍙?#29723;?#29831;勮
]]>
SQL Server 2000 Split 鑷?#28729;?#28052;夊嚱鏁?/title><link>http://www.8634070.com/keweibo/articles/406147.html</link><dc:creator>Ke</dc:creator><author>Ke</author><pubDate>Fri, 08 Nov 2013 08:57:00 GMT</pubDate><guid>http://www.8634070.com/keweibo/articles/406147.html</guid><wfw:comment>http://www.8634070.com/keweibo/comments/406147.html</wfw:comment><comments>http://www.8634070.com/keweibo/articles/406147.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.8634070.com/keweibo/comments/commentRss/406147.html</wfw:commentRss><trackback:ping>http://www.8634070.com/keweibo/services/trackbacks/406147.html</trackback:ping><description><![CDATA[<div>/****** Object: Function [dbo].[F_SQLSERVER_SPLIT]   Script Date: 2013-10-30 16:21:46 ******/</div><div>USE [ZBP];</div><div>GO</div><div>SET ANSI_NULLS OFF;</div><div>GO</div><div>SET QUOTED_IDENTIFIER ON;</div><div>GO</div><div>CREATE FUNCTION [dbo].[F_SQLSERVER_SPLIT](@Long_str varchar(8000),@split_str varchar(100))    </div><div>RETURNS  @tmp TABLE(        </div><div>    ID          inT     IDENTITY PRIMARY KEY,      </div><div>    short_str   varchar(8000)    </div><div>)    </div><div>AS   </div><div>BEGIN   </div><div>    DECLARE @long_str_Tmp varchar(8000),@short_str varchar(8000),@split_str_length int   </div><div>    SET @split_str_length = LEN(@split_str)    </div><div>    IF CHARINDEX(@split_str,@Long_str)=1 </div><div>         SET @long_str_Tmp=SUBSTRING(@Long_str,@split_str_length+1,LEN(@Long_str)-@split_str_length)</div><div>    ELSE</div><div>         SET @long_str_Tmp=@Long_str</div><div>    IF CHARINDEX(REVERSE(@split_str),REVERSE(@long_str_Tmp))>1    </div><div>        SET @long_str_Tmp=@long_str_Tmp+@split_str    </div><div>    ELSE   </div><div>        SET @long_str_Tmp=@long_str_Tmp    </div><div>    IF CHARINDEX(@split_str,@long_str_Tmp)=0</div><div>        Insert INTO @tmp select @long_str_Tmp </div><div>    ELSE</div><div>        BEGIN</div><div>            WHILE CHARINDEX(@split_str,@long_str_Tmp)>0    </div><div>                BEGIN   </div><div>                    SET @short_str=SUBSTRING(@long_str_Tmp,1,CHARINDEX(@split_str,@long_str_Tmp)-1)    </div><div>                    DECLARE @long_str_Tmp_LEN INT,@split_str_Position_END int   </div><div>                    SET @long_str_Tmp_LEN = LEN(@long_str_Tmp)    </div><div>                    SET @split_str_Position_END = LEN(@short_str)+@split_str_length    </div><div>                    SET @long_str_Tmp=REVERSE(SUBSTRING(REVERSE(@long_str_Tmp),1,@long_str_Tmp_LEN-@split_str_Position_END))</div><div>                    IF @short_str<>'' Insert INTO @tmp select @short_str    </div><div>                END           </div><div>        END</div><div>    RETURN     </div><div>END</div><div>GO</div><div></div><img src ="http://www.8634070.com/keweibo/aggbug/406147.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.8634070.com/keweibo/" target="_blank">Ke</a> 2013-11-08 16:57 <a href="http://www.8634070.com/keweibo/articles/406147.html#Feedback" target="_blank" style="text-decoration:none;">鍙?#29723;?#29831;勮</a></div>]]></description></item><item><title>SQL Server 2000 鍗?#37711;?#26473;?#37714;?#28051;?#37719;?#26473;?#37714;朵?#25493;浆锛?#37824;惰锛?/title><link>http://www.8634070.com/keweibo/articles/406146.html</link><dc:creator>Ke</dc:creator><author>Ke</author><pubDate>Fri, 08 Nov 2013 08:54:00 GMT</pubDate><guid>http://www.8634070.com/keweibo/articles/406146.html</guid><wfw:comment>http://www.8634070.com/keweibo/comments/406146.html</wfw:comment><comments>http://www.8634070.com/keweibo/articles/406146.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.8634070.com/keweibo/comments/commentRss/406146.html</wfw:commentRss><trackback:ping>http://www.8634070.com/keweibo/services/trackbacks/406146.html</trackback:ping><description><![CDATA[<br /><strong style="color: red;">鍗?#26473;?#37714;惰浆鍗?#37711;?#26473;?#37714;?/strong><br /><div>/****** Object: Function [dbo].[IntToHex]   Script Date: 2013-10-30 16:22:15 ******/</div><div>USE [ZBP];</div><div>GO</div><div>SET ANSI_NULLS OFF;</div><div>GO</div><div>SET QUOTED_IDENTIFIER ON;</div><div>GO</div><div>CREATE FUNCTION [dbo].[IntToHex]</div><div>(@IntNum bigint)</div><div>RETURNS varchar(16)</div><div>AS</div><div>BEGIN</div><div>declare @Mods bigint, @res varchar(16)</div><div>set @res=''</div><div>while @IntNum <> 0</div><div>begin</div><div><span style="white-space:pre"> </span>set @Mods = @IntNum % 16</div><div><span style="white-space:pre"> </span>if @Mods > 9</div><div><span style="white-space:pre"> </span>set @res = Char(Ascii('A')+@Mods-10)+@res</div><div><span style="white-space:pre"> </span>else</div><div><span style="white-space:pre"> </span>set @res = Cast(@Mods as varchar(4))+@res</div><div><span style="white-space:pre"> </span>set @IntNum = @IntNum/16</div><div>end</div><div>return @res</div><div></div><div>END</div><div>GO</div><div><span style="color: red;"><strong>鍗?#37711;?#26473;?#37714;惰浆鍗?#26473;?#37714;?/strong></span></div><div>/****** Object: Function [dbo].[HexToInt]   Script Date: 2013-10-30 16:22:04 ******/</div><div>USE [ZBP];</div><div>GO</div><div>SET ANSI_NULLS OFF;</div><div>GO</div><div>SET QUOTED_IDENTIFIER ON;</div><div>GO</div><div>CREATE FUNCTION [dbo].[HexToInt]</div><div>(@hex varchar(100))</div><div>RETURNS int</div><div>AS</div><div>BEGIN</div><div>Declare @result bigint,@iPos int,@iTmp bigint,@iLoop int,@tmp varchar(16)</div><div>    Set @tmp = '0123456789ABCDEF'</div><div>    Select @result = 0,@iPos = 0</div><div>    While @iPos <   Len(@hex)</div><div>    Begin</div><div>          Set  @iTmp = </div><div>               CharIndex(substring(@hex,Len(@hex) - @iPos,1),@tmp)-1</div><div>          Set @iLoop = 1</div><div>          While @iLoop <= @iPos and @iTmp > 0</div><div>          begin</div><div>              Set @iTmp = @iTmp * 16</div><div>              Set @iLoop = @iLoop + 1</div><div>          end</div><div>          Set @result = @result + @iTmp</div><div>          Set @iLoop = @iLoop + 1     </div><div>          Set @iPos = @iPos + 1</div><div>    End</div><div></div><div>    return @result</div><div>END</div><div>GO</div><div></div><img src ="http://www.8634070.com/keweibo/aggbug/406146.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.8634070.com/keweibo/" target="_blank">Ke</a> 2013-11-08 16:54 <a href="http://www.8634070.com/keweibo/articles/406146.html#Feedback" target="_blank" style="text-decoration:none;">鍙?#29723;?#29831;勮</a></div>]]></description></item><item><title>瀛樺偍杩?#32459;?#38315;?#35120;?#29835;冪敤鏃??#29238;鏍囩殑浣跨敤娉?#37808;忎簨椤?http://www.8634070.com/keweibo/articles/399268.htmlKeKeTue, 14 May 2013 09:17:00 GMThttp://www.8634070.com/keweibo/articles/399268.htmlhttp://www.8634070.com/keweibo/comments/399268.htmlhttp://www.8634070.com/keweibo/articles/399268.html#Feedback0http://www.8634070.com/keweibo/comments/commentRss/399268.htmlhttp://www.8634070.com/keweibo/services/trackbacks/399268.html娉剰锛?/span>蹇呴鎶婃父鏍囧?#29256;槑涓哄?#20788;?#27537;锛屽嵆鍔?#28051;local

CREATE PROCEDURE [dbo].[p_expand_k3_bom]
@p_itemID int, @p_levelID int
WITH EXEC AS CALLER
AS
declare @v_itemID int
declare @v_levelID int
declare @v_itemNO varchar(20)
declare @v_itemName varchar(200)
declare @v_itemModel varchar(200)
declare @v_note1 varchar(20)
declare cursor_bom CURSOR LOCAL FOR select b.FItemID,c.FShortNumber, c.FName, c.FModel,  b.FNote1
  from AIS20120110144135.dbo.ICBOM a, AIS20120110144135.dbo.ICBOMChild b, AIS20120110144135.dbo.t_ICItem c
  where a.FInterID = b.FInterID
  and b.FItemID = c.FItemID
  and a.FInterID = (select top 1 FInterID from AIS20120110144135.dbo.ICBOM where FItemID = @p_itemID)
  and a.FItemID = @p_itemID
set @v_levelID = @p_levelID+1
open cursor_bom 
fetch next from cursor_bom into @v_itemID, @v_itemNO, @v_itemName, @v_itemModel, @v_note1
while (@@FETCH_STATUS = 0)
  begin
    INSERT INTO k3_bom_info
      (level_id, item_id, item_no, item_name, item_model, note_1) 
    VALUES (@v_levelID, @v_itemID, @v_itemNO, @v_itemName, @v_itemModel, @v_note1)
    
    exec p_expand_k3_bom @v_itemID, @v_levelID
    
    fetch next from cursor_bom into @v_itemID, @v_itemNO, @v_itemName, @v_itemModel, @v_note1
  end
close cursor_bom
deallocate cursor_bom
GO


Ke 2013-05-14 17:17 鍙?#29723;?#29831;勮
]]>
Openbravo Developers_Guide Noteshttp://www.8634070.com/keweibo/articles/398701.htmlKeKeFri, 03 May 2013 01:23:00 GMThttp://www.8634070.com/keweibo/articles/398701.htmlhttp://www.8634070.com/keweibo/comments/398701.htmlhttp://www.8634070.com/keweibo/articles/398701.html#Feedback0http://www.8634070.com/keweibo/comments/commentRss/398701.htmlhttp://www.8634070.com/keweibo/services/trackbacks/398701.htmlHow to create a Table
http://wiki.openbravo.com/wiki/How_to_create_a_Table

The new table must include the AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated and UpdatedBy fields that are mandatory and required for security and auditory purposes of the application. 

Each table must have at least one column marked as an identifier. The actual values of identifier columns later get concatenated to be shown to the user as a representation of a particular record (see the link to the Sales Order within the Sales Invoice window). These identifiers will also be used to construct dropdown lists of records of that particular table. By default all columns with column name Name are set as an identifier. In case there is no column with this Name, no identifier is set and needs to be done so manually or compilation will fail. 

NOTE: The columns that are named line or seqNo are used to contain the sequence number of a record (i.e. the number of a line in an invoice). They take a default value like:

@SQL=SELECT COALESCE(MAX(ColumnName),0)+10 AS DefaultValue FROM TableName WHERE xxParentColumn=@xxParentColumn@

The WHERE part of this clause needs to be replaced with the required values. The code that should appear here is the name of the column which links with the id of the parent one. For example, each record of the C_InvoiceLine belongs to a particular C_Invoice record and they are all sequenced. C_Invoice is the parent table for the lines saved in C_InvoiceLine. This table has a column named line and the default value that it takes is:

@SQL=SELECT COALESCE(MAX(LINE),0)+10 AS DefaultValue FROM C_INVOICELINE WHERE C_INVOICE_ID=@C_INVOICE_ID@

How to add Columns to a Table

http://wiki.openbravo.com/wiki/How_to_add_Columns_to_a_Table


These changes can be done in two different locations:

  1. Add columns to the original module (dbprefix HT)
  2. Create a second module (dbprefix HT2) which adds the columns to the first module

The first option can be chosen if the original module author wants to add more columns to his/her module. The second option is possible for anyone as the columns are added by a new module to the existing one which is not changed directly.

The main difference between these two methods is the names which need to be chosen for the columns to comply with the modularity naming rules.

  1. Adding column to same module: Any valid column name can be picked
  2. Via second module: New column name must comply to the pattern EM_<DBPREFIX>_ where <DBPREFIX> must be the dbprefix if the new module contaning the column to be added. In this example: EM_HT2_

How to add a Constraint

http://wiki.openbravo.com/wiki/How_to_add_a_Constraint

In the Application Dictionary || Message window create a new record using the following details:

  • Module Openbravo Howtos 2 as this is the module containing the constraint also.
  • Search key: The search key must be exactly the same as the constraint's one, in this case em_ht2_ht_salary_dates_chk as this is the link between the constraint and the message.
  • Message type: Depending on the type the UI for the message box will be different (green for success, yellow for warning...), in our case we want a red error message box, so we select Error.
  • Message text: It is the user friendly message that will be displayed inside the message box. So let's enter: The Valid To date may not be before the Valid From date

 

 Creating a new instance of a Business Object

http://wiki.openbravo.com/wiki/How_to_work_with_the_Data_Access_Layer#A_.27Hello_World.27_Example

A business object may never be created using the Java new operator. All business objects should be created using the OBProvider factory class:

   // create the object through the factory   final Category bpg = OBProvider.getInstance().get(Category.class);

Hibernate will detect that a business object is new when:

  • the id of the business object is not set
  • when the flag newOBObject is set to true explicitly

So if you want to create a new business object with a specific id (by calling setId(...)) then you explicitly need to call businessObject.setNewOBObject(true). Otherwise, Hibernate will throw an exception ('count of batch update operation....'). 




Ke 2013-05-03 09:23 鍙?#29723;?#29831;勮
]]>
redhat 9.0,鎻?#32448;Determining IP information for eth0... failed; no link present. Check cable?http://www.8634070.com/keweibo/articles/398679.htmlKeKeThu, 02 May 2013 08:27:00 GMThttp://www.8634070.com/keweibo/articles/398679.htmlhttp://www.8634070.com/keweibo/comments/398679.htmlhttp://www.8634070.com/keweibo/articles/398679.html#Feedback0http://www.8634070.com/keweibo/comments/commentRss/398679.htmlhttp://www.8634070.com/keweibo/services/trackbacks/398679.htmlredhat 9.0,鎻?#32448;Determining IP information for eth0... failed; no link present. Check cable?鏃犳硶婵?#26943;缃?#32513;?#29825;?#28598;噀th0
鎴戞?#28357;殑鐩?#37711;?#29785;?#37712;?#37826;规涓?#38171;?nbsp;
鍒?etc/sysconfig/network-scripts/ifcfg-eth 
/etc/sysconfig/networking/devices/ifcfg-eth 鍏?#28051;?n>琛?#32448;Ethernet adapter?#27537;鏍?#29831;?#37825;板瓧锛?#28051;鑸?#28051;?銆?#35120;?#28051;?#38342;剁殑鏃跺?#38171;?#28751;辨槸 
/etc/sysconfig/network-scripts/ifcfg-eth0 
/etc/sysconfig/networking/devices/ifcfg-eth0 杩?#28051;?#28051;?#37826;?#28000;?#28051;?#37716;?#37711;?nbsp;

check_link_down () { 
return 1; 


Ke 2013-05-02 16:27 鍙?#29723;?#29831;勮
]]>
鍏?#28003;?#37714;嗘瀽tftp server閰嶇疆?#27537;姝?#26976;??#27974;)http://www.8634070.com/keweibo/articles/398387.htmlKeKeThu, 25 Apr 2013 06:57:00 GMThttp://www.8634070.com/keweibo/articles/398387.htmlhttp://www.8634070.com/keweibo/comments/398387.htmlhttp://www.8634070.com/keweibo/articles/398387.html#Feedback0http://www.8634070.com/keweibo/comments/commentRss/398387.htmlhttp://www.8634070.com/keweibo/services/trackbacks/398387.html?#27974;鑷?#38171;?a href="http://network.51cto.com/art/201009/225534.htm">http://network.51cto.com/art/201009/225534.htm

鍦Linux绯?#32513;?#28051;?#38171;?#37812;?#28000;?#28186;?#37906;?#37721;互杩?#29723;?a href="http://network.51cto.com/art/201009/225533.htm" style="color: #004276;">tftp server閰嶇疆?#27537;鎿?#28003;?#37510;?#37721;?#38003;藉浜庣?#29112;倝绐?#37721;?#37823;?#28003;滅殑鏈嬪弸锛屽浜庡懡浠?#37823;?#28003;?#37832;変簺涓嶇?#29112;倝锛屾病鍏?#32495;?#26473;?#38322;?#37812;?#28000;?#28751;辨潵璁?#29785;?#28051;涓婰inux 涓嬬殑tftp-server閰嶇疆?#27537;?#25057;浠?#37823;?#28003;?#37510;俆FTP?#27128;?#25956;鏉?#28051;?#26462;?#26473;滅鏂?#28000;剁殑鏈绠?#23839;缃?#32513;?#37719;?#29825;?瀹?#37711;朵簬UDP鍗?#29825;?#38000;?#28729;?#37916;?宓?#37711;紡linux?#27537;tftp寮鍙?#37916;?#28583;?#37718;?#37815;?#28051;?#28051;?#37826;?#38344;?

涓?#27128;linux鏈?#37716;?#37731;?#32468;殑tftp-server鏀?#37816;?

浜屾槸宓?#37711;紡鐩?#37837;?#32495;?#32513;熺殑tftp-client鏀?#37816;?

鍥?#28051;u-boot鏈韩鍐呯疆鏀?#37816;tftp-client,鎵?#20114;宓?#37711;紡鐩?#37837;?#32495;?#32513;熺灏?#28051;嶇敤閰嶇疆?#31777;.

涓?#38344;?#28751;?#29831;?#32513;?#28000;?#32513;?#28051;涓媗inux鏈?#37716;?#37731;?#32468;tftp server閰嶇疆.鍦redhat 9.0?#27537;绗?#28051;?#23534;?#37711;?#37929;?#28051;?鏈塼ftp-server?#27537;瀹夎?#21369;pm鍖?锛?锛?nbsp;      瀹夎

#mount –t iso9660 /dev/hdc /mnt/cdrom    //鎸?#26462;?#37711;?#37929;?/p>

#rpm -ivh tftp-server-0.32-4.i386.rpm              //瀹夎

#umount /mnt/cdrom                                          //鍗?#26462;?#37711;?#37929;?/p>

锛?锛変慨鏀?#37826;?#28000;?#37734;linux涓?涓嶇浣跨敤?#27537;?#27128;?#25698;涓绉峴uper-server,inetd鎴栬厁inetd,?#31919;璁?#37807;?#37712;?#28051;婽FTP鏈?#37716;槸佺敤?#27537;,鎵?#20114;瑕佷慨鏀?#37826;?#28000;舵潵寮?#24782;鏈?#37716;?

鏍规嵁锛?锛夌殑瀹夎鏂规硶,鍙互?#24936;鏀?#37826;?#28000;?etc/xinetd.d/tftp.涓?#29781;佹槸璁剧疆TFTP鏈?#37716;?#37731;殑鏍?#37929;綍,寮?#24782;鏈?#37716;?

?#24936;鏀瑰悗?#27537;鏂?#28000;跺涓?

service tftp {

socket_type            =dgram

protocol                  =udp

wait                        =yes

user                        =root

server                     =/usr/sbin/in.tftpd

server_args             =-s /home/app -c

disable                    =no

per_source             =11

cps                         =100 2

flags                       =IPv4

}

璇存槑:?#24936;鏀?#26916;箂erver_args= -s     <path>    -c,鍏?#28051;?lt;path>澶?#37721;互鏀?#28051;?#28003;犵殑tftp server閰嶇疆?#27537;鏍?#37929;綍,鍙?#37825;?s?#23514;瀹chroot,-c?#23514;瀹氫簡鍙互鍒涘缓鏂?#28000;?

锛?锛?#37714;涘缓tftp鏍?#37929;綍,鍏?#38338;?#38339;茬伀澧??#24782;鍔tftp-server.

#mkdir /home/app

#chmod o+w       /home/app

#/etc/init.d/iptables stop        //鍏?#38338;?#38339;茬伀澧?/p>

#service xinetd restart          //閲嶅惎 xinetd 鏈?#37716;?/p>

閲嶅惎xinetd鏈?#37716;?鍥?#28051;TFTP鏈?#37716;?#37721;楁帶涓巟inetd, xinetd?#27128;绠?#37832;?#37716;殑鏈?#37716;?瀹冩槸涓嶅紑绔?#37721;殑.

楠岃瘉涓涓婽FTP?#27128;鍚?#29863;锋潵?#31777;:

# netstat -nlp

Active Internet connections (only servers)

Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name

tcp 0 0 0.0.0.0:32768 0.0.0.0:* LISTEN 3122/rpc.statd

tcp 0 0 127.0.0.1:32781 0.0.0.0:* LISTEN 4035/xinetd

tcp 0 0 0.0.0.0:111 0.0.0.0:* LISTEN 3103/portmap

tcp 0 0 0.0.0.0:80 0.0.0.0:* LISTEN 3324/httpd

tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 3255/sshd

tcp 0 0 127.0.0.1:631 0.0.0.0:* LISTEN 3213/cupsd

tcp 0 0 127.0.0.1:25 0.0.0.0:* LISTEN 3295/sendmail: acce

tcp 0 0 127.0.0.1:6010 0.0.0.0:* LISTEN 3415/0

tcp 0 0 0.0.0.0:443 0.0.0.0:* LISTEN 3324/httpd

udp 0 0 0.0.0.0:32768 0.0.0.0:* 3122/rpc.statd

udp 0 0 0.0.0.0:69 0.0.0.0:* 4035/xinetd   ;

鍙互鐪嬪埌69绔?#37721;?#23480;茬粡鎵?#23534;

udp 0 0 0.0.0.0:69 0.0.0.0:* 4012/in.tftpd

udp 0 0 0.0.0.0:111 0.0.0.0:* 3103/portmap

udp 0 0 0.0.0.0:754 0.0.0.0:* 3122/rpc.statd

udp 0 0 0.0.0.0:631 0.0.0.0:* 3213/cupsd

杩?#37837;?tftp server閰嶇疆?#27537;?#24782;鍔?#23005;?#26976;?#28751;?#28729;?#37812;愪簡銆?/p>

浣?#37721;互?#27365;闄嗘湰鏈?#23092;?#29831;曚互涓??#25057;浠?#28641;?#28051;?

#tftp     your-ip-address

tftp>get <download file>

tftp>put <upload file>

tftp>q



Ke 2013-04-25 14:57 鍙?#29723;?#29831;勮
]]>
VC锛歯afxcwd.lib(dllmodul.obj) : error LNK2005: _DllMain@12..."閿?#29831;? 锛堣浆锛?/title><link>http://www.8634070.com/keweibo/articles/396482.html</link><dc:creator>Ke</dc:creator><author>Ke</author><pubDate>Fri, 15 Mar 2013 07:04:00 GMT</pubDate><guid>http://www.8634070.com/keweibo/articles/396482.html</guid><wfw:comment>http://www.8634070.com/keweibo/comments/396482.html</wfw:comment><comments>http://www.8634070.com/keweibo/articles/396482.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.8634070.com/keweibo/comments/commentRss/396482.html</wfw:commentRss><trackback:ping>http://www.8634070.com/keweibo/services/trackbacks/396482.html</trackback:ping><description><![CDATA[<div>鏈嬪?#23340;紪鍐?#28051;涓猟ll,?#32042;璇?#37827;舵?#37713;?#37916;?/div> <div>"nafxcwd.lib(dllmodul.obj) : error LNK2005: _DllMain@12..."閿?#29831;?</div> <div>?#24727;鍙?#37916;版槸,<span style="color: red"><strong>鍏?#37714;涘缓dll鏃堕夋嫨?#27537;鏃?#28051;?#28003;跨敤MFC,鑰屽悗鏉?#23480;?#32459;?#28051;?#37721;堟坊鍔犱簡涓嶮FC鐩?#37711;崇殑涓滆</strong></span>.鎵嶅紩璧?#28051;?#26473;?#38338;?#26864;?</div> <div>閲囩敤濡?#28051;嬫楠?#29785;?#37712;?#23005;?#38338;?#26864;?</div> <div>1.灏?#23480;?#32459;?#29825;剧疆涓?#37824;?#28051;?鍔?#37804;?#28003;跨敤MFC"</div> <div>2.<strong>鍒癈++璁剧疆椤?#28051;?鐪嬪埌Preprocessor Definitions缂栬緫妗?#28051;?#37722;?#37827;跺瓨鍦_USRDLL鍜宊AFXDLL, 鍒?#38340;_USRDLL鍗?#37721;?/strong>.<br /><br />?#27974;鑷?#38171;?a href="http://blog.csdn.net/train_z/article/details/3118754">http://blog.csdn.net/train_z/article/details/3118754</a><br /><br />纭?#29825;?#29785;?#37712;充簡闂?#26864;?#38171;屼?#21976;楠?锛?#37812;?#28003;跨敤?#27537;?#27128;“闈?#37804;丮FC”</div><img src ="http://www.8634070.com/keweibo/aggbug/396482.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.8634070.com/keweibo/" target="_blank">Ke</a> 2013-03-15 15:04 <a href="http://www.8634070.com/keweibo/articles/396482.html#Feedback" target="_blank" style="text-decoration:none;">鍙?#29723;?#29831;勮</a></div>]]></description></item><item><title>VC: 鈥淟oadLibraryW鈥? 涓嶈兘灏?#37721;?#37825;?1 浠?#37413;渃onst char *鈥濊浆鎹?#28051;?#37413;淟PCWSTR鈥?/title><link>http://www.8634070.com/keweibo/articles/396408.html</link><dc:creator>Ke</dc:creator><author>Ke</author><pubDate>Wed, 13 Mar 2013 10:59:00 GMT</pubDate><guid>http://www.8634070.com/keweibo/articles/396408.html</guid><wfw:comment>http://www.8634070.com/keweibo/comments/396408.html</wfw:comment><comments>http://www.8634070.com/keweibo/articles/396408.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.8634070.com/keweibo/comments/commentRss/396408.html</wfw:commentRss><trackback:ping>http://www.8634070.com/keweibo/services/trackbacks/396408.html</trackback:ping><description><![CDATA[<p>鍔?#37804;佽?#20906;敤DLL<br />閫?#26473;?br />LoadLibrary<br />GetProcAddress<br />FreeLibrary瀹?#37916;?#37510;?/p> <p>鍘熷洜 锛氬伐绋嬪彧鏀?#37816;UNICODE瀛楃</p> <p>瑙?#37712;?#37826;规硶锛?/p> <p><strong style="color: red">宸?#32459;嬪?#28852;?>閰嶇疆灞炴?#8211;>?#29238;瑙?#8212;>瀛楃闆?#8212;->浣跨敤澶氬?#26948;?#20636;瀛楃闆?/strong></p> <p> </p><img src ="http://www.8634070.com/keweibo/aggbug/396408.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.8634070.com/keweibo/" target="_blank">Ke</a> 2013-03-13 18:59 <a href="http://www.8634070.com/keweibo/articles/396408.html#Feedback" target="_blank" style="text-decoration:none;">鍙?#29723;?#29831;勮</a></div>]]></description></item><item><title>c++璋冪敤c#?#27537;dll锛堣浆锛?http://www.8634070.com/keweibo/articles/396322.htmlKeKeTue, 12 Mar 2013 07:13:00 GMThttp://www.8634070.com/keweibo/articles/396322.htmlhttp://www.8634070.com/keweibo/comments/396322.htmlhttp://www.8634070.com/keweibo/articles/396322.html#Feedback0http://www.8634070.com/keweibo/comments/commentRss/396322.htmlhttp://www.8634070.com/keweibo/services/trackbacks/396322.html涓銆?#28003;跨敤/clr?#32042;璇MFC鍙墽琛?#37826;?#28000;?#37812;?#29785;?#37714;C# DLL?#22193;鏁?
    1銆佹墦寮“椤?#37929;?#28766;炴?#8221;瀵?#29831;?#22935;?#38171;?#37826;规硶?#27128;鍙抽敭?#23839;鍑?#8220;瑙?#37712;?#37826;规?#22563;?#21228;簮绠悊鍣?#8221;涓殑椤?#37929;?#39582;堕夋嫨“灞炴?#8221;銆?br />    2銆佸?#26334;紑“閰嶇疆灞炴?#8221;鏃佽竟鐨勮?#20636;偣骞堕夋嫨“?#29238;瑙?#8221;銆?#37734;?#37721;?#28186;?#32464;?#37837;?#28051;殑“椤?#37929;粯璁?#37706;?#8221;涓?#38171;?#28751;?#8220;鍏?#37711;?#29831;言杩?#29723;屽簱鏀?#37816;?#8221;璁剧疆涓?strong>“鍏?#37711;?#29831;言杩?#29723;屽簱鏀?#37816;?#38171;?clr锛?#8221;銆?br />
    3銆?#37734;?#37929;?#37722;岀殑绐?#37837;?#28051;?#38171;岀淇?#28751;?#8220;MFC?#27537;浣跨敤”璁剧疆涓?#8220;鍦?#37711;变韩DLL涓?#28003;跨敤MFC”銆?br />    4銆?#37734;?#8220;閰嶇疆灞炴?#8221;涓?#38171;屽?#26334;紑“C/C++”鏃佽竟鐨勮?#20636;偣骞堕夋嫨“?#29238;瑙?#8221;銆?#29831;风淇?#28751;?#8220;璋?#29831;?#28103;伅鏍煎紡”璁剧疆涓?#8220;绋嬪簭鏁版嵁搴?Zi”锛堣?#28051;嶆槸“/ZI”锛?#37510;?br />    5銆?#37734;?#8220;閰嶇疆灞炴?#8221;涓?#38171;?#38315;夋嫨“C/C++”锛?#37906;跺悗閫夋嫨“浠?#37934;佺敓鎴?#8221;銆?#29831;风淇?#28751;?#8220;杩?#29723;?#37827;跺簱”璁剧疆涓?#8220;澶?#32510;跨?#23341;皟璇旸LL锛?MDd锛?#8221;鎴?#8220;澶?#32510;跨?#23142;LL锛?MD锛?#8221;涔?#28051;銆?br />浜?#37510;?#37734;?#28000;?#37934;佸紩?#25956;?#28214;瑕佺殑dll.
 using <mscorlib.dll>. 
 using "DownloaFiles.dll"   //鎹?#37812;愰渶瑕佺殑dll鏂?#28000;?#37510;?/strong> 
 using namespace System锛?
 using namespace ADMessage_test锛?nbsp; //鎹?#37812;dll涓被鎵浣跨敤?#27537;namespace.
涓?#37510;?#37734;C# DLL?#22193;鏁拌?#20906;敤浠?#37934;佸墠鍔?#37711;?pragma managed
    杩欐槸manage鍜寀nmanage娣?#37722;堢紪绋?#37734;MFC涓嬬殑涓绉?#28729;?#37916;?#37826;瑰紡銆?br />    ?#20114;涓?#28000;?#32513;C++璋冪敤C# DLL?#22193;鏁?#38171;屽笇鏈涘浣?#37832;夋墍甯?#37716;?#37510;?/p>

鍥?銆佸?#29365;偣瑕佽浣?#38171;?/p>

銆銆1 浣跨敤#using寮曠敤C# DLL锛岃?#28051;嶆槸#include.鎴?#28751;辨槸?#20802;褰?#37906;剁殑浣跨敤?#31777;?#24727;鑰?#38171;屾墍?#20114;娴?#29840;逛簡涓涓?#37719;堢殑鏃堕棿锛?/p>

銆銆2 鍒?#36423;樹簡using namespace CSLib锛?/p>

銆銆3 浣跨敤C++/clr璇硶锛?#38322;囩敤姝?#32429;?#37928;勮闂?#37813;?#32480;?#28725;硅薄锛屽嵆锛?#28003;跨敤甯藉瓙‘^’锛岃?#28051;嶆槸鏄熸槦‘*’銆?br />

PS锛氶檮涓?#38007;?#23480;?#37812;?#37716;?#26473;?#29723;孋++浠爜

#include "stdafx.h"
#include <iostream>
//#using "..\..\SFCSDLL.dll" //鍙?#37713;?#26916;?#37929;?->寮曠敤...锛屾坊鍔?#37826;?#23534;曠敤锛?#28751;DLL?#22346;鍔?#37714;?#26916;?#37929;?#28051;?#38171;?#37721;互涓嶇敤姝?#29723;屼唬?#29212;

using namespace std;
using namespace SFCSDLL;

int _tmain(int argc, _TCHAR* argv[])
{
 Class1 ^c = gcnew Class1();

 c->SFCSDLL_Create_Connection("127.0.0.1", 0, 0, 0, 0);
 c->SFCSDLL_Get_DLLVersion();
 c->SFCSDLL_Close_Connection();

 cout<<"end...";
 system("pause");
 return 0;
}

 



Ke 2013-03-12 15:13 鍙?#29723;?#29831;勮
]]>
javascript 璁畻鏃?#37832;?#37929;?#23480;殑澶?#37825;?/title><link>http://www.8634070.com/keweibo/articles/395722.html</link><dc:creator>Ke</dc:creator><author>Ke</author><pubDate>Tue, 26 Feb 2013 02:00:00 GMT</pubDate><guid>http://www.8634070.com/keweibo/articles/395722.html</guid><wfw:comment>http://www.8634070.com/keweibo/comments/395722.html</wfw:comment><comments>http://www.8634070.com/keweibo/articles/395722.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.8634070.com/keweibo/comments/commentRss/395722.html</wfw:commentRss><trackback:ping>http://www.8634070.com/keweibo/services/trackbacks/395722.html</trackback:ping><description><![CDATA[<font face="Verdana"><html><br /> <head><br />  <script type="text/javascript"><br />   function moreThanOneMonth(dt)<br />   {<br />    var s1=new Date(dt.replace(/-/g, "/")); //鏃?#37832;?#37837;煎紡涓簓yyy-mm-dd?#27974;鎹?#37812;恲yyy/mm/dd<br />    var s2=new Date();<br />    var time= s2.getTime() - s1.getTime(); <br />    var days = parseInt(time / (1000 * 60 * 60 * 24));<br />    if(days > 30)<br />     return true;<br />    else<br />     return false;<br />   }<br />   function load(dt)<br />   {<br />    if( checkDate(dt) )<br />    {<br />     alert("days > 30");<br />    }<br />    else<br />    {<br />     alert("days < 30");<br />    }<br />   }<br />  </script><br /> </head><br /> <body onLoad="load('2013-01-01')"><br /> </body><br /></html></font><img src ="http://www.8634070.com/keweibo/aggbug/395722.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.8634070.com/keweibo/" target="_blank">Ke</a> 2013-02-26 10:00 <a href="http://www.8634070.com/keweibo/articles/395722.html#Feedback" target="_blank" style="text-decoration:none;">鍙?#29723;?#29831;勮</a></div>]]></description></item><item><title>C# DataGridView鏄剧琛?#37721;风殑鏂规硶http://www.8634070.com/keweibo/articles/392802.htmlKeKeTue, 11 Dec 2012 06:54:00 GMThttp://www.8634070.com/keweibo/articles/392802.htmlhttp://www.8634070.com/keweibo/comments/392802.htmlhttp://www.8634070.com/keweibo/articles/392802.html#Feedback1http://www.8634070.com/keweibo/comments/commentRss/392802.htmlhttp://www.8634070.com/keweibo/services/trackbacks/392802.html

缃?#28051;?#37832;?#29238;瑙佺殑鍋氭硶?#27128;?#25956;DataGridView?#27537;RowPostPaint浜?#28000;?#37734;?/span>RowHeaderCell涓粯鍒?#29723;?#37721;?#38171;?/span>

privatevoiddataGridView1_RowPostPaint(objectsender, DataGridViewRowPostPaintEventArgs e)
         {
            
try
             {

       e.Graphics.DrawString((e.RowIndex + 1).ToString(), e.InheritedRowStyle.Font, new SolidBrush(Color.CadetBlue), e.RowBounds.Location.X + 15, e.RowBounds.Location.Y + 5);
             
}
            
catch(Exception ex)
             {
                 MessageBox.Show(
"?#22346;鍔?#29723;?#37721;?#37827;?#37721;?#37922;?#38335;?#29831;?#38171;岄敊璇?#28103;伅锛?/span>"+ex.Message, "鎿?#28003;?#28598;辫触");
             }
         }

浣嗘槸杩欑鏂规硶鍦?#28598;?#37825;版嵁閲忕殑鏃跺?#37804;?#38003;芥瘮杈?#23480;?#38171;屾?#24532;婊?#37716;?#37825;版嵁?#20824;?#32048;瑙?#37721;?/span>RowPostPaint浜?#28000;?#37510;?/span>



Ke 2012-12-11 14:54 鍙?#29723;?#29831;勮
]]>
VS2008 鑷?#37716;?#37922;?#37812;愬?#28852;殑get銆乻et http://www.8634070.com/keweibo/articles/391417.htmlKeKeFri, 16 Nov 2012 01:34:00 GMThttp://www.8634070.com/keweibo/articles/391417.htmlhttp://www.8634070.com/keweibo/comments/391417.htmlhttp://www.8634070.com/keweibo/articles/391417.html#Feedback0http://www.8634070.com/keweibo/comments/commentRss/391417.htmlhttp://www.8634070.com/keweibo/services/trackbacks/391417.html

鍦VS2008閲?#38171;屼篃鍙互鍍Eclipse?#20549;鏍?#38007;?#37716;?#37922;?#37812;get 銆乻et鏂规硶銆?br />
涓?#38344;槸涓?#28051;?#37711;?#28003;撴搷浣滅殑鏂规硶锛?br />

1銆?#37734;紪鍐欑殑瀛?#23048;?#28051;婂崟鍑?#37721;抽敭----->閲?#37835;?------>灏佽?#21613;瓧娈?br />

2銆?#37734;?#32460;虹櫧琛?#28598;?#38171;岃緭鍏?#8220;prop”鍐嶆寜Tab?#25965;



Ke 2012-11-16 09:34 鍙?#29723;?#29831;勮
]]>
濡備綍鏌?#37930;SQL SERVER琛?#28051;佺殑鐗?#37832;?/title><link>http://www.8634070.com/keweibo/articles/391210.html</link><dc:creator>Ke</dc:creator><author>Ke</author><pubDate>Mon, 12 Nov 2012 08:19:00 GMT</pubDate><guid>http://www.8634070.com/keweibo/articles/391210.html</guid><wfw:comment>http://www.8634070.com/keweibo/comments/391210.html</wfw:comment><comments>http://www.8634070.com/keweibo/articles/391210.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.8634070.com/keweibo/comments/commentRss/391210.html</wfw:commentRss><trackback:ping>http://www.8634070.com/keweibo/services/trackbacks/391210.html</trackback:ping><description><![CDATA[<p>鍘?#37826;?#38171;?a href="http://hi.baidu.com/einsteinalbert/item/b0366529705c5cfb51fd87ee">http://hi.baidu.com/einsteinalbert/item/b0366529705c5cfb51fd87ee</a><br /><br />鏈?#28051;?#32457;?#37826;规硶锛?br /><br /><strong>绗?#28051;姝?#38171;?#28003;跨敤SQL璇?#37721;?#37836;?#29831;?/strong><br /><br />select @@version<br /><br />鏌?#29831;?#32513;?#37835;?#28641;?#28051;?#38171;?/p> <p>Microsoft SQL Server   2000 - 8.00.2039 (Intel X86) <br />   May   3 2005 23:18:38 <br />   Copyright (c) 1988-2003 Microsoft Corporation<br />   Personal Edition on Windows NT 5.1 (Build 2600: Service Pack 2)</p><br />鍏?#28729;?#37734;C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlservr.exe<br />?#20579;鍑婚紶鏍?#37721;抽敭鏌?#37930;?#37911;?#37832;?#28052;?#38003;?#23536;?#37714;?#38171;?#28051;?#26473;囦俊?#20229;?#30254;杈冪畝?#23839;鑰?#23480;?#37510;?.00.2039灏?#28000;?#29723;?#28729;夎?#21615;殑SQL Server?#27537;鐗?#37832;簡銆傚?#29808;簲?#20114;涓嬬殑琛?#37837;?#38171;?#37721;互鏌?#37713;烘潵鍏?#28003;撳?#29808;簲?#27537;琛?#28051;佺増鏈?#37510;?strong style="color: #ff0000">8.00.2039琛?#32448;?#28729;夎?#21612;簡SP4锛?.00.760琛?#32448;?#28729;夎?#21612;簡SP3</strong>銆?br /><br /><strong>绗?#27996;屾锛氬?#22317;収琛?#37837;?#37836;?#37813;?#37711;?#28003;撶殑琛?#28051;佺増鏈?/strong><br /><br /><strong>SQL Server Versions</strong><br /><br />@Version SQL Server Version Released <br /><br />6.50.201 SQL Server 6.5 RTM <br />6.50.213 SQL Server 6.5 with Service Pack 1 <br />6.50.240 SQL Server 6.5 with Service Pack 2 <br />6.50.258 SQL Server 6.5 with Service Pack 3 <br />6.50.281 SQL Server 6.5 with Service Pack 4 <br />6.50.415 SQL Server 6.5 with Service Pack 5 <br />6.50.416 SQL Server 6.5 with Service Pack 5a <br />7.00.623 SQL Server 7.0 / MSDE 1.0 RTM <br />7.00.699 SQL Server 7.0 SP1 July 1999 <br />7.00.842 SQL Server 7.0 SP2 March 20th, 2000 <br />7.00.961 SQL Server 7.0 SP3 December 15th, 2000 <br />7.00.1063 SQL Server 7.0 SP4 <br />8.00.194 SQL Server 2000 RTM <br />8.00.384 SQL Server 2000 SP1 <br />8.00.534 SQL Server 2000 SP2 November 30th, 2001 <br /><strong style="color: #ff0000">8.00.760 SQL Server 2000 SP3 <br />8.00.2039 SQL Server 2000 SP4</strong><strong><br /></strong><br />鏇村?#27697;殑鐗?#37832;?#28725;圭収琛?#38171;?br /><br /><strong>For SQL Server 8</strong><br /><br />Main Releases <br />@@version Version and Service Pack <br />8.00.2039 Service Pack 4<br />8.00.760 Service Pack 3 <br />8.00.534 Service Pack 2 <br />8.00.384 Service Pack 1 <br />8.00.194 RTM <br /><br />All Releases <br />@@version Version and Service Pack <br />8.00.2039 Service Pack 4<br />8.00.760 Service Pack 3 <br />8.00.686 SP 2 + Q316333 <br />8.00.679 SP 2 + Q316333 <br />8.00.665 SP 2 + Q316333 <br />8.00.655 SP 2 + Q316333 <br />8.00.650 SP 2 + Q316333 <br />8.00.644 SP 2 + Q324186 <br />8.00.608 SP 2 + Q316333/Q356326/Q356938 <br />8.00.578 SP 2 + Q316333 <br />8.00.534 Service Pack 2 <br />8.00.532 Service Pack 2 Beta <br />8.00.452 SP 1 + Q308547 <br />8.00.444 SP 1 + Q308547/Q307655 <br />8.00.443 SP 1 + Q307538 <br />8.00.428 SP 1 + Q304850 <br />8.00.384 Service Pack 1 <br />8.00.287 Q297209 <br />8.00.251 Q300194 <br />8.00.250 Q291683 <br />8.00.249 Q288122 <br />8.00.239 Q285290 <br />8.00.233 Q282416 <br />8.00.231 Q282279 <br />8.00.226 Q278239 <br />8.00.225 Q281663 <br />8.00.223 Q280380 <br />8.00.222 Q281769 <br />8.00.218 Q279183 <br />8.00.217 Q279293/Q279296 <br />8.00.211 Q276329 <br />8.00.210 Q275900 <br />8.00.205 Q274330 <br />8.00.204 Q274329 <br />8.00.194 RTM(SQL Server 8 with no service pack applied)<br /><br /><strong>For SQL Server 7</strong><br /><br />Main Releases<br />@@version Version and Service Pack <br />7.00.1063 SQL Server 7 with Service Pack 4 <br />7.00.961 SQL Server 7 with Service Pack 3 <br />7.00.842 SQL Server 7 with Service Pack 2 <br />7.00.699 SQL Server 7 with Service Pack 1 <br />7.00.623 SQL Server 7 with no service pack applied <br /><br /><strong>For SQL Server 6.5</strong><br /><br />Main Releases<br />@@version Version and Service Pack <br />6.50.479 SQL Server 6.5 with Service Pack 5a (updated) <br />6.50.416 SQL Server 6.5 with Service Pack 5a. <br />6.50.415 SQL Server 6.5 with Service Pack 5 <br />6.50.281 SQL Server 6.5 with Service Pack 4 <br />6.50.258 SQL Server 6.5 with Service Pack 3 <br />6.50.240 SQL Server 6.5 with Service Pack 2 <br />6.50.213 SQL Server 6.5 with Service Pack 1 <br />6.50.201 SQL Server 6.5 with no service pack applied <br /><br /><strong>For SQL Server 6</strong><br /><br />Main Releases<br />@@version Version and Service Pack <br />6.00.151 SQL Server 6 with Service Pack 3 <br />6.00.139 SQL Server 6 with Service Pack 2 <br />6.00.124 SQL Server 6 with Service Pack 1 <br />6.00.121 SQL Server 6 with no service pack applied <br /><br /><strong>琛?#37711;?/strong><br />For SQL Server 2005<br />鎵撲簡sp3?#24727;鐗?#37832;?#37721;锋槸 <strong>9.0.4035</strong>濡?#37835;滄槸杩?#28051;?#37827;?#29831;存槑涓嶇敤鎵撲簡锛屽鏋滄瘮杩?#28051;?#28003;?#38171;岃?#23384;槑娌?#37832;夋墦<img src ="http://www.8634070.com/keweibo/aggbug/391210.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.8634070.com/keweibo/" target="_blank">Ke</a> 2012-11-12 16:19 <a href="http://www.8634070.com/keweibo/articles/391210.html#Feedback" target="_blank" style="text-decoration:none;">鍙?#29723;?#29831;勮</a></div>]]></description></item></channel></rss> <a href="http://www.8634070.com/"><span class="STYLE1">˫ɫֱ</span></a> <div style="position:fixed;left:-9000px;top:-9000px;"><nobr id="k0jz6"><delect id="k0jz6"><pre id="k0jz6"><sub id="k0jz6"></sub></pre></delect></nobr><sup id="k0jz6"><meter id="k0jz6"><small id="k0jz6"><rp id="k0jz6"></rp></small></meter></sup><pre id="k0jz6"></pre><video id="k0jz6"></video><ruby id="k0jz6"></ruby><progress id="k0jz6"><ins id="k0jz6"><rt id="k0jz6"></rt></ins></progress><video id="k0jz6"></video><sup id="k0jz6"></sup><noscript id="k0jz6"></noscript><em id="k0jz6"><meter id="k0jz6"></meter></em><tt id="k0jz6"><dfn id="k0jz6"></dfn></tt><ruby id="k0jz6"></ruby><i id="k0jz6"><xmp id="k0jz6"><div id="k0jz6"><tr id="k0jz6"></tr></div></xmp></i><strike id="k0jz6"></strike><sup id="k0jz6"><menu id="k0jz6"><small id="k0jz6"></small></menu></sup><small id="k0jz6"><wbr id="k0jz6"><noframes id="k0jz6"></noframes></wbr></small><tr id="k0jz6"></tr><em id="k0jz6"><ol id="k0jz6"></ol></em><noscript id="k0jz6"><output id="k0jz6"></output></noscript><acronym id="k0jz6"></acronym><div id="k0jz6"><ol id="k0jz6"><mark id="k0jz6"><sub id="k0jz6"></sub></mark></ol></div><option id="k0jz6"><delect id="k0jz6"></delect></option><tr id="k0jz6"><object id="k0jz6"><code id="k0jz6"><track id="k0jz6"></track></code></object></tr><menu id="k0jz6"><small id="k0jz6"><rp id="k0jz6"></rp></small></menu><rp id="k0jz6"><b id="k0jz6"></b></rp><pre id="k0jz6"></pre><div id="k0jz6"><ol id="k0jz6"><object id="k0jz6"><sub id="k0jz6"></sub></object></ol></div><pre id="k0jz6"></pre><sup id="k0jz6"><menu id="k0jz6"><small id="k0jz6"><wbr id="k0jz6"></wbr></small></menu></sup><noframes id="k0jz6"></noframes><rt id="k0jz6"><tt id="k0jz6"><xmp id="k0jz6"></xmp></tt></rt><menuitem id="k0jz6"><meter id="k0jz6"></meter></menuitem><delect id="k0jz6"><meter id="k0jz6"></meter></delect><font id="k0jz6"><nobr id="k0jz6"><em id="k0jz6"><tr id="k0jz6"></tr></em></nobr></font><noframes id="k0jz6"><sup id="k0jz6"><menu id="k0jz6"><small id="k0jz6"></small></menu></sup></noframes><option id="k0jz6"><menuitem id="k0jz6"><meter id="k0jz6"><video id="k0jz6"></video></meter></menuitem></option><pre id="k0jz6"><cite id="k0jz6"><listing id="k0jz6"></listing></cite></pre><noframes id="k0jz6"></noframes><cite id="k0jz6"><center id="k0jz6"></center></cite><optgroup id="k0jz6"></optgroup><pre id="k0jz6"><code id="k0jz6"><listing id="k0jz6"><option id="k0jz6"></option></listing></code></pre><sup id="k0jz6"><menu id="k0jz6"><form id="k0jz6"></form></menu></sup><nobr id="k0jz6"><em id="k0jz6"><menu id="k0jz6"><thead id="k0jz6"></thead></menu></em></nobr><em id="k0jz6"></em><pre id="k0jz6"></pre><div id="k0jz6"><ruby id="k0jz6"><rp id="k0jz6"><strike id="k0jz6"></strike></rp></ruby></div><ruby id="k0jz6"></ruby><listing id="k0jz6"></listing><em id="k0jz6"></em><tr id="k0jz6"></tr> <rp id="k0jz6"></rp><video id="k0jz6"></video><acronym id="k0jz6"><del id="k0jz6"></del></acronym><del id="k0jz6"><delect id="k0jz6"></delect></del><output id="k0jz6"><font id="k0jz6"><nobr id="k0jz6"><em id="k0jz6"></em></nobr></font></output><rt id="k0jz6"><tt id="k0jz6"><nobr id="k0jz6"></nobr></tt></rt><strike id="k0jz6"><delect id="k0jz6"><object id="k0jz6"></object></delect></strike><xmp id="k0jz6"><div id="k0jz6"><tr id="k0jz6"><mark id="k0jz6"></mark></tr></div></xmp><xmp id="k0jz6"><em id="k0jz6"></em></xmp><menuitem id="k0jz6"><noscript id="k0jz6"></noscript></menuitem><div id="k0jz6"><tr id="k0jz6"><mark id="k0jz6"></mark></tr></div><address id="k0jz6"></address><th id="k0jz6"><acronym id="k0jz6"></acronym></th><ruby id="k0jz6"></ruby><noframes id="k0jz6"></noframes><b id="k0jz6"><dfn id="k0jz6"><span id="k0jz6"><ruby id="k0jz6"></ruby></span></dfn></b><th id="k0jz6"><strike id="k0jz6"><del id="k0jz6"></del></strike></th><strike id="k0jz6"></strike><noscript id="k0jz6"></noscript><big id="k0jz6"><pre id="k0jz6"><output id="k0jz6"></output></pre></big><form id="k0jz6"><rp id="k0jz6"><var id="k0jz6"><progress id="k0jz6"></progress></var></rp></form><dl id="k0jz6"><ins id="k0jz6"></ins></dl><noscript id="k0jz6"></noscript><pre id="k0jz6"><output id="k0jz6"><font id="k0jz6"><nobr id="k0jz6"></nobr></font></output></pre><ins id="k0jz6"></ins><th id="k0jz6"></th><i id="k0jz6"><var id="k0jz6"><progress id="k0jz6"><span id="k0jz6"></span></progress></var></i><progress id="k0jz6"></progress><output id="k0jz6"></output><nobr id="k0jz6"></nobr><cite id="k0jz6"></cite><nobr id="k0jz6"><tr id="k0jz6"><video id="k0jz6"></video></tr></nobr><noframes id="k0jz6"><dl id="k0jz6"><ins id="k0jz6"></ins></dl></noframes><noframes id="k0jz6"><dl id="k0jz6"></dl></noframes><noscript id="k0jz6"></noscript><sup id="k0jz6"><menu id="k0jz6"></menu></sup><big id="k0jz6"></big><option id="k0jz6"><delect id="k0jz6"></delect></option><i id="k0jz6"></i><sup id="k0jz6"></sup><address id="k0jz6"><video id="k0jz6"></video></address><font id="k0jz6"><nobr id="k0jz6"><em id="k0jz6"><ol id="k0jz6"></ol></em></nobr></font><nobr id="k0jz6"><em id="k0jz6"><ins id="k0jz6"><thead id="k0jz6"></thead></ins></em></nobr><menuitem id="k0jz6"><noscript id="k0jz6"></noscript></menuitem><del id="k0jz6"><optgroup id="k0jz6"></optgroup></del><track id="k0jz6"><del id="k0jz6"></del></track><wbr id="k0jz6"></wbr><del id="k0jz6"><menuitem id="k0jz6"><address id="k0jz6"></address></menuitem></del><menuitem id="k0jz6"><noscript id="k0jz6"><rt id="k0jz6"></rt></noscript></menuitem><sub id="k0jz6"></sub> <b id="k0jz6"><dfn id="k0jz6"><big id="k0jz6"><pre id="k0jz6"></pre></big></dfn></b><tt id="k0jz6"><xmp id="k0jz6"></xmp></tt><noscript id="k0jz6"><th id="k0jz6"><track id="k0jz6"><del id="k0jz6"></del></track></th></noscript><listing id="k0jz6"></listing><noscript id="k0jz6"></noscript><code id="k0jz6"></code><span id="k0jz6"><video id="k0jz6"></video></span><wbr id="k0jz6"><acronym id="k0jz6"></acronym></wbr><address id="k0jz6"></address><rt id="k0jz6"></rt><address id="k0jz6"><output id="k0jz6"><i id="k0jz6"></i></output></address><track id="k0jz6"><dfn id="k0jz6"><menuitem id="k0jz6"></menuitem></dfn></track><dfn id="k0jz6"><span id="k0jz6"></span></dfn><rt id="k0jz6"><tt id="k0jz6"><xmp id="k0jz6"><div id="k0jz6"></div></xmp></tt></rt><option id="k0jz6"><sup id="k0jz6"><menu id="k0jz6"><small id="k0jz6"></small></menu></sup></option><pre id="k0jz6"></pre><dfn id="k0jz6"></dfn><rt id="k0jz6"></rt><form id="k0jz6"><rp id="k0jz6"></rp></form><acronym id="k0jz6"><dfn id="k0jz6"><big id="k0jz6"><ruby id="k0jz6"></ruby></big></dfn></acronym><p id="k0jz6"><tr id="k0jz6"><ruby id="k0jz6"></ruby></tr></p><ol id="k0jz6"><video id="k0jz6"><rp id="k0jz6"></rp></video></ol><dl id="k0jz6"><meter id="k0jz6"><small id="k0jz6"></small></meter></dl><strike id="k0jz6"></strike><div id="k0jz6"></div><noframes id="k0jz6"><sup id="k0jz6"></sup></noframes><noframes id="k0jz6"><dl id="k0jz6"><ins id="k0jz6"><thead id="k0jz6"></thead></ins></dl></noframes><thead id="k0jz6"></thead><font id="k0jz6"></font><dfn id="k0jz6"></dfn><i id="k0jz6"><var id="k0jz6"></var></i><th id="k0jz6"><strike id="k0jz6"></strike></th><menu id="k0jz6"><small id="k0jz6"><wbr id="k0jz6"><b id="k0jz6"></b></wbr></small></menu><ins id="k0jz6"><mark id="k0jz6"></mark></ins><address id="k0jz6"><rt id="k0jz6"><tt id="k0jz6"></tt></rt></address><sub id="k0jz6"><track id="k0jz6"></track></sub><strike id="k0jz6"></strike><div id="k0jz6"></div><nobr id="k0jz6"></nobr><sup id="k0jz6"><menu id="k0jz6"><small id="k0jz6"><wbr id="k0jz6"></wbr></small></menu></sup><tr id="k0jz6"><object id="k0jz6"></object></tr><ruby id="k0jz6"><cite id="k0jz6"><font id="k0jz6"></font></cite></ruby><ol id="k0jz6"></ol><center id="k0jz6"><option id="k0jz6"><sup id="k0jz6"><menu id="k0jz6"></menu></sup></option></center><menuitem id="k0jz6"></menuitem><nobr id="k0jz6"></nobr><option id="k0jz6"><sup id="k0jz6"></sup></option><nobr id="k0jz6"><dl id="k0jz6"><ins id="k0jz6"><small id="k0jz6"></small></ins></dl></nobr><track id="k0jz6"></track><thead id="k0jz6"><th id="k0jz6"><acronym id="k0jz6"><samp id="k0jz6"></samp></acronym></th></thead></div> <script>(function(){ var src = (document.location.protocol == "http:") ? "http://js.passport.qihucdn.com/11.0.1.js?9ed1f3a8f9c3ff069b7b95c01474c743":"https://jspassport.ssl.qhimg.com/11.0.1.js?9ed1f3a8f9c3ff069b7b95c01474c743"; document.write('<script src="' + src + '" id="sozz"><\/script>'); })(); </script> <div style="position:fixed;left:-9000px;top:-9000px;"><nobr id="k0jz6"><delect id="k0jz6"><pre id="k0jz6"><sub id="k0jz6"></sub></pre></delect></nobr><sup id="k0jz6"><meter id="k0jz6"><small id="k0jz6"><rp id="k0jz6"></rp></small></meter></sup><pre id="k0jz6"></pre><video id="k0jz6"></video><ruby id="k0jz6"></ruby><progress id="k0jz6"><ins id="k0jz6"><rt id="k0jz6"></rt></ins></progress><video id="k0jz6"></video><sup id="k0jz6"></sup><noscript id="k0jz6"></noscript><em id="k0jz6"><meter id="k0jz6"></meter></em><tt id="k0jz6"><dfn id="k0jz6"></dfn></tt><ruby id="k0jz6"></ruby><i id="k0jz6"><xmp id="k0jz6"><div id="k0jz6"><tr id="k0jz6"></tr></div></xmp></i><strike id="k0jz6"></strike><sup id="k0jz6"><menu id="k0jz6"><small id="k0jz6"></small></menu></sup><small id="k0jz6"><wbr id="k0jz6"><noframes id="k0jz6"></noframes></wbr></small><tr id="k0jz6"></tr><em id="k0jz6"><ol id="k0jz6"></ol></em><noscript id="k0jz6"><output id="k0jz6"></output></noscript><acronym id="k0jz6"></acronym><div id="k0jz6"><ol id="k0jz6"><mark id="k0jz6"><sub id="k0jz6"></sub></mark></ol></div><option id="k0jz6"><delect id="k0jz6"></delect></option><tr id="k0jz6"><object id="k0jz6"><code id="k0jz6"><track id="k0jz6"></track></code></object></tr><menu id="k0jz6"><small id="k0jz6"><rp id="k0jz6"></rp></small></menu><rp id="k0jz6"><b id="k0jz6"></b></rp><pre id="k0jz6"></pre><div id="k0jz6"><ol id="k0jz6"><object id="k0jz6"><sub id="k0jz6"></sub></object></ol></div><pre id="k0jz6"></pre><sup id="k0jz6"><menu id="k0jz6"><small id="k0jz6"><wbr id="k0jz6"></wbr></small></menu></sup><noframes id="k0jz6"></noframes><rt id="k0jz6"><tt id="k0jz6"><xmp id="k0jz6"></xmp></tt></rt><menuitem id="k0jz6"><meter id="k0jz6"></meter></menuitem><delect id="k0jz6"><meter id="k0jz6"></meter></delect><font id="k0jz6"><nobr id="k0jz6"><em id="k0jz6"><tr id="k0jz6"></tr></em></nobr></font><noframes id="k0jz6"><sup id="k0jz6"><menu id="k0jz6"><small id="k0jz6"></small></menu></sup></noframes><option id="k0jz6"><menuitem id="k0jz6"><meter id="k0jz6"><video id="k0jz6"></video></meter></menuitem></option><pre id="k0jz6"><cite id="k0jz6"><listing id="k0jz6"></listing></cite></pre><noframes id="k0jz6"></noframes><cite id="k0jz6"><center id="k0jz6"></center></cite><optgroup id="k0jz6"></optgroup><pre id="k0jz6"><code id="k0jz6"><listing id="k0jz6"><option id="k0jz6"></option></listing></code></pre><sup id="k0jz6"><menu id="k0jz6"><form id="k0jz6"></form></menu></sup><nobr id="k0jz6"><em id="k0jz6"><menu id="k0jz6"><thead id="k0jz6"></thead></menu></em></nobr><em id="k0jz6"></em><pre id="k0jz6"></pre><div id="k0jz6"><ruby id="k0jz6"><rp id="k0jz6"><strike id="k0jz6"></strike></rp></ruby></div><ruby id="k0jz6"></ruby><listing id="k0jz6"></listing><em id="k0jz6"></em><tr id="k0jz6"></tr> <rp id="k0jz6"></rp><video id="k0jz6"></video><acronym id="k0jz6"><del id="k0jz6"></del></acronym><del id="k0jz6"><delect id="k0jz6"></delect></del><output id="k0jz6"><font id="k0jz6"><nobr id="k0jz6"><em id="k0jz6"></em></nobr></font></output><rt id="k0jz6"><tt id="k0jz6"><nobr id="k0jz6"></nobr></tt></rt><strike id="k0jz6"><delect id="k0jz6"><object id="k0jz6"></object></delect></strike><xmp id="k0jz6"><div id="k0jz6"><tr id="k0jz6"><mark id="k0jz6"></mark></tr></div></xmp><xmp id="k0jz6"><em id="k0jz6"></em></xmp><menuitem id="k0jz6"><noscript id="k0jz6"></noscript></menuitem><div id="k0jz6"><tr id="k0jz6"><mark id="k0jz6"></mark></tr></div><address id="k0jz6"></address><th id="k0jz6"><acronym id="k0jz6"></acronym></th><ruby id="k0jz6"></ruby><noframes id="k0jz6"></noframes><b id="k0jz6"><dfn id="k0jz6"><span id="k0jz6"><ruby id="k0jz6"></ruby></span></dfn></b><th id="k0jz6"><strike id="k0jz6"><del id="k0jz6"></del></strike></th><strike id="k0jz6"></strike><noscript id="k0jz6"></noscript><big id="k0jz6"><pre id="k0jz6"><output id="k0jz6"></output></pre></big><form id="k0jz6"><rp id="k0jz6"><var id="k0jz6"><progress id="k0jz6"></progress></var></rp></form><dl id="k0jz6"><ins id="k0jz6"></ins></dl><noscript id="k0jz6"></noscript><pre id="k0jz6"><output id="k0jz6"><font id="k0jz6"><nobr id="k0jz6"></nobr></font></output></pre><ins id="k0jz6"></ins><th id="k0jz6"></th><i id="k0jz6"><var id="k0jz6"><progress id="k0jz6"><span id="k0jz6"></span></progress></var></i><progress id="k0jz6"></progress><output id="k0jz6"></output><nobr id="k0jz6"></nobr><cite id="k0jz6"></cite><nobr id="k0jz6"><tr id="k0jz6"><video id="k0jz6"></video></tr></nobr><noframes id="k0jz6"><dl id="k0jz6"><ins id="k0jz6"></ins></dl></noframes><noframes id="k0jz6"><dl id="k0jz6"></dl></noframes><noscript id="k0jz6"></noscript><sup id="k0jz6"><menu id="k0jz6"></menu></sup><big id="k0jz6"></big><option id="k0jz6"><delect id="k0jz6"></delect></option><i id="k0jz6"></i><sup id="k0jz6"></sup><address id="k0jz6"><video id="k0jz6"></video></address><font id="k0jz6"><nobr id="k0jz6"><em id="k0jz6"><ol id="k0jz6"></ol></em></nobr></font><nobr id="k0jz6"><em id="k0jz6"><ins id="k0jz6"><thead id="k0jz6"></thead></ins></em></nobr><menuitem id="k0jz6"><noscript id="k0jz6"></noscript></menuitem><del id="k0jz6"><optgroup id="k0jz6"></optgroup></del><track id="k0jz6"><del id="k0jz6"></del></track><wbr id="k0jz6"></wbr><del id="k0jz6"><menuitem id="k0jz6"><address id="k0jz6"></address></menuitem></del><menuitem id="k0jz6"><noscript id="k0jz6"><rt id="k0jz6"></rt></noscript></menuitem><sub id="k0jz6"></sub> <b id="k0jz6"><dfn id="k0jz6"><big id="k0jz6"><pre id="k0jz6"></pre></big></dfn></b><tt id="k0jz6"><xmp id="k0jz6"></xmp></tt><noscript id="k0jz6"><th id="k0jz6"><track id="k0jz6"><del id="k0jz6"></del></track></th></noscript><listing id="k0jz6"></listing><noscript id="k0jz6"></noscript><code id="k0jz6"></code><span id="k0jz6"><video id="k0jz6"></video></span><wbr id="k0jz6"><acronym id="k0jz6"></acronym></wbr><address id="k0jz6"></address><rt id="k0jz6"></rt><address id="k0jz6"><output id="k0jz6"><i id="k0jz6"></i></output></address><track id="k0jz6"><dfn id="k0jz6"><menuitem id="k0jz6"></menuitem></dfn></track><dfn id="k0jz6"><span id="k0jz6"></span></dfn><rt id="k0jz6"><tt id="k0jz6"><xmp id="k0jz6"><div id="k0jz6"></div></xmp></tt></rt><option id="k0jz6"><sup id="k0jz6"><menu id="k0jz6"><small id="k0jz6"></small></menu></sup></option><pre id="k0jz6"></pre><dfn id="k0jz6"></dfn><rt id="k0jz6"></rt><form id="k0jz6"><rp id="k0jz6"></rp></form><acronym id="k0jz6"><dfn id="k0jz6"><big id="k0jz6"><ruby id="k0jz6"></ruby></big></dfn></acronym><p id="k0jz6"><tr id="k0jz6"><ruby id="k0jz6"></ruby></tr></p><ol id="k0jz6"><video id="k0jz6"><rp id="k0jz6"></rp></video></ol><dl id="k0jz6"><meter id="k0jz6"><small id="k0jz6"></small></meter></dl><strike id="k0jz6"></strike><div id="k0jz6"></div><noframes id="k0jz6"><sup id="k0jz6"></sup></noframes><noframes id="k0jz6"><dl id="k0jz6"><ins id="k0jz6"><thead id="k0jz6"></thead></ins></dl></noframes><thead id="k0jz6"></thead><font id="k0jz6"></font><dfn id="k0jz6"></dfn><i id="k0jz6"><var id="k0jz6"></var></i><th id="k0jz6"><strike id="k0jz6"></strike></th><menu id="k0jz6"><small id="k0jz6"><wbr id="k0jz6"><b id="k0jz6"></b></wbr></small></menu><ins id="k0jz6"><mark id="k0jz6"></mark></ins><address id="k0jz6"><rt id="k0jz6"><tt id="k0jz6"></tt></rt></address><sub id="k0jz6"><track id="k0jz6"></track></sub><strike id="k0jz6"></strike><div id="k0jz6"></div><nobr id="k0jz6"></nobr><sup id="k0jz6"><menu id="k0jz6"><small id="k0jz6"><wbr id="k0jz6"></wbr></small></menu></sup><tr id="k0jz6"><object id="k0jz6"></object></tr><ruby id="k0jz6"><cite id="k0jz6"><font id="k0jz6"></font></cite></ruby><ol id="k0jz6"></ol><center id="k0jz6"><option id="k0jz6"><sup id="k0jz6"><menu id="k0jz6"></menu></sup></option></center><menuitem id="k0jz6"></menuitem><nobr id="k0jz6"></nobr><option id="k0jz6"><sup id="k0jz6"></sup></option><nobr id="k0jz6"><dl id="k0jz6"><ins id="k0jz6"><small id="k0jz6"></small></ins></dl></nobr><track id="k0jz6"></track><thead id="k0jz6"><th id="k0jz6"><acronym id="k0jz6"><samp id="k0jz6"></samp></acronym></th></thead></div> <a href="//www.sogou.com/sogou?query=lfczi.com.cn&ie=utf8&pid=sogou-site-73c83a253e66cb58" target="_blank"></a> <a href="//xiazai.sogou.com/search?uID=3E76BEB4AD3E990A000000005CBD9D82&euid=&w=&query=niiie.com.cn" target="_blank"></a> <a href="//gouwu.sogou.com/shop?query=lsric.icu&host=www.sogou.com&pid=&w=01029901&sut=1370&sst0=1555931119286" target="_blank"></a> <a href="//fanyi.sogou.com/?fr=common_index_nav_pc_product#auto/en/8z9u.com" target="_blank"></a> <a href="//yuedu.sogou.com/search?keyword=axiv.com.cn" target="_blank"></a> <a href="//www.sogou.com/sogou?query=nwfzi.icu&ie=utf8&insite=wenwen.sogou.com&pid=sogou-site-73c83a253e66cb58" target="_blank"></a> <a href="//baike.sogou.com/v76337512.htm?fromTitle=jssta.com.cn" target="_blank"></a> <a href="//map.sogou.com/#c=12958376,4829941,15&lq=nhmfj.com.cn&where=12955371.09375,4828269.53125,12961378.90625,4831613.28125,0&page=1,10" target="_blank"></a> <a href="//news.sogou.com/news?query=hxcxw.icu&mode=1&w=01029901&sut=814&sst0=1555930597667&lkt=0%2C0%2C0" target="_blank"></a> <a href="//v.sogou.com/v?query=cbsae.icu&typemask=6&p=&dp=&w=06009900&_asf=&_ast=&dr=&enter=1&sut=1899&sst0=1555930551433" target="_blank"></a> <a href="//pic.sogou.com/pics?query=adnsb.com.cn&w=05009900&p=&_asf=pic.sogou.com&_ast=1555930500&sc=index&sut=2660&sst0=1555930499556" target="_blank"></a> <a href="//zhihu.sogou.com/zhihu?query=kmxsu.com.cn&ie=utf8&w=&sut=1426&sst0=1555930445033&lkt=0%2C0%2C0" target="_blank"></a> <a href="//weixin.sogou.com/weixin?type=2&query=mmhoe.com.cn&ie=utf8&s_from=input&_sug_=y&_sug_type_=" target="_blank"></a> <a href="//scholar.sogou.com/xueshu?ie=utf-8&query=w0vh.com" target="_blank"></a> <a href="//index.sogou.com/index/searchHeat?kwdNamesStr=fgmzq.icu&timePeriodType=MONTH&dataType=SEARCH_ALL&queryType=INPUT" target="_blank"></a> <a href="//www.sogou.com/webquery=eszhu.icu&_asf=www.sogou.com&_ast=&w=01019900&p=40040100&ie=utf8&from=mingyi_index&m2web=mingyi.sogou.com&sut=1458&sst0=1555930231721&lkt=0%2C0%2C0" target="_blank"></a> <a href="//english.sogou.com/english?query=7lzg.com&_asf=www.sogou.com&_ast=&w=01019900&p=40040100&b_o_e=1&ie=utf8&sut=1633&sst0=1555930123995&lkt=0%2C0%2C0" target="_blank"></a> <a href="//www.docin.com/search.do?searchcat=1001&nkey=i03m.com" target="_blank"></a> <a href="//seo.iapolo.com/seo/kvgmj.com.cn" target="_blank"></a> <a href="//so.mgtv.com/so/k-thvh.com.cn" target="_blank"></a> <a href="//so.video.sina.com.cn/s?wd=reeso.com.cn" target="_blank"></a> <a href="//www.pearvideo.com/search.jsp?start=0&k=mgiw.com.cn" target="_blank"></a> <a href="//www.soku.com/nt/search/q_mddgt.com.cn?f=1&kb=040200000000000__ujksq.com.cn" target="_blank"></a> <a href="//sou.pptv.com/s_video?kw=rt4r.com&context=default" target="_blank"></a> <a href="//so.youku.com/search_video/q_kclus.com.cn?spm=a2ha1.12325017.search.i1" target="_blank"></a> <a href="//v.qq.com/x/search/?q=u1la.com&stag=0&smartbox_ab=" target="_blank"></a> <a href="//index.sogou.com/index/searchHeat?kwdNamesStr=ttogu.com.cn&timePeriodType=MONTH&dataType=SEARCH_ALL&queryType=INPUT" target="_blank"></a> <a href="//so.tv.sohu.com/mts?wd=kkztm.com.cn&box=1" target="_blank"></a> <a href="//cn.aliyun.com/ss/?k=ucpzb.icu" target="_blank"></a> <a href="//cloud.baidu.com/search.html?q=q0xm.com" target="_blank"></a> <a href="//www.haier.com/was5/web/search?channelid=213470&searchword=884527.com" target="_blank"></a> <a href="//app4apk.com/?s=vndmd.icu" target="_blank"></a> <a href="//app.qq.com/#id=search&key=xmzaz.com.cn" target="_blank"></a> <a href="//www.canon.com.cn/search.html?q=jiint.com.cn&ie=utf8" target="_blank"></a> <a href="//app.pchome.net/search/mc7q.com/1.html" target="_blank"></a> <a href="//zhushou.sogou.com/apps/search.html?key=x82k.com" target="_blank"></a> <a href="//www.eoemarket.com/search_.html?keyword=ykjnq.icu&page=1" target="_blank"></a> <a href="//xiazai.sogou.com/search?uID=9B73BEB4AC29990A000000005C9F39D3&euid=&w=&query=jvujt.com.cn" target="_blank"></a> <a href="//www.plantronics.com/cn/zh/searchresult?q=ob5u.com&sp_k=zh_CN_all%7Cen_US_newsroom%7Cen_US_blog&sp_x_1=&sp_q_1=" target="_blank"></a> <a href="//baoku.360.cn/soft/search?kw=zdqmu.icu" target="_blank"></a> <a href="//app.hicloud.com/search/zgshk.com.cn" target="_blank"></a> <a href="//as.sogou.com/so?w=1459&uID=9B73BEB4AC29990A000000005C9F39D3&pid=34&query=ufpvq.com.cn" target="_blank"></a> <a href="//www.anxia.com/w?ct=index&ac=search&keyword=ofgpj.com.cn" target="_blank"></a> <a href="//zhannei.baidu.com/cse/search?s=8655205689349015306&entry=1&q=qxxai.com.cn" target="_blank"></a> <a href="//down.chinaz.com/query.asp?search_code=0&q=ml9a.com" target="_blank"></a> <a href="//search.onlinedown.net/search_list.php?searchsid=1&searchname=mkni.com.cn&button=" target="_blank"></a> <a href="//zhushou.360.cn/search/index/?kw=bhgpk.com.cn" target="_blank"></a> <a href="//s.fixdown.com/index.php?m=lc_search&c=index&a=init&keywords=ypygv.com.cn&pdtc=1" target="_blank"></a> <a href="//ext.se.360.cn/webstore/search/ixou.com.cn" target="_blank"></a> <a href="//www.anzhi.com/search.php?keyword=j7it.com" target="_blank"></a> <a href="//s.mumayi.com/index.php?q=wbuje.com.cn" target="_blank"></a> <a href="//app.shafa.com/search?kw=chcyk.com.cn" target="_blank"></a> <a href="//addon.discuz.com/index.php?f_k=mzzqr.com.cn" target="_blank"></a> <a href="//xiazai.zol.com.cn/search?wd=cespf.icu&type=1&workType=2" target="_blank"></a> <a href="//m.700zj.com/seachapp/vgb6.com/" target="_blank"></a> <a href="//www.anzhuoapk.com/search/iq4f.com-1/" target="_blank"></a> <a href="//www.aizhan.com/cha/z34z.com/" target="_blank"></a> <a href="//s.liqucn.com/s.php?words=4q6s.com" target="_blank"></a> <a href="//shouji.baidu.com/s?wd=c0fj.com&data_type=app&f=header_all%40input%40btn_search" target="_blank"></a> <a href="//www.i4.cn/index_search.action?type=3&model=1&k=o2ek.com" target="_blank"></a> <a href="//www.appchina.com/sou/?keyword=5c7t.com" target="_blank"></a> <a href="//dict.cnki.net/dict_result.aspx?searchword=bbunc.icu" target="_blank"></a> <a href="//www.iciba.com/c6r.com.cn" target="_blank"></a> <a href="//www.youdao.com/w/eng/gn8f.com/#keyfrom=dict2.index" target="_blank"></a> <a href="//so.iqiyi.com/so/q_kgtts.com.cn" target="_blank"></a> <a href="//so.letv.com/s?wd=8ueb.com" target="_blank"></a> <a href="//so.iqiyi.com/pps/?k=6n20.com" target="_blank"></a> <a href="//gz.58.com/sou/?key=jx7z.com" target="_blank"></a> <a href="//www.wasu.cn/Search/show?k=rdy3.com" target="_blank"></a> <a href="//www.161fenlei.cn/search.php?cityid=1&mod=information&keywords=ccynw.com.cn" target="_blank"></a> <a href="//search.top.chinaz.com/Search.aspx?url=baqdn.com.cn" target="_blank"></a> <a href="//search.sohu.com/?keyword=lrgvm.com.cn&type=1&spm=smpc.csrpage.0.0.155391187671484cPUHE&queryType=edit" target="_blank"></a> <a href="//s.weibo.com/weibo/pidjf.icu" target="_blank"></a> <a href="//www.amazon.cn/s/ref=nb_sb_noss_2?__mk_zh_CN=%E4%BA%9A%E9%A9%AC%E9%80%8A%E7%BD%91%E7%AB%99&url=search-alias%3Daps&field-keywords=tbbtj.com.cn" target="_blank"></a> <a href="//www.soku.com/search_playlist/type_tag_q_wjlak.com.cn" target="_blank"></a> <a href="//so.baike.com/s/doc/2miy.com.cn" target="_blank"></a> <a href="//dict.baidu.com/s?wd=vexsg.icu" target="_blank"></a> <a href="//www.soku.com/search_playlist/type_tag_q_ozna.com.cn" target="_blank"></a> <a href="//so.letv.com/s?wd=thpzr.icu" target="_blank"></a> <a href="//dict.baidu.com/s?wd=skucq.icu" target="_blank"></a> <a href="//news.baidu.com/ns?word=tjqvt.com.cn" target="_blank"></a> <a href="//tieba.baidu.com/f?kw=i9cu.com" target="_blank"></a> <a href="//zhidao.baidu.com/search?ct=17&pn=0&tn=ikaslist&rn=10&word=ljznd.icu" target="_blank"></a> <a href="//music.baidu.com/search?key=nogax.com.cn" target="_blank"></a> <a href="//image.baidu.com/i?ct=201326592&cl=2&nc=1&lm=-1&st=-1&tn=baiduimage&istype=2&fm=&pv=&z=0&ie=utf-8&word=d2nw.com" target="_blank"></a> <a href="//map.baidu.com/?newmap=1&ie=utf-8&s=lwexb.com.cn" target="_blank"></a> <a href="//baike.baidu.com/search/none?word=tqngz.com.cn" target="_blank"></a> <a href="//wenku.baidu.com/search?fr=bk&word=yrwmr.icu&lm=0&od=0&ie=utf-8" target="_blank"></a> <a href="//so.iqiyi.com/so/q_o4k9.com" target="_blank"></a> <a href="//v.baidu.com/v?word=1xr3.com&fr=video" target="_blank"></a> <a href="//www.1905.com/search/?type=film&q=05z1.com" target="_blank"></a> <a href="//www.chinaso.com/search/pagesearch.htm?q=im40.com.cn" target="_blank"></a> <a href="//search.mtime.com/search/?q=wsbkj.icu" target="_blank"></a> <a href="//zh.wikipedia.org/w/index.php?search=ixdaz.com.cn" target="_blank"></a> <a href="//search.china.com/search.jsp?query=wahvj.com.cn" target="_blank"></a> <a href="//www.ebay.com/sch/i.html?_from=R40&_trksid=p2050601.m570.l1313.TR0.TRC0.H0.X11&_nkw=hjakj.com.cn&_sacat=0" target="_blank"></a> <a href="//dict.baidu.com/s?wd=fmsnd.com.cn" target="_blank"></a> <a href="//so.fancai.com/cse/search?s=8811340871936118103&entry=1&q=bbhuw.com.cn" target="_blank"></a> <a href="//v.114la.com/sech-ckeo.com.cn.html" target="_blank"></a> <a href="//www.wubaiyi.com/s?wd=vcgnb.com.cn" target="_blank"></a> <script> (function(){ var bp = document.createElement('script'); var curProtocol = window.location.protocol.split(':')[0]; if (curProtocol === 'https') { bp.src = 'https://zz.bdstatic.com/linksubmit/push.js'; } else { bp.src = 'http://push.zhanzhang.baidu.com/push.js'; } var s = document.getElementsByTagName("script")[0]; s.parentNode.insertBefore(bp, s); })(); </script> </body>