22,302
社区成员




<add name="POCConnectionStringExp"
connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=H:\Work\Projects\POC\Code\Call_Project\CallApp\CallApp\POC.mdf;;Initial Catalog=POC;Integrated Security=True"
providerName="System.Data.SqlClient" />
<add name="POCConnectionStringExp"
connectionString="Data Source=.;AttachDbFilename=|DataDirectory|\Data\POC.mdf;Integrated Security=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
namespace CallApp
{
public class RunDataSet
{
// Static constants
private const string SQL_SELECT = "SELECT * FROM Activity_History WHERE ActivityType = 11";
/// <summary>
/// Get all requests
/// </summary>
/// <returns></returns>
public static DataSet GetRunList()
{
SqlCommand cmd = new SqlCommand();
//Open a connection
using (SqlConnection conn = new SqlConnection(SqlHelper.ConnectionStringLocalTransaction))
{
StringBuilder strSQL = new StringBuilder();
strSQL.Append(SQL_SELECT);
// Open the connection
conn.Open();
//Set up the command
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = strSQL.ToString();
//Execute the query
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adapter.Fill(ds, "ACTIVITY_HISTORY");
return ds;
}
}
}
}