Simple connect to sql server
using System;
using System.Collections.Generic;
using System.Web;
using System.Data;
using System.Data.SqlClient;
/// <summary>
/// Summary description for SQLCon
/// </summary>
public class SQLCon
{
public SQLCon()
{
//
// TODO: Add constructor logic here
//
}
//private const string strConn = "server=eureka\\SQLEXPRESS;database=PerLogDB;integrated security=SSPI";
private const string strConn = "server=eureka\\SQLEXPRESS;database=PerLogDB;uid=sa;pwd=eureka@2012";
public static DataTable GetData(string sqlstr)
{
using (SqlConnection conn = new SqlConnection(strConn))
{
SqlDataAdapter da = new SqlDataAdapter(sqlstr, conn);
DataSet ds = new DataSet();
da.Fill(ds, "TableData");
return ds.Tables[0];
}
}
}