在数据库中用DataList的问题~在线~有源程序~~
<%@ Import Namespace="System.Data"%>
<%@ Import Namespace="System.Data.SqlClient"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<script Page_Load(Object sender,EventArgs e)
{
/*string myConnString=@"server=localhost;uid=sa;pwd= ;database=test";
SqlConnection myConnection= new SqlConnection(myConnString);
SqlDataAdapter myAdapter;
string mySelectQuery = "SELECT * from test";
DataSet myDataSet = new DataSet();
myAdapter = new SqlDataAdapter(mySelectQuery, myConnection);
myAdapter.Fill(myDataSet, "test");
DataList1.DataSource=myDataset.Tables.["test"].DefaultView;
DataLIst1.DataBind;
*/
string mySelectQuery = "SELECT * from test";
string myConnString=@"server=localhost;uid=sa;pwd= ;database=test ";
//联结
SqlConnection myConnection = new SqlConnection(myConnString);
DataSet myDataSet = new DataSet();
SqlDataAdapter myAdapter;
try
{
myAdapter = new SqlDataAdapter(mySelectQuery, myConnection);
myAdapter.Fill(myDataSet, "test");
}
catch(Exception ex)
{
return;
}
show.DataSource=myDataSet.Tables["test"].DefaultView;
show.DataBind();
</script>
</HEAD>
<BODY>
<form runat="server">
<P><asp:DataGrid id="show" runat="server"></asp:DataGrid>
/*<asp:DataList id="DataList1" runat="server"
RepeatDirection="Horizontal"
RepetCilumns="2">
<ItemTemplate>
<b><%#DataBinder.Eval(Container.DataItem,"id")%>
<Blockquote>
姓名:<%#DataBinder.Eval(Container.DataItem,"name")%>
</Blockquote>
</ItemTemplate>
</asp:DataList>
*/
</form>
</BODY>
</HTML>
为什么我调度试的时候不显示任何信息~~