Lock

HI,

I am getting a Connection Time Out Error While executing the follwoing code

Transaction isolation Level is "Read Commited"


String sConnectStr = "User ID=sa;Password=sa;Database=DAL;Server=.";

SqlConnection objConnection = new SqlConnection(sConnectStr);

objConnection.Open();

SqlTransaction objTran = objConnection.BeginTransaction();

SqlCommand objCommand = new SqlCommand();

objCommand.Connection = objConnection;

objCommand.CommandText = "INSERT INTO Patient (Name, OId) VALUES (@Name,
@OId)";


SqlParameter objParam1 = objCommand.CreateParameter();

objParam1.DbType = DbType.String;

objParam1.Value = "Test ST";

objParam1.ParameterName = "@Name";

objCommand.Parameters.Add(objParam1);

SqlParameter objParam2 = objCommand.CreateParameter();

objParam2.DbType = DbType.String;

objParam2.Value = "f6a07441-c3e2-4aaa-8913-cfbab8df395b";

objParam2.ParameterName = "@OId";

objCommand.Parameters.Add(objParam2);

objCommand.Transaction = objTran;

MessageBox.Show(objCommand.ExecuteNonQuery().ToString());



SqlConnection objConnection1 = new SqlConnection(sConnectStr);

objConnection1.Open();

SqlCommand objCommand1 = new SqlCommand();

objCommand1.Connection = objConnection1;

objCommand1.CommandText = "select count(*) from Patient";

SqlDataReader objReader = objCommand1.ExecuteReader();


objTran.Commit();


How to over come this??

Thanks in advance

Regards,
karthikeyan. G

Miha
Tue Jan 06 03:34:13 CST 2004

Hi,

You should use same connection and transaction for reading data (otherwise
first connection is locking the data and the second can't access it).
Also, you might remove messagebox from the code as it will cause unnecessary
delay.

--
Miha Markic - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

"Karthikeyan" <Karthikeyan.Ganesan@isoftplc.com> wrote in message
news:%23GPTSWD1DHA.2528@TK2MSFTNGP10.phx.gbl...
> HI,
>
> I am getting a Connection Time Out Error While executing the follwoing
code
>
> Transaction isolation Level is "Read Commited"
>
>
> String sConnectStr = "User ID=sa;Password=sa;Database=DAL;Server=.";
>
> SqlConnection objConnection = new SqlConnection(sConnectStr);
>
> objConnection.Open();
>
> SqlTransaction objTran = objConnection.BeginTransaction();
>
> SqlCommand objCommand = new SqlCommand();
>
> objCommand.Connection = objConnection;
>
> objCommand.CommandText = "INSERT INTO Patient (Name, OId) VALUES (@Name,
> @OId)";
>
>
> SqlParameter objParam1 = objCommand.CreateParameter();
>
> objParam1.DbType = DbType.String;
>
> objParam1.Value = "Test ST";
>
> objParam1.ParameterName = "@Name";
>
> objCommand.Parameters.Add(objParam1);
>
> SqlParameter objParam2 = objCommand.CreateParameter();
>
> objParam2.DbType = DbType.String;
>
> objParam2.Value = "f6a07441-c3e2-4aaa-8913-cfbab8df395b";
>
> objParam2.ParameterName = "@OId";
>
> objCommand.Parameters.Add(objParam2);
>
> objCommand.Transaction = objTran;
>
> MessageBox.Show(objCommand.ExecuteNonQuery().ToString());
>
>
>
> SqlConnection objConnection1 = new SqlConnection(sConnectStr);
>
> objConnection1.Open();
>
> SqlCommand objCommand1 = new SqlCommand();
>
> objCommand1.Connection = objConnection1;
>
> objCommand1.CommandText = "select count(*) from Patient";
>
> SqlDataReader objReader = objCommand1.ExecuteReader();
>
>
> objTran.Commit();
>
>
> How to over come this??
>
> Thanks in advance
>
> Regards,
> karthikeyan. G
>
>