Salve ragazzi
vorrei visualizzare i contenuto di un CAMPO di un database SQL in un altra pagina
utilizzANDO L hyperlink di un datalist :
e visualizzare appunto il cotenuto del campo creando una pagina vuota view con un altro datalist :codice:<asp:HyperLink ID="HyperLink1" runat="server" Target=_blank NavigateUrl='<%# "~/view.aspx?Doc_ID=" + DataBinder.Eval(Container.DataItem,"Doc_ID")%>' Text=abstract" />
ma mida questo errore :codice:<%@ Page Language="c#" Debug=true %> <%@ import Namespace="System" %> <%@ import Namespace="System.IO" %> <%@ import Namespace="System.Data" %> <%@ Import Namespace="System.Data.SqlClient"%> <script runat="server" Language="C#"> SqlConnection myConnection; protected void Page_Load(Object Src, EventArgs E) { myConnection = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=C:\\Inetpub\\wwwroot\\repository\\App_Data\\database.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"); if (!IsPostBack) { SqlDataAdapter myCommand = new SqlDataAdapter("select abstract from upload", myConnection); DataSet ds = new DataSet(); myCommand.Fill(ds, "select"); MyDataList.DataSource = ds.Tables["upload"].DefaultView; MyDataList.DataBind(); } } </script> <html xmlns="http://www.w3.org/1999/xhtml" > <head id="Head1" runat="server"> <title>Untitled Page</title> </head> <body> <form id="form1" runat="server"> <div> <asp:DataList ID="MyDataList" runat="server" RepeatColumns="5" EnableViewState="true" RepeatLayout="Flow" Font-Bold="False" Font-Italic="False" Font-Names="Verdana" Font-Overline="False" Font-Strikeout="False" Font-Underline="False" Font-Size="Smaller"> <ItemTemplate> Abstract: <asp:Label ID="AbstractLabel" runat="server" Width="400" Text='<%# Eval("Abstract") %>'></asp:Label> </ItemTemplate> <SeparatorStyle Font-Bold="True" Font-Italic="False" Font-Overline="False" Font-Strikeout="False" Font-Underline="False" BackColor="Black" ForeColor="Black" HorizontalAlign="Center" Wrap="False" /> <ItemStyle BackColor="White" Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False" Font-Underline="False" /> </asp:DataList><asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:databaseConnectionString8 %>" SelectCommand="SELECT [Abstract] FROM [upload]"> </asp:SqlDataSource> </div> </form> </body> </html>
volevo saper sono sulla stra giusta?in cosa sbaglio?codice:Object reference not set to an instance of an object. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.NullReferenceException: Object reference not set to an instance of an object. Source Error: Line 22: Line 23: Line 24: MyDataList.DataSource = ds.Tables["upload"].DefaultView; Line 25: MyDataList.DataBind(); Line 26: }
Rispondi quotando
