°ï°ïæ datatable SQLÓï¾ä
ÎÒÓÃAdapter ºÍ Fill() ÕâÖÖ·½Ê½ÏëdatasetÌí¼ÓÁËÒ»¸ö±í ÆðÃûΪTable_Score
±íÖÐÓÐÒ»ÁмǼµÄÊÇ·ÖÊý
ÎÒÏëÓà MAX() Çó³öÕâÒ»ÁзÖÊýµÄ×î´óÖµ È»ºó¼Ç¼ÏÂÕâ¸ö×î´óÖµ ºó±ßÓÐÓá£
string sqlstr="SELECT MAX(Score) AS ×î´ó·ÖÖµ from Table_Score WHERE ItemID='02010102'";
SqlÓï¾ä²»ÖªµÀдµÄ¶Ô²»¶Ô ½ÓÏÂÀ´ÓÖ¸ÃÔõÑùÐ´ÄØ?
ÎÒ³¢ÊÔ×ÅÈçÏÂдÁËд
SqlCommand cmd = new SqlCommand(sqlstr, conn);
SqlDataReader reader = cmd.ExecuteReader();
È»ºóÓÃreader¶ÁÈ¡×î´óÖµ µ÷Á˰ëÌì²»¶Ô
Çë´óÏÀÖ¸µãÏ »òÕ߸ø¸ö˼·°É ¸Ð¼¤ÌéÁ㣡£¡£¡
public static DataSet GetDataSet(string sql)
{
SqlDataAdapter sda =new SqlDataAdapter(sql,ConnectionString);
DataSet ds=new DataSet();
sda.Fill(ds);
return ds;
}
´Ó·µ»ØµÄdatasetÀïȡֵ
ľÓÐÎÊÌâ°¡£¬¹Ø¼ü¿´ÄãºóÃæµÄ´úÂëÊÇÔõôдµÄ£¬reader¶ÁÊý¾ÝµÄÄǶÎ
ÄãÌí¼ÓµÄ±íÌíµ½Êý¾Ý¿âÀïÁËô£¬Èç¹ûÖ»ÊǶÔdataset²Ù×÷Óò»µ½sql
C# code:
string sql="SELECT MAX(Score) AS ×î´ó·ÖÖµ from Table_Score WHERE ItemID='02010102'";
Sq
Ïà¹ØÎÊ´ð£º
±¾ÈËc#ÐÂÊÖ ¿ÉÊÇÒªÇóÒªÓÃc# £¬sql2000¿ª·¢c/sµÄ¹¤×÷Á÷£¬Ò»Í·ÎíË®£¬Çë´ó¼Ò°ïæ°ï棬¸øµã˼·£¬ËµµÄÔ¼¾ßÌåÔ½ºÃ£¬ÎÒÒ²ºÃÍùÄǸö·½ÃæÈ¥Ñ§Ï°
http://www.hxzi.com/view/61402.html
B/S°æµÄ£¬»ù±¾Ë¼ÏëÓ¦¸Ã²î²»¶àµÄ¡£¡£ ......
½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿
21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......
ÎÒÓõÄÊÇmysql5.1£¬Êý¾Ý¿â×Ö·û¼¯Îªutf8
ͨ¹ýdosÃüÁîÐе¼ÈëSQLÎļþ ³ö´í£¬ÎÞ·¨µ¼Èë¡£
½«SQLÎļþÖеÄÊý¾ÝÈ«²¿Ê¹ÓÃÓ¢ÎÄ ¿ÉÒÔµ¼Èë
ÇëÎÊÎÊÌâÔÚÄÄ£¿
×°¸öÖÐÎÄÈí¼þ¼´¿É.
ºÜ¶àÄêÒÔǰ,Óùý¸öÒ»¸ ......
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
Êý¾Ý±í¡¾biao¡¿£¬
×ֶΣºid¡¢myname¡¢mytxt
mytxtÄÚÈݸñʽÐÎÈ磺n|abcd¡££¨ÀýÈ磺1|ÁõµÂ»ª£¬2|Èδﻪ£¬3|αÌϼ£¬4|Âõ¿Ë@½Ü¿ËÑ·£©
ÎÒÏÖÔÚÏ£Íû¶Á¼Ç¼³öÀ´ºó£¬°´ÕÕ[mytxt]×Ö¶ÎÀïµÄÊúÏߣ¨|£©Ç°ÃæµÄÄǸöÊý× ......