数据库连接成功以后
显示为这样,我要怎样才能修改number为号码.name为名称.age为年龄.要求不能在数据库里面改啊.只能代码里面设置啊.我知道这个应该是可以的.但是我不会.所以请教一下.看看这样改代码应该怎样写.
number name age
3 li 23
4 wang 25
我的代码如下:
public void bind()
{
string strConnection= "Provider=Microsoft.Jet.OleDb.4.0;Data Source= ";
strConnection+=Server.MapPath( "1.mdb ");
OleDbConnection objConnection=new OleDbConnection(strConnection);
OleDbDataAdapter ob1 = new OleDbDataAdapter( "select number,name age from DS_ProductInf WHERE age> =0 ",objConnection);
DataSet myds=new DataSet();
ob1.Fill(myds, "DS_ProductInf ");
dgrdMain.DataSource=myds.Tables[ "DS_ProductInf "].DefaultView;
dgrdMain.DataBind();
}
------解决方案--------------------------------------------------------
DataTable dt = new DataTable();
dt.Columns[0].ColumnName = "aaa ";
------解决方案--------------------------------------------------------
修改SQL語句，給字段加上別名即可。
OleDbDataAdapter ob1 = new OleDbDataAdapter( "select number,name age from DS_ProductInf WHERE age> =0 ",objConnection);
改為
OleDbDataAdapter ob1 = new OleDbDataAdapter( "select number As 号码,name As 名称, age As 年龄 from DS_ProductInf WHERE age> =0 ",objConnection);
------解决方案--------------------------------------------------------
加別名的方法在ACCESS中一樣可以的