我没学过VB,只是凭直觉看着这么改了一下,也没在VC#下编译,不知道正确与否 [所有相关帖子]
using System.Data.Sqlclient;public class Catalog
{
public SqlDataReader GetDepartments()
{
SqlConnection connection = new Sqlconnection(connectionString);
SqlCommand command = new SqlCommand("GetDepartments", connection);
command.CommandType = CommandType.StoredProcedure;
connection.Open();
return command.ExecuteReader(CommandBehavior.CloseConnection);
}
private string connectionString
{
get
{
return ConfigurationSettings.AppSettings("ConnectionString");
}
set
{
;
}
}
}
using System.Data.Sqlclient;public class Catalog
{
public SqlDataReader GetDepartments()
{
SqlConnection connection = new Sqlconnection(connectionString);
SqlCommand command = new SqlCommand("GetDepartments", connection);
command.CommandType = CommandType.StoredProcedure;
connection.Open();
return command.ExecuteReader(CommandBehavior.CloseConnection);
}
private string connectionString
{
get
{
return ConfigurationSettings.AppSettings("ConnectionString");
}
set
{
;
}
}
}
{
public SqlDataReader GetDepartments
{
SqlConnection connection = new SqlConnection(connectionString);
SqlCommand command = new SqlCommand("GetDepartments", connection);
command.CommandType = CommandType.StoredProcedure;
connection.Open();
return command.ExecuteReader(CommandBehavior.CloseConnection);
} private String connectionString
get
{
return ConfigurationSettings.AppSettings("ConnectionString");
}
}