c# ²Ù×÷sql - .NET¼¼Êõ / C#
c# ÔÚ²Ù×÷SQLʱ¡£¼ÙÉèSQLûÓеǼ£¬ÔÚc#дµÄ¿Í»§¶ËÖÐÏëÒªÓÃÓï¾ä²Ù×÷¡£¿ÉÒÔÕâÑù²»£¿
²»¿ÉÒÔ¡£
ÏÈÁ¬Êý¾Ý¿â¡£
SQlûµÇ¼ÊÇɶÒâ˼£¿
Ò»°ã²Ù×÷Êý¾Ý¿âʱ ÏÈÒªÁ¬½Ó SqlConnection ¡£¡£¡£¡£
ÔÙ²Ù×÷
ʲôÒâ˼°¡£¬ÄãµÄÒâ˼ÊÇûÓÐÁ¬½Ó×Ö·û´®Âð£¿
SQL ûÓеǼÔõôÄÜÁ¬ÉÏÄØ
Á¬½ÓÊý¾Ý¿â²ÅÄܲÙ×÷£¬ÒªÓÐÒ»¸ö½»»¥µÄ¹ý³Ì£¬¾ÍÏñÓжþ¸öµã£¬ÐèÒªÒ»¸ùÏßÁ¬½Ó¡£¼´Ê¹ÊÇÎÞÏߵ绰£¬Ò²ÊÇÐèÒªµç²¨µÄ
Ó¦¸ÃÏÈÓôúÂëÁ¬½ÓÊý¾Ý¿âÔÚ½øÐвÙ×÷
using(SqlConnection conn=new SqlConnection(""))
{
conn.open();
}
ÌâÄ¿²»ÊǺÜÇåÎú£¬²»¹ýÉÏÃæµÄ´ó¶¼ËµÁË
²»¿ÉÒÔ£¬ÏÈÁ¬Êý¾Ý¿â
ÏȵÃÁ¬½ÓÊý¾Ý¿â È»ºó²ÅÄÜʹÓÃÊý¾Ý¿â
ÄãÄܲ»ÎÊÌâ˵Ã÷°×ЩÂð
ÏÈÁ¬½ÓÊý¾Ý¿â°¡ ûÓÐÁ¬½ÓʲôҲ¸É²»ÁË
ÏÈÁ¬½ÓÊý¾Ý¿â°¡ ûÓÐÁ¬½ÓʲôҲ¸É²»ÁË
»ØÈ¥ºÃºÃ¿´¿´ÀíÂÛ֪ʶÔÙÎÊ
ºÇºÇ£¬Â¥Ö÷µÄÒâ˼Ӧ¸ÃÊÇSQLÖ÷³ÌÐòû´ò¿ª¡£
¿ÉÒԵģ¬Ö»ÒªÄãµÄÊý¾Ý¿â´æÔÚ£¬Êý¾Ý¿âÁ¬½Ó×Ö·ûÕýÈ·£¬¶¼ÊÇ¿ÉÒԵġ£
ÏÈÒªÁ¬½Ó SqlConnection ¡£¡£¡£¡£
ÏëÒªÓÃÓï¾ä²Ù×÷,µ±È»Òª·ÃÎÊÁ¬½Ó´ò¿ªÊý¾Ý¿âÖ®ºó²ÅÄܽøÐвÙ×÷ÁË....
¿Ï¶¨ÒªÊÇÏÈÁ¬Êý¾Ý¿âµÄ£¡
ÄãÒªÓë²Ù×÷Êý¾Ý¿â£¬Ê×ÏÈÒª´ò¿ªÁ¬½Ó°¡£¬Â¥Ö÷¿ÉÒÔ¿´¿´¼òµ¥µÄÊý¾Ý¿âÁ¬½ÓÓï·¨
Â¥Ö÷ÊÇ˵ûÁ´½ÓÊý¾Ý¿â¿É²»¿ÉÒÔ²Ù×÷»¹ÊÇ˵û´ò¿ªÊý¾Ý¿â¹ÜÀíÆ÷¿É²»¿ÉÒÔ²Ù×÷£¿£¿
SqlConnection conn=new SqlConnection("")
sqlûÓеǼ£¿£¿Ã»ÓÐÁ´½ÓÊý¾Ý¿âµÄ»°ÏÈÁ´½ÓÊý¾Ý¿â
Èç¹ûÓÐÁ´½ÓÊý¾Ý¿âµÄÓï¾ä£¬·þÎñÆ÷¶ËÊÇ¿ªÆôµÄ»°¿ÉÒÔ·ÃÎÊ
Ïà¹ØÎÊ´ð£º
дÁ˸ö²âÊÔ³ÌÐòÈçÏÂ
struct hostent *hp;
char AlarmDevIP[20];
int x2;
hp = gethostbyname("www.google.com");
if (hp)
{
......
×Ö¶Î1,×Ö¶Î2.....×Ö¶ÎN,Status,ParentID
1,Name1....test1,1,99
1,Name1....test1,3,99
1,Name2....test2,1,101
1,Name2....test2,3,101
1,Name3....test3,2,101
1,Name1....test1,4,101
ÏëÒªµÄ½á¹ûÊÇ:
1,Na ......
ÐèÇóÈçÏ£º
ѧԺ academy£¨aid,aname£©
°à¼¶ class£¨cid,cname,aid£©
ѧÉú stu(sid,sname,aid,cid)
סËÞÇø region(rid,rname)
ËÞÉáÂ¥ build(bid,rid,bnote) bnoteÊÇ¡®ÄС¯/¡®Å®¡¯
ËÞÉá dorm(did,rid,bid£¬bedn ......
ÎÒ¸Õ°ÑÌ·ºÆÇ¿µÄµÚÈý°æµÄÊéѧÍ꣬ÎÒÖªµÀµÄÓÐC++£¬CºÍÖ¸Õë CȱÏݺÍÏÝÚå Cר¼Ò±ä³É£¬»¹ÓÐÊý¾Ý½á¹¹£¬ÎÒÏëÎÊÎÊÎÒÓ¦¸ÃÒÔʲô˳ÐòÀ´Ñ§ÄØ
CȱÏݺÍÏÝÚå Cר¼Ò±à³Ì
Êǽø½×µÄ£¬²»Óü±×Å¿´
ÖÁÓÚ
CºÍÖ¸Õë
Äã²»Àí½âÖ ......
A±í ÓÐÁ½¸ö×Ö¶Î
id ΨһÊý×ÖÓò
InfoTxt text ÀàÐÍ
ÎÒÏÖÔÚÒª°Ñ id ²»ÊÇ14 µÄËùÓÐ InfoTxt×Ö¶Î Îı¾ºóÃæ ¶¼¼ÓÉÏ 'aaa'
°´ÏÂÃæÖ´ÐÐÏÂÀ´ Ö»Óбí×îºóÒ»ÐмÓÉÏÁË 'aaa' ......