protected
void
BindtoDataGrid()
... {
string sql=@"";//blog.csdn.net/jbgh608
string ssql=@"";
DataSet ds = new DataSet();
DataTable tb=new DataTable();
tb=GetDataTable(sql);
tb.TableName="记录";
ds.Tables.Add(tb);
tb=null;
tb=GetDataTable(ssql);
tb.TableName="明细记录";
ds.Tables.Add(tb);
tb=null;
ds.Relations.Add("明细",ds.Tables["记录"].Columns["id"],
ds.Tables["记录"].Columns["id"]);
dataGrid1.SetDataBinding(ds,"记录");
dataGrid2.DataSource=dataGrid1.DataSource;
}
public static DataTable GetDataTable( string commandText)
... {
string connection ="server=ORADB;uid=jbgh608;pwd=jbgh608;";
OracleConnection con = new OracleConnection(connection);
OracleCommand cmd=new OracleCommand(commandText,con);
OracleDataAdapter adapter = new OracleDataAdapter(cmd);
try
...{
DataTable dt=new DataTable();
adapter.Fill(dt);
return dt;
}
catch(Exception err)
...{
throw new Exception(err.Message);
}
finally
...{
cmd.Dispose();
cmd=null;
adapter.Dispose();
adapter=null;
}
}
... {
string sql=@"";//blog.csdn.net/jbgh608
string ssql=@"";
DataSet ds = new DataSet();
DataTable tb=new DataTable();
tb=GetDataTable(sql);
tb.TableName="记录";
ds.Tables.Add(tb);
tb=null;
tb=GetDataTable(ssql);
tb.TableName="明细记录";
ds.Tables.Add(tb);
tb=null;
ds.Relations.Add("明细",ds.Tables["记录"].Columns["id"],
ds.Tables["记录"].Columns["id"]);
dataGrid1.SetDataBinding(ds,"记录");
dataGrid2.DataSource=dataGrid1.DataSource;
}
public static DataTable GetDataTable( string commandText)
... {
string connection ="server=ORADB;uid=jbgh608;pwd=jbgh608;";
OracleConnection con = new OracleConnection(connection);
OracleCommand cmd=new OracleCommand(commandText,con);
OracleDataAdapter adapter = new OracleDataAdapter(cmd);
try
...{
DataTable dt=new DataTable();
adapter.Fill(dt);
return dt;
}
catch(Exception err)
...{
throw new Exception(err.Message);
}
finally
...{
cmd.Dispose();
cmd=null;
adapter.Dispose();
adapter=null;
}
}