��,Ц��~~`

��

�� — Thu, 14 Aug 2008 17:54:25 +0800

һ��"�Լ��",��:�ϲ��ϰ�,��ʲô��,��,�᲻��,Ҫ��Ҫ��.....�Լ��ܰ��ŵ��½��.

һ��"��˵��",��:С�źó��,С�µĻ��,��Һܲ��...�� ¶��.

һ��"��ү��",�磺�᲻��η磬��𣬷��ս��Χ��£��ү��Ͻ��Χ��

�˵ķ��վ��ڣ��Լ��£��ܱ��˵��£��ġ��ү��£��

Ҫ��ںܼ򵥣��ã��Լ��£��ȥ��ܱ��˵��£��ģ��ү��£�

��ֻ��~~

�� — Thu, 14 Aug 2008 17:49:45 +0800

��~~��~~��ֻ��ô�Ļ谵��ô��Ǳ��ڵ��磡��ⲻ��~

�Թ��̬��

�� — Fri, 11 Apr 2008 15:33:48 +0800

�ӱ�ҵ��ڣ��ҵĵڶ��ݹ��֮ǰ�Ĺ��ǽ�Ȼ��ͬ�ġ��ȫ��͡��ı仯̫��һ��ʹ��ڶԴ��ʱ��ڲ��ʶ��˵�򵥵㣬��ģ�

��Ҳ��˼��̬��ԭ�򡣵�һ��ʲ��Ԥ��ڴ��ģ��ܴ�֮ǰ�Ĺ��רҵ��ģ��Լ�Ҳ�ܸ��Ȥ��ͨ��Լ��Ŭ��гɾ͸С��ÿ�춼��Ե��һ��ݡ��ǽ��ظ��Ե�¼�룬�ܷ��Ҳ�ܻ�е��ľ��Ҳ��ͳ��ѧ��ж��û�о��ڶ��ʱ��̫��˵�õ��ǣ�ÿ��Ϣ��δʵ�ֹ��ÿ��Ĺ��ʱ��Ҳ��Լ��Ҫ��ҵĴ��Ҳ��һ�㡣��˾��ղ��Ӧ��Ȼ��ù�˾��ʱ��ӦԱ��ģ�ֻ��Ա��Ӧ��˾��˵��Լ��ڻ�û��ô��Ӧ��ܵ��˵��²��

��

��```

�� — Wed, 12 Dec 2007 17:40:10 +0800

�ҽ��а��```

�ǲ��ǹ��ʲô��ѽ``,��˵Ҳ֪��ǲ��õ��```

��```ǰ��ʱ��,��ҵ�IP,�һ�ɵ��ȥ��ԭ��(Ϊʲô�ϲ��),��IP~~~

��``��Ѷ��!!

��

�� — Thu, 22 Nov 2007 17:45:23 +0800

��```�ջ񲻴�``�۾�ȴԽ��Խ��```��Ϊÿ�춼��ŵ��!!

�ӿ�ʼ�ϰ�,��Ҫת��!!��һ��һ��``ת��ʱ��Ҫ��```(��Ȼ�Լ��ȷ��û��ҹ�``)~~

��Ӧ��ֵ�ø��ĵ��,��ȴ��˷��```��һͬ��`��ְ!!!

