DeadLock occur while execute SqlDataAdapter.Fill method

[Prashant]

Hi,

I am using following code to fill my dataset. when multiple user
connect to the web-site it will give me following error:

Error Message: Transaction (Process ID 98) was deadlocked on lock
resources with another process and has been chosen as the deadlock
victim. Rerun the transaction.

I am using stored procedure to select records from database.

DataSet ds = new DataSet();

SqlConnection mc = OpenSqlConnection();

try

{

SqlCommand cmd = new SqlCommand(strCmd, mc);

cmd.CommandType = CommandType.StoredProcedure;

cmd.CommandTimeout = 0;

if (parameters != null)

{

foreach (KeyValuePair<string, object> p in parameters)

{

cmd.Parameters.AddWithValue(p.Key, p.Value);

}


}

SqlDataAdapter da = new SqlDataAdapter(cmd);

da.Fill(ds);

}

catch (Exception ex)

{

}

finally

{

mc.Close();

}

return ds;



Appreciate your help,

prashant

[Jamie Fraser]

There is no transaction in your code, so I assume it must be in your
Stored Procedure? Either that or your using some kind of attribute
based transactional system, but I doubt it.

Post your stored procedure code.

[ThanderMaX]

the exception was thrown from the sql server side.

You can try adding "(nolock)" hint to ur query ... but only if u are
sure what u r doing.
If u need table/row lock , u don't have any way

[Shakeel]

Why have you used

cmd.CommandTimeout = 0;

Use
cmd.CommandTimeout = 60;

Bye...
Shakeel
(+919836287255)

[Prashant]

thanks all,

the problem was, nested stored procedure we are calling from asp.net
(c#)
I removed the nested stored porc. call and used embedded SQL while
loading data.

thansk for all your suggestions,
prashant