asp.net调用数据库文件

// 示例代码：检查数据库连接
using System.Data.SqlClient;

string connectionString = "your_connection_string_here";
try
{
    using (SqlConnection connection = new SqlConnection(connectionString))
    {
        connection.Open();
        Console.WriteLine("数据库连接成功！");
    }
}
catch (Exception ex)
{
    Console.WriteLine("数据库连接失败：" + ex.Message);
}

// 示例代码：执行 SQL 查询
using System.Data.SqlClient;

string connectionString = "your_connection_string_here";
string sqlQuery = "SELECT * FROM YourTable WHERE Id = @Id";

try
{
    using (SqlConnection connection = new SqlConnection(connectionString))
    {
        SqlCommand command = new SqlCommand(sqlQuery, connection);
        command.Parameters.AddWithValue("@Id", 1);

        connection.Open();
        SqlDataReader reader = command.ExecuteReader();

        while (reader.Read())
        {
            Console.WriteLine(reader["ColumnName"].ToString());
        }
    }
}
catch (Exception ex)
{
    Console.WriteLine("SQL 查询执行错误：" + ex.Message);
}

// 示例代码：数据绑定
using System.Data;
using System.Data.SqlClient;
using System.Web.UI.WebControls;

string connectionString = "your_connection_string_here";
string sqlQuery = "SELECT * FROM YourTable";

try
{
    using (SqlConnection connection = new SqlConnection(connectionString))
    {
        SqlDataAdapter adapter = new SqlDataAdapter(sqlQuery, connection);
        DataTable dataTable = new DataTable();

        adapter.Fill(dataTable);

        GridView gridView = new GridView();
        gridView.DataSource = dataTable;
        gridView.DataBind();

        // 将 GridView 添加到页面中
        this.Controls.Add(gridView);
    }
}
catch (Exception ex)
{
    Console.WriteLine("数据绑定错误：" + ex.Message);
}