Clase para conectar asp.net visual basic con base de datos excel
using Microsoft.AspNet.Identity;
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.OleDb;
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 Datos4
{
private string cadena = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + AppDomain.CurrentDomain.BaseDirectory + @"\Costos.xls;Extended Properties=""Excel 8.0;HDR=YES""";
public OleDbConnection cn;
private OleDbCommandBuilder cmb;
public DataSet ds = new DataSet();
public OleDbDataAdapter da;
public OleDbCommand comando;
private void conectar()
{
cn = new OleDbConnection(cadena);
}
public Datos4()
{
conectar();
}
//consultar
public void consultar(string sql, string tabla)
{
ds.Tables.Clear();
da = new OleDbDataAdapter(sql, cn);
cmb = new OleDbCommandBuilder(da);
da.Fill(ds, tabla);
}
//eliminar
public bool eliminar(string tabla, string condicion)
{
cn.Open();
string sql = "delete from " + tabla + "where" + condicion;
comando = new OleDbCommand(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 OleDbCommand(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 OleDbDataAdapter(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 OleDbCommand(sql, cn);
int i = comando.ExecuteNonQuery();
cn.Close();
if (i > 0)
{
return true;
}
else
{
return false;
}
}
}
}