Voilà mon problème :
Dim command2 As New MySQLCommand(ConfigurationManager.AppSettings("selectSsMenu").ToString, connexion)
'command2.Parameters.Add("@idmenu", Integer.Parse(reader(0).ToString))
command2.Parameters.Add("@idmenu", 1)
Response.Write(command2.CommandText)
Dim reader2 As MySQLDataReader
reader2 = command2.ExecuteReader
et voici mon fichier de web.conf
<?xml version="1.0"?>
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
<appSettings>
<add key="ConnectionTimeout" value="30"/>
<add key="CommandTimeout" value="30"/>
<add key="selectVersion" value="select version from systeme"/>
<add key="selectMenu" value="select id, txtfr, txten, img from menu order by id"/>
<add key="selectSsMenu" value="select id, txtfr, txten, img, action from ssmenu where idmenu=@idmenu order by id"/>
<add key="selectAction" value="select titrefr, titreen, img, txtfr, txten from page where action='@action'"/>
</appSettings>
<connectionStrings>
<add name="dbConnectionString" connectionString="server=localhost;db=matth20969;user id=matth20969;pwd=mtb84b;option=16386" providerName="MySQL ODBC 3.51 Driver"/>
</connectionStrings>
<system.web>
<!--
Set compilation debug="true" to insert debugging
symbols into the compiled page. Because this
affects performance, set this value to true only
during development.
Visual Basic options:
Set strict="true" to disallow all data type conversions
where data loss can occur.
Set explicit="true" to force declaration of all variables.
-->
<compilation debug="true" strict="false" explicit="true"/>
<pages>
<namespaces>
<clear/>
<add namespace="System"/>
<add namespace="System.Collections"/>
<add namespace="System.Collections.Specialized"/>
<add namespace="System.Configuration"/>
<add namespace="System.Text"/>
<add namespace="System.Text.RegularExpressions"/>
<add namespace="System.Web"/>
<add namespace="System.Web.Caching"/>
<add namespace="System.Web.SessionState"/>
<add namespace="System.Web.Security"/>
<add namespace="System.Web.Profile"/>
<add namespace="System.Web.UI"/>
<add namespace="System.Web.UI.WebControls"/>
<add namespace="System.Web.UI.WebControls.WebParts"/>
<add namespace="System.Web.UI.HtmlControls"/>
</namespaces>
</pages>
<authentication mode="Windows"/>
</system.web>
</configuration>
Quelque peut m'expliquer pourquoi la requete ne me retourne rien? alors que j'ai des enregistrements dans la base