Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 / »ù´¡Àà

ÎÒ¶¨ÒåÒ»¸öº¯Êý£¬ÓÐÎå¸ö²ÎÊý
µ«Êµ¼ÊÉÏÎÒµ÷ÓÃʱ²»Ò»¶¨´«Îå¸ö²ÎÊý£¬ÓÐʱֻÐèÒª´«¶þ¸ö²ÎÊý£¬ÓÐʱֻÐèÒª´«Èý¸ö²ÎÊýµÈµÈ
ÕâÖÖ²ÎÊýÔõô¶¨ÒåÄØ£¿
SQL code:
CREATE FUNCTION [ owner_name.] function_name
( [ { ......

mssql´æ´¢¹ý³ÌÖÐÈÝ´í´¦Àí - MS-SQL Server / »ù´¡Àà

exec YYys 'aa' aaÊÇmssql·ÇÕýÈ·µÄÓï¾ä,
ÀïÃæÊÇͨ¹ý exec (@sql)--ÉÏÃæaaËù´«µÝµÄ²ÎÊý¾ÍÊÇ@sqlµ÷Óõģ¬Èç¹ûÈçºÎÈÃexec @sql³ö´íºó´æ´¢¹ý³ÌÄÜÊä³ö´íÎó¡£
Õâ¸ö?
Ã²ËÆºÜÄÑ,ÀàËÆÈËΪ´íÎóÖ»ÄÜ´ÓÐÐÕþ·½ÃæÈëÊÖ.

ûÀí½ ......

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

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

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

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

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

MSSQL¿ç¿â¸üÐÂÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

UPDATE a
SET a.KeyNum=(SELECT COUNT(b.CI_ID) from myTab.dbo.CI_SinKey as b
where CONTAINS(b.SearchKey,a.KeyName)
)
from myKey.dbo.SearchKey as a
where KeyNum=0
Õâ¸öÊÇ´íÎóµÄÓï¾ä£¬ÏàÐÅ´ó¼Ò¿ÉÒÔ¿´¶® ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