绑定DataGridView和SQL表
本文关键字:SQL DataGridView 绑定 | 更新日期: 2023-09-27 18:18:10
我是新手,所以我想这对你来说很容易。我正在申请WFA。我有DataGridView对我的形式,我想在DataGridView插入SQL表。下面是我的代码:
OracleCommand cmd = new OracleCommand();
OracleDataReader reader;
cmd.Connection = conn;
cmd.CommandText = "select * from rezervacija where korisnicko_ime_posetioca = '" + kip + "'";
cmd.CommandType = CommandType.Text;
reader = cmd.ExecuteReader();
while (reader.Read())
{
}
我已经打开了连接,所以这不是问题。我需要做什么,而读者正在阅读,所以我可以绑定数据?
像这样使用OracleDataAdapter
:
OracleDataAdapter yourAdapter = new OracleDataAdapter();
OracleCommand command = new OracleCommand("select * from rezervacija where korisnicko_ime_posetioca = :kip", conn);
//Add your parameters like this to avoid Sql Injection attacks
command.Parameters.AddWithValue(":kip", kip);
yourAdapter.SelectCommand = command;
DataSet yourDataSet = new DataSet("RezervacijaData");
yourAdapter.Fill(yourDataSet, "rezervacija");
//Finally do the binding
yourDataGrid.SetDataBinding(yourDataSet, "Rezervacija");
这是总体思路。我不在我的开发机器上,所以我没有测试代码,但它应该相当接近。