Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

΢ÐÍORM——ÓÃVBºÍC#±àдµÄ¶¯Ì¬ÀàÐÍORM

      ½üÀ´ORM±äµÃÔ½À´Ô½ÆÕ±é£¬Õâ¶¼¹éÓÚÒ»Öֺܾß˵·þÁ¦µÄÔ­Òò£»Ëü¿ÉÒÔʹ¿ª·¢Êý¾Ý¿âÇý¶¯µÄÓ¦ÓóÌÐò±äµÃ¸ü¿ì¡¢¸üÊ¡Á¦¡£µ«ÊÇORM¿ò¼Ü¶¼Óе㓹ÌÖ´¼º¼û”£¬ËûÃÇÆÚÍû¿ª·¢Õß×ñ´ÓÌØ¶¨µÄ¹æÔò£¬µ±¹æÔò±»´òÆÆµÄʱºò¾Í·Ç³£ÄÑÒÔʹÓá£×îͨ³£µÄ¹æÔòÖ®Ò»¾ÍÊÇ£¬´æ´¢¹ý³Ì±ØÐë×ÜÊÇ·µ»Øµ¥¶ÀµÄ½á¹û¼¯£¬ÆäÖдøÓÐÒ»ÖµÄÁеÄÁÐ±í¡£²»ÐÒµÄÊÇ£¬ÓкܶàÕâÑùµÄ´æ´¢¹ý³Ì£¬ÆäÖзµ»ØµÄÊý¾ÝµÄ½á¹û¸ù¾ÝËü×ÔÉíÄÚ²¿Âß¼­µÄ²»Í¬¶ø²»Í¬¡£ÀýÈ磬һ¸ö´æ´¢¹ý³Ì¿ÉÄÜ»á½ÓÊÜÒ»¸ö²ÎÊý£¬Ëü±íʾҪ·µ»ØÄÇЩÁУ¬¶øÁíÒ»¸ö²ÎÊý±íʾÈç¹ûËü°üº¬ÁËËùÓÐÐУ¬ÄÇô¾Í¶ÔÆä½øÐкϼơ£»òÕß´æ´¢¹ý³ÌµÄ½á¹û¿ÉÄÜ»á¸ù¾ÝijЩÄÚ²¿µÄ±êʶ¶ø²»Í¬£¬´Ó¶øÓ¦ÓóÌÐòÐèÒª¼ì²éÊä³ö£¬´Ó¶øÔÚÔËÐÐʱ¾ö¶¨½á¹¹¡£
Ãæ¶ÔÒѾ­È·¶¨Á˵Ĵ洢¹ý³Ì¼¯ºÏ£¬¶øÕâЩ´æ´¢¹ý³Ì²¢·ÇÊÇÕë¶ÔORMϵͳËù»ùÓڵľ²Ì¬½¨Ä£µÄÀàÐÍËùÉè¼ÆµÄ£¬´ó¶àÊý.NET¿ª·¢Õß»áת¶øÊ¹ÓÃDataTableµÄ·½·¨¡£µ«ÊÇÓÐÁË.NET 4.0ÖÐд´½¨µÄ¶Ô¶¯Ì¬ÀàÐ͵ÄÖ§³Ö£¬ËûÃÇ»á²úÉúÁíÒ»¸öÖ÷Òâ¡£Èç¹ûËùÓÐÒ»ÇЗ—°üÀ¨´æ´¢¹ý³ÌµÄÃû³Æ¡¢SQLµÄ²ÎÊýÒÔ¼°µÃµ½µÄ¶ÔÏó——¶¼ÔÚÔËÐÐʱ´¦Àí»áÔõôÑùÄØ£¿
ÏÂÃæÊÇһЩÓÉVBºÍC#±àдµÄʾÀý´úÂë¡£Äã»á×¢Òâµ½VBÐèҪʹÓÃOption Strict£¬¶øC#´óÁ¿µØÊ¹ÓÃÁËËüµÄйؼü×Ö“dynamic”¡£
VB
Using con As New SqlClient.SqlConnection(connectionString)
Dim customer = con.CallSingleProc.CustomerSelect(AccountKey:=12345)
Console.WriteLine(customer.FirstName & " " & customer.LastName)

