DataAdapter ¶ÔÏóÖеÄSQLÃüÁî
±êÇ©£ºÊý¾Ý·ÃÎÊ ADO.NET
DataAdapter ¶ÔÏóÖеÄSQLÃüÁî ×¢£ºADO.NET¶ÔÏóÄ£ÐÍ ºÍ C# Òª±È SQL ¸üÊʺϴ¦Àí¸´ÔÓÔËËã ºÍ µ¼º½Âß¼£¨±ÈÈ磬²éÕÒÏà¹ØµÄÁíÒ»¸ö±íµÄÊý¾Ý£©
ËùÒÔ£¬¿ÉÒÔ°ÑÊý¾ÝÌî³äµ½DataSetÖУ¬ÔÚ¿Í»§»úÉÏÖ´ÐÐÕâÖÖÂß¼¡£
²é¿´SQL SELECT¡¢UPDATE¡¢INSERT ºÍ DELETEÃüÁ
ÃüÁî¹¹½¨Æ÷(command builder)ÓÃÓÚ¸ù¾ÝSELECTÃüÁîÉú³ÉSQLÃüµÄUPDATE¡¢INSERTºÍDELETE)ÃüÁî¡£
¿ÉÒÔÓÃCommandBuilder¶ÔÏóµÄGetUpdateCommand()¡¢GetInsertCommand()ºÍGetDeleteCommand()·½·¨Éú³ÉÃüÁî¡£
Àý£º
SqlConnection thisConnection = new SqlConnection(@".........ConnectString..........."); thisConnection.Open(); SqlDataAdapter thisAdapter = new SqlDataAdapter("SELECT CustomerID from Customers", thisConnection); SqlCommandBuilder thisBuilder = new SqlCommandBuilder(thisAdapter); //ÓÃCommand builder¹¹½¨ÃüÁî
SqlCommand updateCommand = thisBuilder.GetUpdateCommand();
Console.WriteLine(updateCommand.CommandText); // Êä³öbuilder¹¹½¨µÄSQLÃüÁ¿ÉÒÔ¿´µ½SQLÃüÁîÊÇʲôÑùµÄ£¬
Ïà¹ØÎĵµ£º
--Ê¡¼¶ Provincial
--³ÇÊÐ City
create table Provincial(pid int,Provincial varchar(50),primary key (pid))
insert into Provincial values(1,'±±¾©ÊÐ')
insert into Provincial values(2,'Ìì½òÊÐ')
insert into Provincial values(3,'ÉϺ£ÊÐ')
insert into Provincial values(4,'Ö ......
ÔÚSQLÓï¾äÖУ¬³£³£Óûá¶Ôʱ¼ä£¨»òÈÕÆÚ£©½øÐÐһЩ´¦Àí£¬ÏÂÃæÊDZȽÏͨÓõÄһЩÓï¾ä£º
ÑÓ³Ù£º
sysdate+(5/24/60/60) ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5Ãë
sysdate+5/24/60 ÔÚϵͳʱ¼ä»ù´ ......
д³É´æ´¢¹ý³Ì£¬½¨Á¢×÷Òµ¶¨Ê±±¸·Ý~~~
--ÔÚsqlÖÐÓ³ÉäһϾͿÉÒÔÁË
exec master..xp_cmdshell 'net use z: \\yizhi\D$ "ÃÜÂë" /user:yizhi\administrator'
/*--˵Ã÷:
exec master..xp_cmdshell 'net use z: \\xz\c$ "ÃÜÂë" /user:xz\administrator'
z:ÊÇÓ³ÉäÍøÂç·¾¶¶ÔÓ¦±¾»úµÄÅÌ·û,ÓëÏÂÃæµÄ±¸·Ý¶ÔÓ¦
\\xz\c$ÊÇÒªÓ³ÉäµÄÍ ......
exec sp_rename 't_2.lname','lastname','column'
exec sp_rename ‘tabelname’,'new'
»ñµÃsqlÓï¾äµÄÖ´ÐÐʱ¼ä£º
SET STATISTICS TIME ON
// sql Óï¾ä£ºselect * from table
SET STATISTICS TIME OFF
´´½¨Ë÷Òý£ºCRE ......
--default-character-set=utf8 ÓëÐÞ¸ÄsqlÎļþ¼ÓÈ룺SET NAMES 'utf8';
µ¼Èë½Å±¾Ê±£¬SET NAMES 'xxx' £¬xxxÓ¦¸ÃºÍsql½Å±¾ÎļþµÄʵ¼Ê±àÂëÒ»Ö£¬Èç¹ûÄãÉèÖõÄʱutf-8 £¬ÄÇôÇëÈ·ÈÏÄãµÄsql½Å±¾Îļþʱutf-8±£´æµÄ:
iconv -f UTF-8 xxx.sql
Èç¹ûÏÔʾÕý³££¬ÄÇôÕâÒ»²½¾ÍOKÁË
ÁíÍâ×¢ÒâÄãµÄ½Å±¾ÀÓÐûÓиø¿â±íÉèÖ ......