Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- The SqlParameter is already contained by another SqlParameterCollection - Does using() {} cheat?
- using (var conn = new SqlConnection("Data Source=.;Initial Catalog=Test;Integrated Security=True"))
- {
- var parameters = new SqlParameter[] { new SqlParameter("@ProductId", SqlDbType.Int ) };
- using(var cmd1 = new SqlCommand("SELECT ProductName FROM Products WHERE ProductId = @ProductId"))
- {
- foreach (var parameter in parameters)
- {
- cmd1.Parameters.Add(parameter);
- // cmd1.Parameters.Clear(); // uncomment to save your skin!
- }
- }
- using (var cmd2 = new SqlCommand("SELECT Review FROM ProductReviews WHERE ProductId = @ProductId"))
- {
- foreach (var parameter in parameters)
- {
- cmd2.Parameters.Add(parameter);
- }
- }
- }
- CREATE TABLE Products(
- ProductId int IDENTITY(1,1) NOT NULL PRIMARY KEY CLUSTERED,
- ProductName nvarchar(32) NOT NULL)
- GO
- CREATE TABLE ProductReviews(
- ReviewId int IDENTITY(1,1) NOT NULL PRIMARY KEY CLUSTERED,
- ProductId int NOT NULL,
- Review nvarchar(128) NOT NULL)
- GO
Add Comment
Please, Sign In to add comment