怎样把gridview中的数据添加进Oracle数据库?
各位老师,
我现在已把excel的数据绑定到gridview上,怎样才能把gridview中的数据添加进Oracle数据库?
protected void Button1_Click(object sender, EventArgs e)
{ string strID;
string strUsername;
string strPriduct;
OracleConnection connn = new OracleConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);//读取web.config连接字符串
connn.Open();
foreach (GridViewRow gvr in GridView1.Rows)
{
strID,strUsername ,strPriduct 代码?
string sql = "insert into TEST (YUNDANHAO,HANGXIAN,HANGCI) values";
sql += "('" + strID + "','" + strUsername + "','" + strPriduct + "')";
OracleCommand cmd = new OracleCommand(sql, connn);
int exenum = cmd.ExecuteNonQuery();
}
connn.Close();
}
各位老师,
我现在已把excel的数据绑定到gridview上,怎样才能把gridview中的数据添加进Oracle数据库?
protected void Button1_Click(object sender, EventArgs e)
{ string strID;
string strUsername;
string strPriduct;
OracleConnection connn = new OracleConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);//读取web.config连接字符串
connn.Open();
foreach (GridViewRow gvr in GridView1.Rows)
{
strID,strUsername ,strPriduct 代码?
string sql = "insert into TEST (YUNDANHAO,HANGXIAN,HANGCI) values";
sql += "('" + strID + "','" + strUsername + "','" + strPriduct + "')";
OracleCommand cmd = new OracleCommand(sql, connn);
int exenum = cmd.ExecuteNonQuery();
}
connn.Close();
}
解决方案 »
- 我的上传图片并生成缩略图代码为什么不能在虚拟主机上运行了
- 如何去掉字符串中的中文双引号
- 急啊!!!ASP.NET 4.0 目录<authorization></authorization>访问权限问题 帮忙啊!
- 在<asp:GridView 中
- 有关ajax网站发布的问题
- 怎么把一个string 规整成一句??????
- asp转向asp.net的烦恼
- Girdview控件的自定义分页实例
- Visual Studio.Net 安装问题,解决后可另开贴送分!
- 大家帮忙看看我的代码问题在那儿,为什么if,else,catch中的response.redirect都运行呢?
- |zyciis| 200分 如何用ASP.NET AJAX 中的UpdatePanel做像QQ空间的提示:数据正在提交(向服务器发送处理) 数据正在更新(读取服务器信息)
- 论坛回复问题页面
http://www.cnblogs.com/caoxch/archive/2006/11/28/575129.aspx
http://www.cnblogs.com/sapphire/archive/2004/11/19/65966.html
strID,strUsername ,strPriduct 代码? foreach (GridViewRow gr in this.gvUpdatePlan.Rows)
{
HiddenField hdfPlanId = (HiddenField)gr.FindControl("hdfPlanId");//计划编号
Label lbPlanQuantity = (Label)gr.FindControl("lbPlanQuantity");//计划量
参考代码,自己写吧,将Lable换成Textbox就可以了,用模板列
protected void Button1_Click(object sender, EventArgs e)
{ string strID = String.Empty;
string strUsername=String.Empty;
string strPriduct=String.Empty;
OracleConnection connn = new OracleConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);//读取web.config连接字符串
connn.Open();
foreach (GridViewRow gvr in GridView1.Rows)
{
strID=(Lable)gr.Cells[控件列数从0开始计算].FindControl("控件ID"); //其他的类似取法就不给你写了
string sql = "insert into TEST (YUNDANHAO,HANGXIAN,HANGCI) values";
sql += "('" + strID + "','" + strUsername + "','" + strPriduct + "')";
OracleCommand cmd = new OracleCommand(sql, connn);
int exenum = cmd.ExecuteNonQuery();
}
connn.Close();
}
也可以用gvr.Cells[x]取.
模版列比如
DropDownList objDDL = gvr.FindControl("ddlBank") as DropDownList;