��뿴��Ľ��```

��ư�````

GridView 72��(��)

�� — Mon, 24 Sep 2007 11:49:46 +0800

16.GridViewͻ��ʾĳһ��Ԫ��ڶ��٣��ȣ�

Ч��ͼ��

��Ҫ�ǰ󶨺��

GridView1.DataBind();

for (int i = 0; i <= GridView1.Rows.Count - 1; i++)

{

DataRowView mydrv = myds.Tables["�ɺ��"].DefaultView[i];

string score = Convert.ToString(mydrv["��н"]);

if (Convert.ToDouble(score) < 34297.00)//��ݾ��ÿ��ToInt32�ȵ�

{

GridView1.Rows[i].Cells[4].BackColor = System.Drawing.Color.Red;

}

sqlcon.Close();

ȫ��̨��룺

using System;

using System.Data;

using System.Configuration;

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 System.Drawing;

public partial class Default7 : System.Web.UI.Page

{

SqlConnection sqlcon;

SqlCommand sqlcom;

string strCon = "Data Source=(local);Database=��ó��;Uid=sa;Pwd=sa";

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

bind();

}

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)

{

GridView1.EditIndex = e.NewEditIndex;

bind();

}

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)

{

sqlcon = new SqlConnection(strCon);

string sqlstr = "update �ɺ�� set ��='"

+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim() + "',��ͥסַ='"

+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim() + "' where ��֤��='"

+ GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";

sqlcom = new SqlCommand(sqlstr, sqlcon);

sqlcon.Open();

sqlcom.ExecuteNonQuery();

sqlcon.Close();

GridView1.EditIndex = -1;

bind();

}

protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)

{

GridView1.EditIndex = -1;

bind();

}

public void bind()

{

string sqlstr = "select top 10 * from �ɺ��";

sqlcon = new SqlConnection(strCon);

SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);

DataSet myds = new DataSet();

sqlcon.Open();

myda.Fill(myds, "�ɺ��");

GridView1.DataSource = myds;

GridView1.DataKeyNames = new string[] { "��֤��" };

GridView1.DataBind();

for (int i = 0; i <= GridView1.Rows.Count - 1; i++)

{

DataRowView mydrv = myds.Tables["�ɺ��"].DefaultView[i];

string score = Convert.ToString(mydrv["��н"]);

if (Convert.ToDouble(score) < 34297.00)//��ݾ��ÿ��ToInt32�ȵ�

{

GridView1.Rows[i].Cells[4].BackColor = System.Drawing.Color.Red;

}

sqlcon.Close();

}

ǰ̨��룺

http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

http://www.w3.org/1999/xhtml" >

GridViewͻ��ʾĳһ��Ԫ�� ¶�<A href="http://blog.csdn.net/21aspnet">http://blog.csdn.net/21aspnet</A>

OnRowUpdating="GridView1_RowUpdating" OnRowCancelingEdit="GridView1_RowCancelingEdit" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" Font-Size="12px" >

17.GridView��Զ��ƽ��ֵС��

Ч��ͼ��

��

private double sum = 0;//ȡָ��е��ݺͣ��Ҫ��ݾ��Դ��Ҫ��int

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)

{

if (e.Row.RowIndex >= 0)

{

sum += Convert.ToDouble(e.Row.Cells[6].Text);

}

else if (e.Row.RowType == DataControlRowType.Footer)

{

e.Row.Cells[5].Text = "��нˮΪ��";

e.Row.Cells[6].Text = sum.ToString();

e.Row.Cells[3].Text = "ƽ��нˮΪ��";

e.Row.Cells[4].Text = ((int)(sum / GridView1.Rows.Count)).ToString();

}

��̨ȫ��룺

using System;

using System.Data;

using System.Configuration;

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 System.Drawing;

public partial class Default7 : System.Web.UI.Page

{

SqlConnection sqlcon;

SqlCommand sqlcom;

string strCon = "Data Source=(local);Database=��ó��;Uid=sa;Pwd=sa";

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

bind();

}

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)

{

GridView1.EditIndex = e.NewEditIndex;

bind();

}

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)

{

sqlcon = new SqlConnection(strCon);

string sqlstr = "update �ɺ�� set ��='"

+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim() + "',��ͥסַ='"

+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim() + "' where ��֤��='"

+ GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";

sqlcom = new SqlCommand(sqlstr, sqlcon);

sqlcon.Open();

sqlcom.ExecuteNonQuery();

sqlcon.Close();

GridView1.EditIndex = -1;

bind();

}

protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)

{

GridView1.EditIndex = -1;

bind();

}

public void bind()

{

string sqlstr = "select top 5 * from �ɺ��";

sqlcon = new SqlConnection(strCon);

SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);

DataSet myds = new DataSet();

sqlcon.Open();

myda.Fill(myds, "�ɺ��");

GridView1.DataSource = myds;

GridView1.DataKeyNames = new string[] { "��֤��" };

GridView1.DataBind();

sqlcon.Close();

}

private double sum = 0;//ȡָ��е��ݺ�

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)

{

if (e.Row.RowIndex >= 0)

{

sum += Convert.ToDouble(e.Row.Cells[6].Text);

}

else if (e.Row.RowType == DataControlRowType.Footer)

{

e.Row.Cells[5].Text = "��нˮΪ��";

e.Row.Cells[6].Text = sum.ToString();

e.Row.Cells[3].Text = "ƽ��нˮΪ��";

e.Row.Cells[4].Text = ((int)(sum / GridView1.Rows.Count)).ToString();

}

ǰ̨��Ψһ�Ļ�ͷ��ShowFooter="True" ��Ĭ�ϱ�ͷΪ��صģ�

OnRowUpdating="GridView1_RowUpdating" OnRowCancelingEdit="GridView1_RowCancelingEdit" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" Font-Size="12px" OnRowDataBound="GridView1_RowDataBound" ShowFooter="True" >

18.GridView��ݵ��Excel/Excel��ݶ��GridView

Ч��ͼ��

��

ҳ��һ��ť��¼��·��

protected void Button1_Click(object sender, EventArgs e)

{

Export("application/ms-excel", "ѧ��ɼ��.xls");

}

private void Export(string FileType, string FileName)

{

Response.Charset = "GB2312";

Response.ContentEncoding = System.Text.Encoding.UTF7;

Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString());

Response.ContentType = FileType;

this.EnableViewState = false;

StringWriter tw = new StringWriter();

HtmlTextWriter hw = new HtmlTextWriter(tw);

GridView1.RenderControl(hw);

Response.Write(tw.ToString());

Response.End();

}

//��û��淽��ᱨ��͡�GridView��Ŀؼ��GridView1��ھ�� runat=server �Ĵ��

public override void VerifyRenderingInServerForm(Control control)

{

}

��ļ��Ҫ��ƿռ�IO��Text

��̨��룺

using System;

using System.Data;

using System.Configuration;

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 System.Drawing;

using System.IO;

using System.Text;

public partial class Default7 : System.Web.UI.Page

{

SqlConnection sqlcon;

SqlCommand sqlcom;

string strCon = "Data Source=(local);Database=��ó��;Uid=sa;Pwd=sa";

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

bind();

}

public void bind()

{

string sqlstr = "select top 5 * from �ɺ��";

sqlcon = new SqlConnection(strCon);

SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);

DataSet myds = new DataSet();

sqlcon.Open();

myda.Fill(myds, "�ɺ��");

GridView1.DataSource = myds;

GridView1.DataKeyNames = new string[] { "��֤��" };

GridView1.DataBind();

sqlcon.Close();

}

protected void Button1_Click(object sender, EventArgs e)

{

Export("application/ms-excel", "ѧ��ɼ��.xls");

}

private void Export(string FileType, string FileName)

{

Response.Charset = "GB2312";

Response.ContentEncoding = System.Text.Encoding.UTF7;

Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString());

Response.ContentType = FileType;

this.EnableViewState = false;

StringWriter tw = new StringWriter();

HtmlTextWriter hw = new HtmlTextWriter(tw);

GridView1.RenderControl(hw);

Response.Write(tw.ToString());

Response.End();

}

public override void VerifyRenderingInServerForm(Control control)

{

}

ǰ̨��

BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" Font-Size="12px" >

��ȡExcel��ݵĴ��룺��ܼ򵥵�

private DataSet CreateDataSource()

{

string strCon;

strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("excel.xls") + "; Extended Properties=Excel 8.0;";

OleDbConnection olecon = new OleDbConnection(strCon);

OleDbDataAdapter myda = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", strCon);

DataSet myds = new DataSet();

myda.Fill(myds);

return myds;

}

protected void Button1_Click(object sender, EventArgs e)

{

GridView1.DataSource = CreateDataSource();

GridView1.DataBind();

}

GridView 72�� (��)

�� — Mon, 24 Sep 2007 11:48:09 +0800

11.GridViewʵ��á�...��泬��ַ��

Ч��ͼ��

��ݰ󶨺��ÿһ�м��

for (int i = 0; i <= GridView1.Rows.Count - 1; i++)

{

DataRowView mydrv;

string gIntro;

if (GridView1.PageIndex == 0)

{

mydrv = myds.Tables["�ɺ��"].DefaultView[i];//��

gIntro = Convert.ToString(mydrv["��ͥסַ"]);//��Ҫ��ֶ�

GridView1.Rows[i].Cells[3].Text = SubStr(gIntro, 2);

}

else

{

mydrv = myds.Tables["�ɺ��"].DefaultView[i + (5 * GridView1.PageIndex)];

gIntro = Convert.ToString(mydrv["��ͥסַ"]);

GridView1.Rows[i].Cells[3].Text = SubStr(gIntro, 2);

}

��õķ��

public string SubStr(string sString, int nLeng)

{

if (sString.Length <= nLeng)

{

return sString;

}

string sNewStr = sString.Substring(0, nLeng);

sNewStr = sNewStr + "...";

return sNewStr;

}

��̨ȫ��룺

using System;

using System.Data;

using System.Configuration;

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;

public partial class _Default : System.Web.UI.Page

{

SqlConnection sqlcon;

SqlCommand sqlcom;

string strCon = "Data Source=(local);Database=��ó��;Uid=sa;Pwd=sa";

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

ViewState["SortOrder"] = "��֤��";

ViewState["OrderDire"] = "ASC";

bind();

}

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)

{

GridView1.EditIndex = e.NewEditIndex;

bind();

}

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)

{

string sqlstr = "delete from �ɺ�� where ��֤��='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";

sqlcon = new SqlConnection(strCon);

sqlcom = new SqlCommand(sqlstr,sqlcon);

sqlcon.Open();

sqlcom.ExecuteNonQuery();

sqlcon.Close();

bind();

}

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)

{

sqlcon = new SqlConnection(strCon);

string sqlstr = "update �ɺ�� set ��='"

+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim() + "',��ͥסַ='"

+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim() + "' where ��֤��='"

+ GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";

sqlcom=new SqlCommand(sqlstr,sqlcon);

sqlcon.Open();

sqlcom.ExecuteNonQuery();

sqlcon.Close();

GridView1.EditIndex = -1;

bind();

}

protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)

{

GridView1.EditIndex = -1;

bind();

}

public void bind()

{

string sqlstr = "select top 5 * from �ɺ��";

sqlcon = new SqlConnection(strCon);

SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);

DataSet myds = new DataSet();

sqlcon.Open();

myda.Fill(myds, "�ɺ��");

GridView1.DataSource = myds;

GridView1.DataKeyNames = new string[] { "��֤��" };

GridView1.DataBind();

for (int i = 0; i <= GridView1.Rows.Count - 1; i++)

{

DataRowView mydrv;

string gIntro;

if (GridView1.PageIndex == 0)

{

mydrv = myds.Tables["�ɺ��"].DefaultView[i];

gIntro = Convert.ToString(mydrv["��ͥסַ"]);

GridView1.Rows[i].Cells[3].Text = SubStr(gIntro, 2);

}

else

{

mydrv = myds.Tables["�ɺ��"].DefaultView[i + (5 * GridView1.PageIndex)];

gIntro = Convert.ToString(mydrv["��ͥסַ"]);

GridView1.Rows[i].Cells[3].Text = SubStr(gIntro, 2);

}

sqlcon.Close();

}

public string SubStr(string sString, int nLeng)

{

if (sString.Length <= nLeng)

{

return sString;

}

string sNewStr = sString.Substring(0, nLeng);

sNewStr = sNewStr + "...";

return sNewStr;

}

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)

{

//��ǰ��

if (e.Row.RowType == DataControlRowType.DataRow)

{

////��꾭��ʱ��б��ɫ��

//e.Row.Attributes.Add("onmouseover", "this.style.backgroundColor='#E6F5FA'");

////��Ƴ�ʱ��б��ɫ��

//e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor='#FFFFFF'");

////��б༭��ʱ��Ҫ�ӵ�RowState�ж�

//if (e.Row.RowState == DataControlRowState.Normal || e.Row.RowState == DataControlRowState.Alternate)

//{

// ((LinkButton)e.Row.Cells[6].Controls[0]).Attributes.Add("onclick", "javascript:return confirm('��ȷ��Ҫɾ��\"" + e.Row.Cells[1].Text + "\"��?')");

//}

}

if (e.Row.RowIndex != -1)

{

int id = e.Row.RowIndex + 1;

e.Row.Cells[0].Text = id.ToString();

}

11.GridViewһ�㻻��ǿ�ƻ��У�

Ч��ͼ��

��

gridview��һ�а󶨵��ݺܳ��ʾ��ʱ��һ��ʾ��ҳ��úܿ��

ԭ��Ӣ�Ķ�Ϊһ��嵼�µģ��RowDataBound��һ��e.Row.Cells[2].Style.Add("word-break", "break-all")�Ϳ��ԡ�

��Ҫ��е��Ӵ��ԣ�

protected void Page_Load(object sender, EventArgs e)

{

//��

GridView1.Attributes.Add("style", "word-break:keep-all;word-wrap:normal");

//��Զ��

GridView1.Attributes.Add("style", "word-break:break-all;word-wrap:break-word");

if (!IsPostBack)

{

bind();//��ݰ󶨼��

}

��֮��CSS��word-break:break-all;word-wrap:break-word��Լ��ɣ��ͨ�õĶ��̵��ϻ��ⶼ��Խ��GridView��

12.GridView��ʾ��ĳһ�У�

��Ϊ�¶��ͬ��ʽ��Ҿ��һ��CheckBox��Ի��ز��Ҫ��У��û��Լ�ѡ��Ҫ��ֵ��У��ڴ��ʱ��һ��ܺõĽ��

Ч��ͼ��

ͼ1-��ʼ

ͼ2-��ʾ��CheckBox��

��

public void bind()

{

string sqlstr = "select top 5 * from �ɺ��";

sqlcon = new SqlConnection(strCon);

SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);

DataSet myds = new DataSet();

sqlcon.Open();

myda.Fill(myds, "�ɺ��");

GridView1.DataSource = myds;

GridView1.DataKeyNames = new string[] { "��֤��" };

GridView1.DataBind();

sqlcon.Close();

GridView1.Columns[3].Visible = false;//һ��ʼ��

CheckBox1.Checked = false;//��Ĵ��True

}

˫��CheckBox1��CheckedChanged��д�ϴ��룬��£�

protected void CheckBox1_CheckedChanged(object sender, EventArgs e)

{

GridView1.Columns[3].Visible=! GridView1.Columns[3].Visible;

Response.Write("GridView1�ĵ�4��ڵ��ʾ��״̬�ǣ�"+GridView1.Columns[3].Visible.ToString());

}

ע�⣺CheckBox1��AutoPostBackҪTrue��

��̨ȫ��£�

using System;

using System.Data;

using System.Configuration;

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;

public partial class _Default : System.Web.UI.Page

{

SqlConnection sqlcon;

SqlCommand sqlcom;

string strCon = "Data Source=(local);Database=��ó��;Uid=sa;Pwd=sa";

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

ViewState["SortOrder"] = "��֤��";

ViewState["OrderDire"] = "ASC";

bind();

}

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)

{

GridView1.EditIndex = e.NewEditIndex;

bind();

}

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)

{

string sqlstr = "delete from �ɺ�� where ��֤��='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";

sqlcon = new SqlConnection(strCon);

sqlcom = new SqlCommand(sqlstr,sqlcon);

sqlcon.Open();

sqlcom.ExecuteNonQuery();

sqlcon.Close();

bind();

}

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)

{

sqlcon = new SqlConnection(strCon);

string sqlstr = "update �ɺ�� set ��='"

+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim() + "',��ͥסַ='"

+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim() + "' where ��֤��='"

+ GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";

sqlcom=new SqlCommand(sqlstr,sqlcon);

sqlcon.Open();

sqlcom.ExecuteNonQuery();

sqlcon.Close();

GridView1.EditIndex = -1;

bind();

}

protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)

{

GridView1.EditIndex = -1;

bind();

}

public void bind()

{

string sqlstr = "select top 5 * from �ɺ��";

sqlcon = new SqlConnection(strCon);

SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);

DataSet myds = new DataSet();

sqlcon.Open();

myda.Fill(myds, "�ɺ��");

GridView1.DataSource = myds;

GridView1.DataKeyNames = new string[] { "��֤��" };

GridView1.DataBind();

sqlcon.Close();

GridView1.Columns[3].Visible = false;

CheckBox1.Checked = false;

}

protected void CheckBox1_CheckedChanged(object sender, EventArgs e)

{

GridView1.Columns[3].Visible=! GridView1.Columns[3].Visible;

Response.Write("GridView1�ĵ�4��ڵ��ʾ��״̬�ǣ�"+GridView1.Columns[3].Visible.ToString());

}

ǰ̨��룺

http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

http://www.w3.org/1999/xhtml" >

GridView��ʾ�� ¶�<A href="http://blog.csdn.net/21aspnet">http://blog.csdn.net/21aspnet</A>

OnRowUpdating="GridView1_RowUpdating" OnRowCancelingEdit="GridView1_RowCancelingEdit" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" Font-Size="12px" >

OnCheckedChanged="CheckBox1_CheckedChanged" Text="��ʾ��ؼ�ͥסַ" />

13.GridView��ҳ��/��ƶ��Сλ��´��ڣ�

Ч��ͼ��

��һ��򵥵ķ��´��ڲ��̶��С

OnRowUpdating="GridView1_RowUpdating" OnRowCancelingEdit="GridView1_RowCancelingEdit" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" Font-Size="12px" >

DataNavigateUrlFields��ӵ��ֶ��DataNavigateUrlFormatString��·��

��ȷ��Ƶ��ڴ�Сλ��

DataTextField="LastName" HeaderText="LastName">

ʹ�õ��ǽ��javascript��window.open��window.open�Ĳ��кܶ��ӣ��վҲ��ο�

��ڴ�ȫ http://blog.csdn.net/21aspnet/archive/2004/10/25/150231.aspx ��ɣ�

14.GridView�̶��ͷ(��javascriptֻ��CSS!��ܺ��)��

Ч��ͼ��

��룺

http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

http://www.w3.org/1999/xhtml" >

GridView�̶��ͷ ��¶�<A href="http://blog.csdn.net/21aspnet">http://blog.csdn.net/21aspnet</A>

�÷��CSS��ϵ��ʽ��HeaderStyle��CssClass="Freezing��סGridView��Div��ø߶ȿ��

15.GridView�ϲ��ͷ��ر�ͷ�޴��棨�Ժϲ�3��3�о��

Ч��ͼ��

��̨��룺

using System;

using System.Data;

using System.Configuration;

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 System.Drawing;

public partial class _Default : System.Web.UI.Page

{

SqlConnection sqlcon;

SqlCommand sqlcom;

string strCon = "Data Source=(local);Database=��ó��;Uid=sa;Pwd=sa";

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

bind();

}

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)

{

GridView1.EditIndex = e.NewEditIndex;

bind();

}

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)

{

sqlcon = new SqlConnection(strCon);

string sqlstr = "update �ɺ�� set ��='"

+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim() + "',��ͥסַ='"

+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim() + "' where ��֤��='"

+ GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";

sqlcom=new SqlCommand(sqlstr,sqlcon);

sqlcon.Open();

sqlcom.ExecuteNonQuery();

sqlcon.Close();

GridView1.EditIndex = -1;

bind();

}

protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)

{

GridView1.EditIndex = -1;

bind();

}

public void bind()

{

string sqlstr = "select top 10 * from �ɺ��";

sqlcon = new SqlConnection(strCon);

SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);

DataSet myds = new DataSet();

sqlcon.Open();

myda.Fill(myds, "�ɺ��");

GridView1.DataSource = myds;

GridView1.DataKeyNames = new string[] { "��֤��" };

GridView1.DataBind();

sqlcon.Close();

}

//��ǽ��

protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e)

{

switch (e.Row.RowType)

{

case DataControlRowType.Header:

//��һ�б�ͷ

TableCellCollection tcHeader = e.Row.Cells;

tcHeader.Clear();

tcHeader.Add(new TableHeaderCell());

tcHeader[0].Attributes.Add("rowspan", "3"); //��Row

tcHeader[0].Attributes.Add("bgcolor", "white");

tcHeader[0].Text = "";

tcHeader.Add(new TableHeaderCell());

//tcHeader[1].Attributes.Add("bgcolor", "Red");

tcHeader[1].Attributes.Add("colspan", "6"); //��Column

tcHeader[1].Text = "ȫ��Ϣ";

//�ڶ��б�ͷ

tcHeader.Add(new TableHeaderCell());

tcHeader[2].Attributes.Add("bgcolor", "DarkSeaGreen");

tcHeader[2].Text = "��֤��";

tcHeader.Add(new TableHeaderCell());

tcHeader[3].Attributes.Add("bgcolor", "LightSteelBlue");

tcHeader[3].Attributes.Add("colspan", "2");

tcHeader[3].Text = "��Ϣ";

tcHeader.Add(new TableHeaderCell());

tcHeader[4].Attributes.Add("bgcolor", "DarkSeaGreen");

tcHeader[4].Text = "��";

tcHeader.Add(new TableHeaderCell());

tcHeader[5].Attributes.Add("bgcolor", "LightSteelBlue");

tcHeader[5].Attributes.Add("colspan", "2");

tcHeader[5].Text = "��ϵ��ʽ";

//��б�ͷ

tcHeader.Add(new TableHeaderCell());

tcHeader[6].Attributes.Add("bgcolor", "Khaki");

tcHeader[6].Text = "��֤��";

tcHeader.Add(new TableHeaderCell());

tcHeader[7].Attributes.Add("bgcolor", "Khaki");

tcHeader[7].Text = "��";

tcHeader.Add(new TableHeaderCell());

tcHeader[8].Attributes.Add("bgcolor", "Khaki");

tcHeader[8].Text = "��";

tcHeader.Add(new TableHeaderCell());

tcHeader[9].Attributes.Add("bgcolor", "Khaki");

tcHeader[9].Text = "нˮ";

tcHeader.Add(new TableHeaderCell());

tcHeader[10].Attributes.Add("bgcolor", "Khaki");

tcHeader[10].Text = "��ͥסַ";

tcHeader.Add(new TableHeaderCell());

tcHeader[11].Attributes.Add("bgcolor", "Khaki");

tcHeader[11].Text = "��";

break;

}

ǰ̨��

http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

http://www.w3.org/1999/xhtml" >

GridView�ϲ��ر�ͷ��ͷ ��¶�<A href="http://blog.csdn.net/21aspnet">http://blog.csdn.net/21aspnet</A>

��,Ц��~~`

������������

����ֻ����~~

�Թ�����̬��

��```

����

GridView 72�����(��)

GridView 72����� (��)

��

��ֻ��~~

�Թ��̬��

��

GridView 72��(��)

GridView 72�� (��)