The code in .aspx:
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="Data Source=(local);AttachDbFilename=|DataDirectory|\person.mdf;Integrated Security=True;User Instance=True"
DeleteCommand="DELETE FROM zhxxlqk WHERE (xlshj = @xlshj)" InsertCommand="INSERT INTO zhxxlqk(xlnr, xlshj, shj, xlxg, bzh) VALUES (@xlnr, @xlshj, @shj, @xlxg, @bzh)"
SelectCommand="SELECT zhxxlqk.* FROM zhxxlqk" UpdateCommand="UPDATE zhxxlqk SET xlnr = @xlnr, shj = @shj, xlxg = @xlxg, bzh = @bzh WHERE (xlshj = @xlshj)">
<DeleteParameters>
<asp:Parameter Name="xlshj" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="xlnr" />
<asp:Parameter Name="shj" />
<asp:Parameter Name="xlxg" />
<asp:Parameter Name="bzh" />
<asp:Parameter Name="xlshj" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="xlnr" />
<asp:Parameter Name="xlshj" />
<asp:Parameter Name="shj" />
<asp:Parameter Name="xlxg" />
<asp:Parameter Name="bzh" />
</InsertParameters>
</asp:SqlDataSource>
<FarPoint:FpSpread ID="FpSpread1" runat="server" ActiveSheetViewIndex="0" BorderColor="Black"
BorderStyle="Solid" BorderWidth="1px" DesignString='<?xml version="1.0" encoding="utf-8"?><Spread />'
Height="300px" Width="770px">
<Sheets>
<FarPoint:SheetView AutoGenerateColumns="False" DataKeyNames="xlshj" DataSourceID="SqlDataSource1"
......
The code in .aspx.cs:
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
FpSpread1.ActiveSheetView.AllowInsert = true;
FpSpread1.ActiveSheetView.AllowDelete = true;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
FpSpread1.SaveChanges();
}