Hvordan bruger man Access i Asp.Net
Jeg har følgende kode, men får konstant denne fejl når jeg prøver at indtaste data i databasen, via min kode Operation must use an updateable query.<%@ Import namespace="System.Data.OleDb" %>
<%@ Import Namespace="System.Data" %>
<%@ Page language="c#" %>
<HTML>
<HEAD>
<title>Validating a Field</title>
</HEAD>
<body>
<form id="Form1" method="post" runat="server">
<table id="Table1" style="Z-INDEX: 101; LEFT: 8px; POSITION: absolute; TOP: 8px" cellSpacing="0" cellPadding="0" width="300" border="0">
<tr>
<td width="115">
<asp:Label id="Label1" runat="server">Fag</asp:Label>
</td>
<td>
<asp:TextBox id="txtFag" runat="server" width="193" />
</td>
</tr>
<tr>
<td width="115">
<asp:Label id="Label2" runat="server">Navn</asp:Label>
</td>
<td>
<asp:TextBox id="txtNavn" runat="server" width="193" />
</td>
</tr>
<tr>
<tr>
<td width="115">
<asp:Label id="Label3" runat="server">Adresse</asp:Label>
</td>
<td>
<asp:TextBox id="txtAdresse" runat="server" width="193" />
</td>
</tr>
<tr>
<td width="115">
<asp:Label id="Label4" runat="server">Nr</asp:Label>
</td>
<td>
<asp:TextBox id="txtNr" runat="server" width="193" />
</td>
</tr>
<tr>
<td width="115">
<asp:Label id="Label5" runat="server">Postnr</asp:Label>
</td>
<td>
<asp:TextBox id="txtPostnr" runat="server" width="193" />
</td>
</tr>
<tr>
<td width="115">
<asp:Label id="Label6" runat="server">By</asp:Label>
</td>
<td>
<asp:TextBox id="txtBy" runat="server" width="193" />
</td>
</tr>
<tr>
<td width="115">
<asp:Label id="Label7" runat="server">Tlf</asp:Label>
</td>
<td>
<asp:TextBox id="txtTlf" runat="server" width="193" />
</td>
</tr>
<tr>
<td width="115">
<asp:Label id="Label8" runat="server">Mobiltlf</asp:Label>
</td>
<td>
<asp:TextBox id="txtMobiltlf" runat="server" width="193" />
</td>
</tr>
<tr>
<td width="115">
<asp:Label id="Label9" runat="server">Region</asp:Label>
</td>
<td>
<asp:TextBox id="txtRegion" runat="server" width="193" />
</td>
</tr>
<TR>
<td colSpan="2" width="115">
<asp:Button id="btnInsert" runat="server" OnClick="btnInsert_Click" width="298" text="Sæt oplysninger ind i databasen!" />
</td>
</TR>
</table>
<asp:RequiredFieldValidator id="rfvFag" runat="server" style="Z-INDEX: 102; LEFT: 316px; POSITION: absolute; TOP: 14px" ErrorMessage="Indsæt et fag" ControlToValidate="txtFag" />
</form>
<script language="c#" runat="server">
OleDbConnection objConnection;
private void Page_Load(object sender, System.EventArgs e)
{
objConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; data source=C:\\Inetpub\\wwwroot\\Database med skrive\\Underentrepanørere.mdb");
}
private void btnInsert_Click(object sender, System.EventArgs e)
{
if (Page.IsValid)
{
String strSQL = "INSERT INTO Tabel1 (Fag, Navn) VALUES (?, ?)";
OleDbCommand dbComm = new OleDbCommand(strSQL, objConnection);
dbComm.Parameters.Add("Fag", OleDbType.VarChar, 32, "Fag");
dbComm.Parameters.Add("Navn", OleDbType.VarChar, 128, "Navn");
//dbComm.Parameters.Add("Adresse", OleDbType.VarChar, 32, "Adresse");
//dbComm.Parameters.Add("Nr", OleDbType.Integer, 32, "Nr");
//dbComm.Parameters.Add("Postnr", OleDbType.Integer, 32, "Postnr");
//dbComm.Parameters.Add("By", OleDbType.VarChar, 32, "By");
//dbComm.Parameters.Add("Tlf", OleDbType.Integer, 32, "Tlf");
//dbComm.Parameters.Add("Mobiltlf", OleDbType.Integer, 32, "Mobiltlf");
//dbComm.Parameters.Add("Region", OleDbType.VarChar, 32, "Region");
dbComm.Parameters["Fag"].Value = txtFag.Text;
dbComm.Parameters["Navn"].Value = txtNavn.Text;
//dbComm.Parameters["Adresse"].Value = txtAdresse.Text;
//dbComm.Parameters["Nr"].Value = txtNr.Text;
//dbComm.Parameters["Postnr"].Value = txtPostnr.Text;
//dbComm.Parameters["By"].Value = txtBy.Text;
//dbComm.Parameters["Tlf"].Value = txtTlf.Text;
//dbComm.Parameters["Mobiltlf"].Value = txtMobiltlf.Text;
//dbComm.Parameters["Region"].Value = txtRegion.Text;
try
{
objConnection.Open();
dbComm.ExecuteNonQuery();
}
catch (Exception ex)
{
Response.Write(ex.Message);
Response.End();
}
finally
{
if (objConnection.State == ConnectionState.Open);
objConnection.Close();
}
Response.Write("A new record has been added");
Response.End();
}
}
</script>
</body>
</HTML>
