帮帮我吧,一个新手困惑中
我在看asp.net2.0开发指南这本书。在书的第10章有一个利用ObjectDataSource把数据访问层和表示层链接起来。再绑到GridView中。显示的我都做好了,可以,现在问题是修改,在hans.cs中有修改方法public static int UpdataProductName(string ProductName,string ProductID,string SupplierID, string CategoryID, string QuantityPerUnit, string UnitPrice, string UnitsInStock, string UnitsOnOrder, string ReorderLevel)
{
string connectionString = ConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString;
string queryString = "UPDATE [Products] SET SupplierID=@SupplierID, CategoryID=@CategoryID, QuantityPerUnit=@QuantityPerUnit, UnitPrice=@UnitPrice, UnitsInStock=@UnitsInStock, UnitsOnOrder=@UnitsOnOrder, ReorderLevel=@ReorderLevel, ProductID=@ProductID";
SqlDataSource sqlDS = new SqlDataSource();
sqlDS.ConnectionString = connectionString;
sqlDS.UpdateCommand = queryString;
sqlDS.DataSourceMode = SqlDataSourceMode.DataSet;
sqlDS.UpdateParameters.Clear();
Parameter dbPatameterProductID = new Parameter("ProductID", TypeCode.String,ProductID);
sqlDS.UpdateParameters.Add(dbPatameterProductID);
Parameter dbPatameterSupplierID = new Parameter("SupplierID", TypeCode.String, SupplierID);
sqlDS.UpdateParameters.Add(dbPatameterSupplierID);
Parameter dbPatameterCategoryID = new Parameter("CategoryID", TypeCode.String, CategoryID);
sqlDS.UpdateParameters.Add(dbPatameterCategoryID);
Parameter dbPatameterQuantityPerUnit = new Parameter("SupplierID", TypeCode.String, QuantityPerUnit);
sqlDS.UpdateParameters.Add(dbPatameterQuantityPerUnit);
Parameter dbPatameterUnitPrice = new Parameter("UnitPrice", TypeCode.String, UnitPrice);
sqlDS.UpdateParameters.Add(dbPatameterUnitPrice);
Parameter dbPatameterUnitsInStock = new Parameter("UnitsInStock", TypeCode.String, UnitsInStock);
sqlDS.UpdateParameters.Add(dbPatameterUnitsInStock);
Parameter dbPatameterUnitsOnOrder = new Parameter("UnitsOnOrder", TypeCode.String, UnitsOnOrder);
sqlDS.UpdateParameters.Add(dbPatameterUnitsOnOrder);
Parameter dbPatameterReorderLevel = new Parameter("ReorderLevel", TypeCode.String, ReorderLevel);
sqlDS.UpdateParameters.Add(dbPatameterReorderLevel);
Parameter dbPatameterProductName = new Parameter("ProductName", TypeCode.String, ProductName);
sqlDS.UpdateParameters.Add(dbPatameterProductName);
return sqlDS.Update();
}
可是怎么取到要改成的各项参数呢?
网页中是这样的
<asp:GridView ID="GridView1" runat="server" DataSourceID="ObjectDataSource2">
<Columns>
<asp:CommandField ShowEditButton="True" />
<asp:BoundField DataField="ProductID" HeaderText="ProductID" SortExpression="ProductID" />
<asp:BoundField DataField="ProductName" HeaderText="ProductName" SortExpression="ProductName" />
<asp:BoundField DataField="SupplierID" HeaderText="SupplierID" SortExpression="SupplierID" />
<asp:BoundField DataField="CategoryID" HeaderText="CategoryID" SortExpression="CategoryID" />
<asp:BoundField DataField="SupplierID" HeaderText="SupplierID" SortExpression="SupplierID" />
<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="SupplierID" HeaderText="SupplierID" SortExpression="SupplierID" />
</Columns>
</asp:GridView>
书上是有用到<Columns>的,另外请问SortExpression有什么用处?请高手指点,感谢万分!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! --------------------编程问答-------------------- 还有个问题,这样用<Columns>后每种都显示两次,一次是绑定ObjectDataSource加入GridView中的,一次是用<Columns>加入的,请问用<Columns>有什么意义?
补充:.NET技术 , ASP.NET