app.config
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<connectionStrings>
<add connectionString="Data Source=PC-20120110JFDT;Initial Catalog=test1;Persist Security Info=True;User ID=sa;Password=yhb" name="connstr" />
<add connectionString="Data Source=PC-20120110JFDT;Initial Catalog=Test;Persist Security Info=True;User ID=sa;Password=yhb" name="connstr2" />
<add connectionString="Data Source=PC-20120110JFDT;Initial Catalog=School;Persist Security Info=True;User ID=sa;Password=yhb" name="connstr3" />
</connectionStrings>
</configuration>
ClassModel.cs:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
namespace WindowsFormsApplication1
{
class ClassModel
{
public string f_name
{
get;
set;
}
public string f_password
{
get;
set;
}
public string f_email
{
get;
set;
}
}
}
c#
List<ClassModel> li = new List<ClassModel>();
private void button1_Click(object sender, EventArgs e)
{
string connstr= ConfigurationManager.ConnectionStrings["connstr"].ConnectionString;
using (SqlConnection conn = new SqlConnection(connstr))
{
conn.Open();
using(SqlCommand cmd=new SqlCommand("usp_selectall",conn))
{
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
ClassModel cm = new ClassModel();
cm.f_name = reader.IsDBNull(reader.GetOrdinal("f_user")) ? string.Empty : reader.GetString(reader.GetOrdinal("f_user"));
cm.f_password = reader.IsDBNull(reader.GetOrdinal("f_password")) ? string.Empty : reader.GetString(reader.GetOrdinal("f_password"));
cm.f_email = reader.IsDBNull(reader.GetOrdinal("f_email")) ? string.Empty : reader.GetString(reader.GetOrdinal("f_email"));
li.Add(cm);
}
}
}
}
dataGridView1.DataSource = li;
sql:
create proc usp_selectall
as
begin
select * from T_denglu
end