Sql Data reader error While woking more than one person on the Same App.

See more:

ASP.NET

C#3.5

Hi To All. i have the following Problem . i had developed the web application . it is working when single user working it is good.

When More Than One User Working on The Same Application . it will gave the message like 'Sql Data Reader Error'. For that i had wrote the Option 'MultipleActiveResultSets=True' in Connection String of Web Config File. it is also not working.


----> So I Want To Execute The Request[i.e Requests are got fom the diffeent users] One by One Without Interruption. Please Give The Code As well as i Wrote the Following Code for that.



public void CreateConnection()
{
if (_Connection == null)
{
string Connection = ConnectionStrings.ConnectionString;
_Connection = new SqlConnection(Connection);
//_Connection.Open();
}
}

public void OpenConnection()
{
CreateConnection();
if(_Connection.State != ConnectionState.Open)
_Connection.Open();
}

public void CloseConnection()
{
if(_Connection.State == ConnectionState.Open)
_Connection.Close();
}

public DataTable GetTableByQuery(string Qry)
{
CreateConnection();
DataTable _table = new DataTable();
SqlDataAdapter _adapter = new SqlDataAdapter(Qry,_Connection);
using (_adapter)
{
//try
{
_adapter.Fill(_table);
int count = _table.Rows.Count;
}
//catch (System.Exception e)
//{
// string msg = e.Message;
//}
}
return _table;
}