请问下面的代码有什么问题吗? 为什么我运行的时候在页面上什么都显示不出来! 谢谢个位了
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.Drawing;
using System.Web.Configuration;public partial class Default2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
setGridViewStyle();
setFields();
}
SqlDataSource sqldsEmployees = new SqlDataSource();
sqldsEmployees.ConnectionString = WebConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString;
sqldsEmployees.SelectCommand = "select EmployeesID,LastName,FirstName,Title,City from Employees";
sqldsEmployees.UpdateCommand = "update Employees set LastName=@LastName,Title=@Title where EmployeeID=@EmployeeID";
gviewEmployees.DataSourceID = sqldsEmployees.ID;
}
private void setGridViewStyle()
{
gviewEmployees.AutoGenerateColumns=false;
string[] KeyNames = new string[] { "EmployeesID" };
gviewEmployees.DataKeyNames=KeyNames;
gviewEmployees.AllowPaging=true;
gviewEmployees.AllowSorting=true;
gviewEmployees.Font.Size=10;
gviewEmployees.GridLines=GridLines.Both;
gviewEmployees.PageSize=15;
gviewEmployees.PagerStyle.HorizontalAlign=HorizontalAlign.Center;
gviewEmployees.HeaderStyle.BackColor=Color.Tan;
gviewEmployees.RowStyle.BackColor=Color.LightGoldenrodYellow;
gviewEmployees.AlternatingRowStyle.BackColor=Color.PaleGoldenrod;
gviewEmployees.HeaderStyle.ForeColor=Color.Black;
gviewEmployees.PagerStyle.BackColor=Color.Goldenrod;
gviewEmployees.SelectedRowStyle.BackColor=Color.LightBlue;
}
private void setFields()
{
CommandField selectField = new CommandField();
selectField.ButtonType = ButtonType.Link;
selectField.ShowSelectButton = true;
selectField.SelectText = "选择行";
selectField.ItemStyle.Wrap = false; CommandField editField = new CommandField();
editField.ButtonType = ButtonType.Button;
editField.ShowEditButton = true;
editField.ShowCancelButton = true;
editField.EditText = "编辑";
editField.UpdateText = "更新";
editField.CancelText = "取消";
editField.ItemStyle.Wrap = false; BoundField employeeidField = new BoundField();
BoundField lastnameField = new BoundField();
BoundField firstnameField = new BoundField();
BoundField titleField = new BoundField();
BoundField cityField = new BoundField(); employeeidField.DataField = "EmployeeID";
employeeidField.HeaderText = "员工代号";
employeeidField.ItemStyle.Wrap = false;
employeeidField.ReadOnly = true; lastnameField.DataField = "LastName";
lastnameField.HeaderText = "名字";
lastnameField.ItemStyle.Wrap = false; firstnameField.DataField = "FirstName";
firstnameField.HeaderText = "姓氏";
firstnameField.ItemStyle.Wrap = false;
firstnameField.ReadOnly = true; titleField.DataField = "Title";
titleField.HeaderText = "职称";
titleField.ItemStyle.Wrap = false; cityField.DataField = "City";
cityField.HeaderText = "县市";
cityField.ItemStyle.Wrap = false; gviewEmployees.Columns.Add(selectField);
gviewEmployees.Columns.Add(editField);
gviewEmployees.Columns.Add(employeeidField);
gviewEmployees.Columns.Add(lastnameField);
gviewEmployees.Columns.Add(firstnameField);
gviewEmployees.Columns.Add(titleField);
gviewEmployees.Columns.Add(cityField);
}
private void gviewEmployee_RowEditing(object sender, GridViewEditEventArgs e)
{
gviewEmployees.Columns[3].ControlStyle.Width = 50;
gviewEmployees.Columns[3].ControlStyle.BackColor = Color.LightBlue;
gviewEmployees.ShowFooter = true;
gviewEmployees.Columns[3].FooterText = "可编辑";
gviewEmployees.Columns[3].FooterStyle.BackColor = Color.Red;
gviewEmployees.Columns[5].ControlStyle.Width = 100;
gviewEmployees.Columns[5].ControlStyle.BackColor = Color.LightPink;
gviewEmployees.ShowFooter = true;
gviewEmployees.Columns[5].FooterText = "可编辑";
gviewEmployees.Columns[5].FooterStyle.BackColor = Color.Red;
gviewEmployees.Columns[6].ControlStyle.Width = 100;
gviewEmployees.Columns[6].ControlStyle.BackColor = Color.LightGreen;
gviewEmployees.ShowFooter = true;
gviewEmployees.Columns[6].FooterText = "可编辑";
gviewEmployees.Columns[6].FooterStyle.BackColor = Color.Red;
}
private void gviewEmployee_RowCancelingEdit(object sender, GridViewEditEventArgs e)
{
gviewEmployees.ShowFooter = false;
}
private void gviewEmployees_SelectedIndexChanging(object sender, GridViewEditEventArgs e)
{
if (gviewEmployees.EditIndex != -1)
{
gviewEmployees.SelectedIndex = -1;
e.Cancel = true;
Literal txtMsg = new Literal();
txtMsg.Text = "<script>alert('编辑模式下禁止选择换行!')</sctipt>";
Page.Controls.Add(txtMsg);
}
}
private void gviewEmployees_SelectedIndexChanged(object sender, EventArgs e)
{
Label txtMsg = new Label();
switch (gviewEmployees.Rows[gviewEmployees.SelectedIndex].RowState)
{
case DataControlRowState.Selected:
txtMsg.Text = "您选择奇数行,行状态为:" + gviewEmployees.Rows[gviewEmployees.SelectedIndex].RowState + ":" + gviewEmployees.Rows[gviewEmployees.SelectedIndex].Cells[3].Text;
break;
case (DataControlRowState.Alternate | DataControlRowState.Selected):
txtMsg.Text = "您选择的是偶数行,行状态为:" + gviewEmployees.Rows[gviewEmployees.SelectedIndex].RowState + ":" + gviewEmployees.Rows[gviewEmployees.SelectedIndex].Cells[3].Text;
break;
}
Page.Controls.Add(txtMsg);
}
}
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.Drawing;
using System.Web.Configuration;public partial class Default2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
setGridViewStyle();
setFields();
}
SqlDataSource sqldsEmployees = new SqlDataSource();
sqldsEmployees.ConnectionString = WebConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString;
sqldsEmployees.SelectCommand = "select EmployeesID,LastName,FirstName,Title,City from Employees";
sqldsEmployees.UpdateCommand = "update Employees set LastName=@LastName,Title=@Title where EmployeeID=@EmployeeID";
gviewEmployees.DataSourceID = sqldsEmployees.ID;
}
private void setGridViewStyle()
{
gviewEmployees.AutoGenerateColumns=false;
string[] KeyNames = new string[] { "EmployeesID" };
gviewEmployees.DataKeyNames=KeyNames;
gviewEmployees.AllowPaging=true;
gviewEmployees.AllowSorting=true;
gviewEmployees.Font.Size=10;
gviewEmployees.GridLines=GridLines.Both;
gviewEmployees.PageSize=15;
gviewEmployees.PagerStyle.HorizontalAlign=HorizontalAlign.Center;
gviewEmployees.HeaderStyle.BackColor=Color.Tan;
gviewEmployees.RowStyle.BackColor=Color.LightGoldenrodYellow;
gviewEmployees.AlternatingRowStyle.BackColor=Color.PaleGoldenrod;
gviewEmployees.HeaderStyle.ForeColor=Color.Black;
gviewEmployees.PagerStyle.BackColor=Color.Goldenrod;
gviewEmployees.SelectedRowStyle.BackColor=Color.LightBlue;
}
private void setFields()
{
CommandField selectField = new CommandField();
selectField.ButtonType = ButtonType.Link;
selectField.ShowSelectButton = true;
selectField.SelectText = "选择行";
selectField.ItemStyle.Wrap = false; CommandField editField = new CommandField();
editField.ButtonType = ButtonType.Button;
editField.ShowEditButton = true;
editField.ShowCancelButton = true;
editField.EditText = "编辑";
editField.UpdateText = "更新";
editField.CancelText = "取消";
editField.ItemStyle.Wrap = false; BoundField employeeidField = new BoundField();
BoundField lastnameField = new BoundField();
BoundField firstnameField = new BoundField();
BoundField titleField = new BoundField();
BoundField cityField = new BoundField(); employeeidField.DataField = "EmployeeID";
employeeidField.HeaderText = "员工代号";
employeeidField.ItemStyle.Wrap = false;
employeeidField.ReadOnly = true; lastnameField.DataField = "LastName";
lastnameField.HeaderText = "名字";
lastnameField.ItemStyle.Wrap = false; firstnameField.DataField = "FirstName";
firstnameField.HeaderText = "姓氏";
firstnameField.ItemStyle.Wrap = false;
firstnameField.ReadOnly = true; titleField.DataField = "Title";
titleField.HeaderText = "职称";
titleField.ItemStyle.Wrap = false; cityField.DataField = "City";
cityField.HeaderText = "县市";
cityField.ItemStyle.Wrap = false; gviewEmployees.Columns.Add(selectField);
gviewEmployees.Columns.Add(editField);
gviewEmployees.Columns.Add(employeeidField);
gviewEmployees.Columns.Add(lastnameField);
gviewEmployees.Columns.Add(firstnameField);
gviewEmployees.Columns.Add(titleField);
gviewEmployees.Columns.Add(cityField);
}
private void gviewEmployee_RowEditing(object sender, GridViewEditEventArgs e)
{
gviewEmployees.Columns[3].ControlStyle.Width = 50;
gviewEmployees.Columns[3].ControlStyle.BackColor = Color.LightBlue;
gviewEmployees.ShowFooter = true;
gviewEmployees.Columns[3].FooterText = "可编辑";
gviewEmployees.Columns[3].FooterStyle.BackColor = Color.Red;
gviewEmployees.Columns[5].ControlStyle.Width = 100;
gviewEmployees.Columns[5].ControlStyle.BackColor = Color.LightPink;
gviewEmployees.ShowFooter = true;
gviewEmployees.Columns[5].FooterText = "可编辑";
gviewEmployees.Columns[5].FooterStyle.BackColor = Color.Red;
gviewEmployees.Columns[6].ControlStyle.Width = 100;
gviewEmployees.Columns[6].ControlStyle.BackColor = Color.LightGreen;
gviewEmployees.ShowFooter = true;
gviewEmployees.Columns[6].FooterText = "可编辑";
gviewEmployees.Columns[6].FooterStyle.BackColor = Color.Red;
}
private void gviewEmployee_RowCancelingEdit(object sender, GridViewEditEventArgs e)
{
gviewEmployees.ShowFooter = false;
}
private void gviewEmployees_SelectedIndexChanging(object sender, GridViewEditEventArgs e)
{
if (gviewEmployees.EditIndex != -1)
{
gviewEmployees.SelectedIndex = -1;
e.Cancel = true;
Literal txtMsg = new Literal();
txtMsg.Text = "<script>alert('编辑模式下禁止选择换行!')</sctipt>";
Page.Controls.Add(txtMsg);
}
}
private void gviewEmployees_SelectedIndexChanged(object sender, EventArgs e)
{
Label txtMsg = new Label();
switch (gviewEmployees.Rows[gviewEmployees.SelectedIndex].RowState)
{
case DataControlRowState.Selected:
txtMsg.Text = "您选择奇数行,行状态为:" + gviewEmployees.Rows[gviewEmployees.SelectedIndex].RowState + ":" + gviewEmployees.Rows[gviewEmployees.SelectedIndex].Cells[3].Text;
break;
case (DataControlRowState.Alternate | DataControlRowState.Selected):
txtMsg.Text = "您选择的是偶数行,行状态为:" + gviewEmployees.Rows[gviewEmployees.SelectedIndex].RowState + ":" + gviewEmployees.Rows[gviewEmployees.SelectedIndex].Cells[3].Text;
break;
}
Page.Controls.Add(txtMsg);
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货