ASP.NET

Figmo2 wrote:

If I code my SelectCommand to look like ......WHERE Field LIKE @value It will work perfectly if I manually type the % signs in the text box for value. Including if I type %O'Hara% (the single quote no longer chokes it since I'm not concatenating anymore) - but obviously I don't want to have to teach the world to always put % sings at the start and end of their search strings on my web site.

protected void SqlDataSource1_Selecting(object sender, SqlDataSourceSelectingEventArgs e)<br />
{<br />
    e.Command.Parameters["@SearchExpr"].Value = "%" + e.Command.Parameters["@SearchExpr"].Value + "%";<br />
}

Figmo2 wrote:

Am I right in assuming that this should be adequate protection?

Jayadheer Reddy wrote:

my code struck here

if(age>18)
{
///////////

}

amina89 wrote:

but it returns me the following error: The format of the input string is incorrect.

  <asp:GridView ID="GridView1" runat="server" AllowSorting="True" AutoGenerateColumns="False"<br />
            BackColor="White" BorderColor="#CCCCCC" BorderWidth="1px" CellPadding="4" CssClass="th"<br />
            DataKeyNames="NUM_INSCRIPTION" Width ="60%"  Height="9%" PagerStyle-CssClass="note" Style="position: absolute; left: 126px; top: 159px;"<br />
           ><br />
            <FooterStyle BackColor="White" ForeColor="#000066" /><br />
            <RowStyle ForeColor="#000066" /><br />
            <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" /><br />
            <PagerStyle BackColor="White" CssClass="note" ForeColor="#000066" HorizontalAlign="Left" /><br />
            <HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" /><br />
           <br />
<br />
<br />
 <Columns><br />
                <asp:TemplateField HeaderText="IDStudent"><br />
                    <ItemStyle CssClass="td00" /><br />
                    <ItemTemplate><br />
                        <asp:Label ID="lblUserID1" runat="server" Text='<%# Eval("NUM_INSCRIPTION") %>'></asp:Label><br />
                        <itemstyle cssclass="td00" /><br />
                    </ItemTemplate><br />
                </asp:TemplateField><br />
<br />
<br />
    <asp:TemplateField HeaderText="StudentName"><br />
                    <ItemStyle CssClass="td01" /><br />
                    <ItemTemplate><br />
                        <asp:Label ID="lblUserID2" runat="server" Text='<%# Eval("NOM_PRENOM_ETUDIANT_ARABE") %>'></asp:Label><br />
                    </ItemTemplate><br />
                </asp:TemplateField><br />
               <br />
<br />
<br />
 <asp:TemplateField HeaderText="mark1"><br />
                    <ItemTemplate><br />
                            <asp:Label ID="lblLastName1" runat="server" Text='<%# Eval("111") %>' Visible='<%# !(bool) IsInEditMode %>'></asp:Label><br />
                            <asp:TextBox ID="moyt1" runat="server" Text='<%# Eval("111") %>' Visible='<%# IsInEditMode %>'></asp:TextBox><br />
                    </ItemTemplate><br />
                </asp:TemplateField><br />
<br />
<br />
<br />
  <asp:TemplateField HeaderText="mark2"><br />
                     <ItemStyle CssClass="td02" /><br />
                    <ItemTemplate><br />
                        <asp:Label ID="lblLastName" runat="server" Text='<%# Eval("112") %>' Visible='<%# !(bool) IsInEditMode %>'></asp:Label><br />
                        <asp:TextBox ID="validt1" runat="server" Text='<%# Eval("112") %>' Visible='<%# IsInEditMode %>'></asp:TextBox><br />
                    </ItemTemplate><br />
                </asp:TemplateField> <br />
<br />
<br />
<br />
 <asp:TemplateField HeaderText="average"><br />
                    <ItemStyle CssClass="td01" /><br />
                    <ItemTemplate><br />
                        <asp:Label ID="lblUserID4" runat="server" Text='<%# Eval("NOTE_MODULE") %>'></asp:Label><br />
                    </ItemTemplate><br />
                </asp:TemplateField><br />
                <br />
                <br />
                </Columns><br />

<code>

            XmlDocument xmlDoc = new XmlDocument();
            xmlDoc.Load("XMLFile.xml");
            XmlNodeList selectedNodes =  xmlDoc.SelectNodes("//Store[@Stores>30]");

            foreach (XmlNode item in selectedNodes)
            {
                Console.WriteLine(item.Attributes["name"].Value);
            }

            Console.ReadLine();
</code>

<?xml version="1.0" encoding="utf-8" ?>
<Stores>
  <Store name="Name1" store="10"/>
  <Store name="Name2" store="20"/>
  <Store name="Name3" store="30"/>
  <Store name="Name4" store="40"/>  
</Stores>