ÏÖÔÚÕý×öÒ»¸öÏñSQL Server2005ÄÇÑùµÇ¼µÄWinForm³ÌÐò,ÎÒ¸ÃÈçºÎʵÏÖ?
ÔÚÍøÉϲéÕÒÁ˺ܾÃ,¶¼Ã»ÕÒµ½Ïà¹ØµÄ...
ÔÚMainÖÐÏȵ÷Óõǽ´°¿Ú,³É¹¦ºóÔÙÏÔʾÖ÷´°¿Ú
ÎÒÏÖÔÚҪʵÏÖµÄÊÇÏñSQL Server 2005ÄÇÑù½øÐеǼ,Á¬½ÓÊý¾Ý¿âµÄ²¿·Ö¸ÃÈçºÎʵÏÖ?
---------- ADO.NET
´°ÌåÉè¼ÆÈçͼ£¬´úÂë²Î¿¼ÈçÏ£º
C# code:
SqlConnection sqlConn;
string sqlConnStr = "";
SqlConnectionStringBuilder sqlConnStrBuilder = new SqlConnectionStringBuilder();
sqlConnStrBuilder.DataSource = txtDataSource.text;
sqlConnStrBuilder.InitialCatalog = txtDataBase.text;
sqlConnStrBuilder.UserID = txtUsr.text;
sqlConnStrBuilder.Password = txtPass.text;
sqlConnStr = sqlConnStrBuilder.ConnectionString;
sqlConn = new SqlConnection(sqlConnStr);
try
{
sqlConn.Open();
if (sqlConn.State == ConnectionState.Open)
MessageBox.Show("Á¬½Ó³É¹¦£¡");
else
MessageBox.Show("Á¬½Óʧ°Ü£¡");
}
catch
{
MessageBox.Show("Á¬½Ó·¢ÉúÒì³££¡");
}
Ïà¹ØÎÊ´ð£º
±¾ÈËÕýÔÚÓÃJava×öÒ»¸öC/S¼Ü¹¹µÄÏîÄ¿£¬
¿ÉÊÇÓÉÓÚÏîÄ¿±È½Ï´ó£¬Ç°ÆÚ¶Ô¼Ü¹¹µÄÉè¼ÆÓÈÆäÖØÒª£¬ÒòΪºóÆÚ¿ÉÄÜËæÊ±»á¼Ó¸ö¹¦ÄÜ»òÕßÈ¥µôijЩ¹¦ÄÜ¡£
ËùÒÔÌØµØÑ°ÇóÈçºÎÉè¼ÆC/SµÄ¼Ü¹¹Ê¹³ÌÐò¸ü¼ÓÃæÏò¶ÔÏó¸ü¼ÓÒ×ÓÚά ......
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......
×Ö¶Î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 ......
visual c++2008Ëٳɰ棬²»ÄܱàÒëC³ÌÐòÂð£¿Èç¹ûÄÜÊÇÔõô¿ªÊ¼µÄ°¡£¿ÓÃËü´øµÄÃüÁîÌáʾµ¥Ôª³ýÍâ ¡£
н¨¹¤³Ì£¨¿Õ¹¤³Ì»òwin32¿ØÖÆÌ¨£©
¾ø¶Ô¿ÉÒÔ¡£½¨Á¢win32¿ØÖÆÌ¨³ÌÐò¾Í¿ÉÒÔ
ÒýÓÃ
н¨¹¤³Ì£¨¿Õ¹¤³Ì»òwin32¿ØÖÆÌ¨£ ......
ÐèÇóÈçÏ£º
ѧԺ 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 ......