asp.net与ACCESS数据库的问题

Question

<asp:BoundColumn Visible="False" DataField="id"></asp:BoundColumn>
<asp:BoundColumn DataField="StuName" SortExpression="StuName" HeaderText="学生姓名"></asp:BoundColumn>
<asp:BoundColumn DataField="StuNo" SortExpression="StuNo" HeaderText="学生学号"></asp:BoundColumn>
<asp:BoundColumn DataField="StuSex" SortExpression="StuSex" HeaderText="性别"></asp:BoundColumn>
<asp:BoundColumn DataField="StuMingzu" SortExpression="StuMingzu" HeaderText="民族"></asp:BoundColumn>
<asp:BoundColumn DataField="StuAddress" SortExpression="StuAddress" HeaderText="家庭地址"></asp:BoundColumn>
<asp:BoundColumn DataField="StuYear" SortExpression="StuYear" HeaderText="入学年月"></asp:BoundColumn>
<asp:BoundColumn DataField="StuBrith" SortExpression="StuBrith" HeaderText="出生年月"></asp:BoundColumn>
<asp:BoundColumn DataField="StuDep" SortExpression="StuDep" HeaderText="所在系别"></asp:BoundColumn>
<asp:BoundColumn DataField="StuMajor" SortExpression="StuMajor" HeaderText="所在专业"></asp:BoundColumn>
<asp:BoundColumn DataField="StuClass" SortExpression="StuClass" HeaderText="所在班级"></asp:BoundColumn>
<asp:BoundColumn DataField="StuEdit" SortExpression="StuEdit" HeaderText="备注"></asp:BoundColumn>

Answer 1

Dgd_student.DataSource=ds.Tables[0].DefaultView;看看

Answer 2

先看看是不是数据控件没有自动绑定字段，
Dgd_student.DataSource=da;替换为Dgd_student.DataSource=ds;

Answer 3

数据源要设定为具体的datatable.

Answer 4

Dgd_student.DataSource=ds.Tables[0].DefaultView

Answer 5

数据源要用DataTable,不能用dataset

Answer 6

string accessString=dsn+Server.MapPath("school.mdb");
OleDbConnection accessConn=new OleDbConnection(accessString);
accessConn.Open();
string strsql="select * from student";    OleDbDataAdapter da=new OleDbDataAdapter(strsql,accessConn);
DataTable dt = new DataTable();
da.Fill(dt);   
Dgd_student.DataSource=dt;
Dgd_student.DataBind();

accessConn.Close();

Answer 7

或者是:
string accessString=dsn+Server.MapPath("school.mdb");
OleDbConnection accessConn=new OleDbConnection(accessString);
accessConn.Open();
string strsql="select * from student";    OleDbDataAdapter da=new OleDbDataAdapter(strsql,accessConn);
DataSet ds=new DataSet();
da.Fill(ds,"student");   
Dgd_student.DataSource=ds;
Dgd_student.DataBind();

accessConn.Close();

Answer 8

da.Fill(ds,"student"); 
Dgd_student.DataSource=ds.Tables["student"];
Dgd_student.DataBind();

Answer 9

不用Datagrid还有别的方法显示数据吗.
我是刚接触这C#

Answer 10

2003  Datalist  得前台绑定字段 我也刚学慢慢研究吧

Answer 11

string accessString=dsn+Server.MapPath("school.mdb");
OleDbConnection accessConn=new OleDbConnection(accessString);
accessConn.Open();
string strsql="select * from student";
OleDbCommand myCommand=new OleDbCommand(strsql,accessConn);
OleDbDataReader dr=myCommand.ExecuteReader();
DataTable dataTable=new DataTable();
dataTable.Columns.Add("Stuname",typeof(string));
dataTable.Columns.Add("Stuno",typeof(string));
dataTable.Columns.Add("Stusex",typeof(string));
dataTable.Columns.Add("Stumingzu",typeof(string));
dataTable.Columns.Add("Stubrith",typeof(string));
dataTable.Columns.Add("Stuyear",typeof(string));
dataTable.Columns.Add("Studep",typeof(string));
dataTable.Columns.Add("Stumajor",typeof(string));
dataTable.Columns.Add("Stuclass",typeof(string));
dataTable.Columns.Add("Stuedit",typeof(string));
DataSet dataSet=new DataSet();
while(dr.Read())
{
DataRow row=dataTable.NewRow();
row["StuName"]=dr["Stuname"].ToString();
row["StuNo"]=dr["Stuno"].ToString();
row["StuSex"]=dr["Stusex"].ToString();
row["StuMingzu"]=dr["Stumingzu"].ToString();
row["StuBrith"]=dr["Stubrith"].ToString();
row["StuYear"]=dr["Stuyear"].ToString();
row["StuDep"]=dr["Studep"].ToString();
row["StuMajor"]=dr["StuMmjor"].ToString();
row["StuClass"]=dr["Stuclass"].ToString();
row["StuEdit"]=dr["Stuedit"].ToString();
dataTable.Rows.Add(row); }
dr.Close();
accessConn.Close();
dataSet.Tables.Add(dataTable);
Dgd_student.DataSource=dataSet;
Dgd_student.DataBind();

Answer 12

Dgd_student.DataSource=dataSet.Tables[0].DefaultView;
Dgd_student.DataBind();