记录sql数据连接

建立数据库操作类

 

using System.Data;
using System.Data.SqlClient;

namespace ConvertDB
{
    class ReadDb
    {
        SqlConnection sqlCon = new SqlConnection(); 
        DataSet ds = new DataSet();              
        public void LinkDb()
        {
            string ConnectionStr = "Password=xh@123; User ID=finance;Initial Catalog=PG;Data Source=114.255.162.124";
            sqlCon.ConnectionString = ConnectionStr;
            sqlCon.Open();
        }
        public DataSet GetData()
        {
            string sqlStr;
 //           sqlStr = "SELECT TOP 10 * FROM [PG].[dbo].[STK_DIV_INFO]";
            sqlStr = "SELECT TOP 10 "+  " [SEQ],[CTIME] " +  "FROM [PG].[dbo].[STK_DIV_INFO]";


            SqlDataAdapter da = new SqlDataAdapter(sqlStr, sqlCon);
            da.Fill(ds, "tablename");
            return ds; 
        }  
    }
}