关于ImageButton

[m378210048]

就是问一下，美工把HTML页面给我了，我把页面也都换成服务器端控件，添加一个imageButton的时候它有个单击事件，为什么点进去做了以个添加数据到数据库的操作，但是为什么我运行的时候它不执行后台代码呢？？点半天页面也不跳转。

[chen_ya_ping]

楼主还是贴你的代码，大家看的才清楚一点

[m378210048]

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 PDMS.DBHelper;
using PDMS.Common;

public partial class industry_1 : System.Web.UI.Page
{



protected void Page_Load(object sender, EventArgs e)
{

}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{

string con_sql = ConfigurationManager.ConnectionStrings["connstring"].ConnectionString;
SqlConnection connection = new SqlConnection(con_sql);
SQLServerHelper sq = new SQLServerHelper();
qy q = new qy();
try
{

connection.Open();
q.EnterpriseID = "select EnterpirseID from Enterprise";
q.ProjectID = "2";
q.Qymc = this.TextBox29.Text.Trim() ;
q.Sshy = this.select.Value;
q.Frdb = this.TextBox24.Text.Trim();
q.Szdq = this.select2.Value;
q.Frdm = this.TextBox24.Text.Trim() ;
q.Zzxs = this.select3.Value;
q.Zczb = (float)Convert.ToInt32(this.TextBox26.Text.Trim());
q.Zcdd = this.TextBox28.Text.Trim() ;
q.Zcsj = this.TextBox27.Text.Trim();
q.Ywfw = this.TextBox1.Text.Trim() ;
q.Zycp = this.TextBox2.Text.Trim();
q.Cyrs1 = Convert.ToInt32(this.TextBox6.Text.Trim());
q.Zcze1 = (float)Convert.ToInt32(this.TextBox9.Text.Trim());
q.Fzze1 =(float) Convert.ToInt32(this.TextBox12.Text.Trim());
q.Xssr1 =(float) Convert.ToInt32(this.TextBox15.Text.Trim());
q.Lrze1 =(float) Convert.ToInt32(this.TextBox18.Text.Trim());
q.Sjsj1 =(float) Convert.ToInt32(this.TextBox21.Text.Trim());

q.Cyrs2 = Convert.ToInt32(this.TextBox7.Text.Trim());
q.Zcze2 =(float)Convert.ToInt32( this.TextBox10.Text.Trim());
q.Fzze2 = (float)Convert.ToInt32(this.TextBox13.Text.Trim());
q.Xssr2 = (float)Convert.ToInt32(this.TextBox16.Text.Trim());
q.Lrze2 = (float)Convert.ToInt32(this.TextBox19.Text.Trim());
q.Sjsj2 = (float)Convert.ToInt32(this.TextBox22.Text.Trim());

q.Cyrs3 = Convert.ToInt32(this.TextBox8.Text.Trim());
q.Zcze3 = (float)Convert.ToInt32(this.TextBox11.Text.Trim());
q.Fzze3 = (float)Convert.ToInt32(this.TextBox14.Text.Trim());
q.Xssr3 = (float)Convert.ToInt32(this.TextBox17.Text.Trim());
q.Lrze3 = (float)Convert.ToInt32(this.TextBox20.Text.Trim());
q.Sjsj3 = (float)Convert.ToInt32(this.TextBox23.Text.Trim());

string sql = string.Format("insert into Ent_jg_qy(EnterpriseID,ProjectID,qymc,sshy,frdb,szdq,frdm,zzxs,zczb,zcdd,zcsj,ywfw,zycp,cyrs1,zcze1,fzze1,xssr1,lrze1,sjsj1,cyrs2,zcze2,fzze2,xssr2,lrze2,sjsj2,cyrs3,zcze3,fzze3,xssr3,lrze3,sjsj3) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}',{9},'{10}','{11}','{12}','{13}',{14},{15},{16},{17),{18},{19},{20},{21},{22},{23},{24},{25),{26},{27},{28},{29},{30},{31}", q.EnterpriseID, q.ProjectID, q.Qymc, q.Sshy, q.Frdb, q.Szdq, q.Frdm, q.Zzxs, q.Zczb, q.Zcdd, q.Zcsj, q.Ywfw, q.Zycp, q.Cyrs1, q.Zcze1, q.Fzze1, q.Xssr1, q.Lrze1, q.Sjsj1, q.Cyrs2, q.Zcze2, q.Fzze2, q.Xssr2, q.Lrze2, q.Sjsj2, q.Cyrs3, q.Zcze3, q.Fzze3, q.Xssr3, q.Lrze3, q.Sjsj3);

// SqlCommand command=new SqlCommand(sql,connection);

if (sq.Insert(sql))
{
Response.Redirect("industry_2.aspx");
Response.Cookies["id"].Value = "select EnterpriseID from Enterprise ";
}
else
{
Response.Redirect("industry_1.aspx");
}
}
catch
{
throw;

}
finally
{
connection.Close();
}







}


}

[m378210048]

[Quote=引用 2 楼 m378210048 的回复:]



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 PDMS.DBHelper;
using PDMS.Common;

public partial class industry_1 :…
[/Quote]
<asp:ImageButton ID="ImageButton1" runat="server" ImageUrl="~/images/button_1.gif" OnClick="ImageButton1_Click" />

[chwqq521]

好像是看不出什么问题.能调试么?自个调试下吧.一般问题调试下都可以解决..
如果可以的话把这个页面发给我试试.很乐意看下子

[autumn1987]

在函数那设个断点，看能不能进去那个函数，进去了就说明代码有问题，没有的话，把imagebutton删了重加个44，行不行……

[bagegejin]

不得不说，哥们你的SQL字符串这样写也太强大了。。。。

[king_tang88]

[Quote=引用 5 楼 autumn1987 的回复:]
在函数那设个断点，看能不能进去那个函数，进去了就说明代码有问题，没有的话，把imagebutton删了重加个44，行不行……
[/Quote]
支持这位哥们，设个断点就知道结果了。
SQL写的很花眼，呵呵~慢慢来。

[m378210048]

试了不行，换个BUTTON也不行！！

[m378210048]

[m378210048]

设置断点没用，它根本就不进后台。