Hi Billy,
The code below works fine on my side. Would you please post your code?
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<HTML>
<script language="VB" runat="server">
Dim ds As New DataSet()
Sub Page_Load(Sender As Object, E As EventArgs)
Dim sql as String = "select top 80 CustomerID, CompanyName,
ContactName, ContactTitle from customers"
Dim conn as String = "server=sha-china-xp;database=northwind;user
id=sa;password=1234"
Dim da As New SqlDataAdapter(sql, conn)
da.Fill(ds)
DataGrid1.DataSource = ds.Tables(0).DefaultView
DataGrid1.DataBind()
End Sub
</script>
<body>
<form id="Form1" method="post" runat="server">
<asp:DataGrid id="DataGrid1" CellSpacing="0" runat="server"></asp:DataGrid>
</form>
</body>
</HTML>
--
Parker Zhang
Microsoft Developer Support
This posting is provided "AS IS" with no warranties, and confers no rights.
