using System.Data;
using System.Data.SqlClient;
using System;
namespace ConsultasWebExis
{
/// <summary>
/// Descripción breve de ExisCls.
/// </summary>
/// ADMCOLAS Sistemas1
public class ExisCls
{
SqlConnection cn =new SqlConnection ("uid=TUUSER;database=NAMEBD;server=TUSERVIDOR;pwd =TUCONTRASEÑA");
public DataSet GetOTs()
{
String strSelect="SELECT Ot,PedidoAuna,Proyecto FROM OTs";
try
{
SqlDataAdapter da= new SqlDataAdapter(strSelect,cn);
DataSet ds=new DataSet();
da.Fill(ds);
return ds;
}
catch
{
return null;
}
}
}