/// <summary>
/// Process load student data from Database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void StudentListForm_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'qLSVDBDataSet.student' table. You can move, or remove it, as needed.
//this.studentTableAdapter.Fill(this.qLSVDBDataSet.student);
SqlCommand command = new SqlCommand("SELECT * FROM student");
DataGridView1.ReadOnly = true;
//Xu ly hinh anh, tham khao MSDN.
DataGridViewImageColumn imageColumn = new DataGridViewImageColumn(); //Doi tuong lam viec la Image cua DataGirdView
DataGridView1.RowTemplate.Height = 80; //Tham khao MSDN 10/03/2019, co gian Image dep. Dang tim Auto-Size
DataGridView1.DataSource = student.getStudents(command);
imageColumn = (DataGridViewImageColumn)DataGridView1.Columns[7];
imageColumn.ImageLayout = DataGridViewImageCellLayout.Stretch;
DataGridView1.AllowUserToAddRows = false;
}
private void button1_Click(object sender, EventArgs e)
{
s = (DateTime)dateTimePicker1.Value;
end = (DateTime)dateTimePicker2.Value;
if (s > end)
{
MessageBox.Show("Vui lòng điều chỉnh lại thời gian bắt đầu và kết thúc", "Thông báo");
}
else
{
PageCount = DAL_HISTORY.PageCount(s, end);
button3.Enabled = false;
if (PageCount > 1)
{
button2.Enabled = true;
}
else
{
button2.Enabled = false;
}
dgv_History.DataSource = BLL_HISTORY.filterPage(s, end, 1);
if (dgv_History.Rows.Count > 0)
{
DataGridViewImageColumn img = (DataGridViewImageColumn)dgv_History.Columns["AnhNV"];
img.ImageLayout = DataGridViewImageCellLayout.Stretch;
PageCur = 1;
for (int i = 0; i < dgv_History.Rows.Count; i++)
{
try
{
Bitmap imgv = new Bitmap(dgv_History.Rows[i].Cells["IMG_FACE"].Value.ToString());
img.Image = imgv;
}
catch (Exception)
{
img.Image = new Bitmap(Application.StartupPath + @"\File\noimagefound.Jpg");
}
dgv_History.Rows[i].MinimumHeight = 80;
}
}
}
}
private void CreateColumns()
{
DataGridViewImageColumn imageColumn;
int columnCount = 0;
do
{
Bitmap unMarked = blank;
imageColumn = new DataGridViewImageColumn();
//Add twice the padding for the left and
//right sides of the cell.
imageColumn.Width = blank.Width + 2 * bitmapPadding + 1;
imageColumn.Image = unMarked;
gameBoard.Columns.Add(imageColumn);
columnCount = columnCount + 1;
}while (columnCount < game.Size());
}
private void Proveedores_Load(object sender, EventArgs e)
{
prov = Datos.Estado.Llenar_grilla();
proveedores = Lógica.Clase_proveedores.llenargrillaproveedores();
id_estado_proveedor_cmb.DataSource = prov;
dataGridView_provedores.DataSource = proveedores;
id_estado_proveedor_cmb.DisplayMember = "Nombre";
id_estado_proveedor_cmb.ValueMember = "Id";
id_estado_proveedor_cmb.SelectedIndex = -1;
DataGridViewImageColumn btn_img = new DataGridViewImageColumn();
btn_img.Name = " ";
dataGridView_provedores.Columns.Add(btn_img);
if (Program.acceso == 2)
{
this.dataGridView_provedores.Columns[" "].Visible = false;
}
}
private void SetImageColumns(SectionOfBuilding sectionOfBuilding)
{
dgvModel.Columns.Clear();
for (int i = 0; i < sectionOfBuilding.QuantityByWidth; i++)
{
var imageColumn = new DataGridViewImageColumn()
{
Name = i.ToString(),
HeaderText = $"Элемент №{i}",
Width = GetModelSize(2)
};
if (elementsOfModel[0][i].IdTypeOfElement != -1)
{
var typeOfElement = mainForm.ReadTypeOfElement(elementsOfModel[0][i].IdTypeOfElement);
imageColumn.Width = GetModelSize(typeOfElement.Length);
}
dgvModel.Columns.Add(imageColumn);
}
}
private void LoadData()
{
try
{
if (imgColumn == true)
{
DataGridViewImageColumn dgvimgcol = new DataGridViewImageColumn();
dgvimgcol.HeaderText = "Photo";
dgvimgcol.ImageLayout = DataGridViewImageCellLayout.Stretch;
dgvData.Columns.Add(dgvimgcol);
imgColumn = false;
}
using (var conn = new Connection().CreateAndOpenConnection())
{
using (var cmd = new SqlCommand())
{
cmd.Connection = conn;
cmd.CommandText = @"Select id_menu, namamenu, harga, foto From menu oRDER BY id_menu ASC";
using (var reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
this.dgvData.Rows.Add(new [] {
reader["id_menu"].ToString(),
reader["namamenu"].ToString(),
reader["harga"].ToString(),
reader["foto"]
});
}
}
}
}
}
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
}
addPicture();
}
private void button1_Click(object sender, EventArgs e)
{
string name = textBox1.Text;
api.apiKey = textBox2.Text;
matches = api.GetMatchListBySummonerName(name);
dataGridView1.DataSource = matches.matches.Select(u => new
{
务器 = u.platformId,
英 = GetImageFromWeb(u.champion.ToString()),
比赛 = u.matchId,
分路 = u.lane,
位置 = u.role
}).ToList();
DataGridViewImageColumn column = (DataGridViewImageColumn)dataGridView1.Columns[1];
column.ImageLayout = DataGridViewImageCellLayout.Stretch;
column.Width = 25;
}
public void Boton(DataGridView dgv)
{
DataGridViewImageColumn imgEditar = new DataGridViewImageColumn();
imgEditar.HeaderText = "EDITAR";
imgEditar.Name = "EDITAR";
imgEditar.Image = proyecto3.Properties.Resources._3592815_compose_create_edit_edit_file_office_pencil_writing_107734;
imgEditar.ImageLayout = DataGridViewImageCellLayout.Zoom;
dgv.Columns.Add(imgEditar);
DataGridViewImageColumn imgEliminar = new DataGridViewImageColumn();
imgEliminar.HeaderText = "ELIMINAR";
imgEliminar.Name = "ELIMINAR";
imgEliminar.Image = proyecto3.Properties.Resources._3592821_garbage_can_general_office_recycle_bin_rubbish_bin_trash_bin_trash_can_107760;
imgEliminar.ImageLayout = DataGridViewImageCellLayout.Zoom;
dgv.Columns.Add(imgEliminar);
}
private void button8_Click(object sender, EventArgs e)
{
dgvData.DataSource = (from c in db.Courses
select new { c.CourseID, c.Name, c.Credit }).ToList();
DataGridViewImageColumn btn = new DataGridViewImageColumn();
btn.HeaderText = "Del";
btn.Name = "btnDelete";
btn.Image = Properties.Resources.delete_16px;
dgvData.Columns.Add(btn);
DataGridViewImageColumn btn1 = new DataGridViewImageColumn();
btn1.HeaderText = "Edit";
btn1.Name = "btnEdit";
btn1.Image = Properties.Resources.edit_16px;
dgvData.Columns.Add(btn1);
}
public void FillGridProducts(string SearchValue)
{
MySqlConnection conn = DBUtils.GetDBConnection();
MySqlCommand gridfill = new MySqlCommand("SELECT * FROM Products WHERE CONCAT(pid,pname,typename,brandname) LIKE '%" + SearchValue + "%'", conn);
MySqlDataAdapter adapter = new MySqlDataAdapter(gridfill);
DataTable table = new DataTable();
adapter.Fill(table);
dataGridView1.RowTemplate.Height = 60;
dataGridView1.AllowUserToAddRows = false;
dataGridView1.DataSource = table;
DataGridViewImageColumn imgCol = new DataGridViewImageColumn();
imgCol = (DataGridViewImageColumn)dataGridView1.Columns[8];
imgCol.ImageLayout = DataGridViewImageCellLayout.Stretch;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGridView1.AllowUserToResizeRows = false;
dataGridView1.Columns[0].Visible = false;
}
private void ShowClaster(List <SignImage> images, int splitNumber, DataGridView dataGridView)
{
DataGridViewImageColumn imgCol = new DataGridViewImageColumn();
int icIndex = dataGridView.Columns.Add(imgCol);
dataGridView.Columns[icIndex].Name = "Class" + icIndex;
if (dataGridView.RowCount < images.Count)
{
dataGridView.RowCount = images.Count;
}
int i = 0;
foreach (var image in images)
{
dataGridView.Rows[i].Cells["Class" + icIndex].Value = image.Bmp;
dataGridView.Rows[i].Cells["Class" + icIndex].ToolTipText = image.Distances[splitNumber].ToString("0.00000");
i++;
}
}
private void ListDeparts_Load(object sender, EventArgs e)
{
LoadListDepart();
DataGridViewImageColumn btnDEL = new DataGridViewImageColumn();
btnDEL.Name = "btnDel";
btnDEL.HeaderText = "";
btnDEL.Image = Properties.Resources.delete1;
dgvDeparts.Columns.Add(btnDEL);
dgvDeparts.RowTemplate.Height = 30;
DataGridViewImageColumn btnEdit = new DataGridViewImageColumn();
btnEdit.Name = "btnEdit";
btnEdit.HeaderText = "";
btnEdit.Image = Properties.Resources.edit2;
dgvDeparts.Columns.Add(btnEdit);
dgvDeparts.RowTemplate.Height = 30;
}
private void Form1_Load(object sender, EventArgs e)
{
timer1.Interval = 200;
int i, j;
dataGridView1.Rows.Clear();
dataGridView1.Columns.Clear();
for (j = 0; j < 15; j++)
{
DataGridViewImageColumn resim = new DataGridViewImageColumn();
resim.ToolTipText = "5000";
dataGridView1.Columns.Add(resim);
}
for (i = 0; i < 15; i++)
{
dataGridView1.Rows.Add(" ");
DataGridViewRow row = dataGridView1.Rows[i];
row.Height = 30;
}
foreach (DataGridViewRow row in dataGridView1.Rows)
{
foreach (DataGridViewCell cell in row.Cells)
{
if (cell.RowIndex == 0 || cell.RowIndex == 15 || cell.ColumnIndex == 0 || cell.ColumnIndex == 14)
{
cell.Value = Properties.Resources.la1;
cell.ToolTipText = "5000";
}
else
{
cell.Style.BackColor = Color.LightYellow;
cell.Value = Properties.Resources.af;
cell.ToolTipText = "0";
}
}
}
foreach (DataGridViewColumn col in dataGridView1.Columns)
{
col.Width = 30;
}
dataGridView1.ColumnHeadersVisible = false;
dataGridView1.RowHeadersVisible = false;
}
private void fillObjectsDataGrid()
{
var activeObjectList = objectLists[curActiveObjectListIndex];
dgvObjects.DataSource = null;
dgvObjects.Columns.Clear();
dgvObjects.AutoGenerateColumns = true;
dgvObjects.DataSource = activeObjectList.objects;
if (dgvObjects.Columns.Count < ObjectRec.FIELD_COUNT)
{
//add icon column
DataGridViewImageColumn iconColumn = new DataGridViewImageColumn();
iconColumn.Name = "Icon";
iconColumn.HeaderText = "Icon";
dgvObjects.Columns.Insert(0, iconColumn);
//add values from dictionary
if (activeObjectList.objects.Count > 0)
{
var defObject = activeObjectList.objects[0];
var dict = defObject.additionalData;
if (dict != null)
{
foreach (var k in dict.Keys)
{
var dictColumn = new DataGridViewTextBoxColumn();
dictColumn.Name = k;
dictColumn.HeaderText = k;
dgvObjects.Columns.Add(dictColumn);
}
}
}
}
for (int i = 0; i < dgvObjects.Columns.Count; i++)
{
dgvObjects.Columns[i].Width = 35;
}
dgvObjects.Invalidate();
lbObjectsCount.Text = String.Format("objects count: {0}/{1}", dgvObjects.RowCount, getLevelRecForGameType().objCount);
}
private void ManageCharities_Load(object sender, EventArgs e)
{
parent = (Form1)this.ParentForm;
var q = db.Charities;
dataGridView1.RowTemplate.Height = 35;
DataGridViewImageColumn imgColumn = new DataGridViewImageColumn();
imgColumn.HeaderText = "Logo";
imgColumn.ImageLayout = DataGridViewImageCellLayout.Stretch;
dataGridView1.Columns.Add(imgColumn);
dataGridView1.Columns.Add("CharityId", "CharityId");
dataGridView1.Columns.Add("Name", "Name");
dataGridView1.Columns.Add("Description", "Description");
DataGridViewButtonColumn btnColumn = new DataGridViewButtonColumn();
btnColumn.HeaderText = "Edit";
btnColumn.UseColumnTextForButtonValue = true;
btnColumn.Text = "Edit";
dataGridView1.Columns.Add(btnColumn);
dataGridView1.Columns[1].Visible = false;
foreach (var a in q)
{
try
{
using (FileStream fs = new FileStream(Application.StartupPath + "\\marathon-skills-2015-charity-data\\" + a.CharityLogo, FileMode.Open))
{
Image img = Image.FromStream(fs);
dataGridView1.Rows.Add(img, a.CharityId, a.CharityName, a.CharityDescription);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
/// <summary>
/// 数据绑定
/// </summary>
private void DataBind()
{
this.gridGD.Rows.Clear();
DataSet ds = null;
try
{
ds = templateBLL.GetList(fileTemp);
}
catch (Exception)
{
TXMessageBoxExtensions.Info("没有查询到记录！");
return;
}
if (ds.Tables.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
gridGD.Rows.Add();
DataGridViewCellCollection dgvc = gridGD.Rows[i].Cells;
DataRow drc = ds.Tables[0].Rows[i];
string gdid = drc["gdid"].ToString();
string isGdid = string.Empty;
DataGridViewImageColumn status = new DataGridViewImageColumn();
status.DisplayIndex = 4;
status.HeaderText = "是否目录";
status.DataPropertyName = "isDire";
status.ImageLayout = DataGridViewImageCellLayout.Zoom;
if (drc["gdid"].ToString() == "")
{
status.Image = Properties.Resources._121;
}
//gridGD.Columns.Insert(i, status);
dgvc["wjtm"].Value = isGdid + drc["gdwj"].ToString();
dgvc["sorts"].Value = drc["orderIndex"].ToString();
dgvc["fileType"].Value = drc["projectCategory"].ToString() == "Buildding"
? "建筑工程" : drc["projectCategory"].ToString() == "Traffic" ? "地下管线工程" :
drc["projectCategory"].ToString() == "RoadLamp" ? "道路工程" : "桥梁工程";
dgvc["ID"].Value = drc["FileID"].ToString();
}
}
}
private void fListMoto_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'chamSocVaGuiXe_ListMoto.Moto' table. You can move, or remove it, as needed.
this.motoTableAdapter.Fill(this.chamSocVaGuiXe_ListMoto.Moto);
SqlCommand command = new SqlCommand("SELECT * FROM dbo.Moto");
dataGridViewMotoList.ReadOnly = true;
// xu ly hinh anh, code co tham khao msdn
DataGridViewImageColumn picCol1 = new DataGridViewImageColumn(); // doi tuong lam viec voi dang picture cua datagridview
DataGridViewImageColumn picCol2 = new DataGridViewImageColumn();
dataGridViewMotoList.RowTemplate.Height = 80; // dong nay tham khao tren MSDN ngay 10/03/2019,co gian de pic dep, dang tim auto-size
dataGridViewMotoList.DataSource = moto.getMoto(command);
picCol1 = (DataGridViewImageColumn)dataGridViewMotoList.Columns[1];
picCol1.ImageLayout = DataGridViewImageCellLayout.Stretch;
picCol2 = (DataGridViewImageColumn)dataGridViewMotoList.Columns[2];
picCol2.ImageLayout = DataGridViewImageCellLayout.Stretch;
dataGridViewMotoList.AllowUserToAddRows = false;
}
private void loadData(List <Employee> list)
{
DataTable table = new DataTable();
table.Columns.Add().ColumnName = "Id";
table.Columns.Add().ColumnName = "First Name";
table.Columns.Add().ColumnName = "Last Name";
table.Columns.Add().ColumnName = "CMND";
table.Columns.Add().ColumnName = "Birth Date";
table.Columns.Add().ColumnName = "Salary";
table.Columns.Add("Avatar", typeof(byte[]));
table.Columns.Add().ColumnName = "Position Code";
table.Columns.Add().ColumnName = "Phone";
table.Columns.Add().ColumnName = "Address";
table.Columns.Add().ColumnName = "Gender";
table.Columns.Add().ColumnName = "Manager Id";
foreach (var emp in list)
{
DataRow row = table.NewRow();
row[0] = emp.Id;
row[1] = emp.fname;
row[2] = emp.lname;
row[3] = emp.CMND;
row[4] = ((DateTime)emp.bdate).ToShortDateString();
row[5] = emp.salary;
row[6] = emp.avatar;
row[7] = emp.posId;
row[8] = emp.phone;
row[9] = emp.address;
row[10] = emp.gender;
row[11] = emp.manager;
table.Rows.Add(row);
}
show_dgv.DataSource = null;
show_dgv.DataSource = table;
show_dgv.RowTemplate.Height = 80;
DataGridViewImageColumn imageColumn = new DataGridViewImageColumn();
imageColumn = (DataGridViewImageColumn)show_dgv.Columns["Avatar"];
imageColumn.ImageLayout = DataGridViewImageCellLayout.Stretch;
show_dgv.AllowUserToAddRows = false;
}
private void FrmCustomerList_Load(object sender, EventArgs e)
{
dgvCustomerList.DataSource = CustomerDao.ListAllCustomer();
dgvCustomerList.ColumnHeadersDefaultCellStyle.Font =
new Font("Time News Roman", 14, FontStyle.Bold);
dgvCustomerList.DefaultCellStyle.Font = new Font("Khmer OS System", 12);
dgvCustomerList.Columns["Name"].Width = 200; //define column width
//define image size stretch
DataGridViewImageColumn img = new DataGridViewImageColumn();
img = (DataGridViewImageColumn)dgvCustomerList.Columns["Photo"];
img.ImageLayout = DataGridViewImageCellLayout.Zoom;
foreach (DataGridViewColumn col in dgvCustomerList.Columns)
{
col.SortMode = DataGridViewColumnSortMode.NotSortable;
}
dgvCustomerList.ClearSelection(); //clear select item in datagridview
}
private void TextBox1_KeyUp(object sender, KeyEventArgs e)
{
try
{
dataGridView1.Columns.Clear();
dataGridView1.Refresh();
int i = 0;
if (con.State == ConnectionState.Open)
{
con.Close();
}
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select * from student_info where student_name like('%" + textBox1.Text + "%')";
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
dataGridView1.DataSource = dt;
Bitmap img;
DataGridViewImageColumn imageCol = new DataGridViewImageColumn();
imageCol.Width = 500;
imageCol.HeaderText = "student image";
imageCol.ImageLayout = DataGridViewImageCellLayout.Zoom;
imageCol.Width = 100;
dataGridView1.Columns.Add(imageCol);
foreach (DataRow dr in dt.Rows)
{
img = new Bitmap(@"..\..\" + dr["student_image"].ToString());
dataGridView1.Rows[i].Cells[8].Value = img;
dataGridView1.Rows[i].Height = 100;
i = i + 1;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
void BindGridView()
{
SqlConnection con = new SqlConnection(cs);
string query = "select * from S_TABLE";
SqlDataAdapter sda = new SqlDataAdapter(query, con);
DataTable data = new DataTable();
sda.Fill(data);
dataGridView1.DataSource = data;
///Image Column
DataGridViewImageColumn dgv = new DataGridViewImageColumn();
dgv = (DataGridViewImageColumn)dataGridView1.Columns[6];
dgv.ImageLayout = DataGridViewImageCellLayout.Stretch;
//AUTOSIZE
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
//Image Height
dataGridView1.RowTemplate.Height = 50;
}
public void AddImageDataGrid(DataGridView dgv)
{
DataGridViewImageColumn dimg = new DataGridViewImageColumn();
dimg.Image = Properties.Resources.edit;
dimg.HeaderText = "Edit";
dimg.ImageLayout = DataGridViewImageCellLayout.Normal;
dimg.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dgv.Columns.Add(dimg);
DataGridViewImageColumn dimgDelete = new DataGridViewImageColumn();
dimgDelete.Image = Properties.Resources.delete;
dimgDelete.HeaderText = "Delete";
dimgDelete.ImageLayout = DataGridViewImageCellLayout.Normal;
dimgDelete.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dgv.Columns.Add(dimgDelete);
}
private void UserForm_Load(object sender, EventArgs e)
{
// this.user
String sql = "select * from izdelie";
SqlDataAdapter sda = new SqlDataAdapter(sql, connection);
DataSet ds = new DataSet();
sda.Fill(ds, "izdelie");
dataGridView1.DataSource = ds.Tables["izdelie"];
DataGridViewImageColumn img = new DataGridViewImageColumn();
Image image = Image.FromFile("C:/users/lickett2019/test.jpg");
img.Image = image;
dataGridView1.Columns.Add(img);
img.HeaderText = "Image";
img.Name = "img";
}
private void WorkType_Load(object sender, EventArgs e)
{
var editIcon = new Bitmap(LotusLabsTimeTracker.Properties.Resources.edit, 8, 8);
refreshData();
DataGridViewImageColumn editColumn = new DataGridViewImageColumn();
editColumn.Name = "Edit";
editColumn.Image = editIcon;
editColumn.Width = 50;
editColumn.MinimumWidth = 50;
editColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
if (dataGridView1.Columns["Edit"] == null)
{
dataGridView1.Columns.Insert(4, editColumn);
}
}
private void button9_Click(object sender, EventArgs e)
{
try
{
if (itemName.Text == "")
{
MessageBox.Show("Enter Item Name Please !");
}
else
{
string item_name = itemName.Text;
menu_data_grid.DataSource = fim.GetByName(item_name);
DataGridViewImageColumn cell = (DataGridViewImageColumn)menu_data_grid.Columns[4];
cell.ImageLayout = DataGridViewImageCellLayout.Stretch;
}
}
catch (Exception ER) {
}
}
private void FormDichVu_Load(object sender, EventArgs e)
{
DisplayData();
DataGridViewImageColumn delbut = new DataGridViewImageColumn();
delbut.Image = Image.FromFile(@"..\img\modified.png");
delbut.Width = 35;
delbut.HeaderText = "Sửa";
delbut.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataDichVu.Columns.Add(delbut);
DataGridViewImageColumn delbut2 = new DataGridViewImageColumn();
delbut2.Image = Image.FromFile(@"..\img\delicon.png");
delbut2.Width = 35;
delbut2.HeaderText = "Xoá";
delbut2.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataDichVu.Columns.Add(delbut2);
}
//funcion formato grid con modificación busqueda con permisos
protected void fdgvsuid(int iopcion, int icvpolitica, string sdescpolitica, int icvnivel, int icvtiponomina,
int inumeventosmin, int inumeventos, int icvincrepresenta, int icvevaluacion, int isancgenera, int iordenejec,
int istpolitica, string susuumod, string sprgumod)
{
dgvdatos.DataSource = null;
int inumcolumngrid = dgvdatos.ColumnCount;
if (inumcolumngrid == 1)
{
dgvdatos.Columns.RemoveAt(0);
}
DataTable dtdatos = clsancionesincidencias.dtdatos(iopcion, icvpolitica, sdescpolitica, icvnivel, icvtiponomina, inumeventosmin, inumeventos, icvincrepresenta, icvevaluacion, isancgenera, iordenejec, istpolitica, susuumod, sprgumod);
dgvdatos.DataSource = dtdatos;
DataGridViewImageColumn imgCheckUsuarios = new DataGridViewImageColumn();
imgCheckUsuarios.Image = Resources.ic_lens_blue_grey_600_18dp;
imgCheckUsuarios.Name = "img";
dgvdatos.Columns.Insert(0, imgCheckUsuarios);
dgvdatos.Columns[0].HeaderText = "Selección";
dgvdatos.Columns[0].Width = 75;
dgvdatos.Columns[1].Width = 200;
dgvdatos.Columns[2].Width = 210;
dgvdatos.Columns[3].Width = 210;
dgvdatos.Columns[4].Width = 80;
dgvdatos.Columns[5].Width = 80;
dgvdatos.Columns[6].Width = 90;
dgvdatos.Columns[7].Width = 90;
dgvdatos.Columns[8].Width = 105;
dgvdatos.Columns[9].Visible = false;
dgvdatos.Columns[10].Visible = false;
dgvdatos.Columns[11].Visible = false;
dgvdatos.Columns[12].Visible = false;
dgvdatos.Columns[13].Visible = false;
dgvdatos.Columns[14].Visible = false;
dgvdatos.ClearSelection();
lblModif.Visible = true;
}
public void fillGrid(SqlCommand command)
{
dataGridView1.ReadOnly = true;
DataGridViewImageColumn picCol1 = new DataGridViewImageColumn();
DataGridViewImageColumn picCol2 = new DataGridViewImageColumn();
dataGridView1.RowTemplate.Height = 80;
dataGridView1.DataSource = bike.getBike(command);
picCol1 = (DataGridViewImageColumn)dataGridView1.Columns[1];
picCol1.ImageLayout = DataGridViewImageCellLayout.Stretch;
picCol2 = (DataGridViewImageColumn)dataGridView1.Columns[2];
picCol2.ImageLayout = DataGridViewImageCellLayout.Stretch;
dataGridView1.AllowUserToAddRows = false;
//// TODO: This line of code loads data into the 'chamSocVaGuiXeDataSet1.Bike' table. You can move, or remove it, as needed.
//this.bikeTableAdapter.Fill(this.chamSocVaGuiXeDataSet2.Bike);
//// TODO: This line of code loads data into the 'chamSocVaGuiXeDataSet.Bike' table. You can move, or remove it, as needed.
//this.bikeTableAdapter.Fill(this.chamSocVaGuiXeDataSet2.Bike);
//// TODO: This line of code loads data into the 'myDBDataSet.Student' table. You can move, or remove it, as needed.
//this.bikeTableAdapter.Fill(this.chamSocVaGuiXeDataSet2.Bike);
//SqlCommand command = new SqlCommand("SELECT * FROM dbo.Bike");
//dataGridView1.ReadOnly = true;
//// xu ly hinh anh, code co tham khao msdn
//DataGridViewImageColumn picCol1 = new DataGridViewImageColumn(); // doi tuong lam viec voi dang picture cua datagridview
//DataGridViewImageColumn picCol2 = new DataGridViewImageColumn();
//dataGridView1.RowTemplate.Height = 80; // dong nay tham khao tren MSDN ngay 10/03/2019,co gian de pic dep, dang tim auto-size
//dataGridView1.DataSource = bike.getBike(command);
//picCol1 = (DataGridViewImageColumn)dataGridView1.Columns[1];
//picCol1.ImageLayout = DataGridViewImageCellLayout.Stretch;
//picCol2 = (DataGridViewImageColumn)dataGridView1.Columns[2];
//picCol2.ImageLayout = DataGridViewImageCellLayout.Stretch;
//dataGridView1.AllowUserToAddRows = false;
// Dem sinh vien
labelTotalBike.Text = ("Total Bike: " + dataGridView1.Rows.Count);
}
private void Form1_Load(object sender, EventArgs e)
{
//probably a way to do this in the form builder but w/e
this.Icon = Properties.Resources.ACLeaf;
//load the csv
itemGridView.DataSource = loadItemCSV("items.csv");
//set the ID row invisible
itemGridView.Columns["ID"].Visible = false;
//change the width of the first two columns
itemGridView.Columns[0].Width = 150;
itemGridView.Columns[1].Width = 65;
//select the full row and change color cause windows blue sux
itemGridView.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
itemGridView.DefaultCellStyle.BackColor = Color.FromArgb(255, 47, 49, 54);
itemGridView.DefaultCellStyle.ForeColor = Color.FromArgb(255, 114, 105, 110);
itemGridView.DefaultCellStyle.SelectionBackColor = Color.FromArgb(255, 57, 60, 67);
itemGridView.ColumnHeadersDefaultCellStyle.BackColor = Color.FromArgb(255, 57, 60, 67);
itemGridView.ColumnHeadersDefaultCellStyle.ForeColor = Color.White;
itemGridView.ColumnHeadersDefaultCellStyle.SelectionBackColor = Color.FromArgb(255, 57, 60, 67);
itemGridView.EnableHeadersVisualStyles = false;
//create the image column
DataGridViewImageColumn imageColumn = new DataGridViewImageColumn();
imageColumn.Name = "Image";
imageColumn.HeaderText = "Image";
imageColumn.ImageLayout = DataGridViewImageCellLayout.Zoom;
itemGridView.Columns.Insert(3, imageColumn);
imageColumn.SortMode = DataGridViewColumnSortMode.NotSortable;
foreach (DataGridViewColumn c in itemGridView.Columns)
{
c.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
c.HeaderCell.Style.Font = new Font("Arial", 9, FontStyle.Bold);
}
}
private void FrmDeviceList_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'scadaReceiveValueDataSet.Device' table. You can move, or remove it, as needed.
//this.deviceTableAdapter.Fill(this.scadaReceiveValueDataSet.Device);
try
{
connectDB();
cbStatus.DataSource = InitializeStatusData();
cbStatus.DisplayMember = "Display";
dgvList.RowTemplate.Height = 60;
DataGridViewImageColumn img = new DataGridViewImageColumn();
Image image = Image.FromFile("D:\\device.jpg");
img.Image = image;
dgvList.Columns.Add(img);
img.HeaderText = "Hình";
img.Name = "img";
LoadDevice();
dgvList.Columns[1].HeaderText = "ID";
dgvList.Columns[2].HeaderText = "Tên";
dgvList.Columns[3].HeaderText = "Mã";
dgvList.Columns[4].HeaderText = "Serial";
dgvList.Columns[5].HeaderText = "Ngày nhập kho";
dgvList.Columns[6].HeaderText = "Ngày cài đặt";
dgvList.Columns[7].HeaderText = "Ngày tạo";
dgvList.Columns[8].HeaderText = "Trạng thái";
//DataGridViewImageColumn delbut = new DataGridViewImageColumn();
//delbut.Width = 20;
//delbut.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
//dgvList.Columns.Add(delbut);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// Constructor for <see cref="DataGridViewImageColumnVWG"/>
/// </summary>
/// <param name="dataGridViewColumn"></param>
public DataGridViewImageColumnVWG(DataGridViewImageColumn dataGridViewColumn)
: base(dataGridViewColumn)
{
_dataGridViewColumn = dataGridViewColumn;
}
