从文本文件中读取值，并将其存储在数据库表中. [英] Read values from textfile and store it in database table.

问题描述

|序号|会员编号|姓名|地址|职业|
| ------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- ---------- |
|帐号|
| ------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- ---------- |
| | 35957 | SHAH HEMANGINI KANAIYALAL NATVARLAL | SHROFF STREET ,, KILLA PARDI，DIST.VALSAD，Pardi，Pin Cd:396125 |
| 1 | 35959 | SARSIWALA SAKINABEN ASGARALI ABDULHUSEIN | OPP.HIGHPOWER SODA工厂，DUNGRI FALIA，DAMNI ZAPA，KILLA PARDI.DIST.VAL |
| 2 | 36022 | PATEL BHARTIBEN BABUBHAI KHANDUBHAI | B/H BALMANDIR ,, KANSARWAD ,, KILLA PARDI.，Pardi，Pin Cd:396125 |
| 3 | 36023 | PATEL ASHISHKUMAR BABUBHAI KHANDUBHAI | B/H BALMANDIR ,, KANSARWAD ,, KILLA PARDI.，Pardi，Pin Cd:396125 |
| 4 | 36025 | SHAIKH HALIMABIBI UMARBHAI MOHMEDBHAI | OPP.JALARAM KHAMAN HOUSE，CHIVAL ROAD，KILLA PARDI.DIST.VALSAD，Pardi，Pi |
| 5 | 36072 | LAD PUSHPABEN VINODBHAI BHANABHAI | KUMBHARWAD ,, VALSADI ZAPA ,, KILLA PARDI，DIST.VALSAD，Pardi，Pin Cd:396125 |
| 7 | 36076 | KOTHARI PANNABEN JANAKBHAI ISHVARLAL | VANIAWAD ,, KILLA PARDI，DIST.VALSAD，Pardi，Pin Cd:396125 |
| 8 | 36080 | PATEL DHARMESH BHAGU​​BHAI KANJIBHAI |靠近拉丹米米尔，DAMNI ZAPA，KILLA PARDI.，Pardi，Pin Cd:396125 |
| 9 | 36081 | MAPARA BANKIMKUMAR SUNDARLAL HARJIVANDAS |巴拉克拉迪，车站路，KILLA PARDI，帕尔迪，Cd编码:396125 |
| 10 | 36084 | LAD JAMNABEN DAHYABHAI BHAGWANJI | KUMBHARWAD ,, VALSADI ZAPA ,, KILLA PARDI，Pardi，Pin Cd:396125 |
| 11 | 36085 | PRAJAPATI RAKESHKUMAR THAKORBHAI KESHAVB | B/H NUTAN NAGAR ,, KAKABAVANI WADI ,, KILLA PARDI.，Pardi，Pin Cd:396125 |
| 12 | 36086 | PATEL BHANUBEN THAKORBHAI RAGHABHAI | B/H MOHAN DAYAL HOSPITAL ,, DAMNI ZAPA ,, KILLA PARDI.，Pardi，Pin Cd:39612 |
| 13 | 36089 | PATEL PRAFULBHAI BUDHABHAI CHHANABHAI | DANTI FALIA ,, CHIVAL ROAD ,, KILLA PARDI，Pardi，Pin Cd:396125 |
| 14 | 36093 | JOSHI KANAKBHAI MANUBHAI | ISHVARPARK ,, BRAHMIN FALIA ,, KILLA PARDI，Pardi，Pin Cd:396125 |
| 15 | 36095 | DESAI MEGHABEN BHAVINBHAI ISHVARBHAI | 101-ANAND公寓，OPP.D.C.O.学校，BALAKHADI，KILLA PARDI.，Pardi，Pin |
| 16 | 36204 | PATEL MANIBEN CHIMANLAL BABUBHAI. | DEVKA FALIA ,, STATION ROAD，CHAR RASTA ,, KILLA PARDI.DIST.VALSAD.，Pardi，Pi |
| 17 | 36211 | MISTRY RANJANABEN ASHOKBHAI BHAGWANJI | SUKHLAV路，JAKAT NAKA ，， DAMNI ZAMPA ，， KILLA PARDI.，帕尔迪，Cd编码:39612 |
| 18 | 36295 | PRAJAPATI JAYESH CHHAGANBHAI RANCHHODBHA | KUMBHARWAD ,, VALSADI ZAPA ,, KILLA PARDI.DIST.VALSAD，Pardi，Pin Cd:396125 |
| 19 | 36296 | KAHAR NARMADABEN GOVANBHAI BHAGU​​BHAI | KAHARWAD ,, DAMNI ZAPA.，KILLA PARDI.DIST.VALSAD，Pardi，Pin Cd:396125 |
| 20 | 36328 | BHARATIA GIRISHCHANDRA KANTILAL RANCHHOD |"ANAND MANGAL"，SAMIR HSG.SOC.LTD，靠近SWATI COLONY，N.H.NO:8，KILLA PARDI. |


