ʹÓÃLabVIEWº¯ÊýʵÏÖSQL Server²Ù×÷
º¯ÊýλÖ㺻¥Áª½Ó¿Ú-->databse
º¯ÊýÒ»ÀÀ£º
Ö÷Òª½éÉÜÉÏÃæÒ»ÐÐ
1. DB Tool Open Connection.vi
¼ò½é£ºÊ¹ÓÃÁ¬½ÓÐÅÏ¢´ò¿ªÒ»¸öÊý¾Ý¿âÁ¬½Ó£¬È»ºó·µ»ØÒ»¸öÁ¬½ÓÒýÓá£ÈôÁ¬½Ó³É¹¦Ôò´íÎó´ØÀïÃæµÄStatus»á·µ»ØÎªFalse£¬ÈôÁ¬½Óʧ°ÜÔòStatus·µ»ØÎªTrue¡£ connectioninformation¸ñʽ£º
Driver=SQLServer;Server=.; Database=UserInfo;Uid=sa; Pwd=Aa123789 1£©DriverΪÁ¬½ÓµÄÊý¾Ý¿âÀàÐÍ£¨È磺SQL Server¡¢Access£© 2£©DatabaseΪËùÐèÒªÁ¬½ÓµÄÊý¾Ý¿â
3£©UidΪÊý¾Ý¿âµÇ¼ÕË»§£¬±¾°¸ÀýʹÓõÄÊÇsaÕË»§ 4£©PwdΪsaÕË»§¶ÔÓ¦µÄÃÜÂë ʾÀý£º
À©Õ¹£ºÀûÓôíÎó´ØÕ¹Ê¾Êý¾Ý¿âÁ¬½Ó״̬
¼ò½é£ºÁ¬½Óʧ°ÜÔò¡°Êý¾Ý¿âÁ¬½Ó״̬¡±ÀïÃæµÄÎı¾ÏÔʾΪºìÉ«£¬²¢ÌáʾÁ¬½Óʧ°Ü 2. DBTool Close Connection.vi
ͨ¹ýÏú»Ù¹ØÁªµÄÁ¬½ÓÒýÓÃÀ´¹Ø±ÕÒ»¸öÊý¾Ý¿âÁ¬½Ó
3.Database Variant To Data.vi
½«Êý¾Ý¿âÊä³öµÄ±äÌåת½âÎö³ÉËùÐèÊý¾Ý,¡£ÆäÖУ¬Type£¨´Ø³£Á¿£©ºÍdata£¨´ØÀïÃæµÄ¿Ø¼þΪÊä³ö¿Ø¼þ£©Êý¾ÝÀàÐͺ͸ñʽÐèÏàͬ¡£
4. DBTools List Columns.vi
ÁгöÊý¾Ý¿â±íÖÐËù°üº¬µÄÁУ¨Êä³öΪÊý×éÀàÐÍ£©ºÍÏà¹ØÁÐÐÅÏ¢£¨´ØÊý×飩¡£ÆäÖУ¬ÁÐÐÅÏ¢ÀïÃæµÄ´Ø°üº¬ÁÐÃû¡¢Êý¾ÝÀàÐͺͱ»¶¨ÒåµÄ´óС¡£ 5. DBTool Insert Data.vi
¼ò½é£ºÌí¼ÓÒ»¸öеÄÐе½Ö®Ç°Á¬½ÓµÄÊý¾Ý¿âµÄ±íÄÚ¡£ÆäÖÐdataΪ±äÌåÊý¾ÝÀàÐÍ£¬±äÌåÄÚ´æ·ÅµÄÊÇ´Ø£¬´ØÄÚ¿ÉÒÔ´æ·Å¶àÖÖÊý¾ÝÀàÐÍ¡£
ʾÀý£ºÏòAlarmDataÀïÃæÌí¼Óʱ¼äºÍ´íÎó´úÂë