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;
}
}