如图,是GridView,其中类型一栏的数值是0,1类的数字,浏览器查看只有这一栏为空,应该用代码转化,但不知道该写在什么地方,
转换代码如下:
//根据数据库内的编码返回所代表的含义
public string teaType(object source)
{
if (source.ToString() == "0")
{
return "管理员";
}
if (source.ToString() == "1")
{
return "教工";
}
return "";
}
//根据数据库内的编码返回所代表的含义
public string teaSex(object source)
{
if (source.ToString() == "0")
{
return "男";
}
if (source.ToString() == "1")
{
return "女";
}
return "";
}
另外,单击详情时提示(是通过下面的FormView查看和编辑的):
编译器错误消息: CS1061: “ASP.admin_teacher_aspx”不包含“LinkButton2_Click”的定义,并且找不到可接受类型为“ASP.admin_teacher_aspx”的第一个参数的扩展方法“LinkButton2_Click”(是否缺少 using 指令或程序集引用?)
,难道还要为每一个LinkButton写一个click方法?我已经写了RowCommand方法,如下:
protected void GridViewResult_RowCommand(object sender, GridViewCommandEventArgs e)
{
//如果单击的是详情按钮
if (e.CommandName == "MyDetail")
{
//获取单击行的索引值
int index = Convert.ToInt32(e.CommandArgument);
//通过索引获取此行的教工编号
string teaID = this.GridViewResult.Rows[index].Cells[0].Text.Trim();
//创建Sql语句,从数据库内查询出此教工
string sql = "SELECT teaID,teaName,teaSex,teaTelphone,teaType,teaPhone,teaEmail,teaPassword FROM Teacher WHERE teaID='" + teaID + "'";
//设置SqlDataSource数据源控件,使用此SQL语句进行查询
this.SqlDataSourceOperation.SelectCommand = sql;
//设置FormView控件的数据源控件
this.FormViewOperation.DataSourceID = this.SqlDataSourceOperation.ID;
}
if (e.CommandName == "MyModify")
{
//获取单击行的索引值
int index = Convert.ToInt32(e.CommandArgument);
//通过索引获取此行的教工编号
string teaID = this.GridViewResult.Rows[index].Cells[0].Text.Trim();
//创建Sql语句,从数据库内查询出此教工
string SelectSql = "SELECT teaID,teaName,teaSex,teaTelphone,teaType,teaPhone,teaEmail,teaPassword FROM Teacher WHERE teaID='" + teaID + "'";
//设置SqlDataSource数据源控件,使用此SQL语句进行查询
this.SqlDataSourceOperation.SelectCommand = SelectSql;
//设置FormView控件的数据源控件
this.FormViewOperation.DataSourceID = this.SqlDataSourceOperation.ID;
//更改FormView的显示视图
this.FormViewOperation.ChangeMode(FormViewMode.Edit);
}
}