Excel网格化并存储在SQL Server中 [英] Excel to grid and store in sql server

查看:74
本文介绍了Excel网格化并存储在SQL Server中的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我是lakshmana rao,我有一个包含数据网格的c#表单,它是从excel填充的.然后可以通过编辑来修改即将到来的数据,最后我将把所有的gridview数据存储到sql server表中.有人可以建议我...

Hi, I am lakshmana rao, i have an c# form contains data grid, it is filled from excel. and then the coming data can take some changes by editing, finally i wnt to store alla the gridview data to sql server table. can any one suggest me...

推荐答案

您没有向我们提供任何信息,以便我们可以实际帮助您,然后再将您指向某些站点:
通过C#访问SQL Server的入门指南 [ ^ ]
You are not providing any information to us so that we can actually help you other then point you to some sites:
Beginners guide to accessing SQL Server through C#[^]



试试这个
将MS Excel导入数据表 [将Excel数据导入数据表 [ http://forums.asp.net/t/1255191.aspx/1 [ ^ ]
将MS Excel导入数据表 [从GridView插入多行 [
Hi ,
Try this
import MS Excel to datatable[^]
Excel Data into datatable[^]
http://forums.asp.net/t/1255191.aspx/1[^]
import MS Excel to datatable[^]

After bind the data to grid use loop and insert it
like this one
Insert Multiple Rows from GridView[^]
Best Regards
M.Mitwalli


这篇关于Excel网格化并存储在SQL Server中的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