首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 网站开发 > asp.net >

求大神帮忙呀,该怎么处理

2012-08-11 
求大神帮忙呀错误时这么说的:当传递具有新行的 DataRow 集合时,更新要求有效的 InsertCommand。using Syste

求大神帮忙呀
错误时这么说的:当传递具有新行的 DataRow 集合时,更新要求有效的 InsertCommand。


using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;

public partial class Masters_AdminBlue_Demo_Add : System.Web.UI.Page
{
  private int CateId;

  protected void Page_Load(object sender, EventArgs e)
  {
  if (Request.QueryString["CateId"] != null)
  {
  CateId = Convert.ToInt32(Request.QueryString["CateId"].ToString());


  }
  }

  protected void Button1_Click1(object sender, EventArgs e)
  {
  COOL.NEWSTableAdapters.CMS_ContentTableAdapter adp = new COOL.NEWSTableAdapters.CMS_ContentTableAdapter();
  COOL.NEWS.CMS_ContentDataTable dt = new COOL.NEWS.CMS_ContentDataTable();
  COOL.NEWS.CMS_ContentRow dr =dt.NewCMS_ContentRow();

  dr.CateID = CateId; 
  dr.CMS_Cnt =Convert.ToString(FCKeditor1.Value);
  dr.CMS_Title =Convert.ToString(tbOld.Text) ;


  dt.AddCMS_ContentRow(dr);

  if (adp.Update(dt) > 0)
  {
  Tool.Message.ClientMsgPrompt(this, "添加成功");
  tbOld.Text = "";
  FCKeditor1.Value = "";
  }

  else
  Tool.Message.ClientMsgPrompt(this, "添加失败");
  }

  protected void Button2_Click(object sender, EventArgs e)
  {
  Response.Redirect(string.Format("Add.aspx?CateId={0}", CateId));
  }
}

[解决办法]
是什么问题呢?页面跳转,参数没有传递过去?还是???
如果是参数没有传递过去,这样

C# code
using System;using System.Collections;using System.Configuration;using System.Data;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.HtmlControls;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;public partial class Masters_AdminBlue_Demo_Add : System.Web.UI.Page{  private int CateId; protected void Page_Load(object sender, EventArgs e){     if(!IsPostBack)     {         if (Request.QueryString["CateId"] != null)         {               CateId = Convert.ToInt32(Request.QueryString["CateId"].ToString());               ViewState["cateID"]  = Convert.ToInt32(Request.QueryString["CateId"].ToString());         }      }  }protected void Button1_Click1(object sender, EventArgs e){  COOL.NEWSTableAdapters.CMS_ContentTableAdapter adp = new COOL.NEWSTableAdapters.CMS_ContentTableAdapter();  COOL.NEWS.CMS_ContentDataTable dt = new COOL.NEWS.CMS_ContentDataTable();  COOL.NEWS.CMS_ContentRow dr =dt.NewCMS_ContentRow();  dr.CateID = int.Parse(ViewState["cateID"].ToString());   dr.CMS_Cnt =Convert.ToString(FCKeditor1.Value);  dr.CMS_Title =Convert.ToString(tbOld.Text) ;  dt.AddCMS_ContentRow(dr);  if (adp.Update(dt) > 0)  {       Tool.Message.ClientMsgPrompt(this, "添加成功");       tbOld.Text = "";       FCKeditor1.Value = "";   }  else   {      Tool.Message.ClientMsgPrompt(this, "添加失败");    }}   protected void Button2_Click(object sender, EventArgs e)   {        Response.Redirect(string.Format("Add.aspx?CateId={0}",  int.Parse(ViewState["cateID"].ToString())));   }}
[解决办法]
当传递具有新行的 DataRow 集合时,更新要求有效的 InsertCommand。



说明

protected void Button1_Click1(object sender, EventArgs e)
{
COOL.NEWSTableAdapters.CMS_ContentTableAdapter adp = new COOL.NEWSTableAdapters.CMS_ContentTableAdapter();
COOL.NEWS.CMS_ContentDataTable dt = new COOL.NEWS.CMS_ContentDataTable();
COOL.NEWS.CMS_ContentRow dr =dt.NewCMS_ContentRow();

dr.CateID = CateId; 
dr.CMS_Cnt =Convert.ToString(FCKeditor1.Value);
dr.CMS_Title =Convert.ToString(tbOld.Text) ;


dt.AddCMS_ContentRow(dr); //这个方法有问题

if (adp.Update(dt) > 0)
{
Tool.Message.ClientMsgPrompt(this, "添加成功");
tbOld.Text = "";
FCKeditor1.Value = "";
}

else
Tool.Message.ClientMsgPrompt(this, "添加失败");
}

热点排行