<%
@ Page language
=
"
c#
"
Codebehind
=
"
WebForm5.aspx.cs
"
AutoEventWireup
=
"
false
"
Inherits
=
"
csdn.WebForm5
"
%>
<! DOCTYPE HTML PUBLIC " -//W3C//DTD HTML 4.0 Transitional//EN " >
< HTML >
< HEAD >
< title > WebForm5 </ title >
< meta content = " Microsoft Visual Studio .NET 7.1 " name = " GENERATOR " >
< meta content = " C# " name = " CODE_LANGUAGE " >
< meta content = " JavaScript " name = " vs_defaultClientScript " >
< meta content = " http://schemas.microsoft.com/intellisense/ie5 " name = " vs_targetSchema " >
</ HEAD >
< body >
< form id = " Form1 " method = " post " runat = " server " >
< input type = " hidden " id = " rd " runat = " server " name = " rd " >
< asp:textbox id = " TextBox1 " runat = " server " Width = " 88px " ></ asp:textbox >
< asp:TextBox id = " TextBox2 " runat = " server " Width = " 40px " ></ asp:TextBox >
< asp:Button id = " Button1 " runat = " server " Text = " 添加 " ></ asp:Button >
< asp:TextBox id = " TextBox3 " runat = " server " Width = " 128px " ></ asp:TextBox >
< asp:Button id = " Button2 " runat = " server " Text = " 筛选 " ></ asp:Button >
< asp:Button id = " Button3 " runat = " server " Text = " 下载 " ></ asp:Button >
< asp:DataGrid ID = " DataGrid1 " runat = " server " AutoGenerateColumns = " False " DataKeyField = " ID " AllowPaging = " True "
PageSize = " 20 " OnEditCommand = " edit " OnCancelCommand = " cancel " OnUpdateCommand = " update " >
< columns >
< asp:TemplateColumn HeaderText = " 多选 " >
< itemtemplate >
< input type = " hidden " id = " SelectedID " runat = " server "
value = ' <%# Container.ItemIndex%> ' name = " SelectedID " />
< asp:CheckBox ID = " chkExport " runat = " server " />
</ itemtemplate >
</ asp:TemplateColumn >
< asp:TemplateColumn HeaderText = " 单选 " >
< itemtemplate >
<% # Container.ItemIndex + 1 %>
< input type = radio name = " rad " value = ' <%# Container.ItemIndex+1%> ' >
</ itemtemplate >
</ asp:TemplateColumn >
< asp:TemplateColumn HeaderText = " 姓名 " >
< itemtemplate >
<% # myfunc(DataBinder.Eval(Container.DataItem, " vName " )) %>
</ itemtemplate >
< edititemtemplate >
< asp:TextBox ID = " name " runat = " server " Text = ' <%# DataBinder.Eval(Container.DataItem,"vName") %> ' Width = " 88px " > </ asp:TextBox >
</ edititemtemplate >
</ asp:TemplateColumn >
< asp:TemplateColumn HeaderText = " 年龄 " >
< itemtemplate >
<% # DataBinder.Eval(Container.DataItem, " iAge " ) %>
</ itemtemplate >
< edititemtemplate >
< asp:TextBox ID = " age " runat = " server " Text = ' <%# DataBinder.Eval(Container.DataItem,"iAge") %> ' Width = " 40px " > </ asp:TextBox >
</ edititemtemplate >
</ asp:TemplateColumn >
< asp:TemplateColumn HeaderText = " 打开 " >
< itemtemplate >
< asp:HyperLink Text = " 打开 " NavigateUrl = ' <%#"newpage.aspx?name="+DataBinder.Eval(Container.DataItem, "vname")+"&age="+DataBinder.Eval(Container.DataItem, "iage") %> ' runat = " server " Target = " _blank " > </ asp:HyperLink >
</ itemtemplate >
</ asp:TemplateColumn >
< asp:TemplateColumn HeaderText = " 打开 " >
< itemtemplate >
< asp:HyperLink Text = " 打开 " NavigateUrl = ' <%# myfunc2(DataBinder.Eval(Container.DataItem,"vName"),DataBinder.Eval(Container.DataItem,"iAge"))%> ' runat = " server " Target = " _blank " ID = " Hyperlink1 " > </ asp:HyperLink >
</ itemtemplate >
</ asp:TemplateColumn >
< asp:EditCommandColumn ButtonType = " LinkButton " UpdateText = " 更新 " CancelText = " 取消 " EditText = " 编辑 " ></ asp:EditCommandColumn >
< asp:ButtonColumn Text = " 删除 " CommandName = " del " ></ asp:ButtonColumn >
</ columns >
< pagerstyle Mode = " NumericPages " ></ pagerstyle >
</ asp:DataGrid >
< asp:Label id = " Label1 " runat = " server " ></ asp:Label >
< asp:Button ID = " button4 " runat = " server " Text = " 单选结果 " ></ asp:Button >
< asp:Button id = " Button5 " runat = " server " Text = " 多选结果 " ></ asp:Button >
< asp:Button id = " Button6 " runat = " server " Text = " 选中所有 " ></ asp:Button >
< asp:Button id = " Button7 " runat = " server " Text = " 取消所有 " ></ asp:Button ></ form >
< p >& nbsp; </ p >
< p >& nbsp; </ p >
</ body >
</ HTML >
后台代码:
// C# Document
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls; using System.IO;
namespace csdn
{
/**//**//**//// <summary>
/// WebForm5 的摘要说明。
/// </summary>
public class WebForm5 : System.Web.UI.Page
{
protected System.Web.UI.WebControls.TextBox TextBox1;
protected System.Web.UI.WebControls.TextBox TextBox2;
protected System.Web.UI.WebControls.Button Button1;
protected System.Web.UI.WebControls.TextBox TextBox3;
protected System.Web.UI.WebControls.Button Button2;
protected System.Web.UI.WebControls.Button Button3;
protected System.Web.UI.WebControls.Label Label1;
protected System.Web.UI.HtmlControls.HtmlInputHidden rd;
protected System.Web.UI.WebControls.Button button4;
protected System.Web.UI.WebControls.Button Button5;
protected System.Web.UI.WebControls.Button Button6;
protected System.Web.UI.WebControls.DataGrid DataGrid1;
protected System.Web.UI.WebControls.Button Button7;
private void Page_Load(object sender, System.EventArgs e)
{
string js = "";
js+="<script>/r/n";
js+="function ld(){/r/n";
js+="for(i=0;i<document.getElementsByName('rad').length;i++)/r/n";
js+="if(document.getElementsByName('rad')[i].value==";
js+="document.getElementById('rd').value) ";
js+="document.getElementsByName('rad')[i].checked=true/r/n";
js+="}/r/n";
js+="window.οnlοad=ld/r/n";
js+="</script>/r/n";
this.RegisterClientScriptBlock("js",js);
if(!IsPostBack)
{
SetBind();
}
}
protected void SetBind()
{
SqlConnection conn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["conn"]);
SqlDataAdapter da=new SqlDataAdapter("select * from tb1",conn);
DataSet ds=new DataSet();
da.Fill(ds,"table1");
this.DataGrid1.DataSource=ds.Tables["table1"];
this.DataGrid1.DataBind();
this.Label1.Text=ds.Tables["table1"].Compute("avg(iAge)","iAge>20").ToString();
}
protected void SetBind(string s)
{
SqlConnection conn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["conn"]);
SqlDataAdapter da=new SqlDataAdapter("select * from tb1",conn);
DataSet ds=new DataSet();
da.Fill(ds,"table1");
DataView dv=ds.Tables["table1"].DefaultView;
dv.RowFilter=s;
this.DataGrid1.DataSource=dv;
this.DataGrid1.DataBind();
}
Web 窗体设计器生成的代码Web 窗体设计器生成的代码#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/**//**//**//// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.Button1.Click += new System.EventHandler(this.Button1_Click);
this.Button2.Click += new System.EventHandler(this.Button2_Click);
this.Button3.Click += new System.EventHandler(this.Button3_Click);
this.button4.Click += new System.EventHandler(this.Button4_Click);
this.Button5.Click += new System.EventHandler(this.Button5_Click);
this.Button6.Click += new System.EventHandler(this.Button6_Click);
this.Button7.Click += new System.EventHandler(this.Button7_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void Button1_Click(object sender, System.EventArgs e)
{
SqlConnection conn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["conn"]);
SqlCommand comm=new SqlCommand("insert into tb1 (vName,iAge) values (@vName,@iAge)",conn);
SqlParameter parm1=new SqlParameter("@vName",SqlDbType.NVarChar,50);
parm1.Value=this.TextBox1.Text;
SqlParameter parm2=new SqlParameter("@iAge",SqlDbType.Int);
parm2.Value=this.TextBox2.Text;
comm.Parameters.Add(parm1);
comm.Parameters.Add(parm2);
conn.Open();
comm.ExecuteNonQuery();
conn.Close();
SetBind();
}
private void DataGrid1_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
if(e.CommandName=="del"&&e.Item.ItemType!=ListItemType.EditItem)
{
SqlConnection conn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["conn"]);
SqlCommand comm=new SqlCommand("delete from tb1 where ID=@id",conn);
SqlParameter parm1=new SqlParameter("@id",SqlDbType.Int);
parm1.Value=this.DataGrid1.DataKeys[e.Item.ItemIndex];
comm.Parameters.Add(parm1);
conn.Open();
comm.ExecuteNonQuery();
conn.Close();
SetBind();
}
}
private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
this.DataGrid1.CurrentPageIndex=e.NewPageIndex;
SetBind();
}
protected void edit(object sender,DataGridCommandEventArgs e)
{
this.DataGrid1.EditItemIndex=e.Item.ItemIndex;
SetBind();
}
protected void cancel(object sender,DataGridCommandEventArgs e)
{
this.DataGrid1.EditItemIndex=-1;
SetBind();
}
protected void update(object sender,DataGridCommandEventArgs e)
{
if(e.Item.ItemType==ListItemType.EditItem)
{
SqlConnection conn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["conn"]);
SqlCommand comm=new SqlCommand("update tb1 set vName=@vName,iAge=@iAge where ID=@id",conn);
SqlParameter parm1=new SqlParameter("@vName",SqlDbType.NVarChar,50);
parm1.Value=((TextBox)e.Item.FindControl("name")).Text;
SqlParameter parm2=new SqlParameter("@iAge",SqlDbType.Int);
parm2.Value=((TextBox)e.Item.FindControl("age")).Text;
SqlParameter parm3=new SqlParameter("@id",SqlDbType.Int);
parm3.Value=this.DataGrid1.DataKeys[e.Item.ItemIndex];
comm.Parameters.Add(parm1);
comm.Parameters.Add(parm2);
comm.Parameters.Add(parm3);
conn.Open();
comm.ExecuteNonQuery();
conn.Close();
this.DataGrid1.EditItemIndex=-1;
SetBind();
}
}
private void DataGrid1_ItemCreated(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
if(e.Item.ItemType==ListItemType.Item||e.Item.ItemType==ListItemType.AlternatingItem||e.Item.ItemType==ListItemType.EditItem)
{
((LinkButton)e.Item.Cells[7].Controls[0]).Attributes.Add("onclick","return confirm('delete?');");
}
}
private void Button2_Click(object sender, System.EventArgs e)
{
if(this.TextBox3.Text=="")
{
SetBind();
}
else
{
SetBind(this.TextBox3.Text);
}
}
private void DataGrid1_SelectedIndexChanged(object sender, System.EventArgs e)
{
}
private void Button3_Click(object sender, System.EventArgs e)
{
SqlConnection conn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["conn"]);
SqlDataAdapter da=new SqlDataAdapter("select * from tb1",conn);
DataSet ds=new DataSet();
da.Fill(ds,"table1");
DataTable dt=ds.Tables["table1"];
string name=System.Configuration.ConfigurationSettings.AppSettings["downloadurl"].ToString()+DateTime.Today.ToString("yyyyMMdd")+new Random(DateTime.Now.Millisecond).Next(10000).ToString()+".csv";
FileStream fs=new FileStream(name,FileMode.Create,FileAccess.Write);
StreamWriter sw=new StreamWriter(fs,System.Text.Encoding.GetEncoding("gb2312"));
sw.WriteLine("自动编号,姓名,年龄");
foreach(DataRow dr in dt.Rows)
{
sw.WriteLine(dr["ID"]+","+dr["vName"]+","+dr["iAge"]);
}
sw.Close();
Response.AddHeader("Content-Disposition", "attachment; filename=" + Server.UrlEncode(name));
Response.ContentType = "application/ms-excel";
Response.WriteFile(name);
Response.End();
}
private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
if(e.Item.ItemType==ListItemType.Item||e.Item.ItemType==ListItemType.AlternatingItem||e.Item.ItemType==ListItemType.EditItem)
{
if(Convert.ToInt16(DataBinder.Eval(e.Item.DataItem,"iAge"))<30)e.Item.BackColor=Color.Pink;
}
}
protected string myfunc(object s)
{
string _s;
if(s.ToString()=="朱晔")
_s="<b>"+s.ToString()+"</b>";
else
_s=s.ToString();
return _s;
}
protected string myfunc2(object s1,object s2)
{
return "newpage.aspx?name="+s1.ToString()+"&age="+s2.ToString();
}
private void Button4_Click(object sender, System.EventArgs e)
{
if(Request.Form["rad"] != null)
{
rd.Value = Request.Form["rad"].ToString();
this.Label1.Text = "选择的行号:" + Request.Form["rad"].ToString();
}
}
private void Button5_Click(object sender, System.EventArgs e)
{
this.Label1.Text="";
foreach(DataGridItem di in this.DataGrid1.Items)
{
if(((CheckBox)di.FindControl("chkExport")).Checked==true)
{
this.Label1.Text+=this.DataGrid1.DataKeys[int.Parse(((HtmlInputHidden)di.FindControl("SelectedID")).Value)]+"<br>";
}
}
}
private void Button6_Click(object sender, System.EventArgs e)
{
foreach(DataGridItem di in this.DataGrid1.Items)
{
((CheckBox)di.FindControl("chkExport")).Checked=true;
}
}
private void Button7_Click(object sender, System.EventArgs e)
{
foreach(DataGridItem di in this.DataGrid1.Items)
{
((CheckBox)di.FindControl("chkExport")).Checked=false;
}
}
}
<! DOCTYPE HTML PUBLIC " -//W3C//DTD HTML 4.0 Transitional//EN " >
< HTML >
< HEAD >
< title > WebForm5 </ title >
< meta content = " Microsoft Visual Studio .NET 7.1 " name = " GENERATOR " >
< meta content = " C# " name = " CODE_LANGUAGE " >
< meta content = " JavaScript " name = " vs_defaultClientScript " >
< meta content = " http://schemas.microsoft.com/intellisense/ie5 " name = " vs_targetSchema " >
</ HEAD >
< body >
< form id = " Form1 " method = " post " runat = " server " >
< input type = " hidden " id = " rd " runat = " server " name = " rd " >
< asp:textbox id = " TextBox1 " runat = " server " Width = " 88px " ></ asp:textbox >
< asp:TextBox id = " TextBox2 " runat = " server " Width = " 40px " ></ asp:TextBox >
< asp:Button id = " Button1 " runat = " server " Text = " 添加 " ></ asp:Button >
< asp:TextBox id = " TextBox3 " runat = " server " Width = " 128px " ></ asp:TextBox >
< asp:Button id = " Button2 " runat = " server " Text = " 筛选 " ></ asp:Button >
< asp:Button id = " Button3 " runat = " server " Text = " 下载 " ></ asp:Button >
< asp:DataGrid ID = " DataGrid1 " runat = " server " AutoGenerateColumns = " False " DataKeyField = " ID " AllowPaging = " True "
PageSize = " 20 " OnEditCommand = " edit " OnCancelCommand = " cancel " OnUpdateCommand = " update " >
< columns >
< asp:TemplateColumn HeaderText = " 多选 " >
< itemtemplate >
< input type = " hidden " id = " SelectedID " runat = " server "
value = ' <%# Container.ItemIndex%> ' name = " SelectedID " />
< asp:CheckBox ID = " chkExport " runat = " server " />
</ itemtemplate >
</ asp:TemplateColumn >
< asp:TemplateColumn HeaderText = " 单选 " >
< itemtemplate >
<% # Container.ItemIndex + 1 %>
< input type = radio name = " rad " value = ' <%# Container.ItemIndex+1%> ' >
</ itemtemplate >
</ asp:TemplateColumn >
< asp:TemplateColumn HeaderText = " 姓名 " >
< itemtemplate >
<% # myfunc(DataBinder.Eval(Container.DataItem, " vName " )) %>
</ itemtemplate >
< edititemtemplate >
< asp:TextBox ID = " name " runat = " server " Text = ' <%# DataBinder.Eval(Container.DataItem,"vName") %> ' Width = " 88px " > </ asp:TextBox >
</ edititemtemplate >
</ asp:TemplateColumn >
< asp:TemplateColumn HeaderText = " 年龄 " >
< itemtemplate >
<% # DataBinder.Eval(Container.DataItem, " iAge " ) %>
</ itemtemplate >
< edititemtemplate >
< asp:TextBox ID = " age " runat = " server " Text = ' <%# DataBinder.Eval(Container.DataItem,"iAge") %> ' Width = " 40px " > </ asp:TextBox >
</ edititemtemplate >
</ asp:TemplateColumn >
< asp:TemplateColumn HeaderText = " 打开 " >
< itemtemplate >
< asp:HyperLink Text = " 打开 " NavigateUrl = ' <%#"newpage.aspx?name="+DataBinder.Eval(Container.DataItem, "vname")+"&age="+DataBinder.Eval(Container.DataItem, "iage") %> ' runat = " server " Target = " _blank " > </ asp:HyperLink >
</ itemtemplate >
</ asp:TemplateColumn >
< asp:TemplateColumn HeaderText = " 打开 " >
< itemtemplate >
< asp:HyperLink Text = " 打开 " NavigateUrl = ' <%# myfunc2(DataBinder.Eval(Container.DataItem,"vName"),DataBinder.Eval(Container.DataItem,"iAge"))%> ' runat = " server " Target = " _blank " ID = " Hyperlink1 " > </ asp:HyperLink >
</ itemtemplate >
</ asp:TemplateColumn >
< asp:EditCommandColumn ButtonType = " LinkButton " UpdateText = " 更新 " CancelText = " 取消 " EditText = " 编辑 " ></ asp:EditCommandColumn >
< asp:ButtonColumn Text = " 删除 " CommandName = " del " ></ asp:ButtonColumn >
</ columns >
< pagerstyle Mode = " NumericPages " ></ pagerstyle >
</ asp:DataGrid >
< asp:Label id = " Label1 " runat = " server " ></ asp:Label >
< asp:Button ID = " button4 " runat = " server " Text = " 单选结果 " ></ asp:Button >
< asp:Button id = " Button5 " runat = " server " Text = " 多选结果 " ></ asp:Button >
< asp:Button id = " Button6 " runat = " server " Text = " 选中所有 " ></ asp:Button >
< asp:Button id = " Button7 " runat = " server " Text = " 取消所有 " ></ asp:Button ></ form >
< p >& nbsp; </ p >
< p >& nbsp; </ p >
</ body >
</ HTML >
后台代码:
// C# Document
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls; using System.IO;
namespace csdn
{
/**//**//**//// <summary>
/// WebForm5 的摘要说明。
/// </summary>
public class WebForm5 : System.Web.UI.Page
{
protected System.Web.UI.WebControls.TextBox TextBox1;
protected System.Web.UI.WebControls.TextBox TextBox2;
protected System.Web.UI.WebControls.Button Button1;
protected System.Web.UI.WebControls.TextBox TextBox3;
protected System.Web.UI.WebControls.Button Button2;
protected System.Web.UI.WebControls.Button Button3;
protected System.Web.UI.WebControls.Label Label1;
protected System.Web.UI.HtmlControls.HtmlInputHidden rd;
protected System.Web.UI.WebControls.Button button4;
protected System.Web.UI.WebControls.Button Button5;
protected System.Web.UI.WebControls.Button Button6;
protected System.Web.UI.WebControls.DataGrid DataGrid1;
protected System.Web.UI.WebControls.Button Button7;
private void Page_Load(object sender, System.EventArgs e)
{
string js = "";
js+="<script>/r/n";
js+="function ld(){/r/n";
js+="for(i=0;i<document.getElementsByName('rad').length;i++)/r/n";
js+="if(document.getElementsByName('rad')[i].value==";
js+="document.getElementById('rd').value) ";
js+="document.getElementsByName('rad')[i].checked=true/r/n";
js+="}/r/n";
js+="window.οnlοad=ld/r/n";
js+="</script>/r/n";
this.RegisterClientScriptBlock("js",js);
if(!IsPostBack)
{
SetBind();
}
}
protected void SetBind()
{
SqlConnection conn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["conn"]);
SqlDataAdapter da=new SqlDataAdapter("select * from tb1",conn);
DataSet ds=new DataSet();
da.Fill(ds,"table1");
this.DataGrid1.DataSource=ds.Tables["table1"];
this.DataGrid1.DataBind();
this.Label1.Text=ds.Tables["table1"].Compute("avg(iAge)","iAge>20").ToString();
}
protected void SetBind(string s)
{
SqlConnection conn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["conn"]);
SqlDataAdapter da=new SqlDataAdapter("select * from tb1",conn);
DataSet ds=new DataSet();
da.Fill(ds,"table1");
DataView dv=ds.Tables["table1"].DefaultView;
dv.RowFilter=s;
this.DataGrid1.DataSource=dv;
this.DataGrid1.DataBind();
}
Web 窗体设计器生成的代码Web 窗体设计器生成的代码#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/**//**//**//// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.Button1.Click += new System.EventHandler(this.Button1_Click);
this.Button2.Click += new System.EventHandler(this.Button2_Click);
this.Button3.Click += new System.EventHandler(this.Button3_Click);
this.button4.Click += new System.EventHandler(this.Button4_Click);
this.Button5.Click += new System.EventHandler(this.Button5_Click);
this.Button6.Click += new System.EventHandler(this.Button6_Click);
this.Button7.Click += new System.EventHandler(this.Button7_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void Button1_Click(object sender, System.EventArgs e)
{
SqlConnection conn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["conn"]);
SqlCommand comm=new SqlCommand("insert into tb1 (vName,iAge) values (@vName,@iAge)",conn);
SqlParameter parm1=new SqlParameter("@vName",SqlDbType.NVarChar,50);
parm1.Value=this.TextBox1.Text;
SqlParameter parm2=new SqlParameter("@iAge",SqlDbType.Int);
parm2.Value=this.TextBox2.Text;
comm.Parameters.Add(parm1);
comm.Parameters.Add(parm2);
conn.Open();
comm.ExecuteNonQuery();
conn.Close();
SetBind();
}
private void DataGrid1_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
if(e.CommandName=="del"&&e.Item.ItemType!=ListItemType.EditItem)
{
SqlConnection conn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["conn"]);
SqlCommand comm=new SqlCommand("delete from tb1 where ID=@id",conn);
SqlParameter parm1=new SqlParameter("@id",SqlDbType.Int);
parm1.Value=this.DataGrid1.DataKeys[e.Item.ItemIndex];
comm.Parameters.Add(parm1);
conn.Open();
comm.ExecuteNonQuery();
conn.Close();
SetBind();
}
}
private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
this.DataGrid1.CurrentPageIndex=e.NewPageIndex;
SetBind();
}
protected void edit(object sender,DataGridCommandEventArgs e)
{
this.DataGrid1.EditItemIndex=e.Item.ItemIndex;
SetBind();
}
protected void cancel(object sender,DataGridCommandEventArgs e)
{
this.DataGrid1.EditItemIndex=-1;
SetBind();
}
protected void update(object sender,DataGridCommandEventArgs e)
{
if(e.Item.ItemType==ListItemType.EditItem)
{
SqlConnection conn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["conn"]);
SqlCommand comm=new SqlCommand("update tb1 set vName=@vName,iAge=@iAge where ID=@id",conn);
SqlParameter parm1=new SqlParameter("@vName",SqlDbType.NVarChar,50);
parm1.Value=((TextBox)e.Item.FindControl("name")).Text;
SqlParameter parm2=new SqlParameter("@iAge",SqlDbType.Int);
parm2.Value=((TextBox)e.Item.FindControl("age")).Text;
SqlParameter parm3=new SqlParameter("@id",SqlDbType.Int);
parm3.Value=this.DataGrid1.DataKeys[e.Item.ItemIndex];
comm.Parameters.Add(parm1);
comm.Parameters.Add(parm2);
comm.Parameters.Add(parm3);
conn.Open();
comm.ExecuteNonQuery();
conn.Close();
this.DataGrid1.EditItemIndex=-1;
SetBind();
}
}
private void DataGrid1_ItemCreated(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
if(e.Item.ItemType==ListItemType.Item||e.Item.ItemType==ListItemType.AlternatingItem||e.Item.ItemType==ListItemType.EditItem)
{
((LinkButton)e.Item.Cells[7].Controls[0]).Attributes.Add("onclick","return confirm('delete?');");
}
}
private void Button2_Click(object sender, System.EventArgs e)
{
if(this.TextBox3.Text=="")
{
SetBind();
}
else
{
SetBind(this.TextBox3.Text);
}
}
private void DataGrid1_SelectedIndexChanged(object sender, System.EventArgs e)
{
}
private void Button3_Click(object sender, System.EventArgs e)
{
SqlConnection conn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["conn"]);
SqlDataAdapter da=new SqlDataAdapter("select * from tb1",conn);
DataSet ds=new DataSet();
da.Fill(ds,"table1");
DataTable dt=ds.Tables["table1"];
string name=System.Configuration.ConfigurationSettings.AppSettings["downloadurl"].ToString()+DateTime.Today.ToString("yyyyMMdd")+new Random(DateTime.Now.Millisecond).Next(10000).ToString()+".csv";
FileStream fs=new FileStream(name,FileMode.Create,FileAccess.Write);
StreamWriter sw=new StreamWriter(fs,System.Text.Encoding.GetEncoding("gb2312"));
sw.WriteLine("自动编号,姓名,年龄");
foreach(DataRow dr in dt.Rows)
{
sw.WriteLine(dr["ID"]+","+dr["vName"]+","+dr["iAge"]);
}
sw.Close();
Response.AddHeader("Content-Disposition", "attachment; filename=" + Server.UrlEncode(name));
Response.ContentType = "application/ms-excel";
Response.WriteFile(name);
Response.End();
}
private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
if(e.Item.ItemType==ListItemType.Item||e.Item.ItemType==ListItemType.AlternatingItem||e.Item.ItemType==ListItemType.EditItem)
{
if(Convert.ToInt16(DataBinder.Eval(e.Item.DataItem,"iAge"))<30)e.Item.BackColor=Color.Pink;
}
}
protected string myfunc(object s)
{
string _s;
if(s.ToString()=="朱晔")
_s="<b>"+s.ToString()+"</b>";
else
_s=s.ToString();
return _s;
}
protected string myfunc2(object s1,object s2)
{
return "newpage.aspx?name="+s1.ToString()+"&age="+s2.ToString();
}
private void Button4_Click(object sender, System.EventArgs e)
{
if(Request.Form["rad"] != null)
{
rd.Value = Request.Form["rad"].ToString();
this.Label1.Text = "选择的行号:" + Request.Form["rad"].ToString();
}
}
private void Button5_Click(object sender, System.EventArgs e)
{
this.Label1.Text="";
foreach(DataGridItem di in this.DataGrid1.Items)
{
if(((CheckBox)di.FindControl("chkExport")).Checked==true)
{
this.Label1.Text+=this.DataGrid1.DataKeys[int.Parse(((HtmlInputHidden)di.FindControl("SelectedID")).Value)]+"<br>";
}
}
}
private void Button6_Click(object sender, System.EventArgs e)
{
foreach(DataGridItem di in this.DataGrid1.Items)
{
((CheckBox)di.FindControl("chkExport")).Checked=true;
}
}
private void Button7_Click(object sender, System.EventArgs e)
{
foreach(DataGridItem di in this.DataGrid1.Items)
{
((CheckBox)di.FindControl("chkExport")).Checked=false;
}
}
}