Torna al Thread

<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.Odbc" %> <%@ Import Namespace="System.Configuration" %> <%@ Import Namespace="System.IO" %> <script runat="server"> String connectionString = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString; Funzioni uty = new Funzioni(); protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { popola(); } } private void popola() { string strN = Request.QueryString["NewsId"]; OdbcConnection conn = new OdbcConnection(connectionString); /************************** ERRORE QUI ! *********************************/ string SQL = "SELECT * FROM news WHERE NewsId='" + uty.EscapeCodeToHTMLReplace(strN).ToString() + "' and _status='1'"; // Ecco qui dove c'è l'errore de'istanza. OdbcCommand objCommand = new OdbcCommand(SQL, conn); DataSet ds = new DataSet(); OdbcDataAdapter da = new OdbcDataAdapter(objCommand); da.Fill(ds); FormView1.DataSource = ds; FormView1.DataBind(); } </script> <asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server"> </asp:Content> <asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server"> <asp:FormView ID="FormView1" runat="server"> <EmptyDataTemplate>Non ci sono dati</EmptyDataTemplate> <HeaderTemplate> </HeaderTemplate> <ItemTemplate> <h1 ><%#Eval("_subject") %></h1> <%#Eval("_content") %> <p align="right"><a href="#"><%# Eval("_name") %></a></p> <p align="center"><a href="<%# Eval("NewsId") %>">Link</a></p> </ItemTemplate> <FooterTemplate> </FooterTemplate></asp:FormView> </asp:Content>
Copyright © dotNetHell.it 2002-2025
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5