ÏÖÔÚÕý×öÒ»¸öÏñ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("Á¬½Ó·¢ÉúÒì³££¡");
}
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
ÇëÎÊVFPÖÐÈçºÎµ÷ÓÃC/C++º¯Êý£¿
ÄãÒªµ÷ÓÃʲô¹¦Äܵĺ¯Êý£¿Òª¿´¿´VFPÖÐÓÐûÓжÔÓ¦µÄº¯Êý£¬Èç¹ûÓоÍÊ¡×ÅÔÙµ÷ÓÃÁË¡£Èç¹ûûÓУ¬¿ÉÒÔ½«C/C++º¯Êýд¸öDLL»òFLL£¬È»ºóÔÚVFPµ÷Óü´¿É¡£
Ê®¶¹Èý ÀÏʦ£¬Ôõô²ÅÄÜÐÞ¸Ä×Ô¼ºµÄ ......
txt ºÍXML ¸ñʽÏàÓ¦
²»½èÖúDataSet
µ¼Èë¶ÁÈ¡TXTÎļþ
È»ºóÖ±½ÓдÈëXML(ͬһÎļþ,²»Í¬Êý¾Ý,µÝÔöÔÊý¾ÝûÓб»¸²¸ÇÇé¿öÏÂÔö¼ÓÊý¾Ý.)
½Ì¸öÒªµã»ò×îºÃÊÇÓиö´úÂëÌáʾµÄ
¹ý·ºÃºº °ï¸öæÈö^^
²»»á£¬°ïÂ¥Ö÷ ......
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
ÔھƵê¹ÜÀíϵͳÖÐ,ÓÐÒ»¸ö¶ÔÄÚµÄϵͳ,¹©Ç°Ì¨·þÎñÔ±ºÍ¾ÀíʹÓÃ
»¹ÓÐÒ»¸ö¾ÍÊǶÔÍâ,Èÿͻ§¿ÉÒÔÔÚÍøÉÏÔ¤¶©·¿¼ä,
ËüÃÇÖ®¼äÊÇÔõôͨѶµÄ.?µ±ÎÒÌá½»Ô¤¶©·¿¼äÐÅÏ¢µÄʱºò,
ÔÚ¶ÔÄÚµÄϵͳÖÐ,ÈçºÎÖªµÀÎÒÒѾÌá½»ÁËÐÅÏ¢¹ýÈ¥.Ê¹Ç ......