---
title: "Invalid character for ; using reader.NextResult"  
description: "Invalid character for ; using reader.NextResult"  
author: "Anonymous User"  
published: 2014-02-09  
updated: 2014-02-09  
canonical: https://www.mindstick.com/forum/1968/invalid-character-for-using-reader-nextresult  
category: "c#"  
tags: ["c#"]  
reading_time: 1 minute  

---

# Invalid character for ; using reader.NextResult

[string](https://www.mindstick.com/articles/1527/string-split-in-c-sharp) [sql](https://www.mindstick.com/articles/13115/types-of-keys-in-sql-or-oracle-database) = @"[SELECT](https://www.mindstick.com/forum/160534/orderby-then-select-vs-select-then-orderby-performance) sum(subtotal) FROM table1 WHERE clientid=:v1;" +

"SELECT * FROM table2 WHERE clientid = :v2 "

cmd = DBConnection.GetCommand();

cmd.CommandText = sql;

cmd.Parameters.Clear();

cmd.Parameters.Add(":v1", "Name1");

cmd.Parameters.Add(":v2", "Name2");

OracleDataReader reader = cmd.ExecuteReader(); //[Error](https://yourviews.mindstick.com/view/88527/fixing-quickbooks-error-4120-reinstalling-vs-repairing): Invalid [Character](https://www.mindstick.com/articles/23551/an-investigate-distinctive-seafood-restaurant-for-your-image-stamp-character)

while (reader.Read())

{

..results from first [query](https://www.mindstick.com/blog/202/sub-query-in-sqlserver)

}

reader.NextResult();

while (reader.Read())

{

..results from [second](https://answers.mindstick.com/qa/41761/how-did-the-second-industrial-revolution-influence-women-s-roles-in-society) query

}

.NET is not allowing reader.NextResults using [binding](https://www.mindstick.com/blog/146/dynamic-binding-in-c-sharp) [variables](https://www.mindstick.com/articles/715/php-variables)? Why i [am getting](https://www.mindstick.com/forum/34179/i-am-getting-error-while-assigning-the-data-to-the-array-list) Invalid Character?

## Replies

### Reply by Pravesh Singh

Hi Jacob,

Remove the : when adding parameters to the command.

cmd.Parameters.Add("v1", "Name1");

cmd.Parameters.Add("v2", "Name2");


---

Original Source: https://www.mindstick.com/forum/1968/invalid-character-for-using-reader-nextresult

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.