void BindToDgv(INewsBase news, int typeID, int pageIndex = 1)
{
dgv.Rows.Clear();
if (news != null)
{
var newsList = news.GetNewsList(typeID, pageIndex);
if (newsList == null || newsList.Count <= 0) return;
foreach (var item in newsList)
{
int index = dgv.Rows.Add();
DataGridViewTextBoxCell cell = new DataGridViewTextBoxCell();
cell.Value = item.ID;
dgv.Rows[index].Cells["ID"] = cell;
cell = new DataGridViewTextBoxCell();
cell.Value = item.Title;
dgv.Rows[index].Cells["Title"] = cell;
cell = new DataGridViewTextBoxCell();
cell.Value = item.Source;
dgv.Rows[index].Cells["Source"] = cell;
DataGridViewButtonCell cellb = new DataGridViewButtonCell();
cellb.Value = item.IsGetted ? "تامام" : "يىغىش";
dgv.Rows[index].Cells["Make"] = cellb;
dgv.Rows[index].Tag = item;
if (item.IsGetted)
{
dgv.Rows[index].DefaultCellStyle = new DataGridViewCellStyle() { ForeColor = Color.Gray };
}
}
}
}
private void btnAddProduct_Click(object sender, EventArgs e)
{
var af = new AddProductForm();
if (af.ShowDialog() == DialogResult.OK)
{
Product prod=af.Product;
DataGridViewCell cel0 = new DataGridViewTextBoxCell();
cel0.Value = prod.Name;
DataGridViewCell cel1 = new DataGridViewTextBoxCell();
cel1.Value = prod.AlbumName;
DataGridViewCell cel2 = new DataGridViewTextBoxCell();
cel2.Value = prod.Photos.Count;
DataGridViewRow row = new DataGridViewRow();
row.Cells.AddRange(cel0, cel1, cel2);
grid.Rows.Add(row);
Products.Add(prod);
btnStart.Enabled = true;
}
}
public TableForm(string name, IDataReader rdr)
{
DataGridView dgv = new DataGridView();
dgv.Dock = DockStyle.Fill;
DataGridViewTextBoxCell template = new DataGridViewTextBoxCell();
template.Style.Font = new Font("DejaVu Sans",10);
for (int i = 0;i < rdr.FieldCount;i++)
{
DataGridViewColumn col = new DataGridViewColumn(template);
col.Name = rdr.GetName(i);
dgv.Columns.Add(col);
}
while (rdr.Read())
{
DataGridViewRow row = new DataGridViewRow();
row.CreateCells(dgv);
for (int i = 0;i < rdr.FieldCount;i++)
{
object val = rdr[i];
if (val is byte[])
{
val = Encoding.UTF8.GetString((byte[])val);
}
row.Cells[i].Value = val;
}
dgv.Rows.Add(row);
}
Controls.Add(dgv);
}
public void InitialDataGridView()
{
dataGridView.Rows.Clear();
dataGridView.Columns.Clear();
DataGridViewCell textCell = new DataGridViewTextBoxCell();
DataGridViewColumn timeColumn = new DataGridViewColumn();
timeColumn.HeaderText = "记录时间";
timeColumn.Width = 160;
timeColumn.CellTemplate = textCell;
DataGridViewColumn ipColumn = new DataGridViewColumn();
ipColumn.HeaderText = "IP地址";
ipColumn.Width = 120;
ipColumn.CellTemplate = textCell;
DataGridViewColumn portColumn = new DataGridViewColumn();
portColumn.HeaderText = "端口号";
portColumn.Width = 80;
portColumn.CellTemplate = textCell;
DataGridViewColumn statusColumn = new DataGridViewColumn();
statusColumn.HeaderText = "工作状态";
statusColumn.Width = 180;
statusColumn.CellTemplate = textCell;
dataGridView.Columns.Add(timeColumn);
dataGridView.Columns.Add(ipColumn);
dataGridView.Columns.Add(portColumn);
dataGridView.Columns.Add(statusColumn);
}
public void CargarTabla()
{
// Format DataGridView
this.dataGridView1.AllowUserToAddRows = false;
this.dataGridView1.BackgroundColor = this.BackColor;
this.dataGridView1.RowHeadersWidth = 75;
String [] Semana = {"Lunes",
"Martes",
"Miercoles",
"Jueves",
"Viernes",
"Sabado"
};
// Add columns to DataGridView
foreach (String item in Semana)
{
DataGridViewCheckBoxColumn checkColumn = new DataGridViewCheckBoxColumn();
checkColumn.Name = "Columna_" + item;
checkColumn.HeaderText = item;
checkColumn.Width = 75;
checkColumn.ReadOnly = true;
checkColumn.FillWeight = 10; //if the datagridview is resized (on form resize) the checkbox won't take up too much; value is relative to the other columns' fill values
dataGridView1.Columns.Add(checkColumn);
}
// Add rows to DataGridView
for (int i = 7; i <= 32; i++)
{
TimeSpan t = TimeSpan.FromSeconds(25200 + ((i - 7)* 1800));
dataGridView1.Rows.Add();
dataGridView1.Rows[i - 7].HeaderCell.Value = t.ToString().Substring(0, 5) ;
}
// Sabados no se trabaja hasta las 10
for (int i = 0; i < 6; i++)
{
DataGridViewTextBoxCell TextBoxCell = new DataGridViewTextBoxCell();
dataGridView1[5, i] = TextBoxCell;
dataGridView1[5, i].Value = "";
dataGridView1[5, i].Style.BackColor = Color.Black;
dataGridView1[5, i].ReadOnly = true;
}
// Sabados no se trabaja desde las 5
for (int i = 16; i <= 25; i++)
{
DataGridViewTextBoxCell TextBoxCell = new DataGridViewTextBoxCell();
dataGridView1[5, i] = TextBoxCell;
dataGridView1[5, i].Value = "";
dataGridView1[5, i].Style.BackColor = Color.Black;
dataGridView1[5, i].ReadOnly = true;
}
}
private void InitGrid(RedComboBox[] comboboxes, RedContext context)
{
foreach(RedComboBox cb in comboboxes)
{
var row = new DataGridViewRow();
var c1 = new DataGridViewTextBoxCell();
c1.Value = cb.Name;
DataGridViewCell c2;
if (cb.query.ToLowerInvariant() == "textedit")
{
c2 = new DataGridViewTextBoxCell();
c2.Value = "";
}
else
{
c2 = new DataGridViewComboBoxCell();
var t = cb.GetValues(context);
foreach (DataRow r in t.Rows)
{
(c2 as DataGridViewComboBoxCell).Items.Add(r[0].ToString());
}
(c2 as DataGridViewComboBoxCell).Value = (c2 as DataGridViewComboBoxCell).Items[0];
}
c2.ReadOnly = false;
row.Cells.Add(c1);
row.Cells.Add(c2);
dataGridView1.Rows.Add(row);
}
}
/// <summary>
/// Recursively goes through all files in the directory
/// and adds them to the MyFilesDB
/// </summary>
/// <param name="directory">Current Directory To Search</param>
private void addDirectory(String directory)
{
try
{
foreach (String file in Directory.GetFiles(directory))
{
myFilesDb.AddFile(file);
DataGridViewRow row = new DataGridViewRow();
DataGridViewTextBoxCell cell = new DataGridViewTextBoxCell();
cell.Value = "Hashed: " + file;
row.Cells.Add(cell);
if (isShown && !gvLog.IsDisposed && !this.IsDisposed)
{
try
{
this.Invoke(new MethodInvoker(
delegate()
{
gvLog.Rows.Insert(0, row);
}));
}
catch { isShown = false; }
}
}
}
catch { }
foreach (String nextDir in Directory.GetDirectories(directory))
{
addDirectory(nextDir);
}
}
public void DisplayConfigs()
{
ConfigList.Rows.Clear();
foreach (ConfigSet config in Configs)
{
DataGridViewRow row = new DataGridViewRow();
DataGridViewCell cell = new DataGridViewTextBoxCell();
if (config.DefaultConfig)
cell.Value = @"✔";
else
cell.Value = "";
row.Cells.Add(cell);
cell = new DataGridViewTextBoxCell();
cell.Value = config.Name;
row.Cells.Add(cell);
cell = new DataGridViewTextBoxCell();
cell.Value = config.BitSize.ToString();
row.Cells.Add(cell);
cell = new DataGridViewTextBoxCell();
cell.Value = config.ConfigPath;
row.Cells.Add(cell);
ConfigList.Rows.Add(row);
}
}
public void updateGrid()
{
dataGridView1.Rows.Clear();
dataGridView1.Columns.Clear();
//style for classroom name
DataGridViewCell cellStyle = new DataGridViewTextBoxCell();
cellStyle.Style.BackColor = Color.Wheat;
DataGridViewButtonColumn deleteButtonColumn = new DataGridViewButtonColumn();
deleteButtonColumn.Text = "Delete Classroom";
deleteButtonColumn.UseColumnTextForButtonValue = true;
DataGridViewButtonColumn updateButtonColumn = new DataGridViewButtonColumn();
updateButtonColumn.Text = "Update Classroom";
updateButtonColumn.UseColumnTextForButtonValue = true;
DataGridViewButtonColumn manageComputersButtonColumn = new DataGridViewButtonColumn();
manageComputersButtonColumn.Text = "Manage computers";
manageComputersButtonColumn.UseColumnTextForButtonValue = true;
dataGridView1.Columns.Add(new DataGridViewColumn(cellStyle));
dataGridView1.Columns.Add(new DataGridViewCheckBoxColumn());
dataGridView1.Columns.Add(updateButtonColumn);
dataGridView1.Columns.Add(manageComputersButtonColumn);
dataGridView1.Columns.Add(deleteButtonColumn);
foreach (Classroom classroom in MainProgram.rooms)
dataGridView1.Rows.Add(classroom.Classroomname,classroom.Projectoravailable);
}
private void ClientLogWin_Load(object sender, EventArgs e)
{
foreach (string msg in _log)
{
string[] p = msg.Split('|');
DataGridViewRow row = new DataGridViewRow();
if (p.Length == 1)
{
DataGridViewCell cell = new DataGridViewImageCell();
cell.Value = iconList.Images[0];
row.Cells.Add(cell);
cell = new DataGridViewTextBoxCell();
cell.Value = DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString();
row.Cells.Add(cell);
cell = new DataGridViewTextBoxCell();
cell.Value = p[0];
row.Cells.Add(cell);
}
else
{
DataGridViewCell cell = new DataGridViewImageCell();
cell.Value = iconList.Images[Convert.ToInt32(p[0])];
row.Cells.Add(cell);
cell = new DataGridViewTextBoxCell();
cell.Value = p[1];
row.Cells.Add(cell);
cell = new DataGridViewTextBoxCell();
cell.Value = p[2];
row.Cells.Add(cell);
}
row.Height = 17;
messageList.Rows.Add(row);
messageList.FirstDisplayedScrollingRowIndex = messageList.Rows.Count - 1;
}
}
/// <summary>
/// �\���Ώۂ̍s���ݒ肷��D
/// </summary>
/// <param name="m"></param>
public void SetMatrix(KrdLab.Lisys.Matrix m)
{
this.DataGridView.Rows.Clear();
this.DataGridView.Columns.Clear();
if (m == null)
{
return;
}
for (int c = 0; c < m.ColumnSize; ++c)
{
var gridCol = new DataGridViewColumn();
gridCol.HeaderText = String.Format("[ , {0}]", c);
gridCol.ReadOnly = true;
gridCol.SortMode = DataGridViewColumnSortMode.NotSortable;
this.DataGridView.Columns.Add(gridCol);
}
for (int r = 0; r < m.RowSize; ++r)
{
var gridRow = new DataGridViewRow();
gridRow.HeaderCell.Value = String.Format("[{0}, ]", r);
gridRow.ReadOnly = true;
var row = m.Rows[r];
foreach (var v in row)
{
var cell = new DataGridViewTextBoxCell();
cell.Value = v.ToString();
gridRow.Cells.Add(cell);
}
this.DataGridView.Rows.Add(gridRow);
}
this.DataGridView.RowHeadersWidth = 100;
}
public void filldatagrid()
{
computersDataGrid.Rows.Clear();
computersDataGrid.Columns.Clear();
DataGridViewCell cellStyle = new DataGridViewTextBoxCell();
cellStyle.Style.BackColor = Color.Wheat;
DataGridViewButtonColumn deleteButtonColumn = new DataGridViewButtonColumn();
deleteButtonColumn.Text = "Delete Computer";
deleteButtonColumn.UseColumnTextForButtonValue = true;
DataGridViewButtonColumn updateButtonColumn = new DataGridViewButtonColumn();
updateButtonColumn.Text = "Update Computer";
updateButtonColumn.UseColumnTextForButtonValue = true;
DataGridViewButtonColumn viewComputerButtonColumn = new DataGridViewButtonColumn();
viewComputerButtonColumn.Text = "View computer details";
viewComputerButtonColumn.UseColumnTextForButtonValue = true;
DataGridViewButtonColumn moveComputerButtonColumn = new DataGridViewButtonColumn();
moveComputerButtonColumn.Text = "Move computer";
moveComputerButtonColumn.UseColumnTextForButtonValue = true;
computersDataGrid.Columns.Add(new DataGridViewColumn(cellStyle));
computersDataGrid.Columns.Add(updateButtonColumn);
computersDataGrid.Columns.Add(deleteButtonColumn);
computersDataGrid.Columns.Add(viewComputerButtonColumn);
computersDataGrid.Columns.Add(moveComputerButtonColumn);
foreach (Computer comp in classroom.Computersinclassroom)
computersDataGrid.Rows.Add(comp.Computername);
}
void AddToList(CGoodsData pCGoodsData)
{
DataGridViewRow r1 = new DataGridViewRow();
// 상품 시퀀스
DataGridViewTextBoxCell cell_seq = new DataGridViewTextBoxCell();
cell_seq.Value = pCGoodsData.Seq_;
r1.Cells.Add(cell_seq);
// 상품명
DataGridViewTextBoxCell cell_GoodsName = new DataGridViewTextBoxCell();
cell_GoodsName.Value = pCGoodsData.GoodsName_;
r1.Cells.Add(cell_GoodsName);
// 옵션명
DataGridViewTextBoxCell cell_OptionName = new DataGridViewTextBoxCell();
cell_OptionName.Value = pCGoodsData.OptionName_;
r1.Cells.Add(cell_OptionName);
// 채널
DataGridViewTextBoxCell cell_Channel = new DataGridViewTextBoxCell();
cell_Channel.Value = pCGoodsData.ChannelName_;
r1.Cells.Add(cell_Channel);
dataGridView_GoodsList.Rows.Add(r1);
}
public void AddFilesToView(string group)
{
Package p = packages._packages.Find(Package => Package._name == group);
this.form.dataGridView1.BeginInvoke((MethodInvoker)delegate()
{
foreach (Item i in p._items)
{
DataGridViewCellStyle style = new DataGridViewCellStyle();
style.Alignment = DataGridViewContentAlignment.MiddleCenter;
DataGridViewRow row = new DataGridViewRow();
DataGridViewTextBoxCell filename = new DataGridViewTextBoxCell();
filename.Value = i._file;
row.Cells.Add(filename);
DataGridViewTextBoxCell status = new DataGridViewTextBoxCell();
status.Value = "Unknown";
status.Style = style;
row.Cells.Add(status);
DataGridViewProgressCell download = new DataGridViewProgressCell();
download.Value = 0;
row.Cells.Add(download);
i.row = row;
this.form.dataGridView1.Rows.Add(row);
}
});
}
private void AddTimestampColumns()
{
DataGridViewCell cell = new DataGridViewTextBoxCell();
DataGridViewColumn column = new DataGridViewColumn();
column.HeaderText = "Total Hours";
column.Name = "TotalHours";
column.CellTemplate = cell;
column.ReadOnly = true;
this.gridTimestamps.Columns.Add( column );
cell = new DataGridViewTextBoxCell();
column = new DataGridViewColumn();
column.HeaderText = "Hourly Rate";
column.Name = "HourlyRate";
column.CellTemplate = cell;
column.ReadOnly = true;
this.gridTimestamps.Columns.Add( column );
cell = new DataGridViewTextBoxCell();
column = new DataGridViewColumn();
column.HeaderText = "Amount";
column.Name = "Amount";
column.CellTemplate = cell;
column.ReadOnly = true;
this.gridTimestamps.Columns.Add( column );
}
public ResultTable(DataGridView dataView, string[] names) // constructor. Uses array of names for column/row header labels
{
m_dataView = dataView;
m_results = new Result[m_numberOfSequences, m_numberOfSequences];
for (int i = 0; i < m_numberOfSequences; ++i)
{
DataGridViewTextBoxColumn column = new DataGridViewTextBoxColumn();
column.HeaderText = "seq" + (i+1);
column.MaxInputLength = 8;
column.Width = 50;
DataGridViewCell cell = new DataGridViewTextBoxCell();
column.CellTemplate = cell;
m_dataView.Columns.Add(column);
}
for (int j = 0; j < m_numberOfSequences; ++j)
{
DataGridViewRow row = new DataGridViewRow(); // how can I remove the dumb current cell pointer that makes the header cells so big/obfuscates the header text?
row.HeaderCell.Value = "seq"+(j+1);
row.Height = 20;
for (int i = 0; i < m_numberOfSequences; ++i)
{
DataGridViewCell cell = new DataGridViewTextBoxCell();
row.Cells.Add(cell);
}
dataView.RowHeadersWidthSizeMode=DataGridViewRowHeadersWidthSizeMode.AutoSizeToAllHeaders;
m_dataView.Rows.Add(row);
}
dataView.CurrentCell = null;
}
private void SCCInfoFormLoad(object sender, EventArgs e)
{
byte DEFAULT_ALPHA = 255;
for (int i = 0; i < SCCInfo.StrongConnectedComponent.StrongConnectedComponentCount; ++i)
{
DataGridViewRow tableRow = new DataGridViewRow();
DataGridViewTextBoxCell numCell = new DataGridViewTextBoxCell();
numCell.Value = (i + 1).ToString();
DataGridViewTextBoxCell color = new DataGridViewTextBoxCell();
color.Style.BackColor = System.Drawing.Color.FromArgb
(DEFAULT_ALPHA, SCCInfo.VertexColors[i].R, SCCInfo.VertexColors[i].G, SCCInfo.VertexColors[i].B);
DataGridViewTextBoxCell vertices = new DataGridViewTextBoxCell();
for (int j = 0; j < SCCInfo.StrongConnectedComponent.GetStrongConnegtionComponentVerticesCount(i) - 1; ++j)
vertices.Value += (SCCInfo.StrongConnectedComponent.GetVertex(i, j) + 1).ToString() + ", ";
vertices.Value += (SCCInfo.StrongConnectedComponent.GetVertex(i, SCCInfo.StrongConnectedComponent.GetStrongConnegtionComponentVerticesCount(i) - 1) + 1).ToString();
tableRow.Cells.Add(numCell);
tableRow.Cells.Add(color);
tableRow.Cells.Add(vertices);
SCCTable.Rows.Add(tableRow);
}
}
public static void data_grid(DataGridView dgv_grid)
{
dgv_grid.AutoGenerateColumns = true;
DataGridViewCell Cell_1 = new DataGridViewTextBoxCell();
DataGridViewCell Cell_2 = new DataGridViewTextBoxCell();
DataGridViewCell Cell_3 = new DataGridViewTextBoxCell();
DataGridViewColumn col__from = new DataGridViewColumn();
DataGridViewColumn col__to = new DataGridViewColumn();
DataGridViewColumn col__length = new DataGridViewColumn();
col__from.HeaderText = "Откуда";
col__to.HeaderText = "Куда";
col__length.HeaderText = "Длина";
col__from.Width = 110;
col__to.Width = 110;
col__length.Width = 110;
col__from.CellTemplate = Cell_1;
col__to.CellTemplate = Cell_2;
col__length.CellTemplate = Cell_3;
dgv_grid.ReadOnly = false;
dgv_grid.AllowUserToAddRows = true;
dgv_grid.AllowUserToDeleteRows = true;
dgv_grid.Columns.Add(col__from);
dgv_grid.Columns.Add(col__to);
dgv_grid.Columns.Add(col__length);
}
public ResultTable(DataGridView dataView, int numberOfSequences)
{
m_dataView = dataView;
m_numberOfSequences = numberOfSequences;
m_results = new double[m_numberOfSequences, m_numberOfSequences];
for (int i = 0; i < m_numberOfSequences; ++i)
{
DataGridViewTextBoxColumn column = new DataGridViewTextBoxColumn();
column.MaxInputLength = 8;
column.Width = 50;
DataGridViewCell cell = new DataGridViewTextBoxCell();
column.CellTemplate = cell;
m_dataView.Columns.Add(column);
}
for (int j = 0; j < m_numberOfSequences; ++j)
{
DataGridViewRow row = new DataGridViewRow();
row.Height = 20;
for (int i = 0; i < m_numberOfSequences; ++i)
{
DataGridViewCell cell = new DataGridViewTextBoxCell();
//cell.Value = ((double)i);
//cell.Value = "asdas";
row.Cells.Add(cell);
}
m_dataView.Rows.Add(row);
}
}
private void bindGrid()
{
this.countriesDataGrid.AutoGenerateColumns = false;
//create the column programatically
DataGridViewCell cell = new DataGridViewTextBoxCell();
DataGridViewTextBoxColumn colCountry = new DataGridViewTextBoxColumn()
{
CellTemplate = cell,
Name = "Name",
HeaderText = "Country Name",
DataPropertyName = "Name" // Tell the column which property of FileName it should use
};
countriesDataGrid.Columns.Add(colCountry);
DataGridViewTextBoxColumn colCode = new DataGridViewTextBoxColumn()
{
CellTemplate = cell,
Name = "Code",
HeaderText = "Country Code",
DataPropertyName = "Code" // Tell the column which property of FileName it should use
};
countriesDataGrid.Columns.Add(colCode);
var list = p.countries.ToList();
var filenamesList = new BindingList<Country>(list); // <-- BindingList
//Bind BindingList directly to the DataGrid, no need of BindingSource
countriesDataGrid.DataSource = filenamesList;
}
private void button1_Click(object sender, EventArgs e)
{
Win32Assembly assembly = ((AssemblyReference)treeView1.SelectedNode.Tag).assembly;
if (assembly != null)
{
List<DataGridViewColumn> columns = new List<DataGridViewColumn>();
DataGridViewTextBoxColumn column = new DataGridViewTextBoxColumn();
column.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
column.HeaderText = "Name";
columns.Add(column);
column = new DataGridViewTextBoxColumn();
column.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
column.HeaderText = "RVA";
columns.Add(column);
List<DataGridViewRow> rows = new List<DataGridViewRow>();
foreach (ExportMethod meth in assembly.LibraryExports)
{
DataGridViewRow row = new DataGridViewRow();
DataGridViewTextBoxCell cell = new DataGridViewTextBoxCell();
cell.Value = meth.Name;
row.Cells.Add(cell);
cell = new DataGridViewTextBoxCell();
cell.Value = "0x" + ((long)meth.RVA).ToString("x8").ToUpper();
row.Cells.Add(cell);
rows.Add(row);
}
ListDlg dlg = new ListDlg(columns.ToArray(), rows.ToArray(), "Exports of " + Path.GetFileName(assembly.Path), false);
dlg.Show();
}
}
private void AddItems(string[] panels, int sections)
{
foreach (string panel in panels)
{
DataGridViewComboBoxCell reff = new DataGridViewComboBoxCell();
DataGridViewTextBoxCell txt2A = new DataGridViewTextBoxCell();
DataGridViewRow dataGridRow = new DataGridViewRow();
//ComboBox reff = new ComboBox();
reff.MaxDropDownItems = sections;
//reff.DataSource =
txt2A.Value = panel;
for (int i = 1; i <= sections; i++)
reff.Items.Add(i);
try
{
dataGridRow.Cells.Add(txt2A);
dataGridRow.Cells.Add(reff);
Grid.Rows.Add(dataGridRow);
}
catch (Exception e)
{
MessageBox.Show(e.Message, "Error");
}
}
}
public void LoadProperties(xTile.ObjectModel.Component component)
{
m_dataGridView.Rows.Clear();
m_newProperties.Clear();
foreach (KeyValuePair<string, PropertyValue> keyValuePair
in component.Properties)
{
m_newProperties.Add(keyValuePair.Key, keyValuePair.Value);
DataGridViewRow row = new DataGridViewRow();
DataGridViewTextBoxCell nameCell = new DataGridViewTextBoxCell();
nameCell.Value = keyValuePair.Key;
DataGridViewTextBoxCell valueCell = new DataGridViewTextBoxCell();
valueCell.Value = keyValuePair.Value.ToString();
if (keyValuePair.Value.Type == typeof(float)
|| keyValuePair.Value.Type == typeof(int))
valueCell.Style.Alignment = DataGridViewContentAlignment.MiddleRight;
row.Cells.Add(nameCell);
row.Cells.Add(valueCell);
m_dataGridView.Rows.Add(row);
}
}
public override void LoadDetail()
{
lblTableName.Text = "";
//lblTableDBDesc.Text = "";//db_desc
//lblTableLocalDesc.Text = "";//local_desc
txtTableNewDesc.Text = "";//new_desc
dgvSchema.Rows.Clear();
this.node = App.Instance.SelectedNode;
this.view = App.Instance.SelectedNode.Tag as IViewInfo;
if (this.view != null)
{
lblTableName.Text = this.view.RawName;
//lblTableDBDesc.Text = this.view.Description;//db_desc
//lblTableLocalDesc.Text = this.view.Attributes.ContainsKey("local_desc") ? this.view.Attributes["local_desc"] : "";//local_desc
//txtTableNewDesc.Text = this.view.Attributes.ContainsKey("new_desc") ? this.view.Attributes["new_desc"] : "";//new_desc
txtTableNewDesc.Text = this.view["local_desc"] ?? "";//local_desc
//foreach (var item in this.view.Columns)
//{
// int index = dgvSchema.Rows.Add();
// DataGridViewRow row = dgvSchema.Rows[index];
// //row.Tag = item.IsPrimaryKey;
// row.Cells[0].Value = item.RawName;
// row.Cells[1].Value = SQLHelper.GetFullSqlType(item);
// row.Cells[2].Value = item.Nullable ? true : false;
// //row.Cells[3].Value = item.Description;
// //row.Cells[4].Value = item.Attributes.ContainsKey("local_desc") ? item.Attributes["local_desc"] : "";
// //row.Cells[5].Value = item.Attributes.ContainsKey("new_desc") ? item.Attributes["new_desc"] : "";
// row.Cells[3].Value = item["local_desc"] ?? "";
//}
List<DataGridViewRow> rlist = new List<DataGridViewRow>();
foreach (var item in this.view.Columns)
{
DataGridViewTextBoxCell col1 = new DataGridViewTextBoxCell();
col1.Value = item.RawName;
DataGridViewTextBoxCell col2 = new DataGridViewTextBoxCell();
col2.Value = SQLHelper.GetFullSqlType(item);
DataGridViewCheckBoxCell col3 = new DataGridViewCheckBoxCell();
col3.Value = item.Nullable ? true : false;
DataGridViewTextBoxCell col4 = new DataGridViewTextBoxCell();
col4.Value = item["local_desc"] ?? "";
DataGridViewTextBoxCell col5 = new DataGridViewTextBoxCell();
DataGridViewRow row = new DataGridViewRow();
row.Cells.AddRange(new DataGridViewCell[] { col1, col2, col3, col4, col5 });
rlist.Add(row);
}
dgvSchema.Rows.AddRange(rlist.ToArray());
}
}
public override DataGridViewRow GetRemainCells(DataGridViewRow row)
{
DataGridViewRow returnValue = row;
try
{
DataGridViewCellStyle NameCellStyle = new DataGridViewCellStyle(row.DefaultCellStyle);
DataGridViewCellStyle style = new DataGridViewCellStyle(row.DefaultCellStyle);
// Determine Style
switch (ViewType)
{
case ViewTypes.Secondary:
style.BackColor = Color.AntiqueWhite;
NameCellStyle.BackColor = Color.AntiqueWhite;
NameCellStyle.Font = new Font(row.DefaultCellStyle.Font, FontStyle.Bold);
break;
case ViewTypes.Blank:
row.DefaultCellStyle.BackColor = Color.SlateGray;
row.DefaultCellStyle.SelectionBackColor = row.DefaultCellStyle.BackColor;
break;
case ViewTypes.Total:
NameCellStyle.Font = new Font(row.DefaultCellStyle.Font, FontStyle.Bold);
break;
default:
NameCellStyle.BackColor = Color.LightSkyBlue;
NameCellStyle.Font = new Font(row.DefaultCellStyle.Font, FontStyle.Bold);
break;
}
// Create the rest of the cells
switch (ViewType)
{
case ViewTypes.Blank:
// Do nothing
break;
default:
var textCell = new DataGridViewTextBoxCell();
textCell.Value = DisplayName;
textCell.Style = NameCellStyle;
returnValue.Cells.Add(textCell);
textCell = new DataGridViewTextBoxCell();
textCell.Value = Item.FlatLimit;
textCell.Style = style;
returnValue.Cells.Add(textCell);
textCell = new DataGridViewTextBoxCell();
textCell.Value = Item.PercentLimit;
textCell.Style = style;
returnValue.Cells.Add(textCell);
break;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
return returnValue;
}
public void ConfobulateControl()
{
_control.AutoGenerateColumns = false;
_control.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
_control.AllowUserToResizeRows = false;
_control.AllowUserToOrderColumns = false;
_control.BorderStyle = BorderStyle.None;
_control.CellBorderStyle = DataGridViewCellBorderStyle.None;
_control.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing;
_control.Font = new Font( _control.Font.FontFamily, 8.0F, GraphicsUnit.Point);
_control.ColumnHeadersBorderStyle = DataGridViewHeaderBorderStyle.None;
_control.ColumnHeadersDefaultCellStyle.BackColor = Color.FromArgb(255, 72, 78, 83);
_control.ColumnHeadersDefaultCellStyle.ForeColor = Color.White;
_control.ColumnHeadersDefaultCellStyle.Font = new Font(_control.ColumnHeadersDefaultCellStyle.Font.FontFamily, _control.ColumnHeadersDefaultCellStyle.Font.SizeInPoints, FontStyle.Bold, GraphicsUnit.Point);
var cellTemplate = new DataGridViewTextBoxCell();
cellTemplate.Style.ForeColor = Color.White;
cellTemplate.Style.SelectionBackColor = Color.FromArgb(255, 46, 100, 149);
var playingColumnTemplate = new DataGridViewImageCell();
playingColumnTemplate.ValueIsIcon = false;
playingColumnTemplate.Style.NullValue = null;
playingColumnTemplate.Style.ForeColor = cellTemplate.Style.ForeColor;
playingColumnTemplate.Style.SelectionBackColor = cellTemplate.Style.SelectionBackColor;
var playingColumn = new DataGridViewColumn(playingColumnTemplate);
playingColumn.Width = 16;
playingColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
playingColumn.Name = "";
playingColumn.Tag = PlayerAppColumnTypes.NowPlaying;
_control.Columns.Add(playingColumn);
var titleColumn = new DataGridViewColumn(cellTemplate);
titleColumn.Name = "Title";
titleColumn.DataPropertyName = "Title";
titleColumn.Tag = PlayerAppColumnTypes.Title;
_control.Columns.Add(titleColumn);
var artistColumn = new DataGridViewColumn(cellTemplate);
artistColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
artistColumn.Name = "Artist";
artistColumn.DataPropertyName = "Artist";
artistColumn.Tag = PlayerAppColumnTypes.Artist;
_control.Columns.Add(artistColumn);
var durationColumn = new DataGridViewColumn(cellTemplate);
durationColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
durationColumn.Name = "Duration";
durationColumn.DataPropertyName = "Duration";
durationColumn.Tag = PlayerAppColumnTypes.Duration;
_control.Columns.Add(durationColumn);
_control.RowHeadersVisible = false;
_control.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
_control.MultiSelect = false;
}
public void TextBoxTest()
{
SWF.DataGridViewTextBoxColumn column = new SWF.DataGridViewTextBoxColumn();
column.HeaderText = "Edit Column";
SWF.DataGridViewTextBoxCell cell = new SWF.DataGridViewTextBoxCell();
ColumnCellTest(column, cell, false);
}
public void Add_List(CGoodsData pCGoodsData)
{
DataGridViewRow r1 = new DataGridViewRow();
// 시퀀스
DataGridViewTextBoxCell cell_seq = new DataGridViewTextBoxCell();
cell_seq.Value = pCGoodsData.Seq_;
r1.Cells.Add(cell_seq);
// 상품명
DataGridViewTextBoxCell cell_Name = new DataGridViewTextBoxCell();
cell_Name.Value = pCGoodsData.GoodsName_;
r1.Cells.Add(cell_Name);
// 옵션명
DataGridViewTextBoxCell cell_Option = new DataGridViewTextBoxCell();
cell_Option.Value = pCGoodsData.OptionName_;
r1.Cells.Add(cell_Option);
// 채널
DataGridViewTextBoxCell cell_channel = new DataGridViewTextBoxCell();
//cell_channel.Value = pCGoodsData.ChannelName_;
cell_channel.Value = pCGoodsData.ChannelSeq_.ToString();
r1.Cells.Add(cell_channel);
// 상품명(닉
DataGridViewTextBoxCell cell_goods_nick = new DataGridViewTextBoxCell();
cell_goods_nick.Value = pCGoodsData.GoodsNickName_;
r1.Cells.Add(cell_goods_nick);
// 옵션명(닉
DataGridViewTextBoxCell cell_option_nick = new DataGridViewTextBoxCell();
cell_option_nick.Value = pCGoodsData.OptionNickName_;
r1.Cells.Add(cell_option_nick);
// 권리사
DataGridViewTextBoxCell cell_Auth = new DataGridViewTextBoxCell();
cell_Auth.Value = pCGoodsData.AuthoritySeq_;
r1.Cells.Add(cell_Auth);
// 크롤러 시퀀스
DataGridViewTextBoxCell cell_crawler_seq = new DataGridViewTextBoxCell();
cell_crawler_seq.Value = pCGoodsData.CrawlerSeq_;
r1.Cells.Add(cell_crawler_seq);
// 상태
DataGridViewTextBoxCell cell_State = new DataGridViewTextBoxCell();
cell_State.Value = pCGoodsData.State_;
r1.Cells.Add(cell_State);
// 권리사 로그인 시퀀스
DataGridViewTextBoxCell cell_AuLogin = new DataGridViewTextBoxCell();
cell_AuLogin.Value = pCGoodsData.AuthorityLoginSeq_;
r1.Cells.Add(cell_AuLogin);
dataGridView_GoodList.Rows.Add(r1);
}
private void BindGrid(IList<UpdateModel> source)
{
//dataGridView1.DataSource = source;
var col = new DataGridViewTextBoxColumn();
col.HeaderText = "标题";
col.Width = 250;
dataGridView1.Columns.Add(col);
col = new DataGridViewTextBoxColumn();
col.HeaderText = "标签";
col.Width = 200;
dataGridView1.Columns.Add(col);
col = new DataGridViewTextBoxColumn();
col.HeaderText = "摘要";
col.Width = 200;
dataGridView1.Columns.Add(col);
col = new DataGridViewTextBoxColumn();
col.HeaderText = "状态";
col.Width = 90;
dataGridView1.Columns.Add(col);
foreach (var item in source)
{
var row = new DataGridViewRow();
var cell = new DataGridViewTextBoxCell();
cell.Value = item.Title;
row.Cells.Add(cell);
cell = new DataGridViewTextBoxCell();
cell.Value = item.Tags;
row.Cells.Add(cell);
cell = new DataGridViewTextBoxCell();
cell.Value = item.Intro;
row.Cells.Add(cell);
cell = new DataGridViewTextBoxCell();
cell.Value = "";
row.Cells.Add(cell);
dataGridView1.Rows.Add(row);
}
//dataGridView1.
if (InvokeRequired)
{
this.Invoke(new Action(() =>
{
btnUpdate2.Visible = true;
this.progressBar1.Visible = true;
}));
}
}
public void Value ()
{
DataGridViewTextBoxCell tbc = new DataGridViewTextBoxCell ();
Assert.IsNull (tbc.Value, "#1");
tbc.Value = string.Empty;
Assert.AreEqual (string.Empty, tbc.Value, "#2");
tbc.Value = 5;
Assert.AreEqual (5, tbc.Value, "#3");
tbc.Value = null;
Assert.IsNull (tbc.Value, "#4");
}
private void GetThemaByStockCode()
{
RichQuery richQuery = new RichQuery();
KiwoomQuery kiwoomQuery = new KiwoomQuery();
DataTable dt4 = new DataTable();
string strMaxDate = richQuery.p_TDATEQuery(query: "2", tradeDate: "", fromDate: "", toDate: "", bln3tier: false).Tables[0].Rows[0]["MAX_TRADE_DATE"].ToString();
richQuery = null;
richQuery = new RichQuery();
DataTable dt = richQuery.p_ThemaQuery(query: "1", THEMA_CODE: lblThema.Text, TGPSEQ_NO: lblThemaGroup.Text, THEMA_NAME: "", WORK_ID: "", bln3tier: false).Tables[0].Copy();
int row = 0;
_clsDataGridViewUtil.RemoveGridViewRow(dgvThemaPerStock);
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
dgvThemaPerStock.Rows.Add();
dgvThemaPerStock.Rows[row].Cells["ThemaByStock_THEMA_NAME"].Value = dr["THEMA_NAME"].ToString().Trim();
dgvThemaPerStock.Rows[row].Cells["ThemaByStock_STOCK_NAME"].Value = dr["STOCK_NAME"].ToString().Trim();
dgvThemaPerStock.Rows[row].Cells["ThemaByStock_STOCK_CODE"].Value = dr["STOCK_CODE"].ToString().Trim();
dt4 = kiwoomQuery.p_StockCodeOptInfoQuery(query: "1", stockCode: dr["STOCK_CODE"].ToString().Trim(), stockDate: "", bln3tier: false).Tables[0].Copy();
if (dt4 != null)
{
if (dt4.Rows.Count > 0)
{
if (_firstCall == false)
{
foreach (DataColumn dc in dt4.Columns)
{
System.Windows.Forms.DataGridViewColumn dgvColumn = new System.Windows.Forms.DataGridViewColumn();
System.Windows.Forms.DataGridViewCell cell = new System.Windows.Forms.DataGridViewTextBoxCell();
if (dc.ColumnName.ToString() == "STOCK_CODE" || dc.ColumnName.ToString() == "CALL_TIME")
{
continue;
}
if (dc.ColumnName.ToString() == "CALL_DATE")
{
dgvColumn.CellTemplate = cell;
dgvColumn.HeaderText = "기준일자";
dgvColumn.Name = "OPT10001_CALL_DATE";
dgvThemaPerStock.Columns.Add(dgvColumn);
dgvColumn = null;
dgvColumn = new DataGridViewColumn();
dgvColumn.CellTemplate = cell;
dgvColumn.HeaderText = "대금대비시총";
dgvColumn.Name = "대금대비시총";
dgvThemaPerStock.Columns.Add(dgvColumn);
continue;
}
dgvColumn.CellTemplate = cell;
dgvColumn.HeaderText = dc.ColumnName.ToString();
dgvColumn.Name = dc.ColumnName.ToString();
dgvThemaPerStock.Columns.Add(dgvColumn);
}
_firstCall = true;
}
foreach (DataColumn dc in dt4.Columns)
{
if (dc.ColumnName.ToString() == "STOCK_CODE" || dc.ColumnName.ToString() == "CALL_TIME")
{
continue;
}
if (dc.ColumnName.ToString() == "CALL_DATE")
{
dgvThemaPerStock.Rows[row].Cells["OPT10001_CALL_DATE"].Value = dt4.Rows[0][dc.ColumnName.ToString()].ToString();
}
else
{
dgvThemaPerStock.Rows[row].Cells[columnName : dc.ColumnName.ToString()].Value = dt4.Rows[0][dc.ColumnName.ToString()].ToString();
}
}
}
}
dt = null;
dt = new DataTable();
row = row + 1;
}
SetDataGridView();
}
}
private void AddElementToDataGridView(Param element)
{
var row = new DataGridViewRow();
// пустая сточка означет разделитель между
// отдельными интерфейсами
if(element.ParamName == string.Empty)
{
dataGridView1.Rows.Add(row);
return;
}
// добавляем первую ячейку
var cell1 = new DataGridViewTextBoxCell()
{
Value = element.ParamName + ":"
};
cell1.Style.Font = new Font(dataGridView1.Font, FontStyle.Bold);
row.Cells.Add(cell1);
// добавляем вторую ячейку
var cell2 = new DataGridViewTextBoxCell()
{
Value = element.ParamValue
};
row.Cells.Add(cell2);
// добавляем строчку в dataGridView
dataGridView1.Rows.Add(row);
}
