Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

sql c#

C-#ÈëÞ­µä(µÚÈý°æ).pdf
using System;
using System.Data;
using System.Data.SqlClient;
namespace My_Student
{
    static class Program
    {
       
        static void Main()
        {
            //Á¬½Ó×Ö·û´®£¬Á¬½Ó±¾µØµÄMS SQL Server·þÎñÆ÷
            string connString = "data source=MICROSOF-84BB45;persist security info=False;initial catalog=MyDB;integrated security=SSPI;";
            //SQLÓï¾ä£¬É¾³ý¼Ç¼
            string sqlString = "delete from Courses where CourseNo='001'";
            //½¨Á¢Á¬½Ó¶ÔÏó
            SqlConnection conn = new SqlConnection(connString);
            conn.Open();//´ò¿ªÁ¬½Ó
            //½¨Á¢Êý¾ÝÃüÁî¶ÔÏó
            SqlCommand cmd = new SqlCommand(sqlString, conn);
            //Ö´ÐÐÃüÁ·µ»ØÓ°ÏìµÄÐÐÊý
            int rowsReturned = cmd.ExecuteNonQuery();
            Console.WriteLine("{0} ¼Ç¼ÒÑɾ³ý", rowsReturned);
            MessageBox.Show("Êý¾Ý¿â¸üгɹ¦£¡£¡");
            conn.Close();//¹Ø±ÕÁ¬½Ó
        }
    }
}
try
       &nb


Ïà¹ØÎĵµ£º

C#ɾ³ýXML½áµãµÄ¼òµ¥Àý×Ó

½ÓÉÏһƪ
ɾ³ýÔ­genreÊôÐÔ£¬É¾³ýleixing=loveµÄËùÓнáµã¡£
1 Ô­xmlÎļþ bookstore.xml
<?xml version="1.0" encoding="gb2312"?>
<bookstore>
  <book genre="love" ISBN="1234123">
    <title>who am i </title>
    <author>who</aut ......

¸ßÊÖÏê½âSQLÐÔÄÜÓÅ»¯Ê®Ìõ¾­Ñé

1.²éѯµÄÄ£ºýÆ¥Åä
¾¡Á¿±ÜÃâÔÚÒ»¸ö¸´ÔÓ²éѯÀïÃæÊ¹Óà LIKE '%parm1%'—— ºìÉ«±êʶλÖõİٷֺŻᵼÖÂÏà¹ØÁеÄË÷ÒýÎÞ·¨Ê¹Óã¬×îºÃ²»ÒªÓÃ.
½â¾ö°ì·¨:
ÆäʵֻÐèÒª¶Ô¸Ã½Å±¾ÂÔ×ö¸Ä½ø£¬²éѯËٶȱã»áÌá¸ß½ü°Ù±¶¡£¸Ä½ø·½·¨ÈçÏ£º
a¡¢ÐÞ¸Äǰ̨³ÌÐò——°Ñ²éѯÌõ¼þµÄ¹©Ó¦ÉÌÃû³ÆÒ»À¸ÓÉÔ­À´µÄÎı¾ÊäÈë¸ÄΪÏÂÀ­Áб ......

C#——C#ÖÐC/C++³ÌÐòԱҪעÒâµÄÎÊÌâ


1¡¢C/C++³ÌÐòÔ±Çë×¢Ò⣬²»ÄÜÔÚcaseÓï¾ä²»Îª¿Õʱ“ÏòÏÂÖ´ÐД¡£
2¡¢ÖµÀàÐͺÍÒýÓÃÀàÐÍÖ®¼äµÄÇø±ð£ºC#µÄ»ù±¾ÀàÐÍ£¨int£¬charµÈ£©¶¼ÊÇÖµÀàÐÍ£¬ÊÇÔÚÕ»Öд´½¨µÄ¡£¶ø¶ÔÏóÊÇÒýÓÃÀàÐÍ£¬´´½¨ÓÚ¶ÑÖУ¬ÐèҪʹÓùؼü×Önew¡£
3¡¢ÔÚC#ÖÐͨ¹ýʵÀý·ÃÎʾ²Ì¬·½·¨»ò³ÉÔ±±äÁ¿ÊDz»ºÏ·¨µÄ£¬»áÉú³É±àÒëÆ÷´íÎó¡£µ«ÊÇÎÒÃÇ¿ÉÒÔͨ¹ýÉùÃ÷Ëû ......

asp.net C#ÃüÃû²ÎÊýSqlParameterÏê½â

DBHelper:
         /// <summary>
        /// Ö´Ðвéѯ
        /// </summary>
        /// <param name="sql">ÓÐЧµÄselectÓï¾ä</param ......

sql plus ʹÓôóÈ«

1. Ö´ÐÐÒ»¸öSQL½Å±¾Îļþ
SQL>start file_name
SQL>@ file_name
2. ¶Ôµ±Ç°µÄÊäÈë½øÐб༭
SQL>edit

3. ÖØÐÂÔËÐÐÉÏÒ»´ÎÔËÐеÄsqlÓï¾ä
SQL>/

4. ½«ÏÔʾµÄÄÚÈÝÊä³öµ½Ö¸¶¨Îļþ
SQL> SPOOL file_name
ÔÚÆÁÄ»ÉϵÄËùÓÐÄÚÈݶ¼°üº¬ÔÚ¸ÃÎļþÖУ¬°üÀ¨ÄãÊäÈëµÄsqlÓï¾ä¡£

5. ¹Ø±Õspool ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