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

c#ÈçºÎ·ÃÎʾÖÓòÍøÖеÄsqlÊý¾Ý¿â

ÓÐÒ»¸öc#³ÌÐò£¬Ô­À´±à³ÌµÄʱºòÉ趨·ÃÎʱ¾»úµÄsql serverÊý¾Ý¿â
app.configÎļþÄÚÈÝÈçÏ£º
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
    <configSections>
    </configSections>
    <connectionStrings>
        <add name="try.Properties.Settings.abcdConnectionString" connectionString="Data Source=127.0.0.1;Initial Catalog=abcd;Integrated Security=True"
            providerName="System.Data.SqlClient" />
    </connectionStrings>
</configuration>

·ÃÎÊÊý¾Ý¿âʱʹÓÃÈçÏÂÓï¾ä£º
String MySQLConnectionString = global::try.Properties.Settings.Default.abcdConnectionString;
SqlConnection MyConnection = new SqlConnection(MySQLConnectionString);
MyConnection.Open();

ÏÖÔÚ°ÑÕâ¸ö³ÌÐòÄõ½²»ÊÇÊý¾Ý¿â·þÎñÆ÷µÄ»úÉÏÓã¬ÇëÎÊÓ¦¸ÃÈçºÎÐÞ¸ÄÕâ¸ö³ÌÐò£¬Ê¹ËüÄܹ»Í¨¹ý¾ÖÓòÍø·ÃÎÊÊý¾Ý¿â·þÎñÆ÷ÉϵÄSql ServerÊý¾Ý¿â£¿



connectionString="Data Source=Éè³ÉÄãµÄip;

¿ÉÒÔÔÚÃüÁîÐÐÌáʾ·ûÏÂÊäÈëipconfig²é¿´

Data Source=127.0.0.1

¸ÄΪ:ËùÒª·ÃÎʵÄÊý¾Ý¿â·þÎñÆ÷IP

ÆäËüµÄÓû§ÃûÃÜÂëºËʵһϾÍOK.



connectionString="Data Source=Êý¾Ý¿â·þÎñÆ÷µÄip;

connectionString="Data Source=192.168.*.*;Initi


Ïà¹ØÎÊ´ð£º

ÈçºÎÓÃc#£¬sql2000 ¿ª·¢c/sÏµĹ¤×÷Á÷£¿

±¾ÈËc#ÐÂÊÖ ¿ÉÊÇÒªÇóÒªÓÃc# £¬sql2000¿ª·¢c/sµÄ¹¤×÷Á÷£¬Ò»Í·ÎíË®£¬Çë´ó¼Ò°ïæ°ï棬¸øµã˼·£¬ËµµÄÔ¼¾ßÌåÔ½ºÃ£¬ÎÒÒ²ºÃÍùÄǸö·½ÃæÈ¥Ñ§Ï°
http://www.hxzi.com/view/61402.html
B/S°æµÄ£¬»ù±¾Ë¼ÏëÓ¦¸Ã²î²»¶àµÄ¡£¡£ ......

¹ØÓÚgroup byµÄsqlÓï¾ä£¿

  with adod_dict do
    begin
    close;
    commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......

sql ÎÊÌâ

DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)

string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+"') and (EndTime ......

C# Á¬½ÓSQLÊý¾Ý¿â³£ÓõÄÁ¬½Ó×Ö·û´®¸ÃÈçºÎд£¿

£¨1£©string ConnString = "server=localhost;integrated security=sspi;database=pubs;";   
£¨2£©string strConnection="user uid=sa;pwd=123456;Database=test;Server=test;Connect ......

sqlÓï¾ä¶à±í¶à×ֶβéѯ - MS-SQL Server / »ù´¡Àà

ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд 

ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