Ho il seguente codice:
Quando avvio, mi da errore "Cannot implicitly convert type 'int' to 'System.Data.OleDb.OleDbDataReader", la riga che causa l'errore è quella evidenziata, qualcuno mi da una mano?codice:<%@ Page Language="C#" AutoEventWireup="true" %> <%@ Import Namespace = "System.Data" %> <%@ Import Namespace = "System.Data.OleDb" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server"> <title>Pagina senza titolo</title> </head> <body> <script language=C# runat=server> void Page_Load(object Object, EventArgs e) { } protected void Button1_Click(object sender, EventArgs e) { string txtNome = Request.Form["txtNome"].ToString(); string txtCognome = Request.Form["txtCognome"].ToString(); String Scn = "Provider=Microsoft.Jet.OleDb.4.0; Data Source=" + Server.MapPath("Clienti.mdb"); OleDbConnection cn = new OleDbConnection(Scn); cn.Open(); OleDbCommand cmd = new OleDbCommand("INSERTO INTO Categories (Nome, Cognome) VALUE (?,?)", cn); OleDbParameter par1 = new OleDbParameter("txtNome", OleDbType.WChar, 50); OleDbParameter par2 = new OleDbParameter("txtCognome", OleDbType.WChar, 50); par1.Value = txtNome; par2.Value = txtCognome; cmd.Parameters.Add(par1); cmd.Parameters.Add(par2); OleDbDataReader res = cmd.ExecuteNonQuery(); } </script> <form id="form1" runat="server" > <div> NOME: <asp:TextBox ID="txtNome" runat="server"></asp:TextBox> COGNOME: <asp:TextBox ID="txtCognome" runat="server"></asp:TextBox> <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Inserisci" /></div> </form> </body> </html>
Rispondi quotando
