.net 查表

来源：互联网发布：淘宝开店货从哪里来编辑：程序博客网时间：2024/06/06 15:41

protected void Page_Load(object sender, EventArgs e)
        {
            string str = "Data Source=.\\SQLEXPRESS;AttachDbFilename=D:\\data\\Media.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
            SqlConnection myConnection = new SqlConnection(str);
            myConnection.Open();
            SqlCommand myCommand = new SqlCommand("select * from News where Title='安装新设备'", myConnection);
            SqlDataAdapter Adapter = new SqlDataAdapter();
            Adapter.SelectCommand = myCommand;
            DataSet myDs = new DataSet();
            Adapter.Fill(myDs);
            Response.Write("<h3>查询News表单条数据</h3>");
            Response.Write("<table border=1 cellspacing=0 cellpadding=2>");
            DataTable myTable = myDs.Tables[0];
            Response.Write("<tr bgcolor=gray>");
            foreach (DataColumn myColumn in myTable.Columns)
            {
                Response.Write("<td>" + myColumn.ColumnName + "</td>");
            }
            Response.Write("</tr>");
            foreach (DataRow myRow in myTable.Rows)
            {
                Response.Write("<tr>");
                foreach (DataColumn myColumn in myTable.Columns)
                {
                    Response.Write("<td>" + myRow[myColumn] + "</td>");
                }
                Response.Write("</tr>");
            }
            Response.Write("</table>");
            myConnection.Close();
            Response.Write("查询数据成功！");

}

0 0