using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public class DALUsuario
{
private SqlConnection coneccion;
private SqlCommand comando;
public DALUsuario()
{
coneccion = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
comando = new SqlCommand();
comando.CommandType = CommandType.Text;
}
public DataSet SeleccionarDatos()
{
comando.CommandText = "SELECT [id], [noticias]FROM [Noticias]";
comando.Connection = coneccion;
DataSet mydataset = new DataSet();
try
{
coneccion.Open();
SqlDataAdapter da = new SqlDataAdapter(comando.CommandText,comando.Connection);
da.Fill(mydataset, "Maniotas");
}
catch (Exception e)
{ throw; }
finally
{
coneccion.Close();
}
return mydataset;
}
}