Databases
StackOverflow2013
Postsdbo
POstring data from dbf to c# program
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POstring data from dbf to c# program
    primarykey
    data
    text
    <p>I've got a c# program, which is connected to dbf file:</p> <pre><code>OdbcConnection oconn = new OdbcConnection(); oconn.ConnectionString = "Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=" + pelna_sciezka + ";Exclusive=No; Collate=Machine;NULL=NO;DELETED=NO;BACKGROUNDFETCH=NO;"; oconn.Open(); OdbcCommand ocmd = oconn.CreateCommand(); ocmd.CommandText = @"SELECT * FROM " + pelna_sciezka + " where Kod_kontr = '" + row.KNH_KOD + "'"; // ocmd.ExecuteNonQuery(); OdbcDataReader odr = ocmd.ExecuteReader(); while (odr.Read()) { kod_kontr = odr["Kod_kontr"].ToString(); Nzwakontr1 = odr["Nzwakontr1"]; Nzwakontr2 = odr["Nzwakontr2"]; } </code></pre> <p>connection is working very well, but when I want to assemble data to local string variables (kod_kontr, nzwakontr1), all i get for a value is <code>System.Byte[]</code>. When I want to get the other types of data (f.ex. date, numeric, etc)from this dbf, everything is working well. The problem is only for varchar data . How could I solve my problem? </p> <p>Thanx for any help</p> <hr> <p>According to Antonio Bakula help i've read the answer:</p> <p>I must change from ODBC to OLE, and: - change connectionstring to: oconn.ConnectionString = "Provider=vfpoledb.1;Data Source="+pelna_sciezka+";Collating Sequence=machine"; change code for that:</p> <p>OleDbDataReader odr = ocmd.ExecuteReader();</p> <pre><code> while (odr.Read()) { // byte[] A = Encoding.GetEncoding(Encoding.Default.CodePage).GetBytes(odr.GetString(0)); // string p = Encoding.Unicode.GetString((Encoding.Convert(Encoding.GetEncoding(850), Encoding.Unicode, A))); kod_kontr = OdczytajTabliceBajtow(odr["Kod_kontr"]); Nzwakontr1 = OdczytajTabliceBajtow(odr["Nzwakontr1"]); Nzwakontr2 = OdczytajTabliceBajtow(odr["Nzwakontr2"]); } </code></pre> <p>where OdczytajTabliceBajtow:</p> <p>private string OdczytajTabliceBajtow(object p) { Encoding enc8 = Encoding.ASCII; string wynik = ""; Byte[] bytes = (Byte[])p; StringBuilder sb = new StringBuilder(); sb.Append(Encoding.ASCII.GetChars(bytes)); wynik = sb.ToString(); return wynik; }</p> <p>This is the solution of my problem. Thank you all for help.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USBKl
    1. USBKl
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POstring data from dbf to c# program
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. COWhat is the data type of those columns, perhaps you should call `GetString` http://msdn.microsoft.com/en-us/library/system.data.odbc.odbcdatareader.getstring.aspx instead of retrieving the native format.
      singulars
      1. POstring data from dbf to c# program
      1. USJodrell
    2. COthis columns have a varchar type ( C(100) in dbf structure ). Other types is converting very well, only with 'C' type get a problem
      singulars
      1. POstring data from dbf to c# program
      1. USBKl
    3. COAs the documentation states, the index accesor "Gets the value of the specified column in its native format", it just so happens that the native format of some of the columns are compatible with your desired type. It seems the index accessor returns VFP text data as a byte array, not entirely unreasonable. If you know the encoding of the text you can convert to a .Net string using the `System.Text` namespace. If you don't, you could call `GetString` and let the ODBC layer do the conversion for you.
      singulars
      1. POstring data from dbf to c# program
      1. USJodrell
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload