如何使用SQL Server中的数据库代替webforms中模型绑定中的App_Data文件夹

CREATE DATABASE mydatabase;

<add name="MyDBConnection" connectionString="Data Source=YourServerName;Initial Catalog=mydatabase;User ID=YourUsername;Password=YourPassword;" providerName="System.Data.SqlClient" />

CREATE TABLE users (
    id INT PRIMARY KEY,
    name VARCHAR(50),
    email VARCHAR(50)
);

protected void Page_Load(object sender, EventArgs e)
{
    string connectionString = ConfigurationManager.ConnectionStrings["MyDBConnection"].ConnectionString;
    using (SqlConnection connection = new SqlConnection(connectionString))
    {
        string query = "SELECT id, name, email FROM users";
        SqlCommand command = new SqlCommand(query, connection);
        connection.Open();
        SqlDataReader reader = command.ExecuteReader();
        while (reader.Read())
        {
            int id = (int)reader["id"];
            string name = (string)reader["name"];
            string email = (string)reader["email"];
            // 在页面上显示用户数据
            // ...
        }
        reader.Close();
    }
}