Connectionstring problem
Jeg er begynder og har hugget lidt kode fra:http://aspnet.4guysfromrolla.com/articles/040502-1.aspx
Men jeg ved ikke hvad jeg skal skrive i min connectionstring ??
Her er den fulde kode:
-----------------------------------------------------------
<% @Import Namespace="System.Data" %>
<% @Import Namespace="System.Data.SqlClient" %>
<script language="vb" runat="server">
Sub Page_Load(sender as Object, e as EventArgs)
BindData()
End Sub
Sub BindData()
'1. Create a connection
Dim myConnection as New SqlConnection(
ConfigurationSettings.AppSettings("connectionString"))
'2. Create the command object, passing in the SQL string
Const strSQL as String = "select * from Posts"
Dim myCommand as New SqlCommand(strSQL, myConnection)
'Set the datagrid's datasource to the datareader and databind
myConnection.Open()
Posts.DataSource = myCommand.ExecuteReader(
CommandBehavior.CloseConnection)
Posts.DataBind()
End Sub
</script>
<asp:datagrid id="Posts" runat="server" />
---------------------------------------------------------
Den kommer ikke overaskende med en fejl i linien:
Dim myConnection as New SqlConnection(
ConfigurationSettings.AppSettings("connectionString"))
Hvad skal jeg skrive i connectionstring'en ?
Siden ligger på brinkster, hvis det gør nogen forskel.
