Nu har prøvet at skære al den overflødige kode fra og så ser hele koden sådan her ud og med det her kode har jeg stadig det samme problem:
<%@ Page Language="C#" %>
<script runat="server">
private int emneid;
private void Page_Load(object sender, System.EventArgs e)
{
DataGrid1.DataSource = selectEmne();
if (!IsPostBack)
{
BindGrid();
}
}
private void BindGrid()
{
DataGrid1.DataBind();
}
public System.Data.IDataReader selectEmne()
{
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("db1.mdb");
System.Data.IDbConnection dbConnection = new System.Data.OleDb.OleDbConnection(connectionString);
string queryString = "SELECT [Emne].* FROM [Emne]";
System.Data.IDbCommand dbCommand = new System.Data.OleDb.OleDbCommand();
dbCommand.CommandText = queryString;
dbCommand.Connection = dbConnection;
dbConnection.Open();
System.Data.IDataReader dataReader = dbCommand.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
return dataReader;
}
void Button1_Click(object sender, EventArgs e)
{
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("db1.mdb");
System.Data.IDbConnection dbConnection = new System.Data.OleDb.OleDbConnection(connectionString);
string queryString = "INSERT INTO Emne (Navn)"
+ " VALUES (\"ny\")";
System.Data.IDbCommand dbCommand = new System.Data.OleDb.OleDbCommand();
dbCommand.CommandText = queryString;
dbCommand.Connection = dbConnection;
dbConnection.Open();
dbCommand.ExecuteNonQuery();
dbConnection.Close();
DataGrid1.EditItemIndex = -1;
DataGrid1.DataSource = selectEmne();
BindGrid();
}
</script>
<html>
<head>
</head>
<body>
<form runat="server">
<p>
<asp:DataGrid id="DataGrid1" runat="server" AutoGenerateColumns="False">
<Columns>
<asp:BoundColumn DataField="Navn" HeaderText="Navn"></asp:BoundColumn>
</Columns>
</asp:DataGrid>
</p>
<p>
<asp:Button id="Button1" onclick="Button1_Click" runat="server" Text="Button"></asp:Button>
</p>
<!-- Insert content here -->
</form>
</body>
</html>
