亚洲香蕉成人av网站在线观看_欧美精品成人91久久久久久久_久久久久久久久久久亚洲_热久久视久久精品18亚洲精品_国产精自产拍久久久久久_亚洲色图国产精品_91精品国产网站_中文字幕欧美日韩精品_国产精品久久久久久亚洲调教_国产精品久久一区_性夜试看影院91社区_97在线观看视频国产_68精品久久久久久欧美_欧美精品在线观看_国产精品一区二区久久精品_欧美老女人bb

首頁 > 學院 > 開發設計 > 正文

WinForm常用代碼

2019-11-14 16:51:02
字體:
來源:轉載
供稿:網友
//ToolStripSplitButton是標準按鈕和下拉按鈕的組合,各自工作,但有聯系,感覺上后者是沒有向下箭頭ToolStripDropDownButton;
ToolStripDropDownButton只含有一個按鈕,可以選擇有沒有向下箭頭的標志,單擊時顯示關聯的 ToolStripDropDown 的控件。兩者均可改變箭頭標志在做還是在右。//VS自帶雙緩沖this.SetStyle(ControlStyles.UserPaint | ControlStyles.AllPaintingInWmPaint |ControlStyles.OptimizedDoubleBuffer, true);//控件雙緩沖Control.DoubleBuffered=true; //attribute modfied by PRotected//手工雙緩沖Bitmap bmp = new Bitmap(600, 600);Graphics g = Graphics.FromImage(bmp);g.DrawLine();this.CreateGraphics().DrawImage(bmp, 0, 0);//這句是關鍵,不能?在OnPaint里畫BitBmp在這里調InvalidateInvalidate(Rectangle)//規定區域重繪,解決閃爍的另一種方法ComboBox ComboBox1 = (ComboBox) sender;(Sender as SomeObject).Method()this.label1.Font = new System.Drawing.Font("微軟雅黑", 72F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));this.label1.Font = new Font("微軟雅黑", fontSize);//自定義控件背景透明SetStyle(ControlStyles.UserPaint, true);SetStyle(ControlStyles.SupportsTransparentBackColor, true);this.BackColor = Color.Transparent;//獲得程序集System.Reflection.Assembly assem = System.Reflection.Assembly.GetExecutingAssembly();//點移位Point.Offset(Point);Point.Offset(int,int);Rectangle.Contains(Point);//截獲標題欄消息,自畫標題欄using System.Runtime.InteropServices;using System.Drawing.Drawing2D;[DllImport("user32.dll")]private static extern IntPtr GetWindowDC(IntPtr hWnd);[DllImport("user32.dll")]private static extern int ReleaseDC(IntPtr hWnd, IntPtr hDC);private const int WM_NCPAINT = 0x0085;private const int WM_NCACTIVATE = 0x0086;private const int WM_NCLBUTTONDOWN = 0x00A1;protected override void WndProc(ref Message m){ base.WndProc(ref m); Rectangle vRectangle = new Rectangle((Width - 75) / 2, 3, 75, 25); switch (m.Msg) { case WM_NCPAINT: case WM_NCACTIVATE: IntPtr vHandle = GetWindowDC(m.HWnd); Graphics vGraphics = Graphics.FromHdc(vHandle); vGraphics.FillRectangle(new LinearGradientBrush(vRectangle, Color.Pink, Color.Purple, LinearGradientMode.BackwardDiagonal), vRectangle); StringFormat vStringFormat = new StringFormat(); vStringFormat.Alignment = StringAlignment.Center; vStringFormat.LineAlignment = StringAlignment.Center; vGraphics.DrawString("About", Font, Brushes.BlanchedAlmond, vRectangle, vStringFormat); vGraphics.Dispose(); ReleaseDC(m.HWnd, vHandle); break; case WM_NCLBUTTONDOWN: Point vPoint = new Point((int)m.LParam); vPoint.Offset(-Left, -Top); if (vRectangle.Contains(vPoint)) MessageBox.Show(vPoint.ToString()); break; }}Control.SuspendLayout;//在它和ResumeLayout之間的代碼不會引起Parent Control的重繪Control.AddRange(new Control[]{});//添加多個控件Control.ResumeLayout;// 在它和SuspendLayout之間的代碼不會引起Parent Control的重繪Button[] buttons = new Button[] {};//大膽地設類數組吧~Button.SetBounds(int,int,int,int);//設置Button的左、右、寬、高;//應該盡可能地用Anchor、Dock,特殊情況下用Layout事件Form.MdiParent=(Form);//設置MDI父窗口//Active事件里this.Hide()是正道Form.Show();Form.Text=”Mytext”;//這兩句的順序不能//static不能修飾臨時變量,一般用來修飾類變量(不是類的對象實例變量!?。。〧orm.MdiParent = this;Form.TopLevel = true;Form.IsMdiContainer= true;Form. ActivateMdiChild//sqlconnection連接字符串@"Data Source= ./SQLEXPRESS;AttachDBFilename=C:/../*.MDF;Integrated Security=True;User Instance=True"))//sqlconnection連接的基本步驟using System.Data.SqlClient;Dataset dataset = new DataSet();using (SqlConnection conn = new SqlConnection(@"Data Source= ./SQLEXPRESS;AttachDBFilename=C:/SQL Server 2000 Sample Databases/NORTHWND.MDF;Integrated Security=True;User Instance=True")){conn.Open();SqlDataAdapter adapter = new SqlDataAdapter(conn.CreateCommand()); adapter.SelectCommand.CommandText = "select * from customers";adapter.Fill(dataset);foreach (DataRow row in dataset.Tables[0].Rows){string item=row["ContactTitle"]+","+row["ContactName"]; listBox1.Items.Add(item);}}ListBox.Items.Add(new string)//ListBox添加項//創建DataSet中的記錄DataRow row = DataSet.Tables[0].NewRow();row["**"] =***;dataset.Tables[0].Rows.Add(row);//更新DataSetDataRow row=DataSet.Table[0].Rows[index];row[“***”]=***;//刪除DataSet中的記錄DataSet.Tables[0].Rows.Remove(DataSet.Table[0].Rows[index]);//DataRow.Delete()和DataSet.Tables[0].Rows.Remove()不一樣,后者是從DataSet中徹底刪除DataRow row=DataSet.Table[0].Rows[index];row[“***”]=***;row.delete();TYPE varable=row[“***”,DataRowVersion.Original]// DataRow的完整訪問方式和DataRow.RowStateSwitch (row.RowState){case DataRowState.Deleted: row["***", DataRowVersion.Original]; case DataRowState.Added: row["["***"] case DataRowState.Modified: row["***", DataRowVersion.Original] row["***", DataRowVersion.Current]case DataRowVersion.Unchanged: row["***"]}//獲取部分特定狀態的數據集DataTable modifiedTable = DataSet.Tables[0].GetChanges(DataRowState.Added| DataRowState.Modified| DataRowState.Deleted);//創建數據庫查詢連接適配器的幾種方式SqlDataAdapter adapter = new SqlDataAdapter("select * from TABLENAME", SqlConnection); //最簡單SqlDataAdapter adapter = new SqlDataAdapter(SqlConnection.CreateCommand());adapter.SelectCommand.CommandText = "select * from TABLENAME ";SqlDataAdapter adapter = new sqldat SqlDataAdapter();adapter.SelectCommand = new SqlCommand("select * from TABLENAME ", SqlConnection);//萬能的數據集更新器SqlCommandBuilderSqlDataAdapter adapter = new SqlDataAdapter("select * from TABLENAME ", SqlConnection);new SqlCommandBuilder(adapter);try{adapter.Update(modifiedDataSet);PoulateListBox();}catch (System.Exception ex){}//多表數據集建議分別創建適配器SqlDataAdapter adapter1 = new SqlDataAdapter("select * from TABLENAME", SqlConnection); adapter1.Fill(DataSet,”TABLENAME1”);SqlDataAdapter adapter2 = new SqlDataAdapter("select * from TABLENAME", SqlConnection); adapter2.Fill(DataSet,”TABLENAME2”);////Make some changes to the DataSet .TABLENAME1 or DataSet .TABLENAME2//new SqlCommandBuilder(adapter1);adapter1.Update(DataSet,” TABLENAME1”);new SqlCommandBuilder(adapter2);adapter2.Update(DataSet,” TABLENAME2”);//創建DataSet自帶約束UniqueConstraint constrint = new UniqueConstraint(DataTable.Columns["***"]);//唯一性約束DataTable.Constraints.Add(constrint);//外鍵約束:ForeignKeyConstraint//關系基于兩張表的兩個列上,添加于兩張表共屬的數據集,并且自動生成分別在兩個表上生成UniqueConstraint 和ForeignKeyConstraintDataRelation relation = new DataRelation("CustomersOrders", DataTable.Columns["***"], DataTable.Columns["***"]);dataset.Relations.Add(relation);Form.Modal//判斷顯示方式是模式還是非模式,模式為true,非模式為false,只有在Load事件中和之后該屬性才有實際意義,在構造期間默認為falsemyForm.Control1.Text=”Data put in by a user”;//這樣不好,封裝性不強不易維護更新,用下面的pulbic String Control1Text{ get{ return Control1.Text;}Set{ Control1.Text;=value;}}//…myForm. Control1Text=” Data put in by a user”;//DialogResult res=ShowDialog()只是獲取對話框結果的快捷方式,完整方式如下void someButton_Click(object sender,EventArgs e){this.DialogResult=DialogResult.Retry; this.close();}someForm=new someForm();someForm.showDialog();DialogResult ref= someForm .DialogResult;if(ref= DialogResult.Retry)//…string path =Directory.GetCurrentDirectory();System.IO.FileStream aFile = new System.IO.FileStream(path, FileMode.Open);StreamReader sr = new StreamReader(aFile, System.Text.Encoding.Default);/*對于每個關聯的 SqlConnection,一次只能打開一個 SqlDataReaderSqlConnection 與 SqlDataAdapter 和 SqlCommand 一起使用,可以在連接 Microsoft SQL Server 數據庫時提高性能。對于所有第三方 SQL 服務器產品以及其他支持 OLE DB 的數據源,請使用 OleDbConnection。SqlConnection 超出范圍,則不會將其關閉。因此,必須通過調用 Close 或 Dispose 顯式關閉該連接。最好在using 塊內部打開連接。連接自字符串關鍵字不區分大小寫,并將忽略鍵/值對之間的空格。 不過,根據數據源的不同,值可能是區分大小寫的。 任何包含分號、單引號或雙引號的值必須用雙引號引起來。*/System.Data.SqlClient.SqlConnectionStringBuilder builder =new System.Data.SqlClient.SqlConnectionStringBuilder();builder["Data Source"] = "(local)";builder["integrated Security"] = true;builder["Initial Catalog"] = "AdventureWorks;NewValue=Bad";// 使用System.Data.SqlClient.SqlConnectionStringBuilder不需要擔心分號、單引號或雙引號的轉義問題Console.WriteLine(builder.ConnectionString);//打開數據庫的某個古老方法SqlConnection mc=new SqlConnection();mc.ConnectionString=”/*…*/”;mc.Open();//有關SqlCommand, SqlDataReader的基本使用SqlCommand scm=SqlConnection.CreateCommand();scm.CommandText=”select */*…*/”;SqlDataReader sdr=scm.ExecuteReader();sdr.Read();//…sdr.close();//以ToolStrip為例繪制簡便背景e.Graphics.FillRectangle(new System.Drawing.Drawing2D.LinearGradientBrush(new System.Drawing.Point(0, toolStrip1.Height),new System.Drawing.Point(0, 0), Color.FromKnownColor(KnownColor.ControlDark), Color.FromKnownColor(KnownColor.ControlLight)), toolStrip1.ClientRectangle);//獲取Color的幾種方式Color.FromKnownColor(KnownColor.ControlLight);Color.FromArgb(int r,int g,int b);Color.FromArgb(int a,int r,int g,int b);//a表示透明度,0-255,0為全透明,255為不透明,

 

