Ö±½ÓÖ´ÐÐSQLÃüÁî
±êÇ©£ºÊý¾Ý·ÃÎÊ ADO.NET
Ö±½ÓÖ´ÐÐSQLÃüÁî Ö´ÐÐÃæÏò¼¯ºÏµÄ²Ù×÷£¨±ÈÈ磬¸üÐÂÂú×ãÌõ¼þµÄÒ»×éÊý¾Ý£©¿ÉÒÔÖ±½ÓÓÃSQLÃüÁҪ±ÈÓÃC#À©Õ¹µÄSQLÖ¸Áî¸üÓÐЧ¡£
ADO.NET ÌṩÁË SqlCommand ºÍ OleDbCommand¶ÔÏó£¬ËûÃÇÌṩÁË¿ÉÖ±½ÓÖ´ÐÐSQLÃüÁîµÄ·½·¨¡£
ÌáÈ¡µ¥Öµ£º
Àý£º
.....
SqlConnection thisConnection = new SqlConnection(@".........ConnectString.........");
thisConnection.Open();
SqlCommand thisCommand = thisConnection.CreateCommand();
thisCommand.CommandText = "SELECT COUNT (*) from Customers ";
Object countResult = thisCommand.ExecuteScalar();
Console.WriteLine(countResult); //Êä³ö²éѯµ½µÄ¼Ç¼ÊýÄ¿
thisConnection.Close();
²»¼ìË÷Êý¾Ý£º
ÀàËÆSQL INSERT, UPDATE, DELETEµÄÐ޸IJÙ×÷²»ÐèÒª·µ»ØÊý¾Ý£¬Ö»ÐèÒªÖªµÀÓ°ÏìµÄÐÐÊý¡£
ÓÃExecuteNonQuery()·½·¨¡£
Àý£º
......
thisCommand.CommandText = "UPDATE Products SET UnitPrice=UnitPrice*1.05 WHERE SupplierId=12";
int rowAffe
Ïà¹ØÎĵµ£º
ÔÚSQLÓï¾äÖУ¬³£³£Óûá¶Ôʱ¼ä£¨»òÈÕÆÚ£©½øÐÐһЩ´¦Àí£¬ÏÂÃæÊDZȽÏͨÓõÄһЩÓï¾ä£º
ÑÓ³Ù£º
sysdate+(5/24/60/60) ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5Ãë
sysdate+5/24/60 ÔÚϵͳʱ¼ä»ù´ ......
//±¾³ÌÐòÁ¬½ÓµÄÊÇsql server 2005£¬ÓëÁ¬½Ósql server 2000Óе㲻ͬ£ºdriverNameºÍURL¶¼²»Í¬
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class create{
public void getConnection() th ......
1.Á¬½ÓÊý¾Ý¿âÎļþ
<add name="LocalSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;AttachDBFilename=|DataDirectory|TimeTracker.mdf;User Instance=true" />
SqlConnectionStringBuilderʵÀý»¯Ê±£¬ÒªÓõ½connectionString£¬È磺SqlConnectionStringBuild builder = new SqlC ......
ÊìϤSQL SERVER 2000µÄÊý¾Ý¿â¹ÜÀíÔ±¶¼ÖªµÀ£¬ÆäDTS¿ÉÒÔ½øÐÐÊý¾ÝµÄµ¼Èëµ¼³ö£¬Æäʵ£¬ÎÒÃÇÒ²¿ÉÒÔʹÓÃTransact-SQLÓï¾ä½øÐе¼Èëµ¼³ö²Ù×÷¡£ÔÚTransact-SQLÓï¾äÖУ¬ÎÒÃÇÖ÷ҪʹÓÃOpenDataSourceº¯Êý¡¢OPENROWSET º¯Êý£¬¹ØÓÚº¯ÊýµÄÏêϸ˵Ã÷£¬Çë²Î¿¼SQLÁª»ú°ïÖú¡£ÀûÓÃÏÂÊö·½·¨£¬¿ÉÒÔÊ®·ÖÈÝÒ×µØʵÏÖSQL SERVER¡¢ACCESS¡¢EXCELÊý¾Ýת»»£ ......