stò giochiccando con un Host che mi permette gratuitamente di gestire uno spazio in asp.net, però non capisco perchè se eseguo il codice sotto sulla pagina non visualizzo il
GridView1
codice:Imports System.Data Imports System.Data.SqlClient Partial Class protocollo Inherits System.Web.UI.Page Dim conn As New System.Data.SqlClient.SqlConnection("workstation id=Protocollo.mssql.somee.com;packet size=4096;user id=miouser;pwd=miapass;data source=Protocollo.mssql.somee.com;persist security info=False;initial catalog=Protocollo") Dim commandBuilder As SqlClient.SqlCommandBuilder Dim dataAdapter As SqlClient.SqlDataAdapter Dim dataSet As DataSet Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click conn.Open() dataAdapter = New SqlClient.SqlDataAdapter("SELECT * FROM accesso ORDER by ID ASC", conn) commandBuilder = New SqlClient.SqlCommandBuilder(dataAdapter) dataSet = New Data.DataSet dataAdapter.Fill(dataSet) GridView1.DataMember = "ID" GridView1.DataSource = dataSet.Tables(0) GridView1.DataBind() End Sub End Class

Rispondi quotando