Converting a DataGrid to HTML and outputting it to screen

This code shows you how to convert a DataGrid to HTML and outputting it to screen

string ConnStr = "Server=servername;Database=databasename;UID=username;PWD=password;";
SqlConnection sqlConn = new SqlConnection(ConnStr);
string query = "getTest";
SqlCommand sqlComm = new SqlCommand(query,sqlConn);
sqlComm.CommandType=CommandType.StoredProcedure;
sqlConn.Open();
SqlDataReader sqlReader;
sqlReader = sqlComm.ExecuteReader();
dgView.DataSource = sqlReader;
dgView.DataBind();
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
dgView.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter);
Response.End();