Devart Forums

Hi,

Is there examples of how to use dotConnect for Oracle as a datasource
for WPF application?

Regards,
Alfred

Hi,

Is there way of loading data into bytea column via a
stored procedure, or the PgLoader the only way
where row must exist first??

Thanks,
Alfred

v2.0.16.0

Whe you edit existin dataset, existing datatables are listed fine, but the existing relations are not listed. Hence if u add additional datatables
u have to redo new and old relations.

Regards,
Alfred

Can one create SqlDataTable child relation in design-time than in code?

"....
DataRelation deptEmpRel = new DataRelation("dept_emp", deptTable.Columns["deptno"], empTable.Columns["deptno"]);
deptTable.ChildRelations.Add(deptEmpRel);
..."

Hi,

We are using a grid(XtraGrid by Devepress) that ChildRelations required
the datasource to support DataTable ChildRelations for master detail relationships, how add ChildRelations to SQLDataTable?

Qoute from the Grid help file

"This document explains how you can implement master-detail relationships for a DataTable using the methods provided by the data source.

ADO .NET allows you to implement master-detail relationships between data tables. The key object in ADO .NET is the DataTable which encapsulates a two-dimensional table of the in-memory data. You can define a master-detail relationship between two tables via the parent table's DataTable.ChildRelations property. If you bind the grid control to a DataTable, which contains master-detail relationships or to a DataView which refers to such a table, the grid can obtain the relationships and the only thing you need to do is to assign pattern Views for representing particular relationships in the XtraGrid. "

We are using dotConnect for Oracle, SQL Server and Postgres.

Regards,
Alfred

I have not received email reply yet.
[email protected]

Hi,

Is possible to have a VS2005/VS2008 toolbox creator utility for each
dotConnect Controls without have to add them manually or reinstall,
when components disappear from the toolbox for some strange reason.

I'm using
dotConnect for Oracle
dotConnect for PostgreSQL
and dotConnect for SQL Server

on VS2008 SP1

Regards,
Alfred

Hi, Newbie

I have a grid on an ASP page hooked to OracleDataSource control.
On page load I would like to load the data manualy set
the query. I can set the query on OracleDataSource
but unlike OracleDataTable it does not have properties
like Active which I use in winforms to activate or deactivate
a data source.

How is this generally do something similar to forms where us have
OracleDataTable wired to OracleCommand for the select command
and one uses OracleDataTable.Active property to control when the
data is loaded and when it is not...etc.

Regards,
Alfred

Resolved.

Command had a wrong commandtype...

Regards,
Alfred

Hi,
Platform : PostgreSQLDirect .NET V3.85.33, VS2008 SP1, XP ProSP3

I'me getting a strange error calling SP in C# that table couple boolean and strings parameters. The error I get is
[syntax error at or near "pas"].
PAS is the Postgres schema as per below sp definition
CREATE OR REPLACE FUNCTION pas.sp_addclient(vclientname character varying,
vaccountnumber character varying,
vaddress1 character varying,
vaddress2 character varying,
vaddress3 character varying,
vaddress4 character varying,
vemailaddress character varying,
vtelephone character varying,
vcontactperson character varying,
vclientstatus character varying,
vclienttype character varying,
vurl character varying,
vmustdebit boolean,
vmustcrorrespond boolean,
vnotes text,
vbillingaddress text,
vpostaladdress text)
RETURNS void AS
....

Next is call from C#
cmdProcs.CommandText = "pas.sp_addclient";
cmdProcs.Parameters.Clear();
cmdProcs.ParameterCheck = true;

PgSqlParameter pm1 = new PgSqlParameter();
pm1.Direction = ParameterDirection.Input;
pm1.DbType = DbType.String;
pm1.ParameterName = "vclientname";
pm1.Value = edtClientName.Text;
cmdProcs.Parameters.Add(pm1);
....
PgSqlParameter pm13 = new PgSqlParameter();
pm13.Direction = ParameterDirection.Input;
pm13.DbType = DbType.Boolean;
//pm13.PgSqlType = PgSqlType.Boolean;
pm13.ParameterName = "vmustdebit";
pm13.Value = edtMustDebit.Checked;
....
cmdProcs.Parameters.Add(pm13);

Note: cmfProcs is PgSqlCommand connected to PgSqlConnection


Thanks in advance,
Alfred

Hi .Net Newbiw,

How does one get current row value of a column from pgSqlDataTable in code? Like

label1.Text = pgSqlDataTable1.Column["CompanyNameField"].Value;

I have pgSqlDataTable1 wired to the pgSqlConnection1 and pgSqlCommand1
which select the data and displays it on the grid.

Regards,
Alfred

Hi,
Is there a way of accessing field values when iterating through OracleDataReader result without referencing fields by their
index instead to use fieldname.

Delphi has
x := dataset1.FieldByName('Field1').AsString;

What's the equivalent?

Regards.

Hi,
I'm new to Visual Studio 2008 C# coming from Delphi.
How does data components wire together similar to Delphi?

TOraSession=?
TOraTable/TDataset=?
TSmartQuery/TQuery=?
TOraStoredProc=?
TOraDataSource/TDatasource=?

Also how to thing like iterations.
Table1.Open, Table1.Next, Table1.Refresh, while(not(table1.Eof)) do table1.next...etc.

How do parametized tables like Table1.Params...etc.

Thanks
Alfred