初学习ASP.net数据显示不出来,请大家忙!!在线等
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Configuration;
namespace a_serving.noteSale
{
/// <summary>
/// cityList 的摘要说明。
/// </summary>
public class cityList : System.Web.UI.Page
{
public System.Web.UI.WebControls.DataGrid DataGrid1;
public void Page_Load(object sender, System.EventArgs e)
{
string strConn="server=SZTWL;database=serving;uid=sa;password=;";
SqlConnection conn=new SqlConnection(strConn);
conn.Open();
string strSql="select cityID,cityName from notecity";
DataSet objDataSet=new DataSet();
SqlDataAdapter objDataAdapter=new SqlDataAdapter(strSql,conn);
objDataAdapter.Fill(objDataSet,"notecity");
DataView objDataView=new DataView(objDataSet.Tables["notecity"]);
DataGrid1.DataSource=objDataView;
DataGrid1.DataBind();
}
}
}
静太表部分
<%@ Page language="c#" Codebehind="cityList.aspx.cs" AutoEventWireup="false" Inherits="a_serving.noteSale.cityList" debug="true" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>cityList</title>
<meta name="GENERATOR" Content="Microsoft Visual Studio 7.0">
<meta name="CODE_LANGUAGE" Content="C#">
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
</HEAD>
<body MS_POSITIONING="GridLayout">
<form runat="server">
<asp:datagrid ID="DataGrid1" runat="server" HeaderStyle-BackColor="#aaaadd" AlternatingItemStyle-BackColor="#eeeeee" AutoGenerateColumns="false" AllowSorting="true" Width="500">
<columns>
<asp:boundcolumn HeaderText="城市号" SortExpression="cityID" DataField="cityID" ReadOnly="true" />
<asp:boundcolumn HeaderText="城市" SortExpression="cityName" DataField="cityName" />
</columns>
</asp:datagrid>
</form>
</body>
</HTML>