问题描述
--类及方法usingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Web;usingSystem.Data.SqlClient;usingSystem.Data;namespaceWebApplication1.Class__methods{publicclassCommon{privateSqlConnectioncon=newSqlConnection();privateSqlCommandcom=newSqlCommand();privatereadonlystringconString=System.Configuration.ConfigurationSettings.AppSettings["opencon"].ToString();privatevoidopencon(){con.ConnectionString=conString;con.Open();}publicvoidopencom(stringcomtext,CommandTypecomtype,SqlParameter[]paras){opencon();com.Connection=con;com.CommandText=comtext;com.CommandType=comtype;if(paras!=null){for(inti=0;i<paras.Length;i++){com.Parameters.Add(paras[i]);}}}publicDataSetfilldata(stringcomtext,CommandTypecomtype,SqlParameter[]paras){opencom(comtext,comtype,paras);SqlDataAdapterda=newSqlDataAdapter(com);DataSetds=newDataSet();da.Fill(ds);closecon();returnds;}publicintExecuteNonQuery(stringcomtext,CommandTypecomtype,SqlParameter[]paras){opencom(comtext,comtype,paras);inti=com.ExecuteNonQuery();closecon();returni;}privatevoidclosecon(){con.Close();}}}usingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Web;usingSystem.Data;usingSystem.Data.SqlClient;namespaceWebApplication1.Class__methods{publicclassMethodes{privateCommoncom=newCommon();privatereadonlystringLookgodProc=System.Configuration.ConfigurationSettings.AppSettings["LookgodProc"].ToString();privatereadonlystringLookinputgodProc=System.Configuration.ConfigurationSettings.AppSettings["Lookinputgod"].ToString();privatereadonlystringmodifygodProc=System.Configuration.ConfigurationSettings.AppSettings["modiinputgod"].ToString();///<summary>///查看商品信息///</summary>///<returns></returns>publicDataSetLookGood(){DataSetds=com.filldata(LookgodProc,CommandType.StoredProcedure,null);returnds;}///<summary>//////</summary>///<returns></returns>publicDataSetLookinputgod(){DataSetds=com.filldata(LookinputgodProc,CommandType.StoredProcedure,null);returnds;}publicvoidmodifinputgod(stringd,stringN,stringP,stringM){SqlParameter[]paras=newSqlParameter[4];paras[0]=newSqlParameter("@GoodsID",SqlDbType.Int);paras[0].Value=d;paras[1]=newSqlParameter("@GoodsName",SqlDbType.NVarChar,50);paras[1].Value=N;paras[2]=newSqlParameter("@GoodsPrice",SqlDbType.Money);paras[2].Value=P;paras[3]=newSqlParameter("@GoodsNumber",SqlDbType.Int);paras[3].Value=M;com.ExecuteNonQuery(modifygodProc,CommandType.StoredProcedure,paras);}}}-----调用处usingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Web;usingSystem.Web.UI;usingSystem.Web.UI.WebControls;usingWebApplication1.Class__methods;usingSystem.Data;namespaceWebApplication1.Interface{publicpartialclassGoodsInput:System.Web.UI.Page{privateMethodesMd=newMethodes();privateCommoncm=newCommon();protectedvoidPage_Load(objectsender,EventArgse){if(!IsPostBack){bind();}}privatevoidbind(){this.GridView1.DataSource=Md.Lookinputgod();this.GridView1.DataBind();}protectedvoidGridView1_RowEditing(objectsender,GridViewEditEventArgse){GridView1.EditIndex=e.NewEditIndex;bind();}protectedvoidGridView1_RowDeleting(objectsender,GridViewDeleteEventArgse){//stringsqlstr="deletefrom表whereid='"+GridView1.DataKeys[e.RowIndex].Value.ToString()+"'";//sqlcon=newSqlConnection(strCon);//sqlcom=newSqlCommand(sqlstr,sqlcon);//sqlcon.Open();//sqlcom.ExecuteNonQuery();//sqlcon.Close();//bind();}protectedvoidGridView1_RowUpdating(objectsender,GridViewUpdateEventArgse){stringd1=((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim();stringd2=((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim();stringd3=((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim();stringd4=((TextBox)(GridView1.Rows[e.RowIndex].Cells[4].Controls[0])).Text.ToString().Trim();Md.modifinputgod(d1,d2,d3,d4);GridView1.EditIndex=-1;bind();//this.GridView1.DataSource=Md.modifinputgod(d1,d2,d3,d4);//this.GridView1.DataBind();//GridView1.EditIndex=-1;//bind();//stringsqlstr="updateGoodsInputsetGoodsID='"//+((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim()+"',GoodsName='"//+((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim()+"',GoodsPrice='"//+((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim()+"',GoodsNumber='"//+((TextBox)(GridView1.Rows[e.RowIndex].Cells[4].Controls[0])).Text.ToString().Trim()+//"'where@InputID='"//+GridView1.DataKeys[e.RowIndex].Value.ToString()+"'";//cm.opencom(sqlstr,CommandType.Text,null);}protectedvoidGridView1_RowCancelingEdit(objectsender,GridViewCancelEditEventArgse){GridView1.EditIndex=-1;bind();}}}
解决方案
解决方案二:
什么错误呢,调试下吧
解决方案三:
找不到参数
解决方案四:
别用gridview,用datalist,比较不错
解决方案五:
参考:
解决方案六:
用Repeater比较好
解决方案七:
别听他们的就用gridview调试下就知道哪里出问题了,要学会调试
解决方案八:
引用6楼tangserver的回复:
别听他们的就用gridview调试下就知道哪里出问题了,要学会调试
++1不会调试永远是个悲剧