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>