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

access db

 class Program
    {
        static void Main(string[] args)
        {
            String conStr = "Data Source=mesqas;User ID=ctdsp_oee;Password=12345678";
            OracleConnection con = new OracleConnection(conStr);
            try
            {
                con.Open();
                OracleCommand com = con.CreateCommand();
                com.CommandText = "select * from temp";
                OracleDataReader read = com.ExecuteReader();
                while (read.Read())
                {
                    Console.WriteLine(read.GetString(1));
                 
                  
                }
                Console.ReadLine();
                read.Close();
      


Ïà¹ØÎĵµ£º

Ò»¸öÊý¾Ý¿â²Ù×÷À࣬ÊÊÓÃÓÚOracle£¬ACCESS,SQLSERVER

     ×î½ü×öÁËÒ»¸öÊý¾ÝÕï¶ÏµÄÏîÄ¿£¬ÀïÃæ×Ô¼ºÐ´ÁËÒ»¸öÊý¾Ý¿âµÄ²Ù×÷À࣬°üº¬£ºÁ¬½ÓÊý¾Ý¿â¡¢¶ÁÊý¾Ý±í¡¢Ö´ÐÐSQL²Ù×÷£¬ÊÍ·ÅÊý¾Ý¿âµÈ×é³É£¬Ï£Íû¶Ô´ó¼ÒÓÐÓã¬ÓÉÓÚˮƽÓÐÏÞ£¬ÈôÓдíÎó»òÕß´úÂë²»×ãµØ·½»¶Ó­Ö¸Õý£¬Ð»Ð»¡£
ADOOperate.H
//////////////////////////////////////////////////////////////////////
// ......

Ìõ¼þ½ÓÊÕϵͳ £¨CAs:Conditional Access System£©

Ìõ¼þ½ÓÊÕϵͳ £¨CAs:Conditional Access System£©
¡¡¡¡ÓÐÌõ¼þ½ÓÊÕϵͳ£¨CAS£©ÊÇ¿ªÕ¹¸¶·ÑµçÊӵĺËÐļ¼Êõ£¬Á˽âËüµÄÔËÐлúÖÆ£¬ÕÆÎÕºÃËüµÄʹÓúÍά»¤¶Ô¸¶·ÑµçÊÓÒµÎñµÄ³É¹¦¿ªÕ¹·Ç³£¹Ø¼ü¡£CASµÄ×é³É°üÀ¨ÓУºÓû§¹ÜÀíϵͳSMS¡¢ÒµÎñÐÅÏ¢Éú³ÉϵͳSIG¡¢½ÚÄ¿¹ÜÀíPMS/SI±à¼­ÏµÍ³¡¢½ÚÄ¿µ÷¶È´¦ÀíEIS¡¢Óû§ÊÚȨ¹ÜÀíϵͳSAS¡¢Ìõ¼þ½ÓÊÕCAµÈ ......

¹ØÓÚACCESSÖÐÖظ´ÐеĴ¦Àí

ACCESSÖÐÖظ´ÐеĴ¦Àí
ACCESSÖУ¬Ê¹ÓÃdistinctºÍgroup byºó£¬Èç¹ûÔÚjavaÖÐʹÓÃrs.next()µÄ»°£¬¾Í»áÌáʾ“ÎÞЧµÄÓαꔴíÎó¡£
µ«ÊÇ£¬²¢·Ç²»Ö§³ÖÉÏÃæÁ½¸öÓï·¨¡£
ËùÒÔ£¬¿ÉÒÔͨ¹ýÒÔÏÂÓï·¨½øÐжþ´Î²éѯ£¬½«Öظ´Êý¾ÝÈ¥µô¡£
select stockName from (select stockName from stock group by stockName) order by stock ......

ASP.NETʵÏÖÔöɾ¸Ä²éµÈ¹¦ÄÜ(Access°æ)ϵͳ֮Îå ¸üÐÂ

¸üз½·¨Ò»£¬Ö±½ÓÔÚGridViewÖÐÀ´¸üÐÂÊý¾Ý.
¸üз½·¨¶þ£¬´ò¿ªÒ»¸öеÄÒ³ÃæÀ´¸üÐÂÊý¾Ý.
//¸üÐÂ
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        GridView1.EditIndex = e.NewEditIndex;
 &nbs ......

SQL µ¼³öµ½ Ö¸¶¨ACCESS±í ÍêÃÀ·½°¸

ÓÉÓÚ³ÌÐòÐèÒª°ÑSQL SERVER ÀïµÄÊý¾Ýµ¼Èëµ½ACCESSÀï.
¸Õ¿ªÊ¼Ê¹ÓÃDataSetÀ´Ñ­»·.
Êý¾ÝÁ¿ÉÙµÄʱºò»¹Ëã¿ÉÒÔÓ¦¸¶µÄ¹ýÀ´.
µ«µ±Êý¾Ý¶àµÄʱºò.
»á±¨´í"λÖôíÎó"
ÔÚÍøÉÏËÑÑ°Ò»·¬.ÕÒµ½Ò»¸ö·½·¨.
ʹÓÃinsert into openrowset
½Ó×Å´íÎóÒ»¸ö½ÓÒ»¸öµÄÀ´..
"²åÈë´íÎó: ÁÐÃû»òËùÌṩֵµÄÊýÄ¿Óë±í¶¨Ò岻ƥÅä¡£"
"δÄÜÕÒµ½ OLE DB Ì ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