<asp:FormView ID="FormView1" runat="server" DataSourceID="ObjectDataSource1" DefaultMode="Insert">
<InsertItemTemplate>
<asp:TextBox ID='<%bind("列1") %>' runat="server"></asp:TextBox>
<asp:Button ID="Button1" runat="server" Text="插入数据" CommandName="Insert" />
</InsertItemTemplate>
</asp:FormView>
<!--bind双向绑定,CommandName传递命令名-->
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server" TypeName="insertanimation"
DataObjectTypeName="animation" SelectMethod="select" InsertMethod="insert"
UpdateMethod="updata" ConflictDetection="CompareAllValues" OldValuesParameterFormatString="oldAnimation"
DeleteMethod="delete" ></asp:ObjectDataSource>
<!--利用这个来进行操作TypeName="insertanimation", DataObjectTypeName="animation",SelectMethod查询
InsertMethod插入,UpdateMethod更改, DeleteMethod删除,ConflictDetection保存在缓存中
OldValuesParameterFormatString代表原始的实体的参数名称-->
public partial class insertanimation
{
public static int insert(animation animationToInsert)
{
VisualObjectDataContext db = new VisualObjectDataContext();
db.animation.InsertOnSubmit(animationToInsert);//插入数据
db.SubmitChanges();//执行插入操作
return animationToInsert.id;//从数据库中获取新的标志值并更新id
}
public static class update(animantion oldAnimation,animation newAnimation)
{
VisualObjectDataContext db = new VisualObjectDataContext();
db.animation.Attach(newAnimation,oldAnimation);//更新数据
db.SubmitChanges();//执行更新数据操
}
public static void delete(animation animationtodelete)
{
VisualObjectDataContext db = new VisualObjectDataContext();
db.animation.Attach(animationtodelete);//允许将未更改的实体附加到数据上下
db.animation.DeleteOnSubmit(animationtodelete);//删除数据
db.SubmitChanges();//执行删除数据
}
public static IEnumerable<animation> select()
{
VisualObjectDataContext db = new VisualObjectDataContext();
return db.animation;
}
}
<InsertItemTemplate>
<asp:TextBox ID='<%bind("列1") %>' runat="server"></asp:TextBox>
<asp:Button ID="Button1" runat="server" Text="插入数据" CommandName="Insert" />
</InsertItemTemplate>
</asp:FormView>
<!--bind双向绑定,CommandName传递命令名-->
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server" TypeName="insertanimation"
DataObjectTypeName="animation" SelectMethod="select" InsertMethod="insert"
UpdateMethod="updata" ConflictDetection="CompareAllValues" OldValuesParameterFormatString="oldAnimation"
DeleteMethod="delete" ></asp:ObjectDataSource>
<!--利用这个来进行操作TypeName="insertanimation", DataObjectTypeName="animation",SelectMethod查询
InsertMethod插入,UpdateMethod更改, DeleteMethod删除,ConflictDetection保存在缓存中
OldValuesParameterFormatString代表原始的实体的参数名称-->
public partial class insertanimation
{
public static int insert(animation animationToInsert)
{
VisualObjectDataContext db = new VisualObjectDataContext();
db.animation.InsertOnSubmit(animationToInsert);//插入数据
db.SubmitChanges();//执行插入操作
return animationToInsert.id;//从数据库中获取新的标志值并更新id
}
public static class update(animantion oldAnimation,animation newAnimation)
{
VisualObjectDataContext db = new VisualObjectDataContext();
db.animation.Attach(newAnimation,oldAnimation);//更新数据
db.SubmitChanges();//执行更新数据操
}
public static void delete(animation animationtodelete)
{
VisualObjectDataContext db = new VisualObjectDataContext();
db.animation.Attach(animationtodelete);//允许将未更改的实体附加到数据上下
db.animation.DeleteOnSubmit(animationtodelete);//删除数据
db.SubmitChanges();//执行删除数据
}
public static IEnumerable<animation> select()
{
VisualObjectDataContext db = new VisualObjectDataContext();
return db.animation;
}
}