Using ODBC with C# 2005 Express Edition

[Colin Williams]

Hi

I have some paradox db's i need to connect to. I have figured out that
i can do this using ODBC, however C# Express edition does not support
this connectivity easily and must be done programmaticall y. I have a
class to do this:

public static class Data
{
public const string SelectAllComman dText = "select * from
WindowInfo";

public static string ConnectionStrin g;

public static DataSet GetWinInfoDataS et()
{
if (string.IsNullO rEmpty(Connecti onString))
throw new ArgumentNullExc eption("Connect ionString");

DataSet result = new DataSet("WinInf o");

using (OdbcConnection connection = new
OdbcConnection( ConnectionStrin g))
{
using (OdbcCommand command = new
OdbcCommand(Sel ectAllCommandTe xt))
{
command.Connect ion = connection;
using (OdbcDataAdapte r dataAdapter = new
OdbcDataAdapter (command))
{
dataAdapter.Fil l(result);
connection.Clos e();
}
}
}
return result;
}
}

Which seems OK.
Need nelp on how to populate/bind a datagridview on my form. How can
tweak the code below to do this?

private void FormMain_Load(o bject sender, EventArgs e)
{

Data.Connection String = Settings.Defaul t.ConnectionStr ing;

dataSet1 = Data.GetWinInfo DataSet();
bindingSource1. DataSource =
dataSet1.Tables["WindowInfo "] ;
dataGridView1.D ataSource = bindingSource1;

}
Many Thanks

Colin Williams

[Peter Duniho]

On Thu, 14 Jun 2007 13:39:40 -0700, Colin Williams
<co************ **@msn.comwrote :

I have some paradox db's i need to connect to. I have figured out that
i can do this using ODBC, however C# Express edition does not support
this connectivity easily and must be done programmaticall y. [...]

You multi-posted this to at least two different newsgroups (this one and
m.p.dotnet.fram ework). Please learn to cross-post properly by including
all newsgroups in the Newsgroups: field of the same post.

Thank you.

[Colin Williams]

On 14 Jun, 22:40, "Peter Duniho" <NpOeStPe...@nn owslpianmk.comw rote:

On Thu, 14 Jun 2007 13:39:40 -0700, Colin Williams

<colinwilliams. [e-mail] :

I have some paradox db's i need to connect to. I have figured out that
i can do this using ODBC, however C# Express edition does not support
this connectivity easily and must be done programmaticall y. [...]

You multi-posted this to at least two different newsgroups (this one and
m.p.dotnet.fram ework). Please learn to cross-post properly by including
all newsgroups in the Newsgroups: field of the same post.

Thank you.

Peter

Apologies for the incovenience this must have caused. I will look into
cross posting.
Regards
Colin Williams

Experience is something you dont have until just after you need it. ;)

[Nicholas Paldino [.NET/C# MVP]]

Colin,

It looks like it is doing it just fine. Is it not showing anything, are
you getting an exception? More information is needed.
"Colin Williams" <co************ **@msn.comwrote in message
news:11******** **************@ i13g2000prf.goo glegroups.com.. .

Hi

I have some paradox db's i need to connect to. I have figured out that
i can do this using ODBC, however C# Express edition does not support
this connectivity easily and must be done programmaticall y. I have a
class to do this:

public static class Data
{
public const string SelectAllComman dText = "select * from
WindowInfo";

public static string ConnectionStrin g;

public static DataSet GetWinInfoDataS et()
{
if (string.IsNullO rEmpty(Connecti onString))
throw new ArgumentNullExc eption("Connect ionString");

DataSet result = new DataSet("WinInf o");

using (OdbcConnection connection = new
OdbcConnection( ConnectionStrin g))
{
using (OdbcCommand command = new
OdbcCommand(Sel ectAllCommandTe xt))
{
command.Connect ion = connection;
using (OdbcDataAdapte r dataAdapter = new
OdbcDataAdapter (command))
{
dataAdapter.Fil l(result);
connection.Clos e();
}
}
}
return result;
}
}

Which seems OK.
Need nelp on how to populate/bind a datagridview on my form. How can
tweak the code below to do this?

private void FormMain_Load(o bject sender, EventArgs e)
{

Data.Connection String = Settings.Defaul t.ConnectionStr ing;

dataSet1 = Data.GetWinInfo DataSet();
bindingSource1. DataSource =
dataSet1.Tables["WindowInfo "] ;
dataGridView1.D ataSource = bindingSource1;

}
Many Thanks

Colin Williams

[Colin Williams]

Thanks for the reply
No exceptions, but no records are being returned to the grid either.
Im stumped.

Regards

Colin Williams


On 15 Jun, 00:44, "Nicholas Paldino [.NET/C# MVP]"
<[e-mail] d.caspershouse. comwrote:

Colin,

It looks like it is doing it just fine. Is it not showing anything, are
you getting an exception? More information is needed.

"Colin Williams" <colinwilliams. [e-mail] in message

[Nicholas Paldino [.NET/C# MVP]]

Colin,

Are you sure about that? In Windows Forms, when an exception occurs in
an event handler, it is swallowed by the control. You need to wrap the code
in the Load event in a try/catch block and step through it in order to see
if there is an exception.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"Colin Williams" <co************ **@msn.comwrote in message
news:11******** **************@ q66g2000hsg.goo glegroups.com.. .

Thanks for the reply
No exceptions, but no records are being returned to the grid either.
Im stumped.

Regards

Colin Williams


On 15 Jun, 00:44, "Nicholas Paldino [.NET/C# MVP]"
<[e-mail] d.caspershouse. comwrote:

>Colin,

It looks like it is doing it just fine. Is it not showing anything,
are
you getting an exception? More information is needed.

"Colin Williams" <colinwilliams. [e-mail] in message

[Colin Williams]

Nicholas

Tried your advice and no exceptions. I have now solved the problem by
adding the table name to the dataAdapter.fil l() method.
i.e
dataAdapter.Fil l(result,"table name");
Many thanks for you help.

Colin Williams

On 15 Jun, 14:45, "Nicholas Paldino [.NET/C# MVP]"
<[e-mail] d.caspershouse. comwrote:

Colin,

Are you sure about that? In Windows Forms, when an exception occurs in
an event handler, it is swallowed by the control. You need to wrap the code
in the Load event in a try/catch block and step through it in order to see
if there is an exception.

--
- Nicholas Paldino [.NET/C# MVP]
- [e-mail] .caspershouse.c om

[Colin Williams]

Now i can see the data except for the blob fields. This i anticipated.
How do i go about retrieving these?