Posts Tagged Baza de date

How to connect to MySQL database from Visual Studio VS2010 – problems with NET connectors

IĀ have developed a Windows Application in Visual Studio 2008 some years ago and now it has been updated in Visual Studio 2010.

The application connects to a MySQL database and after porting it to VS2010, the IDE does not show the connection to the MySQL in Server Explorer. Also when trying to add the data connection, in the Choose Data Source window it does not show the MySQL Database. Read the rest of this entry »

, ,

29 Comments

Patch pentru conectarea la SQL Server 2008 din Visual Studio 2008

Mediul de programare Visual Studio este utilizat pentru dezvoltarea de aplicatii software, utilizand tehnologii Microsoft.
Conectarea din mediul de dezvoltare Visual Studio 2008 la o baza de date creata pe un server SQL Server 2008 se poate realiza daca exista instalat un patch pentru Visual Studio 2008. Patch-ul poate fi descarcat si instalat de la adresa http://support.microsoft.com/kb/945855.
Dupa restartarea calculatorului, la deschiderea unei aplicatii in Visual Studio 2008 exista posibilitatea de realizare a unei conexiuni la o baza de date creata pe un server SQL Server 2008.
Read the rest of this entry »

, , , ,

No Comments

Crearea unei conexiuni ADO.NET si utilizarea DataSet in VB.NET

Databinding reprezinta caracteristica a controalelor de interfata VB.NET de extragere si afisare a datelor dintr-o sursa de date (baza de date) intr-un mod transparent pentru utilizator. Fiecare control de interfata legat de o sursa de date poseda propriile proprietati.
Legarea controalelor de interfata cu surse de date se realizeaza prin clase suport definite in mediul de programare bazat pe .NET Framework. Un exemplu in acest sens este ADO.NET (System.Data) care creeaza o conexiune la o sursa de date (baza de date).

Read the rest of this entry »

, , , , , , , , ,

No Comments

Definirea relatiilor intre tabelele unei baze de date in VB.NET

Se considera tabelul ANGAJATI cu structura definita la [...]. Tabelul este inclus intr-o baza de date construita in VB.NET la [...], avand denumirea Ang.
Definirea unei relatii intre tabelele bazei de date presupune existenta a cel putin doua tabele. In baza de date Angajati.sdf, se adauga tabelul AccessAng prin care se defineste tipul de acces la resursele materiale, financiare si informationale ale organizatiei.

Read the rest of this entry »

, , , , , , , , ,

1 Comment

How to: Create the Structure of a Table Using Design View in Microsoft Access 2003

Creating a table using Design View in Access 2003 consists in explicit defining the data types [...] associated to the fields and their properties.
TableĀ EMPLOYEES is considered, having the following structure: IDAng, DenDep, Nume, Pren, Functia, AdrEmail, TelInt, Adresa, Loc, Jud, CodPost, TelAcs, TelJob, DataNast, DataAng, Obs.

Read the rest of this entry »

, , , , , , , ,

No Comments

Data Types Associated to the Fields Defined for a Table in Microsoft Access 2003

In Access 2003, each field of a table has associated a data type and properties of these ones.

Data types used to define fields in an Access 2003 table are:

Read the rest of this entry »

, , , , ,

1 Comment

Crearea unei baze de date in VB.NET

Baza de date este un termen ce desemneaza un fisier structurat, creat in vederea stocarii si administrarii datelor. Administrarea datelor in baze de date vizeaza operatii precum: regasirea, sortarea, gruparea si relationarea datelor.
Stocarea si administrarea datelor se realizeaza prin intermediul sistemelor de gestiune a bazelor de date SGBD. Un exemplu de astfel de SGBD este SQL Server. Mai mult, acesta este un SGBD Relational.

Read the rest of this entry »

, , , , , , , , ,

1 Comment

How to: Create a Table Object in a Database Microsoft Access 2003

Creating a table in a database Microsoft Access 2003 consists in:

  • selecting the type of object Tables in the Database Window [...];
  • command launch New in the toolbar of the Database Window;
  • selecting how to create the table from the list of the options in the dialog box New Table.

Read the rest of this entry »

, , , ,

1 Comment

How to: Create a Database in Microsoft Access 2003

A database contains information on data to be stored and managed.

Creating a database Microsoft Access 2003 is made either from a blank database, either from a template of the database provided by Microsoft Access 2003 application.

Read the rest of this entry »

, , ,

1 Comment

Crearea structurii unui tabel inclus intr-o baza de date Microsoft Access 2003 utilizand Design View

Crearea unui tabel utilizand Design View in Access 2003 consta in definirea explicita a tipurilor de date [...] asociate campurilor si proprietatile acestora.

Se considera relatia ANGAJATI cu urmatoarea structura: IDAng, DenDep, Nume, Pren, Functia, AdrEmail, TelInt, Adresa, Loc, Jud, CodPost, TelAcs, TelJob, DataNast, DataAng, Obs.

Read the rest of this entry »

, , , , , , , ,

1 Comment