Microsoft .NET Framework 2.0ÀÌ ºôµåµÈ ÀÀ¿ë ÇÁ·Î±×·¥¿¡¼­ ¼Õ»óµÉ ¼ö ÀÖ´Â System.Data °³Ã¼¸¦ »ç¿ëÇÏ´Â ±¸¼º ¿ä¼Ò¿Í ¿¬°áµÈ µ¥ÀÌÅÍ FIX:

• DataView Ŭ·¡½º¿¡¼­ AcceptChanges ¸Þ¼­µå¸¦ È£ÃâÇÒ ¶§ ·¹ÄÚµå °ü¸®ÀÚ°¡ ¼Õ»óµÉ ¼ö ÀÖ½À´Ï´Ù.
• ½Ä ¿­¿¡¼­ °è»êµÈ °ªÀº ¿Ã¹Ù¸£°Ô ¾÷µ¥ÀÌÆ®µÇÁö ¾ÊÀ» ¼ö ÀÖ½À´Ï´Ù.
• ¿©·¯ °³ÀÇ ¹®À» »ç¿ëÇÏ¿© DataTable.Select ¸Þ¼­µå¸¦ È£ÃâÇÒ ¶§ À߸øµÈ °á°ú¸¦ ¹ÝȯÇÒ ¼ö ÀÖ½À´Ï´Ù.
• DataTable °³Ã¼ÀÇ ³»ºÎ À妽º ¼Õ»óµÉ ¼ö ÀÖ½À´Ï´Ù. ¶ÇÇÑ '13' ¿À·ù ¸Þ½ÃÁö°¡ ³ªÅ¸³³´Ï´Ù.
• º´ÇÕ ÀÛ¾÷ÀÌ ¹ß»ýÇÒ ¶§ ´ë»ó ÇàÀ» ÆíÁý »óÅ¿¡ ÀÖÀ¸¸é ·¹ÄÚµå °ü¸®ÀÚ ¼Õ»óµÉ ¼ö ÀÖ½À´Ï´Ù.
• DataTable °³Ã¼ÀÇ ³»ºÎ À妽º ¼Õ»óµÉ ¼ö ÀÖ½À´Ï´Ù. ¶ÇÇÑ '5' ¿À·ù ¸Þ½ÃÁö°¡ ³ªÅ¸³³´Ï´Ù.

À§·Î °¡±â | Çǵå¹é º¸³»±â

ÇÖÇȽº Á¤º¸

ÀüÁ¦ Á¶°Ç

Àç½ÃÀÛ ¿ä±¸ »çÇ×

ÇÖÇȽº ´ëü Á¤º¸

ÆÄÀÏ Á¤º¸

´ëÇØ x 86 ±â¹Ý ÄÄÇ»ÅÍ

´ëÇØ x 64 ±â¹Ý ÄÄÇ»ÅÍ

Itanium ±â¹Ý ÄÄÇ»ÅÍ

À§·Î °¡±â | Çǵå¹é º¸³»±â

¹®Á¦ 1: DataView Ŭ·¡½º¿¡¼­ AcceptChanges ¸Þ¼­µå¸¦ È£ÃâÇÒ ¶§ ·¹ÄÚµå °ü¸®ÀÚ°¡ ¼Õ»óµÉ ¼ö ÀÖ´Ù

