»Dotnet Ads
»Message Boards
Message Boards
Dotnet Books
»Member Details
Register
Login
LogOut
Submit Code
Submit Jobs
Submit Projects
»Competition
Community
Winners
Prizes
Write For Us
Members
»Other Resources
Links
Dotnet Resources
|
Converting a DataGrid to HTML and outputting it to screenThis 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();
|
|