Stored procedures
Hvad går der galt her? Jeg bruger stored procedures.. Det går galt når jeg bruger EXECUTE getNyheder, men det går fint hvis bare jeg bruger SELECT * FROM mintabel<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<script language="VB" runat="server">
Sub Page_Load(Sender As Object, E As EventArgs)
Dim Conn As New SqlConnection(Session("dsn"))
Dim Comm As New SqlCommand("EXECUTE getNyheder", Conn)
'Dim Comm As New SqlCommand("SELECT * FROM nyheder", Conn)
Dim DR As SqlDataReader
Comm.Connection.Open()
DR = Comm.ExecuteReader
While DR.Read()
Nyheder.Text = DR.Item("tekst") & "<br>" & VBCrLf
End while
Comm.Connection.Close()
End sub
</script>
<asp:label id="Nyheder" runat="server"/>
