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
34
35
36
37
38
| string chaine2 = @"data source=.\SQLEXPRESS;Initial Catalog=gbj;Integrated Security=True";
SqlConnection s2 = new SqlConnection(chaine2);
string cmd2 = "select count(*) from badges where nom_accompagnateur='" + acco + "' and imprime IS NULL ";
SqlCommand cmd3 = new SqlCommand(cmd2, s2);
s2.Open();
SqlDataReader dr2 = cmd3.ExecuteReader();
DataTable dt2 = new DataTable();
dt2.Load(dr2);
int count = (int)dt2.Rows[0][0];
s2.Close();
string chaine3 = @"data source=.\SQLEXPRESS;Initial Catalog=gbj;Integrated Security=True";
SqlConnection s3 = new SqlConnection(chaine3);
string cmd33 = "select * from badges where nom_accompagnateur='" + acco + "' and imprime IS NULL ";
SqlCommand cmd4 = new SqlCommand(cmd33, s3);
s3.Open();
SqlDataReader dr3 = cmd4.ExecuteReader();
DataTable dt3 = new DataTable();
dt3.Load(dr3);
s2.Close();
while( i<count)
{
Label10.Text = dt3.Rows[i][0].ToString();
Label12.Text = dt3.Rows[i][1].ToString();
Label14.Text = dt3.Rows[i][2].ToString();
Label16.Text = dt3.Rows[i][3].ToString();
Label18.Text = dt3.Rows[i][19].ToString();
Label20.Text = dt3.Rows[i][6].ToString();
Label22.Text = dt3.Rows[i][7].ToString();
Label28.Text = dt3.Rows[i][14].ToString();
Label30.Text = dt3.Rows[i][15].ToString();
Label33.Text = dt3.Rows[i][8].ToString();
Label34.Text = dt3.Rows[i][11].ToString();
Response.Write("<script>window.print();</script>");
i++;
} |
