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];
        }
    }
}

posted on 2012-03-06 15:25  子虚乌有  阅读(235)  评论(0)    收藏  举报