winform创建数据库

// 示例代码：连接SQL Server数据库
string connectionString = "Server=your_server_address;Database=your_database_name;User Id=your_username;Password=your_password;";
using (SqlConnection connection = new SqlConnection(connectionString))
{
    try
    {
        connection.Open();
        Console.WriteLine("数据库连接成功！");
    }
    catch (Exception ex)
    {
        Console.WriteLine("数据库连接失败：" + ex.Message);
    }
}

// 示例代码：将DataTable绑定到DataGridView控件
DataTable dataTable = new DataTable();
dataTable.Columns.Add("ID", typeof(int));
dataTable.Columns.Add("Name", typeof(string));

// 添加数据
dataTable.Rows.Add(1, "张三");
dataTable.Rows.Add(2, "李四");

dataGridView1.DataSource = dataTable;

// 示例代码：执行SQL查询
string sqlQuery = "SELECT * FROM your_table_name WHERE ID = @ID";
using (SqlConnection connection = new SqlConnection(connectionString))
{
    SqlCommand command = new SqlCommand(sqlQuery, connection);
    command.Parameters.AddWithValue("@ID", 1);

    try
    {
        connection.Open();
        SqlDataReader reader = command.ExecuteReader();
        while (reader.Read())
        {
            Console.WriteLine("ID: " + reader["ID"] + ", Name: " + reader["Name"]);
        }
    }
    catch (Exception ex)
    {
        Console.WriteLine("数据库操作异常：" + ex.Message);
    }
}