c# oracle datagridview 查找,C# DataGridView怎么显示数据

1、实现一个用于处理数据库数据检索的详细信息的方法。下面的代码示例实现一个 GetData 方法，该方法对一个 SqlDataAdapter 组件进行初始化，并使用该组件填充 DataTable。然后，将 DataTable 绑定到 BindingSource 组件。请确保将 connectionString 变量的值设置为与数据库相应的值。

private void GetData(string selectCommand)

{

try

{

String connectionString =

"Integrated Security=SSPI;Persist Security Info=False;" +

"Initial Catalog=Northwind;Data Source=localhost";

dataAdapter = new SqlDataAdapter(selectCommand, connectionString);

SqlCommandBuilder commandBuilder = new SqlCommandBuilder(dataAdapter);

//Oracle DataSet 操作

/*

connectionString

*/

DataTable table = new DataTable();

table.Locale = System.Globalization.CultureInfo.InvariantCulture;

dataAdapter.Fill(table);

bindingSource1.DataSource = table;

//dataGridView1.AutoResizeColumns(

// DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader);

}

catch (SqlException)

{

MessageBox.Show("To run this example, replace the value of the " +

"connectionString variable with a connection string that is " +

"valid for your system.");

}

}

2、在窗体的 Load 事件处理程序中，将 DataGridView 控件绑定到 BindingSource 组件，并调用 GetData 方法从数据库中检索数据

private void Form1_Load(object sender, System.EventArgs e)

{

dataGridView1.DataSource = bindingSource1;

GetData("select * from Customers");

}