ÕâÊDzÙ×÷´úÂ룺
string strsql = "select * from user where UserID=4445";
string dbpath = Server.MapPath("App_Data/cnhww.mdb");
string strConnection = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + dbpath + ";User Id=;Password=;" ......
ÎÒÏÖÔÚÓöµ½ÕâÑùÒ»¸öÎÊÌâ:
ÏÖÔÚÓÐÒ»¸öÖ÷´°¿Ú,ÀïÃæ·ÅÁËÒ»¸öGRIDVIEW,ÓÐ2ǰ¶àÌõ¼Ç¼,¶øÇÒÔÚ´ËGRIDVIEWÀïÓÐÒ»¸öButtonField, µã»÷´Ë°´Å¥¾Í´ò¿ªÁíÍâÒ»¸ö×Ó´°¿Ú,ÎÒÓõÄÃüÁîÊÇshowModalDialog
µ±ÎÒÓùö¶¯ÌõÑ¡ÖÐijÌõ¼Ç¼,µãButtonFieldºó,¾Íµ¯³ö×Ó´°¿Ú,µ±ÎҹرÕ×Ó´°¿Úʱ,ΪʲôÖ÷´°¿ÚÓֻص½×îÉÏÃæµÄ¼Ç¼,ÓÐûÓа취ÈÃÖ÷´°¿ÚµÄ¹ö¶¯ ......
³ö´íÐÅÏ¢£º
¡°/Web¡±Ó¦ÓóÌÐòÖеķþÎñÆ÷´íÎó¡£
--------------------------------------------------------------------------------
ÎÞ·¨´ò¿ªµÇ¼ËùÇëÇóµÄÊý¾Ý¿â "I:\Rainse\Wuliu\WEB\APP_DATA\db_Wuliu_Data.MDF"¡£µÇ¼ʧ°Ü¡£
Óû§ 'xx\Administrator' µÇ¼ʧ°Ü¡£
˵Ã÷: Ö´Ðе±Ç° Web Ç ......
ÎÒÊÇÓÃgridviewµ¼³öÊý¾Ýµ½excel£¬¿ÉÒÔµ¼³ö£¬µ«ÊÇÈ´ÓÐÒÔÏ µÄÎÊÌâ
1.µ¼³öµÄ ×ÖÓз½¿ò¿ò£¬²»ÊÇÔÓÐµÄ ×Ö
2.ºÃÏñÖ»ÓеÚÒ»Ò³µÄÊý¾Ý£¬Ó¦¸ÃÓÐ10¶àÒ³µÄ
¿ÉÄÜÊǺܼòµ¥µÄÎÊÌ⣬µ«ÊÇÎÒÊÇÐÂÊÖȷʵ²»»á£¬Çë´ó¼Ò¶à¶à°ïæ
±È½Ï׿± £¬Ã÷Ìì¾ÍÒª½»¸øÁìµ¼¡£
ÒýÓÃ
Õâ¸öÒÔǰÓÐÈËÎʹýÁË£¬Ôø¾»Ø´ð¹ý
ÔÙ°ÑÌû×Ó¸øÄã·¢Ò»±é°É£º
C# code
......
A (a1,a2,a3) B±íÒ²ÊÇÈç´Ë ,²éѯA±íÖв»ÔÚB±íµÄ¼Ç¼
ÓÐûÓÐÖ÷¼üѽ£¿
ÒýÓÃ
ÓÐûÓÐÖ÷¼üѽ£¿
ûÓÐ
¿¿°¡Ã»È˻شðô
¶¼³Ô·¹È¥ÁË
ÎÒҲȥÁË
select a.a1,a.a2,a.a3,b.a1 from A a
left outer join B b on a.a1=b.al and a.a2=b.a2 and a.a3=b.a3
where isnull(b.al,'')=''
SELECT A.a1,A.a2,A.a3
from A LEF ......
½«Ñ§ÉúÑ¡¿Î³É¼¨´Ó°Ù·ÖÖÆ¸ÄΪµÈ¼¶ÖÆ£¨¼´A¡¢B¡¢C¡¢D¡¢EÎå¼¶£©¡£
ʹÓô洢¹ý³Ì
SQL code:
select case
when score >=0 and score<20 then 'E'
when score >=20 and score<40 then 'D'
when score >=40 and score<60 then 'C'
when score >=60 and score<80 then 'B'
else 'A'
select ca ......