运行出空白页面
protected void Page_Load(object sender, EventArgs e)
{
if(!Page .IsPostBack )
{
book bk = new book();
DataList1.DataSource = bk.mymethod("select * from mysinger");
DataList1.DataBind();
}
}
public class book
{
protected string connstring;
public book()
{
connstring = ConfigurationManager.ConnectionStrings["SingerConnectionString"].ConnectionString;
}
public DataTable mymethod(string query)
{
SqlConnection conn = new SqlConnection(connstring );
SqlDataAdapter dap = new SqlDataAdapter(query, conn);
DataSet ds = new DataSet();
dap.Fill(ds,"name");
return ds.Tables["name"];
}
}
web.config里配置为:
<connectionStrings>
<add name="SingerConnectionString" connectionString="Data Source=56b4ce34f93c4f0\sqlexpress;Initial Catalog=Singer;Persist Security Info=True;User ID=sa;Password=12345"
providerName="System.Data.SqlClient" />
</connectionStrings>
数据库,数据表都没问题,连接成功数据库,在设计里加入了datalist空间,运行后竟然是空白页面,也无错误提示,这是怎么回事啊?