Sql Server中写查询表存储过程，并在winfrom中的dataGridView控件中显示表内容
用到的表：Class
Sql Server 存储过程：
create procedure usp_Class_select
asend
---------------------------------------------------------------------------
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;
}
}
运行结果：