/*

如果安裝時,改了實例名,也就是命名實例,那么客戶端在連接時,要使用機器名加實例名來進行標識:計算機名/實例名。

*/

 

//This table shows all connection string properties for the ADO.NET SqlConnection object. Most of the properties are also used in ADO. All properties and descriptions is from msdn.

Name

Default

Description

application Name

 

The name of the application, or '.Net SqlClient Data Provider' if no application name is provided.

AttachDBFilename
-or-
extended properties
-or-
Initial File Name

 

The name of the primary file, including the full path name, of an attachable database. The database name must be specified with the keyWord 'database'.

Connect Timeout
-or-
Connection Timeout

15

The length of time (in seconds) to wait for a connection to the server before terminating the attempt and generating an error.

Connection Lifetime

0

When a connection is returned to the pool, its creation time is compared with the current time, and the connection is destroyed if that time span (in seconds) exceeds the value specified by connection lifetime. Useful in clustered configurations to force load balancing between a running server and a server just brought on-line.

Connection Reset

'true'

Determines whether the database connection is reset when being removed from the pool. Setting to 'false' avoids making an additional server round-trip when obtaining a connection, but the programmer must be aware that the connection state is not being reset.

Current Language

 

The SQL Server Language record name.

Data Source
-or-
Server
-or-
Address
-or-
Addr
-or-
Network Address

 