1. You use the following code in the application:

   using System;
   using System.ComponentModel;
   using System.Data;
   
   class Test {
       private static DataRow _dr = null;
       private static bool _accept = false;
       
       public static void Main()
       {
           try {
               DataSet ds = new DataSet();
               DataTable dt = ds.Tables.Add("Customers");
               DataColumn c = dt.Columns.Add("Id", typeof(int));
               dt.PrimaryKey = new DataColumn[] { c };
               dt.Columns.Add("Name", typeof(string));
               dt.Columns.Add("Age", typeof(int));
               
               dt.Rows.Add(new object[] { 1, "A", 10 });
               dt.Rows.Add(new object[] { 2, "B", 20 });
               dt.Rows.Add(new object[] { 3, "G", 30 });
               dt.Rows.Add(new object[] { 4, "H", 40 });
               dt.Rows.Add(new object[] { 5, "I", 50 });
   
               ds.AcceptChanges();
                           
               DataView dv = new DataView(dt);
               dv.Sort = "Name ASC";
                                       
               dv.ListChanged += new ListChangedEventHandler(OnListChanged);
                           
               _dr = dt.Rows[4];
               
               _accept = true;
               _dr["Name"] = "C";
               _accept = false;
                           
               _dr["Name"] = "D";
               _dr["Age"] = 55;            
                           
               Console.WriteLine(dv[2][1]);                        
           } catch (Exception exc) {
               Console.WriteLine(exc);
           }
       }
       
       public static void OnListChanged(object sender, ListChangedEventArgs args)
       {
           if (_dr != null && _accept) {
               _dr.AcceptChanges();
           }
       }
   }

2. ÀÀ¿ë ÇÁ·Î±×·¥À» ½ÇÇàÇÕ´Ï´Ù.

¹®Á¦ 2: ½Ä ¿­¿¡¼­ °è»êµÈ °ªÀÌ Á¦´ë·Î ¾÷µ¥ÀÌÆ®µÇÁö ¾ÊÀ» ¼ö ÀÖ½À´Ï´Ù.

1. You use the following code in the application:

   using System;
   using System.ComponentModel;
   using System.Data;
   
   class Test {
       public static void Main()
       {
           try {
               DataSet ds = new DataSet();
   
               DataTable dt1 = ds.Tables.Add("T1");
               dt1.Columns.Add("CustId", typeof(int));
               dt1.Columns.Add("CustName", typeof(string));
   
               DataTable dt2 = ds.Tables.Add("T2");
               dt2.Columns.Add("EmpId", typeof(int));
               DataColumn dcEmpName = dt2.Columns.Add("EmpName", typeof(string));
               DataColumn dcMgrName = dt2.Columns.Add("MgrName", typeof(string));
               DataColumn dcReports = dt2.Columns.Add("NumberOfReports", typeof(int));
               
               DataRelation rel1 = ds.Relations.Add("T1T2", dt1.Columns["CustId"], dt2.Columns["EmpId"], false);
               DataRelation rel2 = ds.Relations.Add("T2T2", dt2.Columns["EmpName"], dt2.Columns["MgrName"], false);
   
               dcEmpName.Expression = "Parent(T1T2).CustName";
               dcMgrName.Expression = "Parent(T1T2).CustName"; 
   
               //Each person is a manager to himself.
               dcReports.Expression = "Count(Child(T2T2).EmpName)"; 
   
               AddRow(dt1, 1, "N1");
               AddRow(dt1, 2, "N2");
               AddRow(dt1, 3, "N3");
   
               AddRow(dt2, 1);
               AddRow(dt2, 2);
               AddRow(dt2, 3);
   
               Console.WriteLine(ds.GetXml());
   
               dt1.Rows[0]["CustName"] = "N4";
   
               Console.WriteLine(ds.GetXml());
           } catch (Exception exc) {
               Console.WriteLine(exc);
           }
       }
   
       public static void AddRow(DataTable dt, params object[] objArr)
       {
           Console.WriteLine("Adding row to table {0}", dt.TableName);
           dt.Rows.Add(objArr);
       }
   }

2. ÀÀ¿ë ÇÁ·Î±×·¥À» ½ÇÇàÇÕ´Ï´Ù.

