koden:
<%@ Import Namespace="System.Data.OleDb" %>
<%@ Import Namespace="System.Data" %>
<%@ Page Language="C#" Debug="true" %>
<script runat="server">
private OleDbConnection conn;
string connectionString;
private OleDbCommand command;
private OleDbDataAdapter oleDbDataAdapter;
private OleDbCommandBuilder builder;
private DataTable dt;
protected void Page_Load(object sender, EventArgs e)
{
connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" + Server.MapPath("/db/lort.mdb") + ";Jet OLEDB:Database Password=000000;";
conn = new OleDbConnection(connectionString);
dt = new DataTable();
ReturnDataTable();
}
public void ReturnDataTable()
{
oleDbDataAdapter = new OleDbDataAdapter("SELECT * FROM Timer", conn);
oleDbDataAdapter.Fill(dt);
GridView1.DataSource = dt.DefaultView;
GridView1.DataBind();
}
public void UpdateInsertDeleteDatabase(object sender, EventArgs e)
{
DataRow newRow = dt.NewRow();
newRow["ID2"] = 123456;
newRow["testNr"] = 654321;
newRow["Kommentar"] = "bla efwefefe ";
newRow["min"] = 10;
dt.Rows.Add(newRow);
string error = "";
try {
builder = new OleDbCommandBuilder(oleDbDataAdapter);
oleDbDataAdapter.Update(dt);
}
catch (Exception eoe) {
error = eoe.Message;
}
Response.Write("FEJL: " + error);
}
</script>
<html xmlns="
http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Button ID="Button1" runat="server" OnClick="UpdateInsertDeleteDatabase" Text="Button" /><br />
<br />SQL sætning:<br />
INSERT INTO Timer(ID2, testNR, kommentar, min) VALUES (123456,654321, 'bla efwefefe ', 10);<br />
<br />ID = Autonummerering<br />ID2 = tal<br />testNR = tal<br />
Kommentar = notat<br />min = tal<br /><br />
<asp:GridView ID="GridView1" runat="server">
</asp:GridView>
</div>
</form>
</body>
</html>