13 DE MARZO 2013
INFORMACION PARA LOS ESTUDIANTES
3
Microsoft Confidential
4
Microsoft Confidential
DataSet
DataTable
Connection, Command, DataAdapter y
DataReader.
5
Microsoft Confidential
6
Microsoft Confidential
7
Microsoft Confidential
8
Microsoft Confidential
9
Microsoft Confidential
10
Microsoft Confidential
11
Microsoft Confidential
12
Microsoft Confidential
Connection
www.connectionstrings.com
13
Microsoft Confidential
SqlConnection cn;
cn = new SqlConnection(CadenaDeConexión);
Ó
SqlConnection cn =new SqlConnection(CadenaDeConexión);
14
Microsoft Confidential
15
Microsoft Confidential
16
Microsoft Confidential
Servidor
Bases de Datos
17
Microsoft Confidential
18
Microsoft Confidential
19
Microsoft Confidential
20
Microsoft Confidential
ExecuteReader()
Ej: SELECT * FROM Clientes
ExecuteScalar()
Ej: SELECT Max(FacturaNumero) FROM Facturas
ExecuteNonQuery()
21
Microsoft Confidential
22
Microsoft Confidential
23
Microsoft Confidential
24
Microsoft Confidential
25
Microsoft Confidential
Fill
Update
SqlDataAdapter
SqlCommand SqlConnection
26
Microsoft Confidential
27
Microsoft Confidential
Descargar

Acceso - Msc.Ing.Leonel Martinez | SITIO DE TECNOLOGIA …