<NewDataSet>
 <T1>
   <CustId>1</CustId>
   <CustName>N4</CustName>
 </T1>
 <T1>
   <CustId>2</CustId>
   <CustName>N2</CustName>
 </T1>
 <T1>
   <CustId>3</CustId>
   <CustName>N3</CustName>
 </T1>
 <T2>
   <EmpId>1</EmpId>
   <EmpName>N4</EmpName>
   <MgrName>N4</MgrName>
   <NumberOfReports>0</NumberOfReports> 
 </T2>
 <T2>
   <EmpId>2</EmpId>
   <EmpName>N2</EmpName>
   <MgrName>N2</MgrName>
   <NumberOfReports>1</NumberOfReports>
 </T2>
 <T2>
   <EmpId>3</EmpId>
   <EmpName>N3</EmpName>
   <MgrName>N3</MgrName>
   <NumberOfReports>1</NumberOfReports>
 </T2>
</NewDataSet>

¹®Á¦ 3: ¿©·¯ °³ÀÇ ¹®À» »ç¿ëÇÏ¿© DataTable.Select ¸Þ¼­µå¸¦ È£ÃâÇÒ ¶§ À߸øµÈ °á°ú¸¦ ¹ÝȯÇÒ ¼ö ÀÖ½À´Ï´Ù.

string filter = "(NOT ColTwo = 1) AND (ColOne = 2)";
DataTable.Select(filter);

string filter = "NOT ColTwo = 1 AND ColOne = 2";
DataTable.Select(filter);

1. You use the following code in the application:

   public static void Main()
   {
     DataTable table = new DataTable();
     table.Columns.Add("ColID", typeof(int));
     table.Columns.Add("ColOne", typeof(int));
     table.Columns.Add("ColTwo", typeof(int));
     table.Rows.Add(new object[] { 1, 1, 1 });
     table.Rows.Add(new object[] { 2, 1, 2 });
     table.Rows.Add(new object[] { 3, 2, 1 });
     table.Rows.Add(new object[] { 4, 2, 2 });
   
     string[] queries = new string[] {
         "(NOT ColTwo = 1) AND (ColOne = 2)",
         "(ColOne = 2) AND (NOT ColTwo = 1)",
   
         "NOT ColTwo = 1 AND ColOne = 2",
         "ColOne = 2 AND NOT ColTwo = 1",
   
         "NOT ColTwo = 1 AND (ColOne = 2)",
         "(ColOne = 2) AND NOT ColTwo = 1",
   
         "(NOT ColTwo = 1) AND ColOne = 2",
         "ColOne = 2 AND (NOT ColTwo = 1)",
     };
   
     Console.WriteLine("Select");
     foreach(string query in queries) {
         DataRow[] rows = table.Select(query);
         Console.WriteLine("query=\"{0}\" count={1}", query, rows.Length);
         foreach(DataRow row in rows) {
             Console.WriteLine("\t{0}, {1}, {2}", row[0], row[1], row[2]);
         }
     }
   }
   

2. ÀÀ¿ë ÇÁ·Î±×·¥À» ½ÇÇàÇÕ´Ï´Ù.

query="(NOT ColTwo = 1) AND (ColOne = 2)" count=2
        3, 2, 1
        4, 2, 2
query="(ColOne = 2) AND (NOT ColTwo = 1)" count=1
        4, 2, 2
query="NOT ColTwo = 1 AND ColOne = 2" count=1
        4, 2, 2
query="ColOne = 2 AND NOT ColTwo = 1" count=1
        4, 2, 2
query="NOT ColTwo = 1 AND (ColOne = 2)" count=2
        3, 2, 1
        4, 2, 2
query="(ColOne = 2) AND NOT ColTwo = 1" count=1
        4, 2, 2
query="(NOT ColTwo = 1) AND ColOne = 2" count=1
        4, 2, 2
query="ColOne = 2 AND (NOT ColTwo = 1)" count=1
        4, 2, 2

¹®Á¦ 4: DataTable ÀÖ´Â ³»ºÎ À妽º, ¼Õ»óµÇ¾î '13' ¿À·ù ¸Þ½ÃÁö°¡ ³ªÅ¸³­´Ù

