1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
| SqlConnection cn = new SqlConnection(@"Data Source=.\SQLEXPRESS;UID=sa;Password=forChariaa3*;Initial Catalog=scolarite");
cn.Open();
SqlDataAdapter da = new SqlDataAdapter(@"SELECT EXAMEN.NUM_INSCRIPTION, SUM(MATIERE.COEFF * EXAMEN.NOTE) / SUM(MATIERE.COEFF) AS Expr1, MATIERE.CODE_MODULE
FROM MATIERE INNER JOIN
EXAMEN ON MATIERE.CODE_MATIERE = EXAMEN.CODE_MATIERE
GROUP BY MATIERE.CODE_MODULE, EXAMEN.NUM_INSCRIPTION", cn);
DataTable dt = new DataTable();
da.Fill(dt);
cn.Close();
Response.Clear();
Response.ContentType = "application/vnd.ms-excel";
string sep = "";
foreach (DataColumn dc in dt.Columns)
{
Response.Write(sep + dc.ColumnName);
sep = "\t";
}
Response.Write("\n");
int i;
foreach (DataRow dr in dt.Rows)
{
sep = "";
for (i = 0; i < dt.Columns.Count; i++)
{
Response.Write(sep + dr[i].ToString());
sep = "\t";
}
Response.Write("\n");
}
} |
Partager