voglio trasformare una pagina di ricerca che ho fatto in un codebehind, ma quello che facevo prima con page_load ora non funziona più...ho provato a mettere page_init, ma niente lo stesso
posto il codice..
e questa è la pagina aspx:codice:imports system imports System.Data imports system.web imports system.web.ui imports system.web.ui.webcontrols imports corelab.mysql public class ricerca : inherits Page public lblErrore as label public tbxMarca as textBox public tbxCodice as textBox public rfvCodice as requiredfieldvalidator public DataGrid1 as dataGrid Dim connessione As New mySqlConnection("User=admin; pwd=pass; Host=localhost; Port=3306; Database=gestione_ordini") sub page_load (obj as object, e as eventargs) if page.ispostback then datagrid1.CurrentPageIndex = 0 dim myInsertQuery as string if tbxMarca.text = "" then myInsertQuery = "SELECT * FROM tbllistinonazionale WHERE codice_prodotto_produttore LIKE "& server.htmldecode (""") &""&"%"&""& tbxCodice.text &""&"%"&""& server.htmldecode (""") &";" else myInsertQuery = "SELECT * FROM tbllistinonazionale WHERE codice_prodotto_produttore LIKE "& server.htmldecode (""") &""&"%"&""& tbxCodice.text &""&"%"&""& server.htmldecode (""") &" AND sigla_marchio = "& server.htmldecode (""") & tbxMarca.text & server.htmldecode (""") &";" end if Dim myCommand As New mySqldataadapter(myInsertQuery, connessione) dim ds as dataset = new dataset() mycommand.fill(ds, "tbllistinonazionale") datagrid1.datasource=ds datagrid1.databind() connessione.close end if end sub sub DataGrid1_PageIndexChanged(obj as Object, e as DataGridPageChangedEventArgs) DataGrid1.CurrentPageIndex = e.NewPageIndex DataGrid1.DataBind() end sub end class
chi mi sa dare una mano?codice:<%@ Page Inherits="ricerca" Src="codice\ricerca.vb" %> <html> <head> </head> <body> <form runat="server"> <asp:label id="lblErrore" runat="server" ForeColor="Red"></asp:label> </p> <table> <tbody> <tr> <td> Marca:</td> <td> <asp:TextBox id="tbxMarca" runat="server" autopostback="true"></asp:TextBox> </td> <td> <asp:Button id="btCerca" onclick="cerca" runat="server" Text="Button"></asp:Button> </td> </tr> <tr> <td> Codice Prodotto:</td> <td> <asp:textbox id="tbxCodice" runat="server" autopostback="true"></asp:textbox> </td> <td> <asp:RequiredFieldValidator id="rfvCodice" runat="server" ControlToValidate="tbxCodice" ErrorMessage="Devi inserire un codice"></asp:RequiredFieldValidator> </td> </tr> </tbody> </table> <asp:DataGrid id="DataGrid1" runat="server" BorderColor="black" Font-NameFont-Names="Arial" Font-Size="8pt" HeaderStyle-BackColor="#cccc99" FooterStyle-BackColor="#cccc99" ItemStyle-BackColor="#ffffff" AlternatingItemStyle-Backcolor="#cccccc" AllowPaging="true" PageSize="20" PagerStyle-Mode="NumericPages" PagerStyle-PageButtonCount="20" OnPageIndexChanged="DataGrid1_PageIndexChanged" AutoGenerateColumns="true" width="450" cellspacing="0" cellpadding="2"> <FooterStyle backcolor="#CCCC99"></FooterStyle> <HeaderStyle backcolor="#CCCC99"></HeaderStyle> <PagerStyle pagebuttoncount="20" mode="NumericPages"></PagerStyle> <AlternatingItemStyle backcolor="#CCCCCC"></AlternatingItemStyle> <ItemStyle backcolor="White"></ItemStyle> </asp:DataGrid> </p> </form> </body> </html>
Rispondi quotando
