Hi ich hab nen problem (bin noch neu in asp.net)!!
Die Fehlermeldung:
Serverfehler in der Anwendung '/'.
Falsche Syntax in der Nähe des User-Schlüsselwortes.
Fehler im Quelltext bei:
DataGrid1.DataSource = myCommand.ExecuteReader(CommandBehavior.CloseConnection)
Mein kompleter Quelltext:
<%@ Page Language="VB" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.SqlClient" %>
<script runat="server">
Sub Page_Load(Sender As Object, E As EventArgs)
Dim connectionString As String = ConfigurationSettings.AppSettings("connectionString")
Dim CommandText As String = "select Id, FirstName as [Vorname], LastName as [Nachname] from User"
Dim myConnection As New SqlConnection(ConnectionString)
Dim myCommand As New SqlCommand(CommandText, myConnection)
myConnection.Open()
DataGrid1.DataSource = myCommand.ExecuteReader(CommandBehavior.CloseConnection)
DataGrid1.DataBind()
End Sub
Sub DataGrid1_SelectedIndexChanged(sender As Object, e As EventArgs)
End Sub
</script>
<html>
<head>
</head>
<body style="FONT-FAMILY: arial">
<h2>Simple Data Report
</h2>
<hr size="1" />
<form runat="server">
<asp:datagrid id="DataGrid1" runat="server" Height="243px" Width="290px" OnSelectedIndexChanged="DataGrid1_SelectedIndexChanged" EnableViewState="False" ForeColor="Red" BackColor="Navy" CellPadding="3" GridLines="None" CellSpacing="1">
<HeaderStyle font-bold="True" forecolor="Olive" backcolor="Black"></HeaderStyle>
<ItemStyle backcolor="#DEDFDE"></ItemStyle>
</asp:datagrid>
</form>
</body>
</html>
Danke das ihr euch die "mühe" (für mich wäre es sehr viel mühe,hab aber nur noch einen Tag,und suche schon seit zwei tagen den fehler) macht,und euch das ganze anschaut!!!
p.s.
quelltext der web.config:
<?xml version="1.0" encoding="UTF-8" ?>
<configuration>
<appSettings>
<add key="connectionString" value="server=(local);trusted_connection=true;database=manutest"/>
</appSettings>
<!--
The <appSettings> section is used to configure application-specific configuration
settings. These can be fetched from within apps by calling the
"ConfigurationSettings.AppSettings(key)" method:
<appSettings>
<add key="connectionstring" value="server=localhost;trusted_connection=true;database=pubs"/>
</appSettings>
-->
<system.web>
<compilation debug="true"/>
...
...
...
...
Danke!!!!!