• DataSet °³Ã¼¸¦ ÇÑ ÀÏ´ë´Ù °ü°è°¡ Çϳª ÀÌ»óÀÇ Å×À̺íÀÌ µé¾î ÀÖ½À´Ï´Ù.
• DataSet °³Ã¼ÀÇ AcceptChanges ¸Þ¼­µå°¡ È£ÃâµË´Ï´Ù.
• DataSet °³Ã¼ÀÇ AcceptRejectRule °ªÀº ¸ðµÎ·Î ¼³Á¤µË´Ï´Ù. ¸ðµÎ À§ÇØ ÀÌ °ªÀ» ¼³Á¤ÇÒ ¶§ À̸¦ ÀÚµ¿À¸·Î µ¥ÀÌÅ͸¦ ¼ö¶ôÇϰųª µ¥ÀÌÅ͸¦ °ÅºÎÇÒ ¼ö ÀÖµµ·Ï ÀÚ½Ä Å×ÀÌºí¿¡ º¯°æµË´Ï´Ù.

1. You use the following code in the application:

   public void Main()
   {
   			DataTable Table = new DataTable("Employee");
   			Table.Columns.Add("Id", typeof(int));
   			Table.Columns.Add("ManagerId", typeof(int));
   			Table.Columns.Add("Name", typeof(string));
   
   			Table.Columns["Name"].AllowDBNull = false;
   			Table.PrimaryKey = new DataColumn[] {Table.Columns["Id"]};
   
   			DataSet Employees = new DataSet();
   			Employees.Tables.Add(Table);
   
   			DataRelation rel = Employees.Relations.Add(Table.Columns["ID"], Table.Columns["ManagerId"]);
   			rel.ChildKeyConstraint.AcceptRejectRule = AcceptRejectRule.Cascade;
   
   			DataRow ManagerA = Table.NewRow();
   			ManagerA["ID"] = 2019;
   			ManagerA["Name"] = "Manager A";
   			Table.Rows.Add(ManagerA);
   
   			DataRow ManagerB = Table.NewRow();
   			ManagerB["ID"] = 392;
   			ManagerB["Name"] = "Manager B";
   			Table.Rows.Add(ManagerB);
   
   			DataRow EmployeeB = Table.NewRow();
   			EmployeeB["ID"] = 716;
   			EmployeeB["Name"] = "Employee of B";
   			EmployeeB.SetParentRow(ManagerB);
   			Table.Rows.Add(EmployeeB);
   
   			EmployeeB = Table.NewRow();
   			EmployeeB["ID"] = 637;
   			EmployeeB["Name"] = "2nd employee of B";
   			EmployeeB.SetParentRow(ManagerB);
   			Table.Rows.Add(EmployeeB);
   
   			Employees.AcceptChanges();
   			Table.Rows.Find(392).Delete();
   			Employees.AcceptChanges();
   }

2. ÀÀ¿ë ÇÁ·Î±×·¥À» ½ÇÇàÇÕ´Ï´Ù.

¹®Á¦ 5: º´ÇÕ ÀÛ¾÷ÀÌ ¹ß»ýÇÒ °æ¿ì ´ë»ó ÇàÀ» ÆíÁý »óÅ¿¡ ÀÖÀ¸¸é ·¹ÄÚµå °ü¸®ÀÚ ¼Õ»óµÉ ¼ö ÀÖ´Ù

