摘要:
1./// /// DataTable批量添加(有事务) /// /// 数据源 /// 定义数据源和目标源列的关系集合 /// 目标表 public static bool MySqlBulkCopy(DataTable Table, SqlBulkCopyColumnMapping[] Mapping, string DestinationTableName) { bool Bool = true; using (SqlConnection con = new SqlConnection(ConnectionString)) { con.Open(); using (SqlTransa.. 阅读全文
摘要:
public string CreateWordFile() { string message = ""; try { Object Nothing = System.Reflection.Missing.Value; Directory.CreateDirectory("D:/CNSI"); //创建文件所在目录 string name = "CNSI_" + DateTime.Now.ToLongDateString... 阅读全文
摘要:
客户端获取运营商 会弹出安全隐患问题,需要修改IE activx 选项, 非常麻烦,用我的代码可以轻松获取。 阅读全文
摘要:
C#获取指定网页HTML原代码可使用WebClientWebRequestHttpWebRequest 三种方式来实现。当然也可使用webBrowse!在此就不研究webBrowse如何获取了。WebClientprivate string GetWebClient(string url){ string strHTML = ""; WebClient myWebClient = new WebClient(); Stream myStream = myWebClient.OpenRead(url); StreamReader sr = new StreamReader(m 阅读全文
摘要:
protected void Page_Load(object sender, EventArgs e) { InvokeSystemPS("query user /server:192.168.1.222"); //test(); ... 阅读全文
摘要:
/// /// 获取客户端外网IP,省份,城市,运营商 /// 2012年12月18日 15:07 /// public class GetOutMessage { /// /// 获取全部信息 /// /// 一段网页代码 private static string getOutMessage() { WebClient client = new WebClient(); client.Credentials = CredentialCache.DefaultCredentials; client.Headers.Set("User-Agent", "Micro 阅读全文
摘要:
public void AutoPost(string url,string domain, string userName) { AlipayProxy.UserReg.UserReg userRegService = new AlipayProxy.UserReg.UserReg(); string password = userRegService.GetUserPassWord(userName); string language = "zh-cn"; string key = ... 阅读全文
摘要:
javascript:document.getElementById('user').value='jack';document.getElementById('password').value='test';submitForm();void(0); 阅读全文
摘要:
USE [AppCloud]GO/****** Object: UserDefinedFunction [dbo].[splitstr] Script Date: 12/19/2013 09:33:07 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCreate function [dbo].[splitstr](@SourceSql varchar(8000),@StrSeprate varchar(5))returns @temp table(F1 varchar(2000))as begin declare ... 阅读全文
摘要:
select * from(select *, ROW_NUMBER() over(partition by IPAddress order by recordtime desc) as rowNumfrom MonitoringSystem) Awhere A.rowNum =@PreTime and IPAddress=@IPAddress order by RecordTime asc原表结构USE [SimCloudV3.1]GO/****** Object: Table [dbo].[MonitoringSystem] Script Date: 12/06/201... 阅读全文