The name or network address of the instance of SQL Server to which to connect.

Enlist

'true'

When true, the pooler automatically enlists the connection in the creation thread's current transaction context.

Initial Catalog
-or-
Database

 

The name of the database.

Integrated Security
-or-
Trusted_Connection

'false'

Whether the connection is to be a secure connection or not. Recognized values are 'true', 'false', and 'sspi', which is equivalent to 'true'.

Max Pool Size

100

The maximum number of connections allowed in the pool.

Min Pool Size

0

The minimum number of connections allowed in the pool.

Network Library
-or-
Net

'dbmssocn'

The network library used to establish a connection to an instance of SQL Server. Supported values include dbnmpntw (Named Pipes), dbmsrpcn (Multiprotocol), dbmsadsn (Apple Talk), dbmsgnet (VIA), dbmsipcn (Shared Memory) and dbmsspxn (IPX/SPX), and dbmssocn (TCP/IP).
The corresponding network DLL must be installed on the system to which you connect. If you do not specify a network and you use a local server (for example, "." or "(local)"), shared memory is used.

Packet Size

8192

Size in bytes of the network packets used to communicate with an instance of SQL Server.

Password
-or-
Pwd

 

The password for the SQL Server account logging on.

Persist Security Info

'false'

When set to 'false', security-sensitive information, such as the password, is not returned as part of the connection if the connection is open or has ever been in an open state. Resetting the connection string resets all connection string values including the password.

