- 博客(33)
- 资源 (2)
- 收藏
- 关注
RSS订阅原创 sqlserver 各种
1.只取时间 只取日期select CONVERT(varchar(12) , getdate(), 108 ) 時間select CONVERT(varchar(12) , getdate(), 111 ) 2009/07/04 select CONVERT(varchar(12) , getdate(), 112 ) 20090704select CONVE
2012-01-05 15:28:49
293
原创 lamda表达式
List list = new List { new Person {Name="刘艳涓",Age=27,Sex=true,Address="龙步街" }, new Person {Name="刘嫦娥",Age=24,Sex=false,Address="龙步街" },
2012-01-04 18:07:58
474
原创 调用按钮事件
1. button8.Click += new EventHandler(button8_Click); button8_Click(null, null);2. button8.PerformClick();
2012-01-04 18:07:04
367
原创 匿名委托
Thread thread = new Thread(new ThreadStart(delegate() { for (int i = 0; i { Thread.Sleep(i);
2012-01-04 18:06:15
289
原创 T-Sql各种
1.循环插入数据declare @i intset @i=1while @ibegininsert into [Users](Name,Description,DeptId,Email)values('灰太郎','吃羊',1,'123@gmail.com')set @i=@i+1end2.随机选取N条数据SELECT TOP N * FROM 表
2012-01-04 17:54:28
248
原创 mysql各种
1.获取表的列数 select count(*) from information_schema.columns where table_name='表名';2.随即获取N条数据SELECT * FROM 表名 order by rand() limit N;3.数据库备份命令cmd 下mysqldump -uroot -p database名 > e:
2012-01-04 17:44:27
215
原创 xml序列化
<br />FSRItemManage.Save(ddp, "D://a.xml");<br /><br />HRExcelConfig hl = (HRExcelConfig)FSRItemManage.Load(typeof(HRExcelConfig), configFileName);<br /> public class FSRItemManage<br /> {<br /> /// <summary><br /> /// 指定オブジェクトの属性値をxmlフ
2011-02-25 10:14:00
440
原创 两个objec比较
<br /> public static bool Compare(Object objOld, Object objNew)<br /> {<br /> try<br /> {<br /> Type type = objOld.GetType();<br /> PropertyInfo[] infos = type.GetProperties(BindingFlags.Public
2011-02-24 11:42:00
339
原创 sqlite建库+各种
1. using (SQLiteConnection cn = new SQLiteConnection( "Data Source=D://test.db;Pooling=true;FailIfMissing=false") ) { cn.Open(); u
2011-02-24 11:41:00
486
原创 Stopwatch计时
System.Diagnostics.Stopwatch sw = new Stopwatch(); sw.Start(); 代码 sw.Stop(); Console.WriteLine("1---" + sw.ElapsedMilliseconds.ToStr
2011-02-24 11:41:00
259
原创 excel插入图片
<br />Range rangePicture = worksheet.get_Range("O7", Missing.Value);<br /> rangePicture.Select();<br /> Microsoft.Office.Interop.Excel.Pictures pics = (Microsoft.Office.Interop.Excel.Pictures)worksheet.Pictures(Missing.Value);
2011-02-24 11:40:00
457
原创 datatable to excel
<br /> 一行一行zhantie 到excel<br /> Range rangeRowStart;<br /> int startColumnIndex = 25;<br /> int startRowIndex = 12;<br /> for (int i = 0; i < dt.Rows.Count; i++)<br />
2011-02-24 11:39:00
498
原创 0 1PropertyGrid显示
[Browsable(true)] [DisplayName("属性指標値の有無")] public bool HAS_INDICATOR_BOOL { set { _has_indicator_bool = value;
2011-02-24 11:38:00
294
原创 treeview添加节点
private void tsbAdd_Click(object sender, EventArgs e) { try { if (trv.LabelEdit) { return; }
2011-02-24 11:35:00
432
原创 treeview字体扩大缩小
private void tsbZoomIn_Click(object sender, EventArgs e) { try { //字体を拡大する this.trv.Font = new System.Drawing.Font("MS UI Gothic",
2011-02-24 11:34:00
695
原创 DBHelper
<br />using System;<br />using System.Collections.Generic;<br />using System.Text;<br />using System.Data.SqlClient;<br />using System.Data;<br />using System.Configuration;<br />using MySql.Data.MySqlClient;<br />namespace Qa.DAL<br />{<br /> public st
2010-09-17 16:15:00
289
原创 DAL
<br />using System;<br />using System.Collections.Generic;<br />using System.Text;<br />using Qa.Models;<br />using MySql.Data.MySqlClient;<br /><br />namespace Qa.DAL<br />{<br /> public class QuestionService<br /> {<br /> public List<Question>
2010-09-17 16:14:00
453
原创 datagridview to textbox
using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;namespac
2010-09-14 13:29:00
246
原创 listbox to rictbox
<br />using System;<br />using System.Collections.Generic;<br />using System.ComponentModel;<br />using System.Data;<br />using System.Drawing;<br />using System.Text;<br />using System.Windows.Forms;<br />using System.Xml;<br />using System.Collections;<b
2010-09-14 13:05:00
293
原创 行标
private void dgv_CellPainting(object sender, DataGridViewCellPaintingEventArgs e) { if (e.ColumnIndex.Equals(-1) && e.RowIndex > -1) { //セルを描画する
2010-09-14 11:08:00
291
原创 复制粘贴
private void tsbCopy_Click(object sender, EventArgs e) { System.Windows.Forms.SendKeys.SendWait("^C"); } private void tsbPaste_Click(object sender, EventArgs e) { System.Windows.Forms.SendKeys.SendWait(
2010-09-10 09:46:00
241
原创 控件添加事件
public event EventHandler YearChange; private void numericUpDown4_ValueChanged(object sender, EventArgs e) { try { if (YearChange != null) { YearChange(this, new EventArgs());
2010-09-10 09:45:00
297
原创 提示
DialogResult result = MessageBox.Show("上書きしますか？", "確認", MessageBoxButtons.YesNoCancel); if (result.ToString() == "Yes") { if (System.IO.File.Ex
2010-09-10 09:45:00
280
原创 textbox输入数字
private void txtVaInt_KeyPress(object sender, KeyPressEventArgs e) { if ((e.KeyChar == 3) || (e.KeyChar == 24) || (e.KeyChar == 22)) { return;
2010-09-10 09:44:00
275
原创 xml序列化实现最近打开
string fileName = Application.StartupPath + "//RecentFiles.config"; if (System.IO.File.Exists(fileName)) { RecentFiles recnt = (RecentFiles)RecentFiles.Load(typeof(RecentFiles), fileName);
2010-09-10 09:44:00
265
原创 回复
using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using Qa.Models;using Qa.BLL;using QaModels;using QaBLL;namespace Qa{ public partial class WebForm2 : System.Web.UI.Page
2010-09-09 16:46:00
261
原创 图片
<br />using System;<br />using System.Collections.Generic;<br />using System.ComponentModel;<br />using System.Data;<br />using System.Drawing;<br />using System.Text;<br />using System.Windows.Forms;<br />using System.Collections;<br />namespace WindowsAp
2010-09-09 16:46:00
240
原创 date
using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using MySql.Data.MySqlClient;using System.Data.SqlClient;namespace data{ public partial class F
2010-09-09 16:45:00
219
原创 gridview
DataNavigateUrlFormatString="WebForm2.aspx?id={0}" DataTextField="Questionname" HeaderText="??">
2010-09-09 16:45:00
260
原创 chart
ctKT.DataSource = bcmdp.GetKTDataTable(_sdt, _edt, _id); ctKT.Series[0].XValueMember = DATE; ctKT.Series[0].YValueMembers = VALUE;public enum BTType { None, K, P, BP, W } private BTTy
2010-09-09 11:04:00
345
原创 排序
using System;using System.Collections.Generic;using System.Text;using System.Collections;namespace Sort{ public class Class2 : IComparable { private ArrayList column1; public ArrayList Column1 { get {
2010-09-09 10:43:00
188
原创 拖拽
private void MainForm_DragOver(object sender, DragEventArgs e) { //ファイル以外は受け付けない e.Effect = DragDropEffects.None; //ドラッグされたデータ形式を調べ、ファイルのときはコピーとする //コントロール内にドラッグされたとき実行される if (e.Data.GetD
2010-09-09 10:41:00
347
MathParser.dll
2011-05-19
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人