ÔÚ.net ÓÃwinform datagridviewÏÔʾMySQLÊý¾Ý¿â±íÖÐÊý¾Ý£¬ÌáʾInt32ֵ̫´ó»ò̫С
²»Ã÷°×£¬¶¥Ò»ÏÂ
²»ºÃÒâ˼дµÄÓеãÂÒ£¬
ÓÃwinformÖÐ µÄdatagridview¿Ø¼þÏÔʾMySQLÊý¾Ý¿â±íÖÐÊý¾Ýʱ£¬Ìáʾ£º¶ÔÓÚInt32ֵ̫´ó»ò̫С
ÊÇÓëÊý¾Ý¿â±íÖÐ×Ö¶ÎÖµÀàÐÍÓйأ¬»¹ÊǿؼþÊôÐÔÉèÖÃÎÊÌâ
{{ ......
ÓÃmysqlǰ̨Èí¼þ £¬ ÎÒÔÚtest¿âϽ¨¸ötable ¿ÉÊÇ ÀÏ·¢ÉúÒ»ÑùµÄÎÊÌâ £¬ ÎÒ°ÑÑ¡Ïî¶¼Ò»¸öÒ»¸ö³¢ÊÔÁË ¿É¶¼²»ÐÐ £¡
Çë ¸ßÊÖ½øÀ´½âÄÑ! ¼±£¡
Ìáʾ£º²»ÄÜð¤Ìù ÂÔ
ʲôÎÊÌâѾ£¿ËµÇå³ýÈü
ÓÉÓÚ²»ÄÜð¤Ìù ¾ßÌåÒ²ºÜÄÑ˵Çå³þ
ÏÖÔÚ Ö»ÏëÎÊ ÔÚmysql query browserÈí¼þ £¨MySQLǰ̨Èí¼þ£© ÈçºÎÔÚÒ»¸ö¿âÀï¼Ó±í ......
[s:2]ÊäÈëÕâ¶Î´úÂë³öÏÖÒÔϵĴíÎóÌáʾ£º
<?php
$host="localhost";
$username="root";
$password="root";
if($connid=mysql_connect($host,$username,$password)){
echo"<script language='javascript'>alert('Êý¾Ý¿âÁ¬½Ó³É¹¦');</script>";
}else{
ech ......
A±í
×Ö¶Î
A B
Öµ
A001 a1
A001 a2
A001 a3
B001 b1
B002 b2
B±í
×Ö¶Î
A C
A001 c1
B001 c2
B002 c3
ÒªÇóЧ¹û
A001 a1,a2,a3 c1
B001 b1 c2
B002 b2 c3
ÄÜÓÃsqlʵÏÖÂð
......
ÎÒÔÚ±íµ¥ÖÐÊäÈ룺×Öĸ£¬Êý×Ö£¬¿Õ¸ñ£¬¶¼¿ÉÒÔ²åÈëµ½mysqlÖÐ
µ«ÊÇÎÒÊäÈëÖÐÎÄʱ£¬¾ÍËÀ»î²å²»½øÊý¾Ý¿â
ÒòΪÓÃget·½Ê½°ÑÖÐÎͼ±àÒë³ÉÁËÒ»´®×Ö·û´®£¬ÆäËû·½Ê½µÄÊäÈëµÄ¶¼ÊÇûÓбäµÄ
¹À¼ÆÊÇ´«ÖµµÄÎÊÌ⣬µ«ÊDz»ÖªµÀÔõô½â¾ö
´úÂëÈçÏ£º
PHP code:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN&qu ......
ÎÒ½¨Á˸ö±í ÓÉÓÚÒª´æ´¢±È½Ï´óÁ¿µÄÎÄ×Ö
ËùÒÔÀàÐÍÓõÄÊÇtext
µ«ÊÇÎÒÔÚÓÃÍøÒ³ºǫ́дÈëÊý¾ÝµÄʱºòÌáʾ
Incorrect string value: '\xD5\xA2\xB7\xA7\xC6\xD0...' for column 'bt' at row 1
Ö»ÒªÓÃÖÐÎľͳöÏÖ ±àÂëÀàÐÍÎÒÓõÄÊÇGBK ÓÐûÓÐÈËÄܽâ´ðÏÂ
ת³Éutf-8ÄØ£¬²»ÕýÈ·µÄ×Ö·ûÖµ
ת³Éutf-8Ò²Ò»Ñù »¹ÊDz»ÐÐ
ÍøÒ³Ê¹Óõ ......