用到的表:Class
Sql Server 存储过程:
create procedure usp_Class_select
asbegin
select * from Class
end
---------------------------------------------------------------------------------------------------------------
app.configer:
<connectionStrings>
<add name="MySchoolconStr" connectionString="Data Source=PC_THINK-THINK;Initial Catalog=MySchool;User ID=sa; Password=111111"/>
</connectionStrings>
---------------------------------------------------------------------------------------------------------------
ClassModel2.cs类:
public class ClassModel2
{
public string clsName
{
get;
set;
}
public string clsDesc
{
get;
set;
}
}
---------------------------------------------------------------------------------------------------------------
后台代码:
string Constr = ConfigurationManager.ConnectionStrings["MySchoolconStr"].ConnectionString;
private void 查询表中记录的存储过程_Load(object sender, EventArgs e)
{
List<ClassModel2> list = new List<ClassModel2>();
using (SqlConnection conn = new SqlConnection(Constr))
{
conn.Open();
string sp_name = "usp_Class_select";
using (SqlCommand cmd = new SqlCommand(sp_name, conn))
{
cmd.CommandType = CommandType.StoredProcedure;
using (SqlDataReader reader =cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
ClassModel2 model = new ClassModel2();
model.clsName=reader.IsDBNull(reader.GetOrdinal("cName"))?string.Empty:reader.GetString(reader.GetOrdinal("cName"));
model.clsDesc = reader.IsDBNull(reader.GetOrdinal("cDescription")) ? string.Empty : reader.GetString(reader.GetOrdinal("cDescription"));
list.Add(model);
}
}
}
}
dataGridView1.DataSource = list;
}
}
运行结果: