Ciao Comunity,
volevo sapere se procedo correttamente se avendo la necessità di creare una semplice DataGrid associata ad un DB:
<code>
<%@ Page Language="VB" %>
<script runat="server">
Function Autori() As System.Data.DataSet
Dim connectionString As String = "server='(local)'; trusted_connection=true; database='pubs'"
Dim dbConnection As System.Data.IDbConnection = New System.Data.SqlClient.SqlConnection(connectionString)
Dim queryString As String = "SELECT [authors].* FROM [authors]"
Dim dbCommand As System.Data.IDbCommand = New System.Data.SqlClient.SqlCommand
dbCommand.CommandText = queryString
dbCommand.Connection = dbConnection
Dim dataAdapter As System.Data.IDbDataAdapter = New System.Data.SqlClient.SqlDataAdapter
dataAdapter.SelectCommand = dbCommand
Dim dataSet As System.Data.DataSet = New System.Data.DataSet
dataAdapter.Fill(dataSet)
Return dataSet
End Function' Insert page code here
'
Sub DataGrid1_SelectedIndexChanged(sender As Object, e As EventArgs)
DataGrid1.DataSource = Autori()
DataGrid1.DataBind()
End Sub
Sub Page_Load(Sender AS Object, E AS EventArgs)
IF NOT Page.IsPostBack THEN
DataGrid1.DataSource = Autori()
DataGrid1.DataBind()
END IF
End Sub
</script>
<html>
<head>
</head>
<body>
<form runat="server">
<p>
<asp:Label id="Label1" runat="server">Titolo Tabella</asp:Label>
</p>
<p>
<asp:DataGrid id="DataGrid1" runat="server" BorderStyle="None" GridLines="Vertical" BorderWidth="1px" BorderColor="#999999" BackColor="White" CellPadding="3" OnSelectedIndexChanged="DataGrid1_SelectedIndexChanged">
<FooterStyle forecolor="Black" backcolor="#CCCCCC"></FooterStyle>
<HeaderStyle font-bold="True" forecolor="White" backcolor="#000084"></HeaderStyle>
<PagerStyle horizontalalign="Center" forecolor="Black" backcolor="#999999" mode="NumericPages"></PagerStyle>
<SelectedItemStyle font-bold="True" forecolor="White" backcolor="#008A8C"></SelectedItemStyle>
<AlternatingItemStyle backcolor="#DCDCDC"></AlternatingItemStyle>
<ItemStyle forecolor="Black" backcolor="#EEEEEE"></ItemStyle>
</asp:DataGrid>
</p>
</form>
</body>
</html>
</code>
In verità il dubbio che ho sta in questo punto:
<code>
Sub DataGrid1_SelectedIndexChanged(sender As Object, e As EventArgs)
DataGrid1.DataSource = Autori()
DataGrid1.DataBind()
End Sub
</code>
Devo necessariamente creare la SUB DataGrid1_SelectedIndexChanged per associare la DataGrid1 ad Autori() oppure potevo semplicemente associarla nel Page_Load?
Cetalfio
