xcanel

---表名比对SELECT t.name,s.name FROM leatest.dbo.sysobjects t full join les_server.dbo.sysobjects s on t.name=s.nameWHERE t.xtype='U' and t.category =0--and s.xtype='U' and s.category =0order by t.name --列比较select aa.*,bb.* from (select ss.name,sj.name as TableName from leatest.dbo.sysco Read More

select ROW_NUMBER() OVER (order by Id DESC) as aa Read More

<asp:GridView ID="gv_Result" runat="server" AutoGenerateColumns="False" DataKeyNames="plantcode" >添加：DataKeyNames="plantcode" Columns> <asp:TemplateField HeaderText="Select"> <EditItemTemplate> <asp:CheckBox ID=" Read More

1.因为IIS 7默认没有提供对*.svc的扩展映射, 所以需要通过WCF的ServiceModelReg.exe注册.Run as administrator cmd"%windir%\Microsoft.NET\Framework\v3.0\Windows Communication Foundation\ServiceModelReg.exe" -r -y安装完成可以在 处理程序映射 里看到 svc的映射2.如果是添加虚拟目录 需要转换成应用程序 (才可以设置应用程序池)3.选择 对应的 应用程序池 的高级设置 把 "启用32位应用程序" fals Read More

使用消息队列的时候需要通过控制面板 安装删除程序添加windows消息队列.不然无法使用.public bool OperateDB(string sqlString, out string systemState) { bool result = false; systemState = "10000"; if (!string.IsNullOrEmpty(sqlString)) { try { //设置消息队列 string strSMessageName = ConfigurationManager.AppSettings["SMessageName&quo Read More

#region 设置消息显示加粗 /// <summary> /// 设置消息显示加粗 /// </summary> /// <param name="textBox"></param> /// <returns></returns> public RichTextBox SetFontColor(RichTextBox textBox) {textBox.Font = new Font(textBox.Font, textBox.Font.Style | FontStyle.Regular);//定义 Read More

#region Method for InsertSqLBuilder //构建InsertSqLBuilder /// <summary> /// 构建InsertSqLBuilder /// </summary> /// <param name="dataTable">数据表</param> /// <param name="dataConnParm">数据连接参数</param> /// <returns></returns> public string Read More

// Get default databaseDatabase database = DatabaseFactory.CreateDatabase();// Read all the customers in a datasetstring selectSql = "SELECT * FROM Customers";DataSet customerDataSet = database. ExecuteDataSet(CommandType.Text, selectSql);// Modify Recordsforeach (DataRow dr in customerDat Read More

#region Method for ExcelFileIsOpen //Excle文件是否打开判断 /// <summary> /// Excle文件是否打开判断 /// </summary> /// <param name="excelFileName">Excle文件名称(不包含路径)</param> /// <returns></returns> public bool ExcelFileIsOpen(string excelFileName) { bool result = false; // Read More

才开始几天工作，要了解公司的.NET框架，看得人头都大了。 还得加油才可以呀~```有很多东西要学。REMOTE还要看！努力了！！！ Read More