Question

那位大师帮我写一个ASP.NET的连接数据库并查询数据的显示的页面?

Answer 1

private string strCon="SERVER=.;DATABASE=DATABASENANE;UID=;PWD=;";
public DataSet SelectStudentMessage()
{
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand();
da.SelectCommand.Connection = new SqlConnection(strCon);
da.SelectCommand.CommandType = CommandType.Text;
da.SelectCommand.CommandText = "select * from Grade";

da.SelectCommand.Connection.Open();

DataSet ds = new DataSet();

da.Fill(ds);

da.SelectCommand.Connection.Close();
return ds;

}
在页面直接将数据源绑定到datalist\dataview中就可以了

Answer 2

private string strcon="server=.;database=databasename;uid=sa;pwd=;";
然后在page_load事件中写：
sqlConnection con=new sqlConnection(strcon);
con.open();
sqlCommand cmd=new sqlCommand("select * from 表名",con);
this.GridView1.datasource=cmd.ExecuteReader();
this.GridView1.DataBinder();
cmd.dispose();
con.close();