One Method for Batch DHI Data Import into SQL-Server

Abstract : In the cow breeding process, the users also pay attention to the cow’s DHI information, especially in the keen market competition, if they want to improve the milk production, to improve the value of the milk price, to test analysis the information of DHI is of the utmost importance. However, the traditional DHI information often determines and returns the result to users by the Excel by a professional DHI department. Users only can open the tables one by one to inquire and analysis the data, but also when users need to compare with the recently month data, the have to open a large quantity of Excel tables so that it’s not only waste times but also waste energy. This treatise design a method which is based on the .NET environment’s DataSet method to implement the batch import for the DHI in the Excel into the database, it’s also achieve the breeding information management system and the data of DHI integrated management. The application results show that this method is easy to operate and credibility of operation, it can also achieve the history information inquire and it is worth practically generalizing.