储存资料 [英] storing data

问题描述

我正在从Excel文件中检索数据，并将其显示到datagrid中.
现在，我要将数据从此数据网格存储到SQL数据库中.
我怎样才能做到这一点?请帮忙.

预先感谢.

I am retrieving data from an Excel file and display it into datagrid.
Now, I want to store data from this datagrid into a SQL database.
How can I do this? Please help.

Thanks in advance.

推荐答案

显然，通过编写代码.我相信您可以使用ODBC连接到Excel.然后将数据绑定到网格.您只需将数据写入使用SQL的数据层即可将数据直接存储到SQL数据库中.

By writing code, obviously. You can connect to Excel using ODBC, I believe. then you bind the data to your grid. You should store the data directly into a SQL database, just by writing a data layer that uses SQL to do that.

这篇关于储存资料的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！