C#ÓëFirebird¿ª·¢ ²éѯ·µ»Ø±ðÃûÖÐÎÄ×Ö¶Î
×î½üÔÚæÓÚ ½«×âÁÞ¹ÜÀíϵͳmssqlÊý¾Ý¿âתÒÆÖÁfirebirdÊý¾Ý ÒÔ¼õÉٳɱ¾¸ºµ£ Õâ¸ö³£¼ûÎÊÌâ½â¾ö·½°¸Áô¸ø´ó¼Ò ÓиüºÃµÄ»òÕßƲש¿éµÄÀ´×Ų»¾Ü ºÇºÇ
MS-sqlÔÚͨ³£ C#´úÂëÀï ÎÒÃÇÌá½»Ò»¸ö²éѯ×Ö·û´® Ö»ÐèÈ磺 string sql=" select id ±àºÅ,[name] ÐÕÃû,sex ÐÔ±ð from users";
Ìá½»¼´¿É·µ»Øtable
µ«ÊÇÔÚ firebirdÔÚ×ֶΠÃüÃû»òÕß±ðÃû ¶¼±ØÐë¸øºº×Ö ¼ÓÉÏË«ÒýºÅ ²Å¿ÉÒÔʵÏÖÖÐÎÄÃüÃûµÄ×Ö¶Î
ÔÚC# дÉÏÕâÑùд¼´¿É string sql=" select id /"±àºÅ/",name /"ÐÕÃû/",sex /"ÐÔ±ð/" from users"; ¼ÓÒýºÅ²¢¼ÓÉÏתÒå×Ö·û¼´¿É
Ïà¹ØÎĵµ£º
Ò»¡¢³éÏóÀࣺ
³éÏóÀàÊÇÌØÊâµÄÀֻ࣬ÊDz»Äܱ»ÊµÀý»¯£»³ý´ËÒÔÍ⣬¾ßÓÐÀàµÄÆäËûÌØÐÔ£»ÖØÒªµÄÊdzéÏóÀà¿ÉÒÔ°üÀ¨³éÏó·½·¨£¬ÕâÊÇÆÕͨÀàËù²»Äܵġ£³éÏó·½·¨Ö»ÄÜÉùÃ÷ÓÚ³éÏóÀàÖУ¬ÇÒ²»°üº¬ÈκÎʵÏÖ£¬ÅÉÉúÀà±ØÐ븲¸ÇËüÃÇ¡£ÁíÍ⣬³éÏóÀà¿ÉÒÔÅÉÉú×ÔÒ»¸ö³éÏóÀ ......
------------------------
¡ï
Foreach £º
Óŵ㣺
1¡¢²»Óÿ¼ÂÇÊý×éÆðʼË÷ÒýÊǼ¸
int[] nArray = new int[100];
// Use "foreach" to loop array
foreach( int i in nArray )
2¡¢¶ÔÓÚ¶àάÊý×é²Ù×÷ÓÃforeach·Ç³£¼ò±ã
int[,] nVisited = new int[8,8];
// Use "for" to loop two-dimension array
for( int i = 0; i ......
¼Ì³ÐÊÇÅÉÉúÀࣨ×ÓÀࣩȥʵÏÖ£¨ÖØд<override>¡¢Öع¹<new>£©»ùÀࣨ¸¸ÀࣩµÄ·½·¨»òÊôÐÔ¡£´Ó¶ø»ñÈ¡ÔÚÅÉÉúÀàÖÐҪʵÏֵŦÄÜ¡£
×ÓÀàµ÷Óø¸À๹Ôì·½·¨£¬ÔÚ¸¸ÀàÖÐÓиöʵÏÖÐÕÃûºÍÄêÁäµÄ¹¹Ôì·½·¨µ«ÊÇÖÐ×ÓÀàҲҪʵÏÖÕâÑùµÄ¹¦ÄÜÕâʱ×ÓÀ಻ÓÃÔÙ´ÎȥдÕâ¸ö¹¦ÄÜֻҪȥµ÷Óø¸ÀàµÄ¹¦Äܼ´¿É¡£
public class Person
& ......
Ò»¡¢²åͼµÄÀࣨº¬2·½·¨£©
1using System;
2using System.Collections.Generic;
3using System.Text;
4//using Excel = Microsoft.Office.Interop.Excel;
5using Excel;
6using System.Windows.Forms;
7
8
9namespace ExcelReport
10{
11 class InsertPicToExcel
12 {
13 / ......