D
delphibbs_wayne
Unregistered / Unconfirmed
GUEST, unregistred user!
这个代码是要显示两个表格，利用数据绑定的方法。一个表格是直接显示表的内容，另一个是要在原有数据上加一条记录，然后显示出来。代码如下：
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script Language="c#" runat="server">
void Page_Load()
{
if(!(Page.IsPostBack))
{
BindGrid();
}
}
private void Page_Index(Object sender,DataGridPageChangedEventArgs e)
{
myDataGrid.CurrentPageIndex = e.NewPageIndex;
BindGrid();
}
private void BindGrid()
{
string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath(".//Northwind.mdb");
string strSQL = "SELECT FirstName,LastName FROM Employees";
OleDbConnection objConnection = new OleDbConnection(strConnection);
OleDbDataAdapter objAdapter = new OleDbDataAdapter(strSQL,objConnection);
DataSet objDataSet = new DataSet();
try
{
objAdapter.Fill(objDataSet,"Employees");
myDataGrid.DataSource = objDataSet.Tables["Employees"].DefaultView;
myDataGrid.DataBind();
}
catch(Exception e)
{
con_open.Text = "Connection failed to open successfully.<br/>";
con_close.Text = e.ToString();
}
finally
{
objConnection.Close();
}
}
private void AddData(Object sender,EventArgs e)
{
DataTable objTable = objDataSet.Tables["Employees"];
DataRow objNewRow = objTable.NewRow();
objNewRow["FirstName"] = "Norman";
objNewRow["LastName"] = "Blake";
objTable.Rows.Add(objNewRow);
OleDbCommandBuilder objBulider = new OleDbCommandBuilder(objAdapter);
objAdapter.UpdateCommand = objBuilder.GetUpdateCommmand();
objAdapter.InsertCommand = objBuilder.GetInsertCommand();
objAdapter.DeleteCommand = objBuilder.GetDeleteCommand();
objAdapter.Update(objDataSet,"Employees");
strSQL = "SELECT FirstName,LastName FROM Employees";
objConnection.Open();
OleDbCommand objCommand = new OleDbCommand(strSQL,objConnection);
UpdateDataGrid.DataSource = objCommand.ExecuteReader(CommandBehavior.CloseConnection);
UpdateDataGrid.DataSource = DateBind();
}
private void DataAdapterUpdate(Object sender,EventArgs e)
{
BindGrid();
AddData();
}
</script>
<html>
<head>
<title>DataAdapterUpdate</title>
</head>
<body>
<form runat="server">
<asp:datagrid id="myDataGrid" runat="server"
AllowPaging="True"
PageSize="5"
PagerStyle-Mode="NumericPages"
PagerStyle-HorizontalAlign="Right"
OnPageIndexChanged="Page_Index"
CellPadding="3"
Font-Name="arial"
Font-Size="8pt"
HeaderStyle-BackColor="#dcdcdc"
HeaderStyle-ForeColor="blue"
/>
</form>
<hr>
<asp:button id="UpdateButton" onclick="DataAdapterUpdate" runat="server"/>
<asp:datagrid id="UpdateDataGrid" runat="server"
AllowPaging="True"
PageSize="5"
PagerStyle-Mode="NumericPages"
PagerStyle-HorizontalAlign="Right"
OnPageIndexChanged="Page_Index"
CellPadding="3"
Font-Name="arial"
Font-Size="8pt"
HeaderStyle-BackColor="#dcdcdc"
HeaderStyle-ForeColor="blue"
/>
<asp:label id="con_open" runat="server"/>
<asp:label id="con_close" runat="server"/>
</body>
</html>
现在报错为：
编译错误
说明: 在编译向该请求提供服务所需资源的过程中出现错误。请检查下列特定错误详细信息并适当地修改源代码。
编译器错误信息: CS0246: 找不到类型或命名空间名称“objDataSet”（是否缺少 using 指令或程序集引用？）
源错误:
行 58： private void AddData(Object sender,EventArgs e)
行 59： {
行 60： DataTable objTable = objDataSet.Tables["Employees"];
行 61： DataRow objNewRow = objTable.NewRow();
行 62： objNewRow["FirstName"] = "Norman";
源文件: C:/MyWeb/test/dataAdapterupdate.aspx 行: 60
我不知道是什么原因了，请哪位兄弟花点时间，帮忙看看，谢谢！
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script Language="c#" runat="server">
void Page_Load()
{
if(!(Page.IsPostBack))
{
BindGrid();
}
}
private void Page_Index(Object sender,DataGridPageChangedEventArgs e)
{
myDataGrid.CurrentPageIndex = e.NewPageIndex;
BindGrid();
}
private void BindGrid()
{
string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath(".//Northwind.mdb");
string strSQL = "SELECT FirstName,LastName FROM Employees";
OleDbConnection objConnection = new OleDbConnection(strConnection);
OleDbDataAdapter objAdapter = new OleDbDataAdapter(strSQL,objConnection);
DataSet objDataSet = new DataSet();
try
{
objAdapter.Fill(objDataSet,"Employees");
myDataGrid.DataSource = objDataSet.Tables["Employees"].DefaultView;
myDataGrid.DataBind();
}
catch(Exception e)
{
con_open.Text = "Connection failed to open successfully.<br/>";
con_close.Text = e.ToString();
}
finally
{
objConnection.Close();
}
}
private void AddData(Object sender,EventArgs e)
{
DataTable objTable = objDataSet.Tables["Employees"];
DataRow objNewRow = objTable.NewRow();
objNewRow["FirstName"] = "Norman";
objNewRow["LastName"] = "Blake";
objTable.Rows.Add(objNewRow);
OleDbCommandBuilder objBulider = new OleDbCommandBuilder(objAdapter);
objAdapter.UpdateCommand = objBuilder.GetUpdateCommmand();
objAdapter.InsertCommand = objBuilder.GetInsertCommand();
objAdapter.DeleteCommand = objBuilder.GetDeleteCommand();
objAdapter.Update(objDataSet,"Employees");
strSQL = "SELECT FirstName,LastName FROM Employees";
objConnection.Open();
OleDbCommand objCommand = new OleDbCommand(strSQL,objConnection);
UpdateDataGrid.DataSource = objCommand.ExecuteReader(CommandBehavior.CloseConnection);
UpdateDataGrid.DataSource = DateBind();
}
private void DataAdapterUpdate(Object sender,EventArgs e)
{
BindGrid();
AddData();
}
</script>
<html>
<head>
<title>DataAdapterUpdate</title>
</head>
<body>
<form runat="server">
<asp:datagrid id="myDataGrid" runat="server"
AllowPaging="True"
PageSize="5"
PagerStyle-Mode="NumericPages"
PagerStyle-HorizontalAlign="Right"
OnPageIndexChanged="Page_Index"
CellPadding="3"
Font-Name="arial"
Font-Size="8pt"
HeaderStyle-BackColor="#dcdcdc"
HeaderStyle-ForeColor="blue"
/>
</form>
<hr>
<asp:button id="UpdateButton" onclick="DataAdapterUpdate" runat="server"/>
<asp:datagrid id="UpdateDataGrid" runat="server"
AllowPaging="True"
PageSize="5"
PagerStyle-Mode="NumericPages"
PagerStyle-HorizontalAlign="Right"
OnPageIndexChanged="Page_Index"
CellPadding="3"
Font-Name="arial"
Font-Size="8pt"
HeaderStyle-BackColor="#dcdcdc"
HeaderStyle-ForeColor="blue"
/>
<asp:label id="con_open" runat="server"/>
<asp:label id="con_close" runat="server"/>
</body>
</html>
现在报错为：
编译错误
说明: 在编译向该请求提供服务所需资源的过程中出现错误。请检查下列特定错误详细信息并适当地修改源代码。
编译器错误信息: CS0246: 找不到类型或命名空间名称“objDataSet”（是否缺少 using 指令或程序集引用？）
源错误:
行 58： private void AddData(Object sender,EventArgs e)
行 59： {
行 60： DataTable objTable = objDataSet.Tables["Employees"];
行 61： DataRow objNewRow = objTable.NewRow();
行 62： objNewRow["FirstName"] = "Norman";
源文件: C:/MyWeb/test/dataAdapterupdate.aspx 行: 60
我不知道是什么原因了，请哪位兄弟花点时间，帮忙看看，谢谢！