SQL Report Service 2008 ·ÃÎÊÌáʾÓû§ÃûºÍÃÜÂë
×î½üʹÓÃSQL Report Service 2008¿ª·¢±¨±í£¬ÔÚ¹«Ë¾Ã»ÎÊÌ⣬µ«»Ø¼Ò°²×°SqlServer2008 ºó£¬Ê¹Óñ¨±í£¬ÔÚ¿ª·¢µÄʱºòÔ¤ÀÀûÎÊÌ⣬µ«ÊDZ¨±í²¿Êðµ½·þÎñÆ÷ºó·ÃÎÊʱ¾ÍÌáʾÊäÈëÓû§ÃûºÍÃÜÂ룬µ«ÎÞÂÛÎÒÊäÈëʲô¶¼²»ÐУ¬ºÜÓôÃÆ¡£
×Ô¼ºµçÄÔXP ¹«Ë¾windows server 2008
iis Ò²²»ÊÇͬһ¸ö°æ±¾¡£
×î¸Õ½Ó´¥Õâ¸ö¶«¶«£¬ºÜ¶à²»¶®£¬ÕýÔÚѧϰÖУ¬Çë¸ßÊÖÖ¸½Ì¡£ÓÈÆäÊÇÏà¹ØÅäÖ÷½Ãæ¡£
лл¸÷λÁË£¬¸ÕÎÒÒ²¿´ÁËÏà¹ØÄÚÈÝ¡£ÆäÖÐÓеÄÌáµ½ÓòµÄÎÊÌ⣬¸ÕÍüÁË˵£¬×Ô¼ºµçÄÔûÓÐÁ´½Óµ½¹«Ë¾µÄÓò·þÎñÆ÷£¬ÊÇºÍÆäËûÈË×éµÄ¾ÖÓòÍø¡£ÕâЩ¶¼²»Ì«¶®¡£
Ïà¹ØÎÊ´ð£º
ÏÖÔÚÓÐÁ½¸öÒì¹¹µÄsql serverÊý¾Ý¿â,ÎÒÏ뽫µÚÒ»¸ö±íÖеÄÊý¾Ýµ¼Èëµ½µÚ¶þ¸ö±íÖÐ,×Ô¼ºÖ¸¶¨µ¼ÈëÊý¾ÝµÄ×Ö¶Î,ÈçºÎµ¼ÈëÊý¾ÝÄØ,´ó¼ÒÌÖÂÛÒ»ÏÂ?
dts¹¤¾ß
µ¼Èëµ¼³ö¹¤¾ß.
DD
¹þ¹þ£¬¹À¼ÆÕâλÊǵØQIOU¶¼Êܲ»Á˵Ä
Ö±½ÓÐ ......
DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)
string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+"') and (EndTime ......
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£
......
£¨1£©string ConnString = "server=localhost;integrated security=sspi;database=pubs;";
£¨2£©string strConnection="user uid=sa;pwd=123456;Database=test;Server=test;Connect ......