cs代码如下:
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Data.OracleClient;
using System.Data.OleDb;public partial class _Default : System.Web.UI.Page
{
public DataSet ds;
protected void Page_Load(object sender, EventArgs e)
{
ds = (DataSet)this.GridView1.DataSource;
//Session["ds "] = GridView1.DataSource;
// ds = (DataSet)Session["GridView1"];
}
protected void Button1_Click(object sender, EventArgs e)
{
OracleConnection conn = new OracleConnection("Data source = xxxx; User Id=xxxx; Password=xxxx;");
if (conn.State.ToString() == "Closed")
{
conn.Open(); } for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
string danwei = ds.Tables[0].Rows[i][0].ToString();
string chexing = ds.Tables[0].Rows[i][1].ToString();
string chehao = ds.Tables[0].Rows[i][2].ToString();
string jiashiyuan = ds.Tables[0].Rows[i][3].ToString();
string bqqk = ds.Tables[0].Rows[i][4].ToString();
string sql = "insert into tcddbqb([danwei],[chexing],[chehao],[jiashiyuan],[bqqk]) values('" + danwei + "','" + chexing + "','" + chehao + "','" + jiashiyuan + "','" + bqqk + "')";
OracleCommand cmd = new OracleCommand(sql, conn);
try
{
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
Response.Write("插入失败!由于:" + ex.Message);
}
}
conn.Close();
Response.Write("<SCRIPT>alert('数据已成功导入到数据库!');</SCRIPT>");
}
}
我想把gridview的内容放入dataset中,然后再写入数据库,但是在for (int i = 0; i < ds.Tables[0].Rows.Count; i++)的时候报错,说明内容没有写入到dataset 的ds中。请问应该如何更改,还是有更好的方法,请把代码给出来,不胜感激~!
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Data.OracleClient;
using System.Data.OleDb;public partial class _Default : System.Web.UI.Page
{
public DataSet ds;
protected void Page_Load(object sender, EventArgs e)
{
ds = (DataSet)this.GridView1.DataSource;
//Session["ds "] = GridView1.DataSource;
// ds = (DataSet)Session["GridView1"];
}
protected void Button1_Click(object sender, EventArgs e)
{
OracleConnection conn = new OracleConnection("Data source = xxxx; User Id=xxxx; Password=xxxx;");
if (conn.State.ToString() == "Closed")
{
conn.Open(); } for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
string danwei = ds.Tables[0].Rows[i][0].ToString();
string chexing = ds.Tables[0].Rows[i][1].ToString();
string chehao = ds.Tables[0].Rows[i][2].ToString();
string jiashiyuan = ds.Tables[0].Rows[i][3].ToString();
string bqqk = ds.Tables[0].Rows[i][4].ToString();
string sql = "insert into tcddbqb([danwei],[chexing],[chehao],[jiashiyuan],[bqqk]) values('" + danwei + "','" + chexing + "','" + chehao + "','" + jiashiyuan + "','" + bqqk + "')";
OracleCommand cmd = new OracleCommand(sql, conn);
try
{
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
Response.Write("插入失败!由于:" + ex.Message);
}
}
conn.Close();
Response.Write("<SCRIPT>alert('数据已成功导入到数据库!');</SCRIPT>");
}
}
我想把gridview的内容放入dataset中,然后再写入数据库,但是在for (int i = 0; i < ds.Tables[0].Rows.Count; i++)的时候报错,说明内容没有写入到dataset 的ds中。请问应该如何更改,还是有更好的方法,请把代码给出来,不胜感激~!
解决方案 »
- 如何判断Framework4.0是否安装完整???
- 求大神解决Microsoft SOAP Toolkit Version 3 在C#的用法。
- 共用active directory中的用戶名和密碼的問題?
- 问一个关于label格式化显示list的每一个item的问题
- fpspread控件里,如何将从数据库里读出的图片在cell里显示出来,以及如何调整图片大小,高手请指点!
- C# socket中的IPPacketInformation
- 谁知道哪有Whidbey自带的Visio下载?
- win7 关于iis的安装
- 请教一下C#用以太网访问PLC的源码
- BizTalk这个东东可以应用在哪些方面,请大家说来听听。
- DataGridViewCheckBoxColumn怎么实现单选??
- C# 如何隐藏windows任务栏中的其他应用程序的图标
不就是把GridView的数据存入数据库吗?干么还非得用DataSet 直接遍历GridView就是了
),一般的作法是获得一个DataSet,然后GridView再绑定数据源(这里就是GridView的显示)
,如果真有你这样的作法,你可以调试看下(DataSet)this.GridView1.DataSource这个有没有值的,再就是出的错又是什么错来的,这也是一个问题
ds = (DataSet)this.GridView1.DataSource;
可改为DataTable dt=this.GridView1.DataSource;
DataSet ds=new DataSet();
ds.Add(dt);
for (int i = 0; i < GridView1.Rows.Count; i++)
{
string danwei = GridView1.Rows[i][0].ToString();
string chexing = GridView1.Rows[i][1].ToString();
string chehao = GridView1.Rows[i][2].ToString();
string jiashiyuan = GridView1.Rows[i][3].ToString();
string bqqk = GridView1.Rows[i][4].ToString();
string sql = "insert into tcddbqb([danwei],[chexing],[chehao],[jiashiyuan],[bqqk]) values('" + danwei + "','" + chexing + "','" + chehao + "','" + jiashiyuan + "','" + bqqk + "')";//像这种东西用string.Format("")比较好
OracleCommand cmd = new OracleCommand(sql, conn);
try
{
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
Response.Write("插入失败!由于:" + ex.Message);
}
}
conn.Close();
Response.Write("<SCRIPT>alert('数据已成功导入到数据库!');</SCRIPT>");
}
for (int i = 0; i < GridView1.Rows.Count; i++)
{
string danwei = GridView1.Rows[i].Cell[0].Text.Trim();
string chexing = GridView1.Rows[i].Cell[1].Text.trim;
string chehao = GridView1.Rows[i].Cell[2].Text.Trim();
string jiashiyuan = GridView1.Rows[i].Cell[3].Text.Trim();
string bqqk = GridView1.Rows[i].Cell[4].Text.Trim();
string sql = "insert into tcddbqb([danwei],[chexing],[chehao],[jiashiyuan],[bqqk]) values('" + danwei + "','" + chexing + "','" + chehao + "','" + jiashiyuan + "','" + bqqk + "')";//像这种东西用string.Format("")比较好
OracleCommand cmd = new OracleCommand(sql, conn);
try
{
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
Response.Write("插入失败!由于:" + ex.Message);
}
}
conn.Close();
Response.Write("<SCRIPT>alert('数据已成功导入到数据库!');</SCRIPT>");
}