using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;
/// <summary>
/// Summary description for dbClass
/// </summary>
public class dbClass
{
String connectionString = "Data Source=127.0.0.1;Initial Catalog=TestDb;Persist Security Info=True;User ID=Test1;Password=123456";
SqlConnection conn = null;
SqlCommand myCommand = null;
DataSet ds = null;
public dbClass()
{
}
//连接数据库
public string conDb()
{
conn = new SqlConnection(connectionString);
myCommand = conn.CreateCommand();
try
{
conn.Open();
}
catch (SqlException e)
{
throw new Exception(e.Message);
}
return "OK";
}
public DataSet gvBind(string strSQL) {
try
{
SqlDataAdapter da = new SqlDataAdapter(strSQL,connectionString);
ds = new DataSet();
da.Fill(ds);
}
catch (SqlException e)
{
throw new Exception(e.Message);
}
return ds;
}
}
protected void Page_Load(object sender, EventArgs e)
{
string strSQL = "select * from testtable1";
dbClass dbc = new dbClass();
if (dbc.conDb().Equals("OK"))
{
GridView2.DataSource = dbc.gvBind(strSQL);
GridView2.DataBind();
}
}