The name 'nyhedId' does not exist in the class or namespace
Hej jeg får følgende fejl i linje 68:The name 'nyhedId' does not exist in the class or namespace 'ASP.nyhed_rediger_temp_aspx'
jeg kan ikke finde fejlen da jeg mener jeg har ramt den rigtig men måske har jeg kigget det forkert sted?
Line 66: OurConnection = new
Line 67: SqlConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\Inetpub\wwwroot\eHandel\abcd.mdb");
Line 68: OurCommand = new SqlCommand ("UPDATE nyhed SET nyhedOverskrift = @nyhedOverskrift, nyhedTekst = @nyhedTekst WHERE nyhedId = " + nyhedId, OurConnection);
Line 69: OurCommand.Parameters.Add("@nyhedOverskrift", SqlDbType.VarChar).Value = nyhedOverskrift.Text;
Line 70: OurCommand.Parameters.Add("@nyhedTekst", SqlDbType.LongVarChar).Value = nyhedTekst.Text;
Her er koden kan nogen se fejlen:
<%@ Page Language="C#" ContentType="text/html" ResponseEncoding="iso-8859-1" debug="true" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.SqlClient" %>
<% string title; title = "Indsæt nyheder"; %>
<script runat="server">
void Page_Load()
{
if(!IsPostBack)
{
LoadData();
}
}
void LoadData()
{
SqlConnection OurConnection;
SqlCommand OurCommand;
SqlDataAdapter OurDataAdapter;
DataSet OurDataSet = new DataSet();
OurConnection = new SqlConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\Inetpub\wwwroot\eHandel\abcd.mdb");
OurConnection.Open();
OurCommand = new SqlCommand ("SELECT * FROM nyhed" ,OurConnection);
OurDataAdapter = new SqlDataAdapter(OurCommand);
OurDataAdapter.Fill(OurDataSet, "nyhed");
OurDataGrid.DataSource=OurDataSet.Tables["nyhed"];
UpdateNyhederId.DataSource=OurDataSet.Tables["nyhed"];
DeleteNyhederId.DataSource=OurDataSet.Tables["nyhed"];
DataBind();
}
void UpdateSetup(object Sender, EventArgs E)
{
UpdateSelect.Visible=false;
UpdateTextBoxes.Visible=true;
String SelectedID = UpdateNyhederId.SelectedItem.Value.ToString();
UpdateButton.CommandArgument = SelectedID;
SqlConnection OurConnection;
OurConnection = new SqlConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\Inetpub\wwwroot\eHandel\abcd.mdb");
OurConnection.Open();
SqlCommand OurCommand;
SqlDataReader OurDataReader2;
OurCommand = new SqlCommand("SELECT * FROM nyhed WHERE nyhedId = " + SelectedID ,OurConnection);
OurDataReader2 = OurCommand.ExecuteReader();
OurDataReader2.Read();
UpdateOverskrift.Visible=true;
UpdateTekst.Visible=true;
UpdateOverskrift.Text = OurDataReader2["nyhedOverskrift"].ToString();
UpdateTekst.Text = OurDataReader2["nyhedTekst"].ToString();
OurConnection.Close();
OurDataReader2.Close();
LoadData();
}
void UpdateReset(object sender, System.EventArgs e)
{
UpdateSelect.Visible=true;
UpdateTextBoxes.Visible=false;
LoadData();
}
void UpDateCommand(object sender, System.Web.UI.WebControls.CommandEventArgs e)
{
SqlConnection OurConnection;
SqlCommand OurCommand;
string UpdateNyhedID = e.CommandArgument.ToString();
OurConnection = new
SqlConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\Inetpub\wwwroot\eHandel\abcd.mdb");
OurCommand = new SqlCommand ("UPDATE nyhed SET nyhedOverskrift = @nyhedOverskrift, nyhedTekst = @nyhedTekst WHERE nyhedId = " + nyhedId, OurConnection);
OurCommand.Parameters.Add("@nyhedOverskrift", SqlDbType.VarChar).Value = nyhedOverskrift.Text;
OurCommand.Parameters.Add("@nyhedTekst", SqlDbType.LongVarChar).Value = nyhedTekst.Text;
OurConnection.Open();
OurCommand.ExecuteNonQuery();
OurConnection.Close();
LoadData();
}
void DeleteCommand(object sender, System.EventArgs e)
{
SqlConnection OurConnection;
string SelectedID = DeleteNyhedID.SelectedItem.Value;
SqlCommand OurCommand;
OurConnection = new
SqlConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\Inetpub\wwwroot\eHandel\abcd.mdb");
OurCommand = new SqlCommand("DELETE * FROM nyhed WHERE nyhedId = " + SelectedID, OurConnection);
OurConnection.Open();
OurCommand.ExecuteNonQuery();
OurConnection.Close();
LoadData();
}
</script>
<!-- #INCLUDE FILE="head.aspx" -->
<h3>Rediger nyheder</h3>
<table>
<tr>
<td><asp:datagrid ID="OurDataGrid" EnableViewState="false" BorderWidth="1" BackColor="#000000"
CellPadding="3" CellSpacing="0" Font-Name="Arial" HeaderStyle-BackColor="#AAAAAA" ItemStyle-BackColor="#EEEEEE" runat="server" />
</td>
<td>
<h4>Opdater Nyheder</h4>
<asp:panel ID="UpdateSelect" runat="server" >
NyhedsID: <asp:dropdownlist ID="UpdateNyhederId" DataTextField="nyhedId" DataValueField="nyhedId" runat="server" />
<asp:button runat="server" Text="Vælg nyhed" OnClick="UpdateSetup" />
</asp:panel>
<asp:panel ID="UpdateTextBoxes" Visible="false" runat="server">
Overskrift: <asp:textbox ID="UpdateOverskrift" runat="server" /><br />
Nyheds Tekst: <asp:textbox ID="UpdateTekst" TextMode="MultiLine" Rows="10" Columns="40" runat="server" /><br />
<asp:button ID="UpdateButton" onCommand="UpdateCommand" runat="server" Text="Opdater Nyhed" />
<asp:button ID="CancelUpdateButton" runat="server" OnClick="UpdateReset" Text="Vælg en anden Nyhed" />
</asp:panel><br />
<hr style="height:1px" />
<h4>Slet Nyhed</h4>
NyhedsID: <asp:dropdownlist ID="DeleteNyhederId" DataTextField="nyhedId" DataValueField="nyhedId" runat="server" />
<asp:button runat="server" Text="Slet Nyheden" OnClick="DeleteCommand" />
</td>
</tr>
</table>
<!-- #INCLUDE FILE="footer.aspx" -->
