private void showData() //作用是将gridview中的数据行绑定到上面的输入框里显示
{
conn = new OracleConnection(ConnectionString);
string tname = "";
try
{
if (conn == null) conn.Open();
DataAdapter = new OracleDataAdapter("SELECT record_no,MoveBound_No,tool_no,toolName,TotalNum,TotalWeight,Source_CK_no,Source_Stock,Desk_CK_no,Dest_Stock,Oper_Time,Operator,Insert_Time,Other From T_BJ_MoveBound order by record_no", conn);
DataSet dataset = new DataSet();
DataAdapter.Fill(dataset);
dataGridView2.DataSource = dataset;
dataGridView2.DataMember = dataset.Tables[0].ToString();
tname = dataset.Tables[0].ToString();
//控件绑定清除,然后再将控件的内容添加绑定到dataset
MoveBound_No.DataBindings.Clear();
tool_no.DataBindings.Clear();
toolName.DataBindings.Clear();
TotalNum.DataBindings.Clear();
TotalWeight.DataBindings.Clear();
Source_CK_no.DataBindings.Clear();
Source_Stock.DataBindings.Clear();
Desk_CK_no.DataBindings.Clear();
Dest_Stock.DataBindings.Clear();
Oper_Time.DataBindings.Clear();
Operator.DataBindings.Clear();
Other.DataBindings.Clear();
MoveBound_No.DataBindings.Add("Text", dataset, "table.MoveBound_No");
tool_no.DataBindings.Add("Text", dataset, "table.tool_no");
Source_CK_no.DataBindings.Add("Text", dataset, "table.Source_CK_no");
Source_Stock.DataBindings.Add("Text", dataset, "table.Source_Stock");
Desk_CK_no.DataBindings.Add("Text", dataset, "table.Desk_CK_no");
Dest_Stock.DataBindings.Add("Text", dataset, "table.Dest_Stock");
Oper_Time.DataBindings.Add("Text", dataset, "table.Oper_Time");
Operator.DataBindings.Add("Text", dataset, "table.Operator");
Other.DataBindings.Add("Text", dataset, "table.Other");
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
conn.Close();
dataset.Dispose();
}
}
{
conn = new OracleConnection(ConnectionString);
string tname = "";
try
{
if (conn == null) conn.Open();
DataAdapter = new OracleDataAdapter("SELECT record_no,MoveBound_No,tool_no,toolName,TotalNum,TotalWeight,Source_CK_no,Source_Stock,Desk_CK_no,Dest_Stock,Oper_Time,Operator,Insert_Time,Other From T_BJ_MoveBound order by record_no", conn);
DataSet dataset = new DataSet();
DataAdapter.Fill(dataset);
dataGridView2.DataSource = dataset;
dataGridView2.DataMember = dataset.Tables[0].ToString();
tname = dataset.Tables[0].ToString();
//控件绑定清除,然后再将控件的内容添加绑定到dataset
MoveBound_No.DataBindings.Clear();
tool_no.DataBindings.Clear();
toolName.DataBindings.Clear();
TotalNum.DataBindings.Clear();
TotalWeight.DataBindings.Clear();
Source_CK_no.DataBindings.Clear();
Source_Stock.DataBindings.Clear();
Desk_CK_no.DataBindings.Clear();
Dest_Stock.DataBindings.Clear();
Oper_Time.DataBindings.Clear();
Operator.DataBindings.Clear();
Other.DataBindings.Clear();
MoveBound_No.DataBindings.Add("Text", dataset, "table.MoveBound_No");
tool_no.DataBindings.Add("Text", dataset, "table.tool_no");
Source_CK_no.DataBindings.Add("Text", dataset, "table.Source_CK_no");
Source_Stock.DataBindings.Add("Text", dataset, "table.Source_Stock");
Desk_CK_no.DataBindings.Add("Text", dataset, "table.Desk_CK_no");
Dest_Stock.DataBindings.Add("Text", dataset, "table.Dest_Stock");
Oper_Time.DataBindings.Add("Text", dataset, "table.Oper_Time");
Operator.DataBindings.Add("Text", dataset, "table.Operator");
Other.DataBindings.Add("Text", dataset, "table.Other");
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
conn.Close();
dataset.Dispose();
}
}