C#ÖÐʹÓÃDataTableÏÔʾAccessÊý¾Ý¿âÖÐÎļþÁбí
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
this.comboBox2.Items.Clear();
switch(this.comboBox1.SelectedIndex)
{
case 0:
try
{
OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;User ID=admin;Data Source=C:\tmpAccess\DataBase1.mdb");
conn.Open();
if(conn.State == System.Data.ConnectionState.Open){
Console.WriteLine("Success");
}
DataTable test = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new Object[] { null, null, null, "Table" });
this.dataGridView1.DataSource =test;
int tableIndex = test.Columns.IndexOf("TABLE_NAME");
foreach (DataRow row in test.Rows)
comboBox2.Items.Add(row[tableIndex].ToString());
&nb
Ïà¹ØÎĵµ£º
ÎÞÂÛÔÚcmpp»òsgipÖУ¬¶¼»áÓöµ½¶ÌÐűàÂë¸ñʽת»»µÄÎÊÌâ¡£
ÒòΪÏÖÔÚ¶ÌÐűàÂë³£ÓõĸñʽÓÐÈýÖÖ£º0£ºASCII´®£¬8£ºUCS2±àÂ룬15£ºº¬GBºº×Ö¡£ÔÚ·¢ËÍ»ò½ÓÊÕ¶ÌÐÅʱ£¬¶¼»áÓõ½ÏàÓ¦µÄ±àÂëת»»¡£ÈçÒÔÏ´úÂ룺
public static String Decode(Byte[] buf, int StartIndex, int Length, CODING Coding)
{
......
1 ·ÀÖ¹sql×¢Èëʽ¹¥»÷(¿ÉÓÃÓÚUI²ã¿ØÖÆ£© #region ·ÀÖ¹sql×¢Èëʽ¹¥»÷(¿ÉÓÃÓÚUI²ã¿ØÖÆ£©
2
3 /**/ ///
4 /// ÅжÏ×Ö·û´®ÖÐÊÇ·ñÓÐSQL¹¥»÷´úÂë
5 ///
6 /// ´«ÈëÓû§Ìá½»Êý¾Ý
7 /// ......
Ribbon ÔÀ´³öÏÖÔÚ Microsoft Office 2007 µÄ Word¡¢Excel ºÍ Powerpoint 組¼þÖУ¬ºóÀ´Ò²±»ÔËÓõ½ Windows 7 µÄһЩ¸½¼Ó×é¼þµÈÆäËüÈí¼þÖУ¬Èç»Í¼ºÍд×Ö°å¡£ËüÊÇÒ»¸öÊÕ²ØÁËÃüÁî°´Å¥ºÍͼ±êµÄÃæ°å¡£Ëü°ÑÃüÁî×éÖ¯³ÉÒ»×é"±êÇ©"£¬Ã¿Ò»×é°üº¬ÁËÏà¹ØµÄÃüÁÿһ¸öÓ¦ÓóÌÐò¶¼ÓÐÒ»¸ö²»Í¬µÄ±êÇ©×飬չʾÁ˳ÌÐòËùÌṩ ......
Õâ¶Îʱ¼äÔÚ×öCMS£¨¿Í»§¹ÜÀíϵͳ£¬²»ÊÇÄÚÈݹÜÀí£©µÄ·ÃÎʹÜÀí¹¦ÄÜ£¬ÒªÇóʵÏÖ¶Ô·þÎñÌṩÉ豸£¬¿Í»§¶Ë£¬¼Æ·Ñ£¬È¨ÏÞÈÏÖ¤µÈÐÅÏ¢µÄ´æ´¢Í³¼Æ£¬Ô¶³Ì¹ÜÀí¡£ÒªÇóϵͳ·¢²¼Òª·½±ã£¬Ô¶³Ì¹ÜÀíÈí¼þÒªÅÜÔÚWINƽ̨¡£¿¼Âǵ½ÏµÍ³¹æÄ££¬¿Í»§ÒªÇó£¬×îºóÑ¡ÔñÁËWIN+ACCESSµÄ·½°¸£¬¶ø×î½üÓÖ·¢ÏÖÒ»¸öÃâ·ÑµÄSQLITE£¬¶øÇÒ¿ÉÄÜÔÚÒÔºóµÄÊÖ³ÖÉ豸ÉÏÓ㬻¨µã ......
MSSQL:
declare @begin datetime
declare @End datetime
set @begin=getdate()
--Ö´ÐеÄÓï¾äдÔÚÕâÀï
set @End=getdate()
select datediff(millisecond,@begin,@End) as Ö´ÐеÄʱ¼ä
--millisecond±íʾºÁÃë Èç¹û¿´Ãë¿ÉÒÔʹÓÃss
C#:
ºÜ¶àʱº ......