private void AdminForm_Load(object sender, EventArgs e)
{
using (VRAMEntities db = new VRAMEntities())
{
dgvSearch.AutoGenerateColumns = false;
List <Member> list = db.Members.SqlQuery("SELECT * FROM Member").ToList();
dgvSearch.DataSource = list;
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
using (VRAMEntities db = new VRAMEntities())
{
dgvSearch.AutoGenerateColumns = false;
//List<Member> list = db.Members.ToList();
string Searchname = txtMemberName.Text.Trim();
if (Searchname.Equals(""))
{
MessageBox.Show("이름을 적지 않았습니다.");
}
else
{
List <Member> list = db.Members.SqlQuery("SELECT * FROM Member WHERE MemberName = '" + Searchname + "'").ToList();
dgvSearch.DataSource = list;
}
}
}