对于此文本文件，我想在数据库中存储SRNO，MembershipNo，Name，Address值.如何单独选择所有这些值并插入数据库中?

| Sr.No | Membership No | Name | Addresss | Occupation |
|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| Account |
|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| | 35957 | SHAH HEMANGINI KANAIYALAL NATVARLAL |SHROFF STREET,, KILLA PARDI, DIST.VALSAD, Pardi, Pin Cd : 396125 |
| 1 | 35959 | SARSIWALA SAKINABEN ASGARALI ABDULHUSEIN |OPP.HIGHPOWER SODA FACTORY,, DUNGRI FALIA,DAMNI ZAPA,, KILLA PARDI.DIST.VAL |
| 2 | 36022 | PATEL BHARTIBEN BABUBHAI KHANDUBHAI |B/H BALMANDIR,, KANSARWAD,, KILLA PARDI., Pardi, Pin Cd : 396125 |
| 3 | 36023 | PATEL ASHISHKUMAR BABUBHAI KHANDUBHAI |B/H BALMANDIR,, KANSARWAD,, KILLA PARDI., Pardi, Pin Cd : 396125 |
| 4 | 36025 | SHAIKH HALIMABIBI UMARBHAI MOHMEDBHAI |OPP.JALARAM KHAMAN HOUSE,, CHIVAL ROAD,, KILLA PARDI.DIST.VALSAD, Pardi, Pi |
| 5 | 36072 | LAD PUSHPABEN VINODBHAI BHANABHAI |KUMBHARWAD,, VALSADI ZAPA,, KILLA PARDI,DIST.VALSAD, Pardi, Pin Cd : 396125 |
| 7 | 36076 | KOTHARI PANNABEN JANAKBHAI ISHVARLAL |VANIAWAD,, KILLA PARDI, DIST.VALSAD, Pardi, Pin Cd : 396125 |
| 8 | 36080 | PATEL DHARMESH BHAGUBHAI KANJIBHAI |NEAR RATAN RICE MILL,, DAMNI ZAPA,, KILLA PARDI., Pardi, Pin Cd : 396125 |
| 9 | 36081 | MAPARA BANKIMKUMAR SUNDARLAL HARJIVANDAS |BALAKHADI,, STATION ROAD,, KILLA PARDI, Pardi, Pin Cd : 396125 |
| 10 | 36084 | LAD JAMNABEN DAHYABHAI BHAGWANJI |KUMBHARWAD,, VALSADI ZAPA,, KILLA PARDI, Pardi, Pin Cd : 396125 |
| 11 | 36085 | PRAJAPATI RAKESHKUMAR THAKORBHAI KESHAVB |B/H NUTAN NAGAR,, KAKABAVANI WADI,, KILLA PARDI., Pardi, Pin Cd : 396125 |
| 12 | 36086 | PATEL BHANUBEN THAKORBHAI RAGHABHAI |B/H MOHAN DAYAL HOSPITAL,, DAMNI ZAPA,, KILLA PARDI., Pardi, Pin Cd : 39612 |
| 13 | 36089 | PATEL PRAFULBHAI BUDHABHAI CHHANABHAI |DANTI FALIA,, CHIVAL ROAD,, KILLA PARDI, Pardi, Pin Cd : 396125 |
| 14 | 36093 | JOSHI KANAKBHAI MANUBHAI |ISHVARPARK,, BRAHMIN FALIA,, KILLA PARDI, Pardi, Pin Cd : 396125 |
| 15 | 36095 | DESAI MEGHABEN BHAVINBHAI ISHVARBHAI |101-ANAND APARTMENT,, OPP.D.C.O.SCHOOL,BALAKHADI,, KILLA PARDI., Pardi, Pin |
| 16 | 36204 | PATEL MANIBEN CHIMANLAL BABUBHAI. |DEVKA FALIA,, STATION ROAD,CHAR RASTA,, KILLA PARDI.DIST.VALSAD., Pardi, Pi |
| 17 | 36211 | MISTRY RANJANABEN ASHOKBHAI BHAGWANJI |SUKHLAV ROAD,JAKAT NAKA,, DAMNI ZAMPA,, KILLA PARDI., Pardi, Pin Cd : 39612 |
| 18 | 36295 | PRAJAPATI JAYESH CHHAGANBHAI RANCHHODBHA |KUMBHARWAD,, VALSADI ZAPA,, KILLA PARDI.DIST.VALSAD, Pardi, Pin Cd : 396125 |
| 19 | 36296 | KAHAR NARMADABEN GOVANBHAI BHAGUBHAI |KAHARWAD,, DAMNI ZAPA., KILLA PARDI.DIST.VALSAD, Pardi, Pin Cd : 396125 |
| 20 | 36328 | BHARATIA GIRISHCHANDRA KANTILAL RANCHHOD |"ANAND MANGAL",SAMIR HSG.SOC.LTD, NEAR SWATI COLONY,N.H.NO:8,, KILLA PARDI. |


