asp.net连接sqlserver

最新推荐文章于 2024-02-28 15:54:49 发布

原创最新推荐文章于 2024-02-28 15:54:49 发布 · 833 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#sqlserver #asp.net #string #exception #security #database

本文介绍了一个使用C#连接SQL Server数据库并读取数据的示例代码。通过SqlConnection建立连接，并利用SqlCommand和SqlDataReader执行SQL查询，获取UserLogin表中的所有记录。

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 = "Server Version:" + conn.ServerVersion;
 Label1.Text += " Connection is:" + 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) + " " ;

 }
 Response.Write(strResult);
 reader.Close();

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