2
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;
namespace Emergency
{
public partial class Report : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void btnexport_Click(object sender, EventArgs e)
{
// SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrin gs["servicecreation"].ConnectionString);
// SqlCommand command = new SqlCommand();
//command.CommandText = "select * from emergencypatient";
//using (SqlDataAdapter dataAdapter = new SqlDataAdapter(command.CommandText, con))
//{
// DataTable t = new DataTable();
// dataAdapter.Fill(t);
// Workbook book = new Workbook();
// Worksheet sheet = book.Worksheets[0];
// sheet.InsertDataTable(t, true, 1, 1);
// book.SaveToFile("ToExcel.xls");
// }
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "EMRPatDetails.xls"));
Response.ContentType = "application/ms-excel";
DataTable dt = GetDatafromDatabase();
string str = string.Empty;
foreach (DataColumn dtcol in dt.Columns)
{
Response.Write(str + dtcol.ColumnName);
str = "\t";
}
Response.Write("\n");
foreach (DataRow dr in dt.Rows)
{
str = "";
for (int j = 0; j < dt.Columns.Count; j++)
{
Response.Write(str + Convert.ToString(dr[j]));
str = "\t";
}
Response.Write("\n");
}
Response.End();
}
protected DataTable GetDatafromDatabase()
{
DataTable dt = new DataTable();
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrin gs["servicecreation"].ConnectionString);
{
con.Open();
SqlCommand cmd = new SqlCommand("Select * FROM emergencypatient", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
con.Close();
}
return dt;
}
}
}
