Har jeg glemt at lukke adgangen til databsen
Jeg har denne asp.net-side i c#. Den læser fra en database og putter det i en tabel. Simpelt nok.Men jeg tror jeg mangler et "close" et eller andet sted, for hver gang jeg opdaterer poster i databasen (access) og uploader til min ISP, så kommer der application-error, og jeg kan kun få det til at virke ved at omdøbe databasen til et andet navn.
Koden:
<%@ Page Language="C#" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.OleDb" %>
<script runat="server">
string connectionString;
OleDbConnection objConnection;
string commandString;
OleDbDataAdapter dataAdapter;
DataSet dataSet;
DataTable dataTable;
OleDbCommand objCmd;
private void Page_Load(object sender, System.EventArgs e)
{
connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("repertoiret.mdb");
objConnection = new OleDbConnection(connectionString);
commandString = "Select Kunstner, Sang from rep ORDER BY Kunstner";
dataAdapter = new OleDbDataAdapter (commandString, objConnection);
dataSet = new DataSet();
dataAdapter.Fill(dataSet,"Sange");
dataTable = dataSet.Tables[0];
lbRepertoire.DataSource = dataTable.DefaultView;
lbRepertoire.DataBind();
objCmd = new OleDbCommand(connectionString, objConnection);
}
void Button1_Click(Object sender, EventArgs e)
{
connectionString = "Select Kunstner, Sang from rep ORDER BY Kunstner";
objConnection.Open();
objCmd.CommandText = connectionString;
// objCmd = new OleDbCommand(connectionString, objConnection);
lbRepertoire.DataSource = objCmd.ExecuteReader(CommandBehavior.CloseConnection);
lbRepertoire.DataBind();
}
void Button2_Click(Object sender, EventArgs e) {
connectionString = "Select Kunstner, Sang from rep ORDER BY Sang";
objConnection.Open();
objCmd.CommandText = connectionString;
// objCmd = new OleDbCommand(connectionString, objConnection);
lbRepertoire.DataSource = objCmd.ExecuteReader(CommandBehavior.CloseConnection);
lbRepertoire.DataBind();
}
</script>
<html>
<head>
</head>
<body>
<form runat="server">
Sorter efter:
<asp:Button id="BtKunstner" onclick="Button1_Click" runat="server" Text="Kunstner"></asp:Button>
<asp:Button id="BtSang" onclick="Button2_Click" runat="server" Text="Sang"></asp:Button>
<asp:DataGrid id="lbRepertoire" runat="server" ForeColor="#dead63"></asp:DataGrid>
</form>
</body>
</html>
