SQLÊÂÎñ£¬Í¬Ê±Ö´Ðд¿sqlÓï¾äºÍ´ø²ÎµÄSQLÓï¾ä
/// <summary>
193 /// Ö´ÐÐÊý¾Ý¿âÊÂÎñ
194 /// </summary>
195 /// <param name="sqlStringList"> </param>
196 public void ExecuteTransaction(System.Collections.ArrayList sqlStringList)
197 {
198 Connection.Open();
199 DbTransaction tran = Connection.BeginTransaction();
200 DbCommand Command = BuildInitCommand();
201 Command.Transaction = tran;
202 try
203 {
204 for (int i = 0; i < sqlStringList.Count; i++)
205 {
206 Command.CommandText = sqlStringList[i].ToString();
207 Command.ExecuteNonQuery();
208 }
209 tran.Commit();
210 &n
Ïà¹ØÎÊ´ð£º
sql¿ÉÒÔÓÐÁ½¸öÒÔÉϵĴ¥·¢Æ÷Â𣿣¿ÎÒÖ¸µÄÊÇfor´¥·¢Æ÷£¬ÄÇÆäËûµÄÄØ£¿£¿
ʲôÒâ˼£¿
¿ÉÒÔµÄ
10¸ö¶¼Ã»ÎÊÌâ
¿ÉÊÇÎÒдÁËÁ½¸öfor insert ´¥·¢Æ÷£¬Ôì³É½ø³Ì×èÈûÁËÄØ£¿Ôõô°ìÄØ£¿Çë¸ßÈËÖ¸µã
......
ÔÊý¾Ý
ÉÌÆ· Ô¼Û ´òÕÛ·½Ê½1 ÕÛ¿Û1 ´òÕÛ·½Ê½2 ÕÛ¿Û2
±Ê¼Ç±¾ 10000 NULL 0 NULL&nb ......
table1:
uID uName
1 СÀî
2 СÕÅ
table2:
pID uID type
1 1 H1
2   ......
±ía
Ïß·´úÂë Ïß·Ãû³Æ Main_ID
cir11 cirA 1
cir21 cirB 1
cir13 ......
СµÜÎÒÓÃADOÁ¬½ÓSQL server 2000Êý¾Ý¿â£¬È»ºóÔÚDBGridÖÐÏÔʾ£¬ÏÖÔÚÏë°ÑÔÚDBGridÖвéѯµ½µÄÊý¾ÝiPlot×÷ͼ£¬ÇëÎÊÈçºÎʵÏÖÔÚDBGridÖеÄÊý¾Ý¶ÁÈ¡£¬¶Á³öµÄÊý¾ÝÊÇSTRINGÀàÐ͵ģ¬ÈçºÎÓÐЧµÄת±ä³ÉÊý¾Ý¿âÖÐËù´æ´¢µÄDOUBLEÀàÐ ......