1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| for (int d = 0; d < ddlAdr.Items.Count; d++)
{
connection.Open();
System.Data.SqlClient.SqlDataReader oDBDataReader2;
String Query2 = "SELECT * FROM [StationsServices]";// where ID_Station =" + ddlAdr.Items[d].Value
SqlCommand cmdDatabase2 = new SqlCommand(Query2, connection);
oDBDataReader2 = cmdDatabase2.ExecuteReader();
string[,] tabStation;
tabStation = new string[ddlAdr.Items.Count,2];
while (oDBDataReader2.Read() == true)
{
for (int i = 0; i < ddlAdr.Items.Count; i++)
{
tabStation[i, 0] = oDBDataReader2["Adresse"].ToString();
tabStation[i, 1] = oDBDataReader2["Name_station"].ToString();
break;
}
}
connection.Close();
} |
Partager