can you kindly help me load my gridview with data from appsetings.xml . the gridview must have the following three columns(key,value and description)
here is my appsettings.xml.
<?xml version="1.0"?>
<configuration>
<Global>
<FromEmail value="test@uiplay.com"
description="From Email Address Name" />
<AdminEmail value="cmckowen@gmail.com"
description="Admin Email Used for Admin Test and Unsubscribe Comments" />
</Global>
<Data>
<!--<Connection value="server=localhost;database='PolicyNet';uid='sa';pwd='sa123!'"
description="Default Database Connection String" />-->
<!--<Connection value="server=wormwood;database='PolicyNet';uid='PolicyNetTest';pwd='PNet123!'"
description="Default Database Connection String" />-->
<Connection value="server=196.14.77.139;database='PolicyNetTest';uid='PolicyNetTest';pwd='PNet123!'"
description="Default Database Connection String" />
<!-- 196.14.77.139 -->
<AllowManualStoredProcedureExecution value="false"
description="allow execution of stored procedures from outside data classes (bad practice!)" />
<SqlPath value="Data/sql"
description="Path to the XML Query Files"/>
</Data>
<Users>
<EncryptionData value="(rS06BeTdkbD9TB9RUWQWESvsJUs+kw82wcTlN2e+8NBAB87CPkT/gl3sDQnh4NbjhzQJB36h6KTNX80HeQHnNw==)"
description="Encryption data" />
</Users>
<Communication>
<Mail>
<SmtpServer value="127.0.0.1" description="SMTP Server Used By Newsletter Application" />
</Mail>
<Sms>
<LogicSms>
<Username value="Ronelle@UIPLAY" description="Username for LogicSms" />
<Password value="wong2fu" description="Password for LogicSms" />
</LogicSms>
</Sms>
</Communication>
<CMS>
<Handlers>
<DelayedResponseHandler.Timeout value="50000"
description="Timeout for DelayedResponseHandler" />
</Handlers>
</CMS>
<CRM>
<CampaignTools>
<Newsletter>
<FromEmail value="test@uiplay.com"
description="Address used as from field for newsletters" />
<UnsubscribeLinkFormat value="http://localhost:100/index.aspx?PageKey=Unsubscribe&Id=[:ContactId:]"
description="Url used to unsubrscribe a contact" />
</Newsletter>
</CampaignTools>
</CRM>
<PayinDueDay value="24"
description="Day by which Pay-ins should be entered." />
</configuration>