c# 笔记

最新推荐文章于 2023-10-17 16:40:14 发布

不断学习的ITer

最新推荐文章于 2023-10-17 16:40:14 发布

阅读量674

点赞数

分类专栏： .NET 文章标签： c# random string

本文链接：https://blog.csdn.net/wyqlxy/article/details/7498780

版权

.NET 专栏收录该内容

111 篇文章 2 订阅

订阅专栏

/ / 新增列（假数据）并且设置默认值
DataColumn dc = new DataColumn("机型",typeof(string));
dc.DefaultValue = "B737#1";

dstTrainPCode.Tables[0].Columns.Add(dc);

dstTrainPCode.Tables[0].Columns["机型"].SetOrdinal(0);//设置新增列在表中的位置

2.生成随机数：

long tick = DateTime.Now.Ticks;
Random rd = new Random((int)(tick & 0xffffffffL) | (int)(tick >> 32));
int Molecular= rd.Next(1, 10);

3.取得连续点击鼠标的时间间隔

int previousClick = SystemInformation.DoubleClickTime;

int now = System.Environment.TickCount;

if (now - previousClick <= SystemInformation.DoubleClickTime)
{
if (DoubleClick != null)
DoubleClick(this, EventArgs.Empty);
}

4.导入EXCEL到dataset

/// <summary>
/// 执行导入
/// </summary>
/// <param name="strFileName">文件名</param>
/// <returns>DataSet</returns>
private static DataSet doImportExcel(string strFileName,string sheetName)
{
string strConn;
if (strFileName == "")
return null;

strConn = "Provider=Microsoft.Ace.OleDb.12.0;Data Source='" + strFileName + "';Extended Properties='Excel 12.0';";
OleDbDataAdapter ExcelDA = new OleDbDataAdapter("SELECT * FROM ["+sheetName+"$]", strConn);
DataSet ExcelDs = new DataSet();
ExcelDA.Fill(ExcelDs);
return ExcelDs;
}