public class StudentService
{
#region 从配置文件中读取
//从配置文件中读取数据库连接字符串
private readonly string connString = ConfigurationManager.ConnectionStrings["MySchoolConnectionString"].ToString();
private readonly string dboOwner = ConfigurationManager.ConnectionStrings["DataBaseOwner"].ToString();
#endregion #region //获取所有学员信息
public DataSet GetAllStudents()
{
DataSet da = new DataSet();
SqlConnection conn = new SqlConnection(dboOwner);
SqlDataAdapter objAdapter = new SqlDataAdapter(dboOwner
+ ".usp_SelectStudentsPartInfo",conn);
objAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
objAdapter.Fill(da,"studentTable");
conn.Close();
conn.Dispose();
return da;
}
#endregion
求高手 从索引 0 处开始,初始化字符串的格式不符合规范。
{
#region 从配置文件中读取
//从配置文件中读取数据库连接字符串
private readonly string connString = ConfigurationManager.ConnectionStrings["MySchoolConnectionString"].ToString();
private readonly string dboOwner = ConfigurationManager.ConnectionStrings["DataBaseOwner"].ToString();
#endregion #region //获取所有学员信息
public DataSet GetAllStudents()
{
DataSet da = new DataSet();
SqlConnection conn = new SqlConnection(dboOwner);
SqlDataAdapter objAdapter = new SqlDataAdapter(dboOwner
+ ".usp_SelectStudentsPartInfo",conn);
objAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
objAdapter.Fill(da,"studentTable");
conn.Close();
conn.Dispose();
return da;
}
#endregion
求高手 从索引 0 处开始,初始化字符串的格式不符合规范。
SqlDataAdapter objAdapter = new SqlDataAdapter(dboOwner
+ ".usp_SelectStudentsPartInfo",conn);
SqlConnection connection = new SqlConnection(connString);