简单的数据库调用
/// <summary>
/// 秋式开源团队---WinForm小组数据访问类 编写:铁公鸡-权
/// 2011-04-19
/// </summary>
public class QSW_Data_Sql
{
string QSW_SqlCommand_Text = null;
string QSW_SqlConnection_String = null;
SqlConnection QSW_SqlConnection = null;
SqlCommand QSW_SqlCommand = null;
SqlDataAdapter QSW_SqlDataAdapter = null;
DataSet QSW_DataSet = null;
/// <summary>
/// SQL连接字符串属性
/// </summary>
public string QSW_SqlConnectionString
{
get
{
return QSW_SqlConnection_String;
}
set
{
QSW_SqlConnection_String = value;
}
}
/// <summary>
/// SQL命令文本属性
/// </summary>
public string QSW_SqlCommandText
{
get
{
return QSW_SqlCommand_Text;
}
set
{
QSW_SqlCommand_Text = value;
}
}
/// <summary>
/// 根据查询文本查询数据库,并返回数据集。
/// </summary>
/// <param name="ConnectString">数据库连接字符串</param>
/// <param name="CommandText">查询命令文本</param>
/// <returns>返回数据通道填充了的数据集</returns>
public DataSet QSW_SelectDatabase(string ConnectString,string CommandText)
{
QSW_SqlConnection = new SqlConnection(ConnectString);
QSW_SqlConnection.Open();
QSW_SqlCommand = new SqlCommand(CommandText, QSW_SqlConnection);
QSW_SqlDataAdapter = new SqlDataAdapter(QSW_SqlCommand);
QSW_DataSet = new DataSet();
QSW_SqlDataAdapter.Fill(QSW_DataSet);
return QSW_DataSet;
}
}
调用上面类的方法:
QSW_Data_Sql qsw_data = new QSW_Data_Sql();
qsw_data.QSW_SqlConnectionString = @"Data Source=LINHQ-PC;Initial Catalog=UR_Manage;Integrated Security=True";
qsw_data.QSW_SqlCommandText = "SELECT * FROM Users";
DataSet ds = qsw_data.QSW_SelectDatabase(qsw_data.QSW_SqlConnectionString, qsw_data.QSW_SqlCommandText);
dataGridView1.DataSource = ds.Tables[0];
效果如下: