17,741
社区成员
发帖
与我相关
我的任务
分享
if (ds.Tables.Count == 1)
{
//dv = new DataView();
dgv = new DataGrid();
//dv = ds.Tables[0].DefaultView;
DataGridTableStyle dgts = new DataGridTableStyle();
dgts.AllowSorting = true;
dgts.MappingName=Data.TableName;
foreach (DataColumn col in ds.Tables[0].Columns)
{
DataGridTextBoxColumn dgtbc = new DataGridTextBoxColumn();
dgtbc.MappingName=col.ColumnName;
dgtbc.NullText = "NULL";
dgts.GridColumnStyles.Add(dgtbc);
}
dgv.DataSource = ds.Tables[0];
dgv.TableStyles.Add(dgts);
if (ds.Tables.Count == 1)
{
//dv = new DataView();
dgv = new DataGrid();
//dv = ds.Tables[0].DefaultView;
DataGridTableStyle dgts = new DataGridTableStyle();
dgts.AllowSorting = true;
foreach (DataColumn col in ds.Tables[0].Columns)
{
DataGridTextBoxColumn dgtbc = new DataGridTextBoxColumn();
dgtbc.NullText = "NULL";
dgts.GridColumnStyles.Add(dgtbc);
}
dgv.TableStyles.Add(dgts);
dgv.DataSource = ds.Tables[0];
if (ds.Tables.Count == 1)
{
//dv = new DataView();
dgv = new DataGrid();
//dv = ds.Tables[0].DefaultView;
DataGridTableStyle dgts = new DataGridTableStyle();
dgts.AllowSorting = true;
foreach (DataRow row in ds.Tables[0].Columns)
{
DataGridTextBoxColumn dgtbc = new DataGridTextBoxColumn();
dgtbc.NullText = "NULL";
dgts.GridColumnStyles.Add(dgtbc);
}
dgv.TableStyles.Add(dgts);
dgv.DataSource = ds.Tables[0];
//dv.ApplyDefaultSort = true;
//dgv.DataSource = dv;
dgv.AllowNavigation = true;
dgv.Size = new Size(1000, 150);
dgv.CaptionVisible = false;
dgv.Font = new Font("Courier New", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
dgv.ReadOnly = true;
dgv.Dock = DockStyle.Fill;
dgv.BorderStyle = BorderStyle.FixedSingle;
dgv.GridLineColor = Color.WhiteSmoke;
dgv.Padding = new Padding(1);
dgv.ForeColor = Color.Black;
dgv.SelectionBackColor = Color.PowderBlue;
dgv.SelectionForeColor = Color.Black;
//dgv.CellBorderStyle = DataGridViewCellBorderStyle.Raised;
plList.Controls.Add(dgv);
//tabTable.Controls.Add(dgv);
}
if (ds.Tables.Count == 1)
{
//dv = new DataView();
dgv = new DataGrid();
//dv = ds.Tables[0].DefaultView;
DataGridTableStyle dgts = new DataGridTableStyle();
dgts.AllowSorting = true;
foreach (DataRow row in ds.Tables[0].Rows)
{
DataGridTextBoxColumn dgtbc = new DataGridTextBoxColumn();
dgtbc.NullText = "NULL";
dgts.GridColumnStyles.Add(dgtbc);
}
dgv.TableStyles.Add(dgts);
dgv.DataSource = ds.Tables[0];
//dv.ApplyDefaultSort = true;
//dgv.DataSource = dv;
dgv.AllowNavigation = true;
dgv.Size = new Size(1000, 150);
dgv.CaptionVisible = false;
dgv.Font = new Font("Courier New", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
dgv.ReadOnly = true;
dgv.Dock = DockStyle.Fill;
dgv.BorderStyle = BorderStyle.FixedSingle;
dgv.GridLineColor = Color.WhiteSmoke;
dgv.Padding = new Padding(1);
dgv.ForeColor = Color.Black;
dgv.SelectionBackColor = Color.PowderBlue;
dgv.SelectionForeColor = Color.Black;
//dgv.CellBorderStyle = DataGridViewCellBorderStyle.Raised;
plList.Controls.Add(dgv);
//tabTable.Controls.Add(dgv);
}
if (ds.Tables.Count == 1)
{
//dv = new DataView();
dgv = new DataGrid();
//dv = ds.Tables[0].DefaultView;
DataGridTableStyle dgts = new DataGridTableStyle();
foreach (DataRow row in ds.Tables[0].Rows)
{
DataGridTextBoxColumn dgtbc = new DataGridTextBoxColumn();
dgtbc.NullText = "NULL";
dgts.GridColumnStyles.Clear();
dgts.AllowSorting = true;
dgts.GridColumnStyles.Add(dgtbc);
}
dgv.TableStyles.Add(dgts);
dgv.DataSource = ds.Tables[0];
//dv.ApplyDefaultSort = true;
//dgv.DataSource = dv;
dgv.AllowNavigation = true;
dgv.Size = new Size(1000, 150);
dgv.CaptionVisible = false;
dgv.Font = new Font("Courier New", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
dgv.ReadOnly = true;
dgv.Dock = DockStyle.Fill;
dgv.BorderStyle = BorderStyle.FixedSingle;
dgv.GridLineColor = Color.WhiteSmoke;
dgv.Padding = new Padding(1);
dgv.ForeColor = Color.Black;
dgv.SelectionBackColor = Color.PowderBlue;
dgv.SelectionForeColor = Color.Black;
//dgv.CellBorderStyle = DataGridViewCellBorderStyle.Raised;
plList.Controls.Add(dgv);
//tabTable.Controls.Add(dgv);
}