du får lige hele min kode, for den henter bare det som der stod der fra starten af hvor den gamle data er indtastet...
<%@ Page Language="C#" Debug="true" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.OleDb" %>
<script runat="server">
void OpdaterBtn_Click(Object sender, EventArgs e) {
//replace(input, vbCrLf, "<br>");
string strConnect = @"PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=C:\dokumenter\betachat\data.mdb;";
OleDbConnection objConn = new OleDbConnection(strConnect);
OleDbCommand objCmd1 = new OleDbCommand( "UPDATE SchoolTable SET SchoolPostcode = ' " + SchoolPostcode.Text + " ' WHERE id = 4", objConn);
OleDbCommand objCmd2 = new OleDbCommand( "UPDATE SchoolTable SET SchoolName = ' " + SchoolName.Text + " ' WHERE id = 4", objConn);
OleDbCommand objCmd3 = new OleDbCommand( "UPDATE SchoolTable SET SchoolAdress = ' " + SchoolAdress.Text + " ' WHERE id = 4", objConn);
OleDbCommand objCmd4 = new OleDbCommand( "UPDATE SchoolTable SET SchoolWebsite = ' " + SchoolWebsite.Text + " ' WHERE id = 4", objConn);
objConn.Open();
objCmd1.ExecuteNonQuery();
objCmd2.ExecuteNonQuery();
objCmd3.ExecuteNonQuery();
objCmd4.ExecuteNonQuery();
objConn.Close();
Response.Write("Skolens informationer er blevet gemt!");
}
void Page_Load(){
string strConnect = @"PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=C:\dokumenter\betachat\data.mdb;";
OleDbConnection objConn = new OleDbConnection(strConnect);
OleDbCommand objCmd = new OleDbCommand( "SELECT SchoolPostcode, SchoolName, SchoolAdress, SchoolWebsite FROM SchoolTable WHERE id = 4", objConn);
objConn.Open();
OleDbDataReader objReader = objCmd.ExecuteReader( CommandBehavior.CloseConnection );
while( objReader.Read() ){
SchoolPostcode.Text = objReader.GetString(0);
SchoolName.Text = objReader.GetString(1);
SchoolAdress.Text = objReader.GetString(2);
SchoolWebsite.Text = objReader.GetString(3);
}
//Response.Write( "<br>Det virker, jubii" );
}
</script>
<html>
<head></head>
<body>
<form runat='server'><table width='100%' border='0'><tr>
<td width='30%'>Skolen: <asp:TextBox id='SchoolName' runat='server'></asp:TextBox></td>
<td width='10%'>Postnr: <asp:TextBox id='SchoolPostcode' runat='server'></asp:TextBox></td>
<td width='30%'>Sted: <asp:TextBox id='SchoolAdress' runat='server'></asp:TextBox></td>
<td width='30%'>Web: <asp:TextBox id='SchoolWebsite' runat='server'></asp:TextBox></td>
</tr></table>
<asp:button id="OpdaterBtn" onclick="OpdaterBtn_Click" runat="server" text="Opdater"></asp:button></form>
</body>
</html>
Ny bruger
Nybegynder
Opret
Preview
