SQL server ¿ª·¢³öÀ´µÄ³ÌÐòÊÇÔõÃ´ÒÆÖ²µ½¿Í»§µÄ
ÒÔǰÓùývcд¹ý²Ù×÷SQLserver Êý¾Ý¿âµÄ³ÌÐò£¬Á¬½ÓÊý¾Ý¿âµÄʱºòÓõ½ÁËÓû§ÃûºÍÃÜÂë¡£
ÿ¸öserverµÄÓû§ÃûºÍÃÜÂëÓ¦¸ÃÊDz»Ò»ÑùµÄ£¬ÒÔǰÊǿγÌÉè¼ÆÑÝʾһϸøÀÏʦ¿´¾Í¿ÉÒÔÁË¡£
µ«ÄǸöʱºòÎÒÒ»Ö±ÓиöÎÊÌ⣬Èç¹ûÒªÊǰѳÌÐò¸ø±ðÈËÓã¬Êý¾Ý¿â»¹ÄÜÁ¬ÉÏÂ𣬶Է½ÏµÍ³ÉÏÒª×öÐ©Ê²Ã´ÄØ¡£
¶ÔÊý¾Ý¿â±È½Ï¸ÐÐËȤ£¬¿Éϧ±ÏÒµºóû´ÓÊÂÕâ·½ÃæµÄ£¬Ã»ÕÒµ½¸ü¶àµÄÐÅÏ¢¡£
½ñÌìͻȻÓÖÏëÆðÕâ¸öÒÉÎÊÁË£¬ÓÐËÄܸøÎÒ½â»óÂð¡£
дÅäÖÃÎļþ Ö±½Ó¸ÄÁ¬½Ó×Ö·û´® ÕâÑù¾Í¿ÉÒÔÒÆÖµÁË
дÅäÖÃÎļþ
»òÊÇÔڵǼ½çÃæÉÏÌí¼ÓÑ¡ÔñÊý¾Ý¿â·þÎñÆ÷¸úÊý¾Ý¿âÃû³Æ.
Ó¦¸Ã¾ÍÐÐÁ˰É
Èç¹û±¾µØ°æ±¾µÄ»°Ò»°ã¶¼ÊÇËùÓж«Î÷ÒѾ·â×°ÆðÀ´µÄ£¬°²×°Ö®ºó»áÌáʾÊäÈësqlÓû§ÃûºÍÃÜÂëµÄ
¿´ÄãµÄ³ÌÐòÔõô´¦ÀíÊý¾Ý¿âÁ¬½ÓµÄÁË£¬¿ÉÒÔÓÃÅäÖÃÎļþÒ²¿ÉÒÔÓÃ×¢²á±í
Ïà¹ØÎÊ´ð£º
PBÖпª·¢µÄ¡£
DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)
string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+&q ......
DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)
string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+"') and (EndTime ......
´ó¼Ò°ïæ¿´¿´Õâ2¸ösqlÓï¾äÄĸö²éѯµÄËٶȸü¿ìµã¡£Ð»Ð»°ïæ¡£±È½Ï׿±¡£ÔÚ×öÐÔÄܲâÊÔ¡£
select * from
±íA LEFT OUTER JOIN ±íB ON (±íA.id || ' ' =±íB.id) ,±íC , ±íD, ±íE
WhereÆäËûÌõ¼þ
select * ......
C#ÈçºÎÅжÏÁ¬½Ósql serverÊý¾Ý¿â³É¹¦£¿
try
{
connection.connect()
return true;
}
catch()
{
return false;
}
Â¥Ö÷ºÜ׿±£¬¿ªÁ˼¸ÌùÁË¡£
ÒýÓÃ
try
{
connection.connect( ......
ÒÑÖª´ÓB,±íÖÐÕÒ³öID, NAMEÁ½ÏîÓëC±íÏàͬµÄÊý¾Ý£¬ÔÙÒÀ¾ÝB±íÖо¹ý²éѯ³öÀ´µÄID,CODEÁ½ÏîÊý¾Ý²éѯÓëA±íID,CODEÁ½ÏîÏàͬµÄÊý¾ÝÖжÔÓ¦µÄEMAILÀ´£¬²¢ÁгöÈçÏÂD±íµÄÐÎʽ£¬²»ÖªÎÒÊÇ·ñ±íʾÇå³þ£¿Âé·³°ïÎÒÁÐһϹ«Ê½ºÃÂð£¿Íò· ......