DeadLock Occur While Execute SqlDataAdapter.Fill Method

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