Dim orders As IList = con.CallListProc.OrderSearch(AccountKey:=12345, MinCreatedDate:=Now.AddDays(-7), MaxCreatedDate:=Now)
Dim totalValue = Aggregate order In orders Into Sum(CDec(order.TotalOrderValue))
Console.WriteLine("This customer ordered a total of $" & totalValue & " last week")
For Each order In orders
Console.WriteLine(vbTab & "Order Key: " & order.OrderKey & " Value: $" & order.TotalOrderValue)
Next

End Using
  
C#
using (var con = new SqlConnection(connectionString))
{
var customer = con.CallSingleProc().CustomerSelect(AccountKey: 12345);
Console.WriteLine(customer.FirstName + " " + customer.LastName);

IList<dynami


Ïà¹ØÎĵµ£º

C#·¢ÅÆ

֮ǰ²»Ì«Ï²»¶C#£¬ÎÞÒâÖз¢ÏÖlinq,ÓÃÀ´ÊµÏÖÅÅÐòÊÇÈç´Ë¼òµ¥£¬ËùÒÔÓÖÓÃC#дÁË±é·¢ÅÆ³ÌÐò
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
namespace ConsoleApplication1
{
    class Program
    {
      &nb ......

ÌÖÂÛVBÖеĽṹÌå

ÌÖÂÛVBÖеĽṹÌå[×ªÔØ]
2009Äê10ÔÂ20ÈÕ ÐÇÆÚ¶þ 11:30
VBÀïÃæµÄ½á¹¹ÌåÊÇÒ»ÖÖWORD/DWORD¶ÔÆëµÄ½á¹¹Ì壬ÕâÒ»µãÔÚ±à³ÌÖÐÓÈÆäҪעÒ⣬Èç¹ûÊÇ´¿VB±à³Ì£¬Ôò½á¹¹ÌåµÄ¸÷¸öÓòÈçºÎÅÅÁпÉÒÔ»ù±¾²»ÓùØÐÄ£¬
¶øÈç¹ûÊǵ÷ÓÃAPI»òÕßÊǵ÷ÓÃÆäËûµÄ¶¯Ì¬Á´½Ó¿â£¬ÔòºÜÈÝÒ׳öÎÊÌ⣬ԭÒò¾ÍÔÚÓÚ£ºÕâЩ¶¯Ì¬Á´½Ó¿âÊÇÓÃC/C++дµÄ£¬¶ø´ó²¿·ÖC/C++»·¾³ ......

VB ÎÞ±êÌâ´°¿ÚÖö¥

Private Declare Function SetWindowPos Lib "user32" (ByVal hwnd As Long, ByVal hWndInsertAfter As Long, ByVal x As Long, ByVal y As Long, ByVal cx As Long, ByVal cy As Long, ByVal wFlags As Long) As Long
Private Const a& = -1
Private Const b& = &H1
Private Const c& = &H2
Priva ......

Excel µ¼Èësqlserver c#

using System.Data.SqlClient;
using System.Data.OleDb;
 private void button1_Click(object sender, EventArgs e)
        {
OleDbConnection conn = null;
            try
     &nbs ......

java¡¢C#ÖÐSqlÓï¾ä´«²ÎµÄд·¨¼°ÒâÒå

 SqlserverÕâ¶«Î÷ûÉÙ¸úËû´ò½»µÀ,¸Õѧ¿ª·¢ÓïÑÔʱ¾ÍÒѾ­¸úËû½Ó´¥ÁË,²»ÒªËµºÜ¾«Í¨,µ«¾ÍÓï·¨»¹ËãÊÇÊìϤ,µ«ÏÖÔÚ¿ªÊ¼Ð´C#,·¢ÏÖºÜC#¶àÁËÒ»ÖÖSqlServerµÄ²ÎÊý´«È뷽ʽ,ÒÔÍùÎÒÃdz£³£¶ÔÒª´«²ÎµÄSqlÓï¾ä¶¼ÊÇÖ±½Óͨ¹ýÆ´´ÕSqlÓï¾äµÄ·½Ê½À´ÊµÏÖ,µ«ÏÖÔÚC#ΪʲôҪרÃÅ×öÒ»¸öSql²ÎÊýµÄÀàÀ´ÊµÏÖÄØ,¾­¹ý²éÕÒ²ÅÖªµÀ,ÕâÑù×öÊÇÓеÀÀíµÄ,Ò»Ê ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