急救! 把什么写在ItemdataBound里啊,我e.Item.Cells[4].Text=Server.HtmlDecode(e.Item.Cells[4].Text);写进去了,翻页不能用了 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 老兄写在ItemDataBound中是不报错了。可是这一列的值成空的了,还不可编辑。 private void News_DataBind() { SqlConnection conn= new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]); try { if (conn.State.ToString()=="Closed") { conn.Open(); } SqlDataAdapter myReader =new SqlDataAdapter("browse_news_other",conn); DataSet DS=new DataSet(); Db_G_news.Columns[0].HeaderText ="删除"; Db_G_news.Columns[1].HeaderText="更新"; myReader.Fill(DS,"news"); Db_G_news.DataSource=DS; Db_G_news.DataBind(); myReader.Dispose(); DS.Dispose(); } catch(Exception ex) { string Error_info_detail=Server.UrlEncode(ex.Message.ToString()); Response.Redirect("Error_page.aspx?Error_info="+ Error_info_detail); } finally { if (conn.State.ToString()=="Open") { conn.Close(); conn.Dispose(); } } }private void News_update(int n_id,string n_title,string n_content,string n_date,int n_num,int n_type) { SqlConnection conn=new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]); try { if (conn.State.ToString()=="Closed") { conn.Open(); } SqlCommand com= new SqlCommand("update_news",conn); com.CommandType=CommandType.StoredProcedure; com.Parameters.Add("@n_id",SqlDbType.Int); com.Parameters["@n_id"].Value=n_id; n_title=formatString(n_title); com.Parameters.Add("@n_title",SqlDbType.VarChar); com.Parameters["@n_title"].Value=n_title; n_content=formatString(n_content); com.Parameters.Add("@n_content",SqlDbType.VarChar); com.Parameters["@n_content"].Value=n_content; com.Parameters.Add("@n_date",SqlDbType.SmallDateTime); com.Parameters["@n_date"].Value=Convert.ToDateTime(n_date); com.Parameters.Add("@news_bro_num",SqlDbType.VarChar); com.Parameters["@news_bro_num"].Value=n_num; com.Parameters.Add("@n_type",SqlDbType.Int); com.Parameters["@n_type"].Value=n_type; com.ExecuteNonQuery(); com.Dispose(); } catch(Exception ex) { String Error_info1=ex.Message.ToString(); Error_info1="Error_page.aspx?Error_info="+Error_info1; Response.Redirect(Error_info1); } finally { if (conn.State.ToString()=="Open") { conn.Close(); conn.Dispose(); } } } private void Db_G_news_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e) { Db_G_news.CurrentPageIndex=e.NewPageIndex; News_DataBind(); }private void Db_G_news_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { int n_id; int n_num; int n_type; ((TextBox)e.Item.Cells[4].Controls[0]).Text=Server.UrlDecode(((TextBox)e.Item.Cells[4].Controls[0]).Text); //string eee=((TextBox)e.Item.Cells[3].Controls[0]).Text; //string test=((TextBox)e.Item.Cells[4].Controls[0]).Text; int test= Convert.ToInt32(((TextBox)e.Item.Cells[2].Controls[0]).Text); if(((TextBox)e.Item.Cells[2].Controls[0]).Text=="" || ((TextBox)e.Item.Cells[2].Controls[0]).Text.Length==0) { return;} else { n_id=Convert.ToInt32(((TextBox)e.Item.Cells[2].Controls[0]).Text);} string n_title=((TextBox)e.Item.Cells[3].Controls[0]).Text; //n_title=formatString(n_title); Server.UrlDecode(n_title); string n_content=((TextBox)e.Item.Cells[4].Controls[0]).Text; //n_content=formatString(n_content); string n_date=((TextBox)e.Item.Cells[5].Controls[0]).Text; if(((TextBox)e.Item.Cells[6].Controls[0]).Text=="" || ((TextBox)e.Item.Cells[6].Controls[0]).Text.Length==0) { n_num=0;} else { n_num=Convert.ToInt32(((TextBox)e.Item.Cells[6].Controls[0]).Text);} if(((TextBox)e.Item.Cells[7].Controls[0]).Text=="" || ((TextBox)e.Item.Cells[7].Controls[0]).Text.Length==0) { n_type=0;} else {n_type=Convert.ToInt32(((TextBox)e.Item.Cells[7].Controls[0]).Text);} News_update(n_id,n_title,n_content,n_date,n_num,n_type); Db_G_news.EditItemIndex=-1; News_DataBind(); } private void Db_G_news_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { Db_G_news.EditItemIndex=-1; News_DataBind(); } private string formatString(string str) { str=str.Replace(" "," ");//处理空格 str=str.Replace("<","<");//处理小于号 str=str.Replace(">",">");//处理大于号 str=str.Replace("\n","<br>");//处理换行 return str; } private string formatString_too(string str) { str=str.Replace(" "," ");//处理空格 str=str.Replace("<","<");//处理小于号 str=str.Replace(">",">");//处理大于号 str=str.Replace("<br>","\n");//处理换行 return str; } private void Db_G_news_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e) { //e.Item.Cells[2].Enabled=false; e.Item.Cells[3].Text=formatString_too(e.Item.Cells[3].Text); e.Item.Cells[4].Text=formatString_too(e.Item.Cells[4].Text); } 试试看修改web.config文件:<configuration> <system.web> <pages validateRequest="false" /> </system.web> </configuration> 太谢谢了,交个朋友吧。我的MSN是 vzxq@[email protected]亲人啊·! 发错了!太谢谢了,交个朋友吧。我的MSN是 [email protected]亲人啊·! Repeater里checkbox全选反选 非哥 foo 什么意思? 在统计记录数时报错 我在AjaxPanel中放了一个按钮,但是点击按钮后,只显示一个Loading...,然后就没反映了,也打不开新页.怎么解决 .NET版本号是多少? 服务器端如何获得客户端的title 怎么在ASP.net页面中更新数据源(急啊!!) 关于json格式在后台获取值的问题 关于datagrid的分页问题 散分.... 数据库连接的问题,在线等!!!! 有没有办法弹出窗口,然后返回值给父页面后,继续执行父页面的程序?
SqlConnection conn= new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]); try
{
if (conn.State.ToString()=="Closed")
{
conn.Open();
}
SqlDataAdapter myReader =new SqlDataAdapter("browse_news_other",conn);
DataSet DS=new DataSet();
Db_G_news.Columns[0].HeaderText ="删除";
Db_G_news.Columns[1].HeaderText="更新";
myReader.Fill(DS,"news");
Db_G_news.DataSource=DS;
Db_G_news.DataBind();
myReader.Dispose();
DS.Dispose();
}
catch(Exception ex)
{
string Error_info_detail=Server.UrlEncode(ex.Message.ToString());
Response.Redirect("Error_page.aspx?Error_info="+ Error_info_detail);
}
finally
{
if (conn.State.ToString()=="Open")
{
conn.Close();
conn.Dispose();
}
}
}
private void News_update(int n_id,string n_title,string n_content,string n_date,int n_num,int n_type)
{
SqlConnection conn=new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
try
{
if (conn.State.ToString()=="Closed")
{
conn.Open();
}
SqlCommand com= new SqlCommand("update_news",conn);
com.CommandType=CommandType.StoredProcedure;
com.Parameters.Add("@n_id",SqlDbType.Int);
com.Parameters["@n_id"].Value=n_id;
n_title=formatString(n_title);
com.Parameters.Add("@n_title",SqlDbType.VarChar);
com.Parameters["@n_title"].Value=n_title;
n_content=formatString(n_content);
com.Parameters.Add("@n_content",SqlDbType.VarChar);
com.Parameters["@n_content"].Value=n_content;
com.Parameters.Add("@n_date",SqlDbType.SmallDateTime);
com.Parameters["@n_date"].Value=Convert.ToDateTime(n_date); com.Parameters.Add("@news_bro_num",SqlDbType.VarChar);
com.Parameters["@news_bro_num"].Value=n_num; com.Parameters.Add("@n_type",SqlDbType.Int);
com.Parameters["@n_type"].Value=n_type;
com.ExecuteNonQuery();
com.Dispose();
}
catch(Exception ex)
{
String Error_info1=ex.Message.ToString();
Error_info1="Error_page.aspx?Error_info="+Error_info1;
Response.Redirect(Error_info1);
}
finally
{
if (conn.State.ToString()=="Open")
{
conn.Close();
conn.Dispose();
}
}
}
private void Db_G_news_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
Db_G_news.CurrentPageIndex=e.NewPageIndex;
News_DataBind();
}
private void Db_G_news_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
int n_id;
int n_num;
int n_type;
((TextBox)e.Item.Cells[4].Controls[0]).Text=Server.UrlDecode(((TextBox)e.Item.Cells[4].Controls[0]).Text);
//string eee=((TextBox)e.Item.Cells[3].Controls[0]).Text;
//string test=((TextBox)e.Item.Cells[4].Controls[0]).Text;
int test= Convert.ToInt32(((TextBox)e.Item.Cells[2].Controls[0]).Text);
if(((TextBox)e.Item.Cells[2].Controls[0]).Text=="" || ((TextBox)e.Item.Cells[2].Controls[0]).Text.Length==0)
{ return;}
else
{ n_id=Convert.ToInt32(((TextBox)e.Item.Cells[2].Controls[0]).Text);} string n_title=((TextBox)e.Item.Cells[3].Controls[0]).Text;
//n_title=formatString(n_title);
Server.UrlDecode(n_title);
string n_content=((TextBox)e.Item.Cells[4].Controls[0]).Text;
//n_content=formatString(n_content); string n_date=((TextBox)e.Item.Cells[5].Controls[0]).Text;
if(((TextBox)e.Item.Cells[6].Controls[0]).Text=="" || ((TextBox)e.Item.Cells[6].Controls[0]).Text.Length==0)
{ n_num=0;}
else
{ n_num=Convert.ToInt32(((TextBox)e.Item.Cells[6].Controls[0]).Text);}
if(((TextBox)e.Item.Cells[7].Controls[0]).Text=="" || ((TextBox)e.Item.Cells[7].Controls[0]).Text.Length==0)
{ n_type=0;}
else
{n_type=Convert.ToInt32(((TextBox)e.Item.Cells[7].Controls[0]).Text);}
News_update(n_id,n_title,n_content,n_date,n_num,n_type);
Db_G_news.EditItemIndex=-1;
News_DataBind();
} private void Db_G_news_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
Db_G_news.EditItemIndex=-1;
News_DataBind(); }
private string formatString(string str)
{
str=str.Replace(" "," ");//处理空格
str=str.Replace("<","<");//处理小于号
str=str.Replace(">",">");//处理大于号
str=str.Replace("\n","<br>");//处理换行
return str;
}
private string formatString_too(string str)
{
str=str.Replace(" "," ");//处理空格
str=str.Replace("<","<");//处理小于号
str=str.Replace(">",">");//处理大于号
str=str.Replace("<br>","\n");//处理换行
return str;
} private void Db_G_news_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
//e.Item.Cells[2].Enabled=false;
e.Item.Cells[3].Text=formatString_too(e.Item.Cells[3].Text);
e.Item.Cells[4].Text=formatString_too(e.Item.Cells[4].Text);
}
<configuration>
<system.web>
<pages validateRequest="false" />
</system.web>
</configuration>
亲人啊·!
太谢谢了,交个朋友吧。我的MSN是 [email protected]
亲人啊·!