2005DetailsView的困惑!!
今天玩了一下2005的DetailsView控件,发觉还挺方便的!但有个地方郁闷我,就是那“新建”,“编辑”,“更新”,“取消”。这些文字改不了,也就是说我像把“新建”改为“新增”,
找了老半天帮助,都没找着是怎么改法的。
protected void DetailsView1_ItemInserted(object sender, DetailsViewInsertedEventArgs e)
{
this.DetailsView1.DataBind();
}
protected void DetailsView1_ItemInserting(object sender, DetailsViewInsertEventArgs e)
{
TextBox txtName = (TextBox)this.DetailsView1.FindControl("TextBox2");
TextBox txtPrice = (TextBox)this.DetailsView1.FindControl("TextBox1");
string Sql = "Insert into products(ProductName,UnitPrice)values('" + txtName.Text + "'," + txtPrice.Text + ")";
this.SqlDataSource1.InsertCommand = Sql;
this.SqlDataSource1.UpdateCommandType = SqlDataSourceCommandType.Text;
Page.RegisterClientScriptBlock("aa", "<script language='javascript'>alert('新增成功!');</script>");
}
protected void DetailsView1_ItemUpdating(object sender, DetailsViewUpdateEventArgs e)
{
TextBox txtName = (TextBox)this.DetailsView1.FindControl("TextBox2");
string SQL_Edit = " Update products set ProductName='" + txtName.Text + "' where ProductID=" + this.DetailsView1.DataKey.Value;
this.SqlDataSource1.UpdateCommand = SQL_Edit;
this.SqlDataSource1.UpdateCommandType = SqlDataSourceCommandType.Text;
}
protected void DetailsView1_ItemUpdated(object sender, DetailsViewUpdatedEventArgs e)
{
Page.RegisterClientScriptBlock("aa", "<script language='javascript'>alert('修改成功!');</script>");
this.DetailsView1.DataBind();
}
{
this.DetailsView1.DataBind();
}
protected void DetailsView1_ItemInserting(object sender, DetailsViewInsertEventArgs e)
{
TextBox txtName = (TextBox)this.DetailsView1.FindControl("TextBox2");
TextBox txtPrice = (TextBox)this.DetailsView1.FindControl("TextBox1");
string Sql = "Insert into products(ProductName,UnitPrice)values('" + txtName.Text + "'," + txtPrice.Text + ")";
this.SqlDataSource1.InsertCommand = Sql;
this.SqlDataSource1.UpdateCommandType = SqlDataSourceCommandType.Text;
Page.RegisterClientScriptBlock("aa", "<script language='javascript'>alert('新增成功!');</script>");
}
protected void DetailsView1_ItemUpdating(object sender, DetailsViewUpdateEventArgs e)
{
TextBox txtName = (TextBox)this.DetailsView1.FindControl("TextBox2");
string SQL_Edit = " Update products set ProductName='" + txtName.Text + "' where ProductID=" + this.DetailsView1.DataKey.Value;
this.SqlDataSource1.UpdateCommand = SQL_Edit;
this.SqlDataSource1.UpdateCommandType = SqlDataSourceCommandType.Text;
}
protected void DetailsView1_ItemUpdated(object sender, DetailsViewUpdatedEventArgs e)
{
Page.RegisterClientScriptBlock("aa", "<script language='javascript'>alert('修改成功!');</script>");
this.DetailsView1.DataBind();
}
<div>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
SelectCommand="SELECT * FROM products order by ProductID desc"></asp:SqlDataSource>
</div>
<asp:DetailsView ID="DetailsView1" runat="server" AllowPaging="True" AutoGenerateRows="False"
DataKeyNames="ProductID" DataSourceID="SqlDataSource1" Height="50px" Width="125px"
AutoGenerateInsertButton="true" AutoGenerateEditButton="true" OnItemInserted="DetailsView1_ItemInserted"
OnItemInserting="DetailsView1_ItemInserting" OnItemUpdating="DetailsView1_ItemUpdating" OnItemUpdated="DetailsView1_ItemUpdated">
<Fields>
<asp:TemplateField HeaderText="hehe ">
<ItemTemplate>
<table width="600" border="1" cellpadding="2" style="border-color: Black;">
<tr>
<td>
ProductName</td>
<td>
<asp:TextBox ID="TextBox2" runat="server" Text='<%# Eval("ProductName")%>'></asp:TextBox></td>
<td>
QuantityPerUnit</td>
<td>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Eval("UnitPrice")%>'></asp:TextBox></td>
<td>
</td>
</tr>
</table>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="ProductID" HeaderText="ProductID" InsertVisible="False" ReadOnly="True"
SortExpression="ProductID" />
<asp:BoundField DataField="ProductName" HeaderText="ProductName" SortExpression="ProductName" />
<asp:BoundField DataField="QuantityPerUnit" HeaderText="QuantityPerUnit" SortExpression="QuantityPerUnit" />
<asp:BoundField DataField="UnitPrice" HeaderText="UnitPrice" SortExpression="UnitPrice" />
<asp:BoundField DataField="UnitsInStock" HeaderText="UnitsInStock" SortExpression="UnitsInStock" />
<asp:BoundField DataField="UnitsOnOrder" HeaderText="UnitsOnOrder" SortExpression="UnitsOnOrder" />
<asp:BoundField DataField="ReorderLevel" HeaderText="ReorderLevel" SortExpression="ReorderLevel" />
<asp:CheckBoxField DataField="Discontinued" HeaderText="Discontinued" SortExpression="Discontinued" />
</Fields>
<PagerSettings Mode="NextPrevious" NextPageText="下一条" PreviousPageText="上一条" />
</asp:DetailsView>
<asp:GridView ID="GridView1" runat="server">
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
SelectCommand="SELECT * FROM products order by ProductID desc"></asp:SqlDataSource>
</div>
<asp:DetailsView ID="DetailsView1" runat="server" AllowPaging="True" AutoGenerateRows="False"
DataKeyNames="ProductID" DataSourceID="SqlDataSource1" Height="50px" Width="125px"
AutoGenerateInsertButton="true" AutoGenerateEditButton="true" OnItemInserted="DetailsView1_ItemInserted"
OnItemInserting="DetailsView1_ItemInserting" OnItemUpdating="DetailsView1_ItemUpdating" OnItemUpdated="DetailsView1_ItemUpdated">
<Fields>
<asp:TemplateField HeaderText="hehe ">
<ItemTemplate>
<table width="600" border="1" cellpadding="2" style="border-color: Black;">
<tr>
<td>
ProductName</td>
<td>
<asp:TextBox ID="TextBox2" runat="server" Text='<%# Eval("ProductName")%>'></asp:TextBox></td>
<td>
QuantityPerUnit</td>
<td>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Eval("UnitPrice")%>'></asp:TextBox></td>
<td>
</td>
</tr>
</table>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="ProductID" HeaderText="ProductID" InsertVisible="False" ReadOnly="True"
SortExpression="ProductID" />
<asp:BoundField DataField="ProductName" HeaderText="ProductName" SortExpression="ProductName" />
<asp:BoundField DataField="QuantityPerUnit" HeaderText="QuantityPerUnit" SortExpression="QuantityPerUnit" />
<asp:BoundField DataField="UnitPrice" HeaderText="UnitPrice" SortExpression="UnitPrice" />
<asp:BoundField DataField="UnitsInStock" HeaderText="UnitsInStock" SortExpression="UnitsInStock" />
<asp:BoundField DataField="UnitsOnOrder" HeaderText="UnitsOnOrder" SortExpression="UnitsOnOrder" />
<asp:BoundField DataField="ReorderLevel" HeaderText="ReorderLevel" SortExpression="ReorderLevel" />
<asp:CheckBoxField DataField="Discontinued" HeaderText="Discontinued" SortExpression="Discontinued" />
</Fields>
<PagerSettings Mode="NextPrevious" NextPageText="下一条" PreviousPageText="上一条" />
</asp:DetailsView>
<asp:GridView ID="GridView1" runat="server">
</asp:GridView>