For this text file I want to store SRNO,MembershipNo,Name,Address values in database.How to pick all these values individually and insert in database?
Help me with this.

推荐答案

使用此代码...

use this code...

Dim StrAreaCode As New List(Of String) 'collect area-codes

       Dim objStreamReader As New IO.StreamReader("E:\Rachna\ELECTION 2009-SHAREHOLDERS AREAWISE.txt")
       Dim strLine = objStreamReader.ReadLine
 
       Dim ReadGridFlag = -1
 
       Do While Not strLine Is Nothing
           If strLine.Trim.ToUpper.StartsWith("Area Code :".ToUpper) Then
               strLine.Trim()
               StrAreaCode.Add(strLine.Split(" :")(1)) 'ADD AreaCode in list
           End If
           strLine = objStreamReader.ReadLine
 
           If strLine.Trim.ToUpper.StartsWith("| Sr.No".ToUpper) Then
               ReadGridFlag = 0
           ElseIf ReadGridFlag = 1 Then
            Dim c = strLine.Split("|")
                Dim SrNo = c(1).Trim
                Dim memberNo = c(2).Trim
                Dim name = c(3).Trim
                Dim address = c(4).Trim
                
                Dim Query = "Insert into tbl (srno,memberno,name,address) values('" & SrNo & "','" & memberNo & "','" & name & "','" & address & "')"
               'write code to execute query ...

           ElseIf strLine.Trim.ToUpper.StartsWith("|--".ToUpper) And ReadGridFlag = 0 Then
               ReadGridFlag = 1
           End If
       Loop
       objStreamReader.Close()

祝您编码愉快！
:)

Happy Coding!
:)

这篇关于从文本文件中读取值，并将其存储在数据库表中.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！