C# 使用文本框查询数据库单据信息并展示在DataGridView中 - 完整代码示例

{ "title": "C# 使用文本框查询数据库单据信息并展示在DataGridView中 - 完整代码示例", "description": "本示例演示如何使用C#开发Windows Forms应用程序，实现通过文本框输入单号，查询数据库相关单据信息并展示在DataGridView中，同时将查询过的单号添加到ListBox中，并提供从ListBox选择单号重新查询的功能。", "keywords": "C#, Windows Forms, DataGridView, ListBox, 数据库查询, 单据信息, 代码示例", "content": ""using System;\nusing System.Data;\nusing System.Data.SqlClient;\nusing System.Windows.Forms;\n\nnamespace WindowsFormsApp\n{\n public partial class Form1 : Form\n {\n private string connectionString = "your_connection_string"; // 替换为实际的数据库连接字符串\n\n public Form1()\n {\n InitializeComponent();\n }\n\n private void btnSearch_Click(object sender, EventArgs e)\n {\n string orderId = txtOrderID.Text;\n\n if (!string.IsNullOrEmpty(orderId))\n {\n // 查询数据库并展示在DataGridView中\n DataTable dt = GetOrderDetails(orderId);\n dataGridView1.DataSource = dt;\n\n // 添加单号到ListBox中\n listBox1.Items.Add(orderId);\n }\n }\n\n private DataTable GetOrderDetails(string orderId)\n {\n DataTable dt = new DataTable();\n\n using (SqlConnection connection = new SqlConnection(connectionString))\n {\n string query = "SELECT * FROM Orders WHERE OrderID = @OrderId";\n SqlCommand command = new SqlCommand(query, connection);\n command.Parameters.AddWithValue("@OrderId", orderId);\n\n SqlDataAdapter adapter = new SqlDataAdapter(command);\n adapter.Fill(dt);\n }\n\n return dt;\n }\n\n private void listBox1_SelectedIndexChanged(object sender, EventArgs e)\n {\n string selectedOrderId = listBox1.SelectedItem.ToString();\n txtOrderID.Text = selectedOrderId;\n\n // 重新查询并展示在DataGridView中\n DataTable dt = GetOrderDetails(selectedOrderId);\n dataGridView1.DataSource = dt;\n }\n }\n}\n"\n}