codigo para conexion a base de datos, Essays (high school) of French

Download codigo para conexion a base de datos and more Essays (high school) French in PDF only on Docsity! Visual Basic Imports System.Data Imports System.Data.SqlClient Dim sCnn As String sCnn = "data source = ServidorSQL; initial catalog = BaseDatos; user id = Usuario; password = Contraseña" Dim sSel As String = "SELECT * FROM NombreTabla" Dim da As SqlDataAdapter Dim dt As New DataTable Try da = New SqlDataAdapter(sSel, sCnn) da.Fill(dt) Me.GridView1.DataSource = dt Me.GridView1.DataBind() LabelInfo.Text = String.Format("Total datos en la tabla: {0}", dt.Rows.Count) Catch ex As Exception LabelInfo.Text = "Error: " & ex.Message End Try C# using System.Data.SqlClient; string sCnn; sCnn = "data source = ServidorSQL; initial catalog = BaseDatos; user id = Usuario; password = Contraseña"; string sSel = "SELECT * FROM NombreTabla"; SqlDataAdapter da; DataTable dt = new DataTable(); try { da = new SqlDataAdapter(sSel, sCnn); da.Fill(dt); this.GridView1.DataSource = dt; this.GridView1.DataBind(); LabelInfo.Text = String.Format("Total datos en la tabla: {0}", dt.Rows.Count); } catch(Exception ex) { LabelInfo.Text = "Error: " + ex.Message; }