asp.net连接sqlserver

string ConnectString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True";
        SqlConnection conn = new SqlConnection(ConnectString);
        try
        {
            conn.Open();
            Label1.Text = "<b>Server Version:</b>" + conn.ServerVersion;
            Label1.Text += "<br/><b>Connection is:</b>" + conn.State.ToString();

            string sql = "SELECT * FROM UserLogin";
            SqlCommand cmd = new SqlCommand(sql,conn);
            SqlDataReader reader = cmd.ExecuteReader ();
            string strResult=" " ;

            while(reader.Read ())
            {
                strResult += reader.GetInt32(0).ToString() + reader.GetString(1) +reader.GetString(2) + "<br/>" ;
               
            }
            Response.Write(strResult);
            reader.Close();

        }
        catch (Exception err)
        {
            Response.Write("Error reading the database:" + err.Message);
        }
        finally {
            conn.Close();
        }

posted on 2013-03-09 21:46  AI_JJ  阅读(178)  评论(0)    收藏  举报

导航