Pooling

'true'

When true, the SQLConnection object is drawn from the appropriate pool, or if necessary, is created and added to the appropriate pool.

User ID

 

The SQL Server login account.

Workstation ID

the local computer name

The name of the workstation connecting to SQL Server.

 

 


發表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發表
亚洲香蕉成人av网站在线观看_欧美精品成人91久久久久久久_久久久久久久久久久亚洲_热久久视久久精品18亚洲精品_国产精自产拍久久久久久_亚洲色图国产精品_91精品国产网站_中文字幕欧美日韩精品_国产精品久久久久久亚洲调教_国产精品久久一区_性夜试看影院91社区_97在线观看视频国产_68精品久久久久久欧美_欧美精品在线观看_国产精品一区二区久久精品_欧美老女人bb
日本道色综合久久影院| 亚洲成avwww人| 国产日韩在线精品av| 一区二区三区www| 国产精品日韩av| 日韩精品视频在线观看网址| 国产精品成人aaaaa网站| 色老头一区二区三区| 成人羞羞国产免费| 黄色精品一区二区| yw.139尤物在线精品视频| yw.139尤物在线精品视频| 国产婷婷色综合av蜜臀av| 国产精品福利观看| 成人在线中文字幕| 日韩美女免费观看| 久久久久久久久久久免费精品| 国产国语刺激对白av不卡| 高清在线视频日韩欧美| 久久人人爽人人爽爽久久| 亚洲免费视频观看| 国产免费一区二区三区在线能观看| 日韩视频中文字幕| 在线视频免费一区二区| 日本伊人精品一区二区三区介绍| 亚洲欧美日韩视频一区| 欧美电影在线播放| 欧美俄罗斯性视频| 丰满岳妇乱一区二区三区| 国产精品久久久久久搜索| 国产成人欧美在线观看| 精品无人国产偷自产在线| 久久久在线观看| 欧美在线视频一区二区| 3344国产精品免费看| 国产日韩欧美日韩大片| 日韩在线播放av| 亚洲男人av在线| 91色视频在线导航| 久久韩国免费视频| 成人免费看吃奶视频网站| 久久综合久久八八| 久久精品成人欧美大片古装| 欧美成人一二三| 久久九九热免费视频| 欧美国产中文字幕| 亚洲最大av网站| 亚洲精品美女视频| 亚洲欧美一区二区精品久久久| 亚洲人成在线观看| 日韩欧美成人免费视频| 亚洲热线99精品视频| 亚洲成人精品视频| 91国产美女在线观看| 久久精品亚洲一区| 日韩免费精品视频| 精品一区二区三区三区| 奇米4444一区二区三区| 欧美日韩国产在线| 亚洲精品永久免费精品| 日韩精品在线免费| 91亚洲国产成人久久精品网站| 91国产高清在线| 日韩免费高清在线观看| 黑人巨大精品欧美一区免费视频| 亚洲国产小视频在线观看| 国产精品99久久久久久久久| 欧美精品18videos性欧美| 日韩中文字幕视频在线观看| 日韩中文字幕在线免费观看| 国产午夜精品美女视频明星a级| 国产成人精品日本亚洲专区61| 久久影视三级福利片| 国产精品免费久久久久久| 另类色图亚洲色图| 欧美激情区在线播放| 欧美日韩亚洲一区二区三区| 欧美丝袜一区二区三区| 国产精品第三页| 成人免费视频97| 亚洲高清久久久久久| 欧美成aaa人片免费看| 国产精品一区二区三区毛片淫片| 欧美最猛性xxxxx亚洲精品| 久久精品国产清自在天天线| 4438全国成人免费| 久热精品视频在线| 亚洲欧美制服第一页| 欧美激情在线观看视频| 日韩中文字幕第一页| 欧美精品激情在线观看| 久久久噜噜噜久久| 日韩在线视频免费观看| 亚洲国产美女久久久久| 日韩精品亚洲元码| 国产精品亚洲一区二区三区| 亚洲人成毛片在线播放| 久久天堂电影网| www.亚洲免费视频| 国产欧美最新羞羞视频在线观看| 久久91亚洲精品中文字幕| 国产精品国产三级国产专播精品人| 国产亚洲视频中文字幕视频| 国产成人在线一区| 亚洲色图欧美制服丝袜另类第一页| 亚洲成色www8888| 亚洲欧美日韩久久久久久| 国产一区二区在线播放| 欧美国产激情18| 国产精品pans私拍| 亚洲精品综合精品自拍| www.亚洲男人天堂| 中文字幕日韩av| 亚洲成在人线av| 欧美激情精品在线| 久久久久久久久国产| 国产精品日本精品| 国产精品91在线观看| 欧美老女人www| 黑人狂躁日本妞一区二区三区| 国产一区av在线| 亚洲片国产一区一级在线观看| 久久香蕉频线观| 精品视频在线播放色网色视频| 亚洲成色www8888| 黑人与娇小精品av专区| 亚洲欧美中文字幕| 日韩中文字幕在线免费观看| 高清在线视频日韩欧美| 26uuu久久噜噜噜噜| 91av福利视频| 久久中文精品视频| 日韩高清欧美高清| 日韩在线中文字幕| 欧美成人黑人xx视频免费观看| 久久久日本电影| 亚洲国产精品资源| 亚洲国产女人aaa毛片在线| 97久久精品人搡人人玩| 亚洲高清不卡av| 91在线观看免费网站| 97精品国产97久久久久久免费| 欧美精品激情在线观看| 精品呦交小u女在线| 色偷偷偷亚洲综合网另类| 成人夜晚看av| 国产精品毛片a∨一区二区三区|国| 久久精品一本久久99精品| 一本一本久久a久久精品牛牛影视| 欧美精品videossex88| 亚洲成人激情视频| 亚洲欧美一区二区三区情侣bbw| 国产精品久久久久久久久免费看| 91精品国产高清自在线| 国产一区二区视频在线观看| 精品久久久久久亚洲精品| 国产精品亚发布| 亚洲天堂免费视频| 久久影视三级福利片| 在线视频日本亚洲性| 欧美一级高清免费播放| 日韩av手机在线观看| 亚洲激情视频在线播放| 日韩福利伦理影院免费|