Work with Advantage Database Server 9.1 / 11 with .NET ( C# )

I need some one who know how to build application using C# and Advantage Database Server for my long term project. • Advantage Database Server ( c# ) If you are using Microsoft Visual Studio, you can access the Advantage .NET Data Provider components visually from the Toolbox. After installing the provider and starting Visual Studio, open the Toolbox (available under the View menu if it is not visible) and expand the Data category. Right click and select "Choose Items…" This will open a dialog that allows you to select which components should be displayed in the Toolbox. You can select the Advantage components (AdsCommand, AdsConnection, and AdsDataAdapter). • In your project, Add a reference to Advantage.Data.Provider. For example, from Visual Studio .NET, choose "Add Reference…" from the Project menu. [login to view URL] should be available in the .NET component list. If it is not, you may need to run the Advantage .NET Data Provider installation. Note that if you drag one of the visual components from the Toolbox onto a form, a reference to [login to view URL] will be added automatically. • Specify the name space at the top of the source file prior to any declarations. For example, with C#, include this statement: using [login to view URL]; Within Visual Basic .NET, use this statement: Imports [login to view URL] • Declare and use the Advantage .NET Data Provider classes. The following is a simple example that connects to Advantage Database Server, runs a SELECT statement and prints the field values to the console. C# Example: // create a connection object AdsConnection conn = new AdsConnection( "data source=c:\\data;" + "ServerType=remote|local; TableType=ADT" ); AdsCommand cmd; AdsDataReader reader; int iField; try { // make the connection to the server [login to view URL](); // create a command object cmd = [login to view URL](); // specify a simple SELECT statement [login to view URL] = "select * from departments"; // execute the statement and create a reader reader = [login to view URL](); // dump the results of the query to the console while ( [login to view URL]() ) { for ( iField = 0; iField < [login to view URL]; iField++ ) [login to view URL]( [login to view URL](iField) + " "); [login to view URL](); } [login to view URL](); } catch ( AdsException e ) { // print the exception message [login to view URL]( [login to view URL] ); }