Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÓÃvisual studioµÄÅóÓѽøŶ£¡mssqlÎÊÌ⣡

ÎÒʹÓÃÁËsharpdevelop×öѧϰ£¡ÔÚdata¹¤¾ß¿¨ÖÐÖ»ÓÐÁÈÁȼ¸¸ö


Óûä¯ÀÀmssqlÊý¾Ý¿âtestÖÐijһÕÅ±í¡£Ã²ËÆû·¢ÏÖɶ¿Ø¼þ¡£ÓÃÁËviewºÍsourceµÄ¡£
ûÓÐÉèÖõĵط½£¬¿¨ÔÚÕâÀï´ó¸ÅºÃ¼¸¸öСʱÁË¡£baidugooleÎÞ¹û¡£
À´Ñ°Çó´ïÈË°ïÖú

mssqlÀïµÄtest¿âÀïµÄtabletest±íÀïÓÐname×ֶκÍage×Ö¶Î
¸ñʽÊÇ
name age
СÍõ 15
ÕÅÈý 20
Ï£Íû´ïÈËÖ¸½ÌÈçºÎͨ¹ýʹÓÃ
C# code:

SqlConnection con = new SqlConnection();
con.ConnectionString="server=127.0.0.1;database=test;uid=sa;pwd=2150255;";
con.Open();
string sql="select * from tabletest";

µÈÓï¾äʵÏÖ

Õâ¸öЧ¹û

µ¯³öÕâЩÊý¾Ý£¡

ͬʱÎÊһϡ£Visual studioÀïÓпìËÙµÄÉèÖõÄÂ

»òÕ߸æËßÎÒsharpdevelopÀïÈçºÎ¿ìËÙͨ¹ýÉèÖÃdatagridview¿ìËÙä¯ÀÀÊý¾Ý¿âÄØ£¿


100·ÖСÈâ²»³É¾´ÒâΪÄú·îÉÏ£¡

sharpdevelop
ÕⶫÎ÷ûÓùý,ºÇºÇ

ûÓùý¡£

·ÅÊÇDataGrid,ÔÚÍÏÒ»¸öBindSource³öÀ´.
ÉèÖÃDataGride µÄÊý¾ÝÔ´. ÔËÐм´¿É¿´µ½Êý¾Ý

¶¥~

ʹÓÃbindingSource
String connectionString =""£»
dataAdapter = new SqlDataAdapter(selectCommand, connectionString);
SqlCommandBuilder commandBuilder = new SqlCommandBuilder(dataAdapter);
DataTable dt= new DataTable();
dataAdapter.Fill(dt);
bindingSource1.DataSource = dt;


Ïà¹ØÎÊ´ð£º

¹ØÓÚMSSQLÔ¼ÊøÃû³ÆµÄÎÊÌâ - MS-SQL Server / »ù´¡Àà

×ֶεÄĬÈÏÖµÔ¼ÊøÉúËùµÄÔ¼ÊøÃû³Æϵͳ³£³£ÔÚºóÃæÌíÉÏÒ»¸öËæ»úµÄ×Ö·û´®£¬
Èç
DF__Admin__locked__014935CB
ÕâÑùÔì³ÉÒÔºóÔÚÐ޸ĸÄÔ¼ÊøµÄʱºòºÜÂé·³£¬ÔõôÉèÖò»ÈÃÊý¾Ý¿â×Ô¶¯Éú³ÉÕâÑùµÄËæ»úÃû³ÆµÄÔ¼ÊøÃû³Æ
¶øÏòÕâÑù ......

Mssql2005 xml ²éѯ ʹÓà exist - .NET¼¼Êõ / C#

SQL code:

@uid int
@money float
If not exists(SELECT null from bc_users_table where bet_id=@uid and bet_hk_rationing.exist('/root/items[@straight_bet>'+@money+']') = 1)
--BEGIN
......

php´Ómssql¶ÁblobÀàÐÍÏÔʾͼÏñ - PHP / »ù´¡±à³Ì

ÒòϵͳÐèÇ󣬽«Í¼Ïñ·ÅÈëmssqlÖУ¬×Ö¶ÎÀàÐÍΪblob£¬Í¼ÏñΪjpgÀàÐÍ£¬ÈçÏ´úÂëÖ´ÐÐʱ²¢²»ÄÜÕýÈ·Êä³öͼÏñ£¬Âé·³¸÷λ°ï濴һϣ¬·Ç³£¸Ðл!!
<?php
  include_once("db.class.php");
// retr ......

php5.3Ö§³ÖmssqlÂð - PHP / »ù´¡±à³Ì

°²×°²»ÁËmssql£¬ÈçºÎÅäÖÃÄØ
ûÈË

extension=php_mssql.dll
°²×°ÕýÈ·Á˺󣬸ÄPHP¡£INIÔÙÖØÆð¡£

php startup:unable to load dynamic library 'ext\php_mssql.dll - ÕÒ²»µ½Öƶ¨µÄÄ£¿é

Ö§³ÖµÄ
»¹ÊǺ£ÔôÃÔ ......

mssqlÊý¾ÝתÒƵ½mysql - PHP / »ù´¡±à³Ì

×î½ü¹«Ë¾»»Êý¾Ý¿â£¬mssql »» mysql ¡£´ó¼ÒÓÐʲôºÃµÄ·½·¨°¡£¡
  ²»ÓÃphpת»»£¬´æÔÚÊý¾ÝÄ£Ð͵ÄÎÊÌâ¡£±¾È˺ÜÏëÓÃphp£¬¿ÉÊÇmssqlÀ©Õ¹Ôõô¶¼¼ÓÔز»ÉÏ£¬¸ãÁËÒ»Ììû¸ãÃ÷°×£¡»·¾³ÊÇ£ºapache2.2.4£¬php5.3.2£¨°²×°³ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