protected void btnDataTable_Click(object sender, System.EventArgs e)
{
object retVal = DeadLockManagement.CreateDeadlock("prcDeadLock_PartA", QueryType.DataTable);
DataTable dt = (DataTable)retVal;
string strResult = dt.Rows[0].ItemArray[0].ToString();
lblResult.Text = "DataTable Query Complete. Returned: " + strResult;
}
protected void btnDataSet_Click(object sender, System.EventArgs e)
{
object retVal = DeadLockManagement.CreateDeadlock("prcDeadLock_PartA", QueryType.DataSet);
DataSet ds = (DataSet)retVal;
string strResult = ds.GetXml();
lblResult.Text = "DataSet Query Complete. Returned: " + strResult;
}
protected void btnXmlReader_Click(object sender, System.EventArgs e)
{
object retVal = DeadLockManagement.CreateDeadlock("prcDeadLock_PartB", QueryType.XMLReader);
XmlReader reader = (XmlReader)retVal;
string strResult = "";
while (reader.Read())
{
strResult = strResult + reader.ReadString() + "|";
}
lblResult.Text = "XML Reader Query Complete. Returned: " + strResult;
}
protected void btnXmlReader_Click(object sender, System.EventArgs e)
{
object retVal = DeadLockManagement.CreateDeadlock("prcDeadLock_PartA", QueryType.XMLReader);
lblResult.Text = "XML Reader Query Complete. Returned: " + (String)retVal;
}
protected void btnScalar_Click(object sender, System.EventArgs e)
{
object retVal = DeadLockManagement.CreateDeadlock("prcDeadLock_PartA", QueryType.Scalar);
lblResult.Text = "Scalar Query Complete. Returned: " + retVal.ToString();
}
protected void btnStartPartA_Click(object sender, System.EventArgs e)
{
DeadLockManagement.CreateDeadlock("prcDeadLock_PartA", QueryType.NonQuery);
lblResult.Text = "NonQuery Executed.";
}
