sitter och kämpar som faaaan, mjahaja, hursomhelst, för här får man ju inte mycket hjälp :), jag har iaf lyckats med detta:
<%@ Page Language="C#" %>
<%@ import Namespace="System.Web.UI.WebControls" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.OleDb" %>
<script runat="server">
public void MyDataGrid_Edit(Object sender, DataGridCommandEventArgs e) {
Response.Write("Edit");
MyDataGrid.EditItemIndex = (int)e.Item.ItemIndex;
}
public void MyDataGrid_Cancel(Object sender, DataGridCommandEventArgs e) {
Response.Write("Cancel");
MyDataGrid.EditItemIndex = -1;
}
public void MyDataGrid_Delete(Object sender, DataGridCommandEventArgs e) {
Response.Write("Delete");
Response.Write((int)e.Item.ItemIndex);
MyQueryMethod("DELETE from fragor where ID = " + (int)e.Item.ItemIndex);
Response.Redirect("http://localhost/testadatagrid.aspx"); // ladda om sidan
}
DataSet MyQueryMethod(string sqlstring) {
DataSet mittDataSet=new DataSet();
OleDbConnection dbConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; Data Source=C:\\Documents and Settings\\olle\\Mina dokument\\WebMatrixServer\\question\\newquiz.mdb");
OleDbDataAdapter myDataAdapter = new OleDbDataAdapter(sqlstring, dbConnection);
myDataAdapter.Fill(mittDataSet, "fragor");
return mittDataSet;
}
protected void Page_Load(Object sender, EventArgs e) {
MyDataGrid.DataSource=MyQueryMethod("SELECT * FROM fragor");
MyDataGrid.DataBind();
}
void SparaButton_Click(object sender, EventArgs e) {
Response.Write(LaggTillTextBox.Text);
MyQueryMethod("INSERT INTO fragor (fraga) VALUES ('" + LaggTillTextBox.Text + "')");
Response.Redirect("http://localhost/testadatagrid.aspx"); //ladda om sidan
}
</script>
<html>
<head>
</head>
<body>
<form runat="server">
<div align="left">
<asp:DataGrid EnableViewState="false" id="MyDataGrid" AutoGenerateColumns="true" runat="server"
DataKeyField="ID"
OnCancelCommand="MyDataGrid_Cancel"
OnEditCommand="MyDataGrid_Edit"
OnDeleteCommand="MyDataGrid_Delete">
<Columns>
<asp:ButtonColumn Text="Delete" CommandName="Delete"></asp:ButtonColumn>
<asp:ButtonColumn Text="Cancel" CommandName="Cancel"></asp:ButtonColumn>
<asp:ButtonColumn Text="Edit" CommandName="Edit"></asp:ButtonColumn>
</Columns>
</asp:DataGrid>
</div>
<div align="left">
</div>
<div align="left">Lägg till en fråga:<asp:TextBox id="LaggTillTextBox" runat="server"></asp:TextBox>
<asp:Button id="SparaButton" onclick="SparaButton_Click" runat="server" Text="Spara"></asp:Button>
</div>
</form>
</body>
</html>
Hmm, det funkar å lägga till poster, men det funkar inte att editera eller delete:a, delete:a funkar ibland, men inte alltid, Nån som vet vad som kan va fel?