C # Enables the Datawindow.net component to process data

window| data datawindow.net is a data access component developed for the PB ms.net.

1. Installation

Install the. net2003 First, frame version 1.1, and then install the Datawindow.net component and design the build environment.

The Sybase DataWindow control page sign appears when you install the. net2003 form Design.



2. Use

The DataWindow control can be used directly in a C # form.

3. Design DataWindow

Design Data window in PB or DataWindow design environment, coexist to. PBL, for program call.

Can be compiled into a. pbd file format after publication.

4. Call DataWindow in C #

A the form creates a DataWindow control named DW.

b) Create a transaction control on the form named Trans.

c) Initialize the transaction control

Trans.dbms = sybase.datawindow.dbmstype.oledb;//Database connection method

Trans.password = "123";

Trans.userid = "sa";

Trans.autocommit = false;

Trans.lock = "RC";

Trans.dbparameter = "provider= ' SQLOLEDB ', datasource= ' Xiancai ',

providerstring= ' Database=demo ' ";//Database connection string

Trans.connect ()//Connection database



d) Display Data window

Dw. Librarylist = "TEST.PBL"; use. pbd files after publication

Dw. Datawindowobject = "Datawindowname";//Data window name

Dw. Settransaction (Trans);

Dw. Retrieve ()//Display Data window



e) Closing the connection

Trans.disconnect ();



5. C # uses the DataWindow control to manipulate data

A) Add

int row = This.dw.InsertRow (0);//Insert a record

Dw. Setrow (row);

Dw. Setitemstring (Row, "ID", "100");//Assign a value to a field

Dw. Setitemstring (row, title, name); Assigning values to a field



b) Delete

This.dw.DeleteRow (1);//delete first row record



c) Preservation

This.dw.UpdateData (True, true);

Trans.commit ()//data is submitted before it is written to the database



6. Notes

The above is simply to explain the use of DataWindow in C #, the actual development process will encounter a lot of details, especially when the data window design.

I am also used soon, welcome to exchange.

Msn:yutao728@hotmail.com