将非字符串类型的参数添加到objectdatasource
将非字符串类型的参数添加到objectdatasource
提问于 2019-06-09 13:30:38
我得到了下面这段代码，用于添加属于我的ObjectDataSource对象的Insert方法的插入参数。在网格的页脚中有一个插入按钮\链接，它依赖于ObjectDataSource的insert方法。
在下面的方法中，DefaultValue是一个字符串类型。
在链接上显示给我的示例中，所有参数都是字符串类型。如果参数不是字符串类型，该怎么办？这是链接，如果你感兴趣的话：http://csharp-video-tutorials.blogspot.com/2013/03/gridview-insert-update-delete-in-aspnet_13.html
protected void lbInsert_Click(object sender, EventArgs e)
{
ObjectDataSource1.InsertParameters["Name"].DefaultValue =
((TextBox)GridView1.FooterRow.FindControl("txtName")).Text;
ObjectDataSource1.InsertParameters["Gender"].DefaultValue =
((DropDownList)GridView1.FooterRow.FindControl("ddlInsertGender")).SelectedValue;
ObjectDataSource1.InsertParameters["City"].DefaultValue =
((TextBox)GridView1.FooterRow.FindControl("txtCity")).Text;
ObjectDataSource1.Insert();
}
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server"
DeleteMethod="DeleteEmployee" InsertMethod="InsertEmployee"
SelectMethod="GetAllEmployees" TypeName="Demo.EmployeeDataAccessLayer"
UpdateMethod="UpdateEmployee">
<DeleteParameters>
<asp:Parameter Name="EmployeeId" Type="Int32" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="Name" Type="String" />
<asp:Parameter Name="Gender" Type="String" />
<asp:Parameter Name="City" Type="String" />
</InsertParameters>
<UpdateParameters>
....
</UpdateParameters>
</asp:ObjectDataSource>
// Insert Method for ObjectDataSource control
public static int InsertEmployee(string Name, string Gender, string City)
{
string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
using (SqlConnection con = new SqlConnection(CS))
{
string updateQuery = "Insert into tblEmployee (Name, Gender, City)" +
" values (@Name, @Gender, @City)";
SqlCommand cmd = new SqlCommand(updateQuery, con);
SqlParameter paramName = new SqlParameter("@Name", Name);
cmd.Parameters.Add(paramName);
SqlParameter paramGender = new SqlParameter("@Gender", Gender);
cmd.Parameters.Add(paramGender);
SqlParameter paramCity = new SqlParameter("@City", City);
cmd.Parameters.Add(paramCity);
con.Open();
return cmd.ExecuteNonQuery();
}在我的例子中，我没有字符串参数。所以我不知道如何编码我的插入按钮点击，这是在网格的页脚。我的场景是：
<asp:ObjectDataSource ID="ObjectDataSource2" runat="server" SelectMethod="GetAllProducts" TypeName="VenketGrid.DataAccessLayer2" UpdateMethod="UpdateProduct" ConflictDetection = "CompareAllValues" OldValuesParameterFormatString = "Original_{0}" DeleteMethod="Delete" OnSelecting="ObjectDataSource2_Selecting" OnUpdated="ObjectDataSource2_Updated" InsertMethod="InsertProduct">
<DeleteParameters>
...
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="Inactive" Type="Boolean" />
<asp:Parameter Name="CategoryId" Type="Int32" />
<asp:Parameter Name="Description" Type="String" />
<asp:Parameter Name="CurrentPrice" Type="Decimal" />
<asp:Parameter Name="Modified" Type="DateTime" />
</InsertParameters>
<UpdateParameters>
...
</UpdateParameters>
</asp:ObjectDataSource>
// Insert Method for ObjectDataSource control
public static int InsertProduct(bool Inactive, int CategoryId, string Description, Decimal CurrentPrice, DateTime Modified)
{
string ConnectionString;
ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["DBConn"].ToString();
SqlConnection con = new SqlConnection(ConnectionString);
SqlCommand cmd = new SqlCommand("_SP_Insert_RefProducts", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@Inactive", Inactive));
cmd.Parameters.Add(new SqlParameter("@CategoryId", CategoryId));
cmd.Parameters.Add(new SqlParameter("@Description", Description));
cmd.Parameters.Add(new SqlParameter("@CurrentPrice", CurrentPrice));
con.Open();
int affected;
affected = cmd.ExecuteNonQuery();
con.Close();
return affected;
}页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/56512219
复制相关文章
相似问题