1. You use the following code in the application:

   using System;
   using System.Data;
   using System.Collections.Generic;
   using System.Text;
   
   namespace ConsoleApplication1
   {
       class Program
       {
           static void Main(string[] args)
           {
               DataSet set = new DataSet();
               DataTable table = set.Tables.Add("table");
               table.Columns.Add("C1", typeof(int));
               table.Columns.Add("C2", typeof(char));
               table.PrimaryKey = new DataColumn[] { table.Columns[0] };
               for (int i = 0; i < 26; ++i)
               {
                   table.Rows.Add(new object[] { i, (char)((ushort)'a' + i) });
               }
               table.AcceptChanges();
   
               DataSet clone = set.Copy();
               clone.Tables[0].Rows[0][1] = 'Z';
               //clone.AcceptChanges();
   
               table.Rows[0][1] = '1';
               table.Rows[0].BeginEdit();
               table.Rows[0][1] = '2';
   
   
               try
               {
                   set.Merge(clone);
               }
               finally
               {
                  foreach (DataRow row in table.Rows) {
   																	Console.WriteLine("{0}={1}", row[0], row[1]);
   															}
               }
   
           }
       }
   }

2. ÀÀ¿ë ÇÁ·Î±×·¥À» ½ÇÇàÇÕ´Ï´Ù.

¹®Á¦ 6: DataTable °³Ã¼ÀÇ ÀÖ´Â ³»ºÎ À妽º, ¼Õ»óµÇ¾î '5' ¿À·ù ¸Þ½ÃÁö°¡ ³ªÅ¸³­´Ù

1. DataColumn.Expression °ªÀº ½Ä¿¡¼­ ½ÄÀÌ ¾ø´Â º¯°æµË´Ï´Ù. ÀÌ ½Ã³ª¸®¿À¿¡¼­´Â DataColumn °³Ã¼ÀÇ ¸ðµç µ¥ÀÌÅÍ´Â DBNull·Î ¼³Á¤µË´Ï´Ù.
2. DataTable.Clear ¸Þ¼­µå¸¦ È£ÃâÇÒ ¶§ DataTable °³Ã¼ ¸ðµç µ¥ÀÌÅÍ°¡ Á¦°ÅµÇ°í À妽º°¡ ¾÷µ¥ÀÌÆ®µË´Ï´Ù. ±×·¯³ª DataTable °³Ã¼¸¦ ÂüÁ¶ÇÏ´Â ´Ù¸¥ Å×À̺íÀº ¾÷µ¥ÀÌÆ®µÇÁö ¾Ê½À´Ï´Ù.

1. You use the following code in the application:

   using System;
   using System.Data;
   using System.Collections.Generic;
   using System.Text;
   
   namespace ConsoleApplication1
   {
       class Program
       {
           static void Main(string[] args)
           {
               DataSet set = new DataSet("s");
               DataTable table1 = set.Tables.Add("a");
               table1.Columns.Add("C1", typeof(int));
               table1.Columns.Add("C2", typeof(int));
               table1.DefaultView.Sort = "C2";
   
               DataTable table2 = set.Tables.Add("b");
               table2.Columns.Add("C1", typeof(int));
               table2.Columns.Add("C2", typeof(int));
               table2.DefaultView.Sort = "C2";
   
               set.Relations.Add(new DataRelation("t1t2", table1.Columns[0], table2.Columns[0], false));
               table1.Columns[1].Expression = "Sum(Child(t1t2).C2)";
   
               AddData(table1, 1);
               AddData(table2, 2);
   
               table1.Columns[1].Expression = null;
   
               AddData(table2, 2);
               AddData(table1, 2);
   
           }
           private static void AddData(DataTable table, int y)
           {
               object[] x = new object[y];
               Random rand = new Random(20070125);
               for (int i = 0; i < 1000; ++i)
               {
                   switch (rand.Next(3))
                   {
                       case 0:
                       case 1:
                           for (int k = 0; k < x.Length; ++k)
                           {
                               x[k] = rand.Next(500);
                           }
                           table.Rows.Add(x);
                           break;
                       case 2:
                           if (0 < table.Rows.Count)
                           {
                               table.Rows.RemoveAt(rand.Next(table.Rows.Count));
                           }
                           break;
                   }
               }
           }
   
       }
   }
   
   

2. ÀÀ¿ë ÇÁ·Î±×·¥À» ½ÇÇàÇÕ´Ï´Ù.

À§·Î °¡±â | Çǵå¹é º¸³»±â