文章分类 - C#
摘要：无色 = -4142,自动 = -4105,黑色 = 1,褐色 = 53,橄榄 = 52,深绿 = 51,深青 = 49,深蓝 = 11,靛蓝 = 55,灰色80 = 56,深红 = 9,橙色 = 46,深黄 = 12,绿色 = 10,青色 = 14,蓝色 = 5,蓝灰 = 47,灰色50 = 16,红色 = 3,浅橙色 = 45,酸橙色 = 43,海绿 = 50,水绿色 = 42,浅蓝 = 41,紫罗兰 = 13,灰色40 = 48,粉红 = 7,金色 = 44,黄色 = 6,鲜绿 = 4,青绿 = 8,天蓝 = 33,梅红 = 54,灰色25 = 15,玫瑰红 = 38,茶色 = 40,浅
阅读全文
摘要：//定义拼音区编码数组 private static int[] getValue = new int[] { -20319,-20317,-20304,-20295,-20292,-20283,-20265,-20257,-20242,-20230,-20051,-20036, -20032,-20026,-20002,-19990,-19986,-19982,-19976,-19805,-19784,-19775,-19774,-19763, -19756,-19751,-...
阅读全文
摘要：DateTime dt = DateTime.Now;Label1.Text = dt.ToString();//2005-11-5 13:21:25Label2.Text = dt.ToFileTime().ToString();//127756416859912816Label3.Text = dt.ToFileTimeUtc().ToString();//127756704859912816Label4.Text = dt.ToLocalTime().ToString();//2005-11-5 21:21:25Label5.Text = dt.ToLongDateString().To
阅读全文
摘要：private void WindowShowHide() { if (this.WindowState == FormWindowState.Normal) { Point cursorPoint = new Point(Cursor.Position.X, Cursor.Position.Y); Rectangle rectgle = new Rectangle(this.Left, this.Top, this.Left + this.Width, this.Top + ...
阅读全文
摘要：lvStartItems为listview控件#region 获取注册表名和值 private void GetStartItemsName() { RegistryKey regKey = Registry.LocalMachine; using (RegistryKey startKey = regKey.OpenSubKey(startString, true)) { string[] arrStartItems = startKey.GetValueNames()...
阅读全文
摘要：方法一： /// <summary> /// 把数据库的数据导出到Excel ，不会出现导出遇到格式的问题 /// </summary> /// <param name="dt">DataTable</param> /// <param name="strName">Sheet的名称</param> /// <param name="strColumnName">要导出的列明</param> /// 格式string[,] strColum
阅读全文
摘要：方法一：/// 将图片插入到指定的单元格位置，并设置图片的宽度和高度。 /// 注意：图片必须是绝对物理路径 /// </summary> /// <param name="RangeName">单元格名称，例如：B4</param> /// <param name="PicturePath">要插入图片的绝对路径。</param> public void InsertPicture(string RangeName, Excel._Worksheet sheet, string Picture
阅读全文
摘要：方法一： 也是广为人知的一种： YourDataTable.Columns.Remove("列名"); 但是这种情况只适合于去掉很少列的情况。 如果有很多列我却只要一两列呢，那就得用方法二了。方法二： DataTable dat = YourDataTable.DefaultView.ToTable(false, new string[] { "你要的列名", "你要的列名" });补加dataTable操作相关内容：对DataTable的一些操作在dataTable中最容易想到的是用for循环来操作，但事实不到万不得已是不会用for
阅读全文
摘要：staticvoid Main(string[] args) { GenerateHTML(); ProcessStartInfo startInfo =new ProcessStartInfo("IExplore.exe"); startInfo.Arguments = Environment.CurrentDirectory +"\\index.html"; Process process1 =new Process(); process1.StartInfo = startInfo; process1.Start(); }static void G
阅读全文
摘要：今天用到了CheckedListBox，就见到总结一下常用的知识。1、添加项：Items.AddcheckedListBox1.Items.Add("June");checkedListBox1.Items.Add("Jun");复制代码2、判断第i项是否选中GetItemChecked(index)checkedListBox1.GetItemChecked(i)3、设置第i项是否选中SetItemChecked(index，bool)或者SetItemCheckState(index,CheckState）checkedListBox1.SetIte
阅读全文
摘要：出现这个问题【线程间操作无效: 从不是创建控件“listview”的线程访问它】，用下面这个方法delegate void WriteMessage(string str); //写信息 //设置操作信息 private void SetListBoxMsg(string str) { if (this.lbMsg.InvokeRequired) { WriteMessage wm = new WriteMessage(SetListBoxMsg); ...
阅读全文
摘要：出现这个问题【线程间操作无效: 从不是创建控件“listview”的线程访问它】用下面这种方法 string Temp1 = "", Temp2 = ""; delegate void GetMessage(int rows); //定义一个委托 //获取ListView值 private void GetListViewValue(int rows) { ListViewItem lvi = new ListViewItem(); if (this.lvAccount.InvokeRe...
阅读全文
摘要：public bool AddMuch(DataTable dt){ try { SqlBulkCopy sqlBulk = new SqlBulkCopy(SQLHelperTQOA.connectionString, SqlBulkCopyOptions.UseInternalTransaction); sqlBulk.NotifyAfter = dt.Rows.Count; sqlBulk.DestinationTableName = "Yugu"; sqlBulk.ColumnMappings.Add("ShopID", "ShopID
阅读全文
摘要：protected void Button1_Click(object sender, EventArgs e) {StreamReader sr = new StreamReader(new FileStream(@"D:\test.txt", FileMode.Open, FileAccess.Read), System.Text.Encoding.Default); SqlConnection sqlcon = new SqlConnection("server=.;database=TM_pos;uid=sa;pwd=123"); string
阅读全文
摘要：OpenFileDialog ofd = new OpenFileDialog(); ofd.InitialDirectory = Environment.CurrentDirectory; ofd.Filter = "txt files (*.txt)|*.txt"; if (ofd.ShowDialog() == DialogResult.OK) { string fileName = ofd.FileName; string strline = ""; using (StreamReader sr = new StreamReader(fileNa
阅读全文