티스토리 뷰

WPF

SqlDataReader to DataTable

NicSub 2022. 10. 14. 19:26
728x90
반응형

                   


                    SqlDataReader DB_reader = Comm_String.ExecuteReader();

                    DataTable DT = new DataTable();
                    DataRow relation;

 

 while (await DB_reader.ReadAsync())
                    {
                        relation = DT.NewRow();
                        if (i == 1)
                        {
                            for (int k = 0; k < DB_reader.FieldCount; k++)
                            {
                                DT.Columns.Add(new DataColumn(DB_reader.GetName(k), DB_reader.GetFieldType(k)));
                            }

                        }

                        object[] values = new object[DB_reader.VisibleFieldCount];
                        DB_reader.GetValues(values);
                        relation.ItemArray = values;
                        DT.Rows.Add(relation);
                        i++;
                     
                    } // while End

반응형
댓글