private void InitGridList()
{
DSkinGridListColumn dSkinGridListColumn1 = new DSkinGridListColumn();
DSkinGridListColumn dSkinGridListColumn2 = new DSkinGridListColumn();
//
//
//
dSkinGridListColumn1.Item.Font = new System.Drawing.Font("宋体", 9F);
dSkinGridListColumn1.Item.ForeColor = System.Drawing.Color.Black;
dSkinGridListColumn1.Item.InheritanceSize = new System.Drawing.SizeF(0F, 1F);
dSkinGridListColumn1.Item.Location = new System.Drawing.Point(0, 0);
dSkinGridListColumn1.Item.Name = string.Empty;
dSkinGridListColumn1.Item.Size = new System.Drawing.Size(40, 22);
dSkinGridListColumn1.Item.Text = "项";
dSkinGridListColumn1.Item.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
dSkinGridListColumn1.Name = "项";
dSkinGridListColumn1.Visble = true;
dSkinGridListColumn1.Width = 88;
dSkinGridListColumn1.DataPropertyName = "Column_Item";
//
//
//
dSkinGridListColumn2.Item.Font = new System.Drawing.Font("宋体", 9F);
dSkinGridListColumn2.Item.ForeColor = System.Drawing.Color.Black;
dSkinGridListColumn2.Item.InheritanceSize = new System.Drawing.SizeF(0F, 1F);
dSkinGridListColumn2.Item.Location = new System.Drawing.Point(40, 0);
dSkinGridListColumn2.Item.Name = string.Empty;
dSkinGridListColumn2.Item.Size = new System.Drawing.Size(70, 22);
dSkinGridListColumn2.Item.Text = "值";
dSkinGridListColumn2.Item.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
dSkinGridListColumn2.Name = "值";
dSkinGridListColumn2.Visble = true;
dSkinGridListColumn2.Width = dSkinGridList_FileInfo.Width - 88 - 5;
dSkinGridListColumn2.DataPropertyName = "Column_Value";
//dSkinGridList_FileInfo.RowHeight = 22;
dSkinGridList_FileInfo.ColumnFill = true; //窗体最大化后，列宽自适应
dSkinGridList_FileInfo.EnablePage = false;
dSkinGridList_FileInfo.Dock = System.Windows.Forms.DockStyle.Fill;
//设置透明
dSkinGridList_FileInfo.BackColor = Color.Transparent;
dSkinGridList_FileInfo.DoubleItemsBackColor = Color.Transparent;
dSkinGridList_FileInfo.SingleItemsBackColor = Color.Transparent;
DSkinLinearGradientBrush dSkinLinearGradientBrush1 = new DSkinLinearGradientBrush();
dSkinGridList_FileInfo.ColumnHeaderBrush = dSkinLinearGradientBrush1;
dSkinGridList_FileInfo.ColumnHeaderHoverBrush = dSkinLinearGradientBrush1;
dSkinGridList_FileInfo.ColumnHeaderPressBrush = dSkinLinearGradientBrush1;
dSkinGridList_FileInfo.Columns.AddRange(new DSkinGridListColumn[] {
dSkinGridListColumn1,
dSkinGridListColumn2
});
}
/// <summary>
/// 读取excel
/// </summary>
private void 导入excel_Click()
{
string path = "";
System.Windows.Forms.OpenFileDialog fd = new System.Windows.Forms.OpenFileDialog();
fd.Title = "选择文件"; //选择框名称
fd.Filter = "xls files (*.xls)|*.xls"; //选择文件的类型为Xls表格
if (fd.ShowDialog() == System.Windows.Forms.DialogResult.OK) //当点击确定
{
path = fd.FileName.Trim(); //文件路径
path = path.Replace("\\", "/");
}
dSkinGridList1.Rows.Clear();
string mystring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='";
mystring += path.ToString();
mystring += "';User ID=admin;Password=;Extended properties='Excel 8.0;IMEX=1;HDR=NO;'";
OleDbConnection cnnxls = new OleDbConnection(mystring);
OleDbDataAdapter myDa = new OleDbDataAdapter("Select * from [Sheet1$]", cnnxls);
DataSet myDs = new DataSet();
myDa.Fill(myDs); //数据存放在myDs中了
System.Data.DataTable dataTable = myDs.Tables[0];
for (int i = 10; i < dataTable.Columns.Count; i++)
{
DSkinGridListColumn dSkinGridListColumn = new DSkinGridListColumn();
dSkinGridListColumn.Name = dataTable.Columns[i].ColumnName;
dSkinGridListColumn.Width = 100;
dSkinGridListColumn.DataPropertyName = dataTable.Columns[i].ColumnName;
dSkinGridList1.Columns.Add(dSkinGridListColumn);
}
for (int j = 0; j < dataTable.Rows.Count; j++)
{
if (dataTable.Rows[j].ItemArray[3].ToString() != "")
{
dSkinGridList1.Rows.AddRow(dataTable.Rows[j].ItemArray);
}
}
}
private void InitDSkinListView()
{
DSkinGridListColumn dSkinGridListColumn0 = new DSkinGridListColumn();
DSkinGridListColumn dSkinGridListColumn1 = new DSkinGridListColumn();
DSkinGridListColumn dSkinGridListColumn11 = new DSkinGridListColumn();
//dSkinGridListColumn0.ItemType = ControlType.DuiPictureBox;
dSkinGridListColumn0.Item.Font = new System.Drawing.Font("宋体", 9F);
dSkinGridListColumn0.Item.ForeColor = System.Drawing.Color.Black;
dSkinGridListColumn0.Item.InheritanceSize = new System.Drawing.SizeF(0F, 1F);
dSkinGridListColumn0.Item.Location = new System.Drawing.Point(0, 0);
dSkinGridListColumn0.Item.Name = "";
dSkinGridListColumn0.Item.Size = new System.Drawing.Size(25, 25);
dSkinGridListColumn0.Item.Text = "DeviceIcon";
dSkinGridListColumn0.Item.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
dSkinGridListColumn0.DockStyle = DockStyle.Fill;
dSkinGridListColumn0.Name = "DeviceIcon";
dSkinGridListColumn0.Visble = true;
dSkinGridListColumn0.Width = 25;
dSkinGridListColumn0.DataPropertyName = "Column_Icon";
dSkinGridListColumn1.Item.Font = new System.Drawing.Font("宋体", 9F);
dSkinGridListColumn1.Item.ForeColor = System.Drawing.Color.Black;
dSkinGridListColumn1.Item.InheritanceSize = new System.Drawing.SizeF(0F, 1F);
dSkinGridListColumn1.Item.Location = new System.Drawing.Point(0, 0);
dSkinGridListColumn1.Item.Name = "";
dSkinGridListColumn1.Item.Size = new System.Drawing.Size(40, 22);
dSkinGridListColumn1.Item.Text = "Device名称";
dSkinGridListColumn1.Item.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
dSkinGridListColumn1.DockStyle = DockStyle.Left;
dSkinGridListColumn1.Name = "Device名称";
dSkinGridListColumn1.Visble = true;
dSkinGridListColumn1.Width = 180;
dSkinGridListColumn1.DataPropertyName = "Column_Name";
dSkinGridListColumn11.Item.Font = new System.Drawing.Font("宋体", 9F);
dSkinGridListColumn11.Item.ForeColor = System.Drawing.Color.Black;
dSkinGridListColumn11.Item.InheritanceSize = new System.Drawing.SizeF(0F, 1F);
dSkinGridListColumn11.Item.Location = new System.Drawing.Point(0, 0);
dSkinGridListColumn11.Item.Name = "";
dSkinGridListColumn11.Item.Size = new System.Drawing.Size(40, 22);
dSkinGridListColumn11.Item.Text = "DeviceID";
dSkinGridListColumn11.Item.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
dSkinGridListColumn11.DockStyle = DockStyle.Left;
dSkinGridListColumn11.Name = "DeviceID";
dSkinGridListColumn11.Visble = true;
dSkinGridListColumn11.Width = 180;
dSkinGridListColumn11.DataPropertyName = "Column_Name";
dSkinGridList_DLNA.RowHeight = 25;
dSkinGridList_DLNA.ColumnHeadersVisible = false;
//设置透明
dSkinGridList_DLNA.BackColor = Color.Transparent;
dSkinGridList_DLNA.DoubleItemsBackColor = Color.Transparent;
dSkinGridList_DLNA.SingleItemsBackColor = Color.Transparent;
DSkinLinearGradientBrush dSkinLinearGradientBrush1 = new DSkinLinearGradientBrush();
dSkinGridList_DLNA.ColumnHeaderBrush = dSkinLinearGradientBrush1;
dSkinGridList_DLNA.Columns.AddRange(new DSkinGridListColumn[] {
dSkinGridListColumn0,
dSkinGridListColumn1,
dSkinGridListColumn11
});
}