<asp:DataGrid id="DataGrid1" style="Z-INDEX: 101; LEFT: 144px; POSITION: absolute; TOP: 136px"
runat="server">
<Columns>
<asp:EditCommandColumn ButtonType="LinkButton" UpdateText="Update" CancelText="Cancel" EditText="Edit"></asp:EditCommandColumn>
<asp:ButtonColumn Text="Delete" CommandName="Delete"></asp:ButtonColumn>
</Columns>
</asp:DataGrid>
code-behind:
public class WebForm1 : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DataGrid DataGrid1;
OleDbCommand mycommand=new OleDbCommand();
private void Page_Load(object sender, System.EventArgs e)
{
mycommand.Connection=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\test.mdb;User Id=admin;Password=;");
if(Page.IsPostBack==false)
{
DataBindDataGrid();
}
}
private void DataBindDataGrid()
{
mycommand.Connection.Open();
mycommand.CommandText="SELECT * FROM namn";
DataGrid1.DataSource=mycommand.ExecuteReader();
DataGrid1.DataBind();
mycommand.Connection.Close();
}
private void DataGrid1_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
Response.Write("CANCEL");
}
private void DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
Response.Write("DELETE");
}
private void DataGrid1_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
Response.Write("EDIT" + e.Item.ItemIndex);
DataGrid1.EditItemIndex=e.Item.ItemIndex;
DataBindDataGrid();
}
private void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
Response.Write("UPDATE");
}
private void WebForm1_Unload(object sender, System.EventArgs e)
{
mycommand.Connection.Close();
mycommand.Connection.Dispose();
mycommand.Dispose();
}
}
När jag trycker Edit så får jag fram UPDATE i datagriden och allt är frid och fröjd, men textboxarna uteblir??. underligt, nån som ser vad det är för fel?.