Testing two stored procedures efficiency

Here is a quick SQL statement that will report on CPU and elapsed time for specified stored procedures.

USE DatabaseName
GO

SET STATISTICS TIME ON
GO
PRINT '---------------- START SP 1 ------------------------'
EXEC stored_proc1
PRINT '---------------- END SP 1 --------------------------'
GO

PRINT '---------------- START SP 2 ------------------------'
EXEC stored_proc2
PRINT '---------------- END SP 2 --------------------------'
GO

SET STATISTICS TIME OFF
GO

Bind XML to DataGrid

Binding XML from a data table to a DataGrid

Code Behind
string xml = null;
while(reader.Read()){
  xml = reader["Responses"].ToString();
}

StringReader stream = new StringReader(xml);

using(DataSet ds = new DataSet()){
  ds.ReadXml(stream, XmlReadMode.InferSchema);

  ResultsDataGrid.DataSource = ds;
  ResultsDataGrid.DataBind();
}


aspx page
<asp:datagrid id="ResultsDataGrid" runat="server" AutoGenerateColumns="false">
  <Columns>
    <asp:BoundColumn DataField="LABEL" HeaderText="Question"></asp:BoundColumn>
    <asp:BoundColumn DataField="RESPONSE" HeaderText="Response"></asp:BoundColumn>
  </Columns>
</asp:datagrid>