查询数据

查询数据1

*.aspx.cs

//查询数据
            String strConn = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\guest.mdf;Integrated Security=True";

            using (SqlConnection con = new SqlConnection(strConn))
            {
                SqlCommand com = con.CreateCommand();

                com.CommandText = "SELECT G_UserName FROM G_User";
                con.Open();
                SqlDataReader sdr = com.ExecuteReader();
                while (sdr.Read())
                {
                    Context.Response.Write(sdr[0] + "<br/>");
                }

            }