Clase para conectar asp.net visual basic con base de datos sql
using Microsoft.Owin.Security;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
using System.Text;
using System.Net.Mail;
using System.Net.Mime;
using System.Net;
using System.Collections;
using System.Drawing;
using System.Globalization;
using System.IO;
using System.Configuration;
using iTextSharp.text;
using iTextSharp.text.html.simpleparser;
using iTextSharp.text.pdf;
using WebSite17;
namespace WebSite17
{
public class Datos2
{
private string cadena = @"Data Source=SQL5023.HostBuddy.com;Initial Catalog=DB_9DE8D0_Base;User Id=DB_9DE8D0_Base_admin;Password=P4ch3rr3s;";
public SqlConnection cn;
private SqlCommandBuilder cmb;
public DataSet ds = new DataSet();
public SqlDataAdapter da;
public SqlCommand comando;
private void conectar()
{
cn = new SqlConnection(cadena);
}
public Datos2()
{
conectar();
}
//consultar
public void consultar(string sql, string tabla)
{
ds.Tables.Clear();
da = new SqlDataAdapter(sql, cn);
cmb = new SqlCommandBuilder(da);
da.Fill(ds, tabla);
}
//eliminar
public bool eliminar(string tabla, string condicion)
{
cn.Open();
string sql = "delete from " + tabla + " where " + condicion;
comando = new SqlCommand(sql, cn);
int i = comando.ExecuteNonQuery();
cn.Close();
if (i > 0)
{
return true;
}
else
{
return false;
}
}
// eliminar toda las filas de la tabla
public bool eliminarfilas(string tabla)
{
cn.Open();
string sql = "delete from " + tabla ;
comando = new SqlCommand(sql, cn);
int i = comando.ExecuteNonQuery();
cn.Close();
if (i > 0)
{
return true;
}
else
{
return false;
}
}
//actualizar
public bool actualizar(string tabla, string campos, string condicion)
{
cn.Open();
string sql = "update " + tabla + " set " + campos + " where " + condicion;
comando = new SqlCommand(sql, cn);
int i = comando.ExecuteNonQuery();
cn.Close();
if (i > 0)
{ return true; }
else
{ return false; }
}
public DataTable consultar2(string tabla, string sql)
{
da = new SqlDataAdapter(sql, cn);
DataSet dts = new DataSet();
da.Fill(dts, tabla);
DataTable dt = new DataTable();
dt = dts.Tables[tabla];
return dt;
}
public bool limpiar()
{
cn.Close();
return true;
}
public bool insertar(string sql)
{
cn.Open();
comando = new SqlCommand(sql, cn);
int i = comando.ExecuteNonQuery();
cn.Close();
if (i > 0)
{
return true;
}
else
{
return false;
}
}
}
}