![](https://img-blog.csdnimg.cn/20201014180756738.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
C#
文章平均质量分 54
丫头爱剑剑
这个作者很懒,什么都没留下…
展开
-
c# excel插入图表
c# excel插入柱状图原创 2022-09-07 09:54:03 · 1039 阅读 · 1 评论 -
c# copy文件夹
private void CopyDirectory(string srcdir, string desdir){if (srcdir.LastIndexOf("\") == (srcdir.Length - 1)){srcdir = srcdir.Substring(0, srcdir.Length - 1);}string folderName = srcdir.Substring(srcdir.LastIndexOf("\") + 1); string desfolderd原创 2021-07-09 10:49:23 · 480 阅读 · 0 评论 -
c# Datatable批量写入数据库
DataTable dTable = new DataTable(“Table_RowData”);dTable.Columns.Add(“SerialNo”, typeof(String));dTable.Columns.Add(“DUT”, typeof(String));dTable.Columns.Add(“HardBinNo”, typeof(String));dTable.Columns.Add(“SWBin”, typeof(String));dTable.Columns.Add(“原创 2021-06-21 15:49:16 · 401 阅读 · 1 评论 -
C# FTP上传--FtpWebRequest
参考文档:http://cache.baiducontent.com/c?m=s0cZ8DUsvIKSqpZ31zPM70S7XphWku2wLcqUqpjxkCb8MktcgKRalco_bAWz93SJ8GLBjmKOwzBZs6GIcR8qQyympXkQdtRz5z3LIYXzelbB5Lut8fdbGOHXtSQSvoyz_8_RM6lOhc0ee6sfAsARvf8CBGBcInReUJm0hPvb2Fm&p=9f3be75485cc43ea10bd9b7b16&newp=917原创 2021-03-02 15:04:54 · 692 阅读 · 0 评论 -
Sql 语句总结
1.删除表名中的ID字段alter table [tablename] drop column [ID]2.删除表table1中[DEVICE],[PKG],[SHOTNAME]重复的三个字段,留下ID最小的字段delete from table1 where [ID] Not in (select min([ID]) from table1 group by [DEVICE],[PKG],[SHOTNAME])3.删除表的数据且ID会重新从1开始自增truncate table tablenam原创 2021-02-22 11:52:54 · 119 阅读 · 0 评论 -
c# 按文件名大小排序
1.创建一个FileComparerusing System;using System.Collections;using System.IO;namespace CSV_combine_XLSX{class FileComparer : IComparer{int IComparer.Compare(object o1, object o2){//int result = (o1 as string).CompareTo((o2 as string));//return result原创 2021-02-19 14:28:27 · 454 阅读 · 0 评论 -
c# 连接Oracle数据库
string sql = "select * from TSBLCS_LOTRESULT;OracleConnection conn = new OracleConnection(“data source=数据库名;user id=用户名;password=密码”);conn.Open();OracleCommand cmd = new OracleCommand(sql, conn);cmd.CommandTimeout = 300;OracleDataAdapter sda = new Ora原创 2021-02-19 14:12:28 · 155 阅读 · 0 评论 -
c# 连接sql server数据库
using System;using System.Data;using System.Data.SqlClient;using System.Text;namespace Yield_Limit_Import{class SQLHelper{SqlConnection conn = new SqlConnection(“server=IP地址;database=数据库名;uid=用户名;pwd=密码”);public void Connection(){conn.Open();}原创 2021-02-19 14:05:14 · 332 阅读 · 0 评论 -
c# 读写文件
c# 读写文件原创 2021-02-19 13:58:26 · 321 阅读 · 0 评论 -
c#日期和字符串之间的转换
字符串和时间的转换原创 2021-02-19 10:51:56 · 4063 阅读 · 0 评论 -
C# EXCEL操作
1.引用Microsoft.Office.Interop.ExcelMicrosoft.Office.Interop.Excel.Application excel= new Microsoft.Office.Interop.Excel.Application();//应用程序excel.Visible = false;//可见性,运行程序时不可看到excel表格excel.DisplayAlerts = false;//设置是否显示警告窗体Workbook wbk = excel.Workbook原创 2021-02-19 13:35:11 · 747 阅读 · 1 评论