Qualcuno sarebbe così gentile da spiegarmi per bene questo codice:
Fino alla creazione della connessione al Db è tutto ok, il fatto è che il resto non mi è chiarissimo! :incupito:codice:<%@Import Namespace="System.Data.OleDb"%> <%@Import Namespace="System.Data"%> <%@ Page Language="vb" %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML> <HEAD> <title>Query Parametrica</title> <script runat="server"> Dim Conn as new OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;" & _ "Data Source=c:\Dev\banking.mdb") Sub GetData(obj as object, e as EventArgs) Dim objCmd as OleDbCommand = new OleDBCommand("Select * from tblUsers where UserId=@ID", conn) Dim objReader as OleDbDataReader Dim objParam as OleDbParameter objParam = objCmd.Parameters.add("@ID", OleDbType.Integer) objParam.Direction = ParameterDirection.Input objParam.Value = tbId.Text try objCmd.Connection.Open() objReader = objCmd.ExecuteReader catch ex as OleDbException Label1.Text = "Errore nel recupero dei dati" End Try DataGrid1.DataSource = objReader DataGrid1.DataBind() objReader.Close objCmd.Connection.Close() End Sub </script> <meta content="True" name="vs_showGrid"> <meta content="Microsoft Visual Studio.NET 7.0" name="GENERATOR"> <meta content="Visual Basic 7.0" name="CODE_LANGUAGE"> <meta content="JavaScript" name="vs_defaultClientScript"> <meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema"> </HEAD> <body MS_POSITIONING="GridLayout"> <form id="Form1" method="post" runat="server"> <asp:Label id="lbl1" style="Z-INDEX: 101; LEFT: 11px; POSITION: absolute; TOP: 16px" runat="server" Width="57px">Enter ID:</asp:Label> <asp:TextBox id="tbId" style="Z-INDEX: 102; LEFT: 69px; POSITION: absolute; TOP: 13px" runat="server" Width="72px" OnTextChanged="GetData" AutoPostBack="True"></asp:TextBox> <asp:DataGrid id="DataGrid1" style="Z-INDEX: 103; LEFT: 7px; POSITION: absolute; TOP: 39px" runat="server" Width="100%"> <HeaderStyle BackColor="ActiveBorder"></HeaderStyle> </asp:DataGrid> <asp:Label id="Label1" style="Z-INDEX: 104; LEFT: 12px; POSITION: absolute; TOP: 186px" runat="server" Width="418px"></asp:Label></form> </body> </HTML>

Rispondi quotando