• <%@ import namespace="System" %>
    <%@ import namespace="System.IO" %>
    <%@ import namespace="System.Web" %>
    <%@ import namespace="System.Web.UI" %>
    <%@ import namespace="System.Data" %>
    <%@ import namespace="System.Data.OleDb" %>

    <script language="C#" runat="server">
    void Page_Load(Object sender, EventArgs e)
    {
    Response.Write("</br>NB : La <u>DATA</u> se non specificata, verra\' inserita quella odierna.</br>");
    }

    void doInsertNews(Object sender, EventArgs e)
    {
    try
    {
    string MyConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("./"+"news.mdb");
    string MySQL = "insert into [NewsTable] (nwsData, nwsTitle, nwsContent) values (@frmNwsData, @frmNwsTitle, @frmNwsContent)";

    OleDbConnection myConn = new OleDbConnection(MyConn);
    OleDbCommand cmd = new OleDbCommand(MySQL, myConn);

    if (formNwsData.Text != "") cmd.Parameters.Add(new OleDbParameter("@frmNwsData", formNwsData));

    cmd.Parameters.Add(new OleDbParameter("@frmNwsTitle", formNwsTitle));
    cmd.Parameters.Add(new OleDbParameter("@frmNwsContent", formNwsContent));

    myConn.Open();

    cmd.ExecuteNonQuery();

    myConn.Close();

    Span1.InnerHtml = "Inserimento effettuato!
    ";
    }
    catch (Exception Ex)
    {
    Span1.InnerHtml = "Errore : Inserimento effettuato!
    ";
    Span1.InnerHtml += Ex.Message + "</br>";
    }
    }
    </script>

    <html>
    <head>
    </head>
    <body>
    <Form id="form1" runat="server">
    <table border="0">
    <tr>
    <td align="right">News Data </td>
    <td><asp:textbox id="formNwsData" runat="server" /></td>
    </tr>
    <tr>
    <td align="right">News Title</td>
    <td>
    <asp:textbox id="formNwsTitle" runat="server" />
    <%/* <asp:RequiredFieldValidator runat="server" id="vldNwsTitle" ControlToValidate="formNwsTitle" ErrorMessage="News Title is required" display="dynamic"> The News Title field is Required!</asp:RequiredFieldValidator> */%>
    </td>
    </tr>
    <tr>
    <td align="right">News Content</td>
    <td>
    <asp:textbox id="formNwsContent" runat="server" />
    <%/* <asp:RequiredFieldValidator runat="server" id="vldNwsContent" ControlToValidate="formNwsContent" ErrorMessage="News Content is required" display="dynamic"> The News Content field is Required!</asp:RequiredFieldValidator>*/ %>
    </td>
    </tr>
    <tr>
    <td align="center" colspan="2">
    <asp:Button id="button1" Text="Insert" onserverclick="doInsertNews" runat="server" />
    </td>
    </tr>
    </table>
    <span id="Span1" style="font: 8pt verdana;" runat="server" />
    </Form>
    </body>
    </html>


DataBase :
nwsID => Contatore [Prim.Key]
nwsData => DATA/Ora
nwsTitle => Testo [255]
nwsContent => Testo [255]

Perche' non mi inserisce niente nel Database?
E' tutto il giorno che ci sclero...