C# .net2.0 dataset problem
I'm retrieving information from an access database. I have a field in the access database that has long text in it, more then 255 characters, but i only get the first 255 characters.
I use a DataSet,
any ideas on how to solve this issue?
thanks a lot,
this is a test script:
[code]
using System;
using System.IO;
using System.Text;
using System.Security.Cryptography;
using System.Collections.Generic;
using System.Data;
using System.Data.OleDb;
/// <summary>
/// Summary description for Class1
/// </summary>
public class Tester
{
public static void Main()
{
Tester t = new Tester();
string str = t.GetEvents();
Console.WriteLine("str:\n{0}\n", str);
}
private string GetSelectedEvents(string strQueryToBeExecuted)
{
string str = "";
try
{
// maak verbinding met access database
string strConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\db.mdb;Persist Security Info=False";
OleDbDataAdapter objDataAdapter = new OleDbDataAdapter(strQueryToBeExecuted, strConnectionString);
DataSet objDataSet = new DataSet();
objDataAdapter.Fill(objDataSet);
DataTable objDataTable = objDataSet.Tables[0];
// loop door de dataset heen
foreach (DataRow objDataRow in objDataTable.Rows)
{
str += objDataRow["omschrijving"].ToString();
str += "\n";
}
}
catch (Exception e)
{
str += e.ToString();
}
// return
return str;
}
public string GetEvents()
{
string strQueryToGetEvents = "SELECT prod.productieId AS evenementCode, prod.uitvoerende AS artiest, prod.titel, prod.internettekst AS omschrijving, " +
"prod.emailtekst AS teaser, prod.[website-groep] AS hyperlink, prod.fotobestandsnaam AS afbeeldingUrl, genre.GenreInternet AS genre, prod.seizoen " +
"FROM ( ( tblProductie AS prod " +
"INNER JOIN tblVoorstelling AS vrst ON prod.productieId = vrst.productie ) " +
"INNER JOIN tlkpGenreInternet AS genre ON prod.genreInternet = genre.GenreInternetId ) " +
"WHERE prod.seizoen >= 2006 AND vrst.[web j/n] = true " +
"GROUP BY prod.productieId, prod.uitvoerende, prod.titel, prod.internettekst, " +
"prod.emailtekst, prod.[website-groep], prod.fotobestandsnaam, genre.GenreInternet, prod.seizoen " +
"ORDER BY prod.seizoen ASC, prod.productieId ASC";
return this.GetSelectedEvents(strQueryToGetEvents);
}
}
[/code]
