sql c#
ÔÚC#winFormÖÐÔÚÒ»¸ötextboxÖÐÊäÈë3~5£¬ÎÒҪдÌõsqlÓï¾ä¾ßÓÐselect * from S where sn between 3 and 5µÄ¹¦ÄÜ
3~±íʾ´óÓÚ3£¬ ~5±íʾСÓÚ5£»
ÔõÑùÔÚsqlÖн«textboxÖÐ3~5·Ö³É3ºÍ5£»
indexof("~")ÕâÑù¿ÉÒÔÅж¨~·ûºÅµÄλÖã¬"~"ÒÔǰµÄ¾ÍÊÇ3£¬"~"ÒÔºóµÄ¾ÍÊÇ5
substring2´Î
indexof£¨~£©
½ØÈ¡Ê± °Ñ ÕÒµ½µÄ~λÖà -1ÕÒµ½3 +1 ÕÒµ½5
string str_condition=textbox.text;
string[] conditions=str_condtion.split('~');
conditions[0]=3 //'~'Ç°ÃæµÄÊý
conditions[1]=5 //'~'ºóµÄÊý
²»Ã÷°×È¥ÎҵĸöÈËÖ÷Ò³http://game.1c2c.com.cn
3~5
string[] arr=textbox.text.Split(new char[]{'~'},StringSplitOptions.RemoveEmptyEntries);
if(textbox.test=="3~5")
{
sql=select * from S where sn between 3 and 5
}
±¾ÈËÓÞ¼û£¡
string str_condition=textbox.text;
string[] conditions=str_condtion.split('~');
conditions[0]=3 //'~'Ç°ÃæµÄÊý
conditions[1]=5 //'~'ºóµÄÊý
indexof("~")ÕâÑù¿ÉÒÔÅж¨~·ûºÅµÄλÖã¬"~"ÒÔǰµÄ¾ÍÊÇ3£¬"~"ÒÔºóµÄ¾ÍÊÇ5
Ö§³Öindexof£¨£©
split£¨"",~£© È»ºó·ÅÔÚÊý¾ÝÀïÃæ
Ïà¹ØÎÊ´ð£º
txt ºÍXML ¸ñʽÏàÓ¦
²»½èÖúDataSet
µ¼Èë¶ÁÈ¡TXTÎļþ
È»ºóÖ±½ÓдÈëXML(ͬһÎļþ,²»Í¬Êý¾Ý,µÝÔöÔÊý¾ÝûÓб»¸²¸ÇÇé¿öÏÂÔö¼ÓÊý¾Ý.)
½Ì¸öÒªµã»ò×îºÃÊÇÓиö´úÂëÌáʾµÄ
¹ý·ºÃºº °ï¸öæÈö^^
²»»á£¬°ïÂ¥Ö÷ ......
DataSetµ¼³öxml Åú´¦Àí(Ñ»·)µÃÔõô´¦Àí
XMLÎļþ
<A>
<B>
<C>
</C>
&nb ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
<table style="width: 1000px"><tr>
<td style="height: 38px; width: 35px;">
ÐÕÃû</td>
......
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......