protected void Bind()
{
mydatabaseDataContext db = new mydatabaseDataContext();
var results = from c in db.Login
select c;
gvCategory.DataSource = results;
gvCategory.DataBind();
}
protected void btnDelete_Click(object sender, EventArgs e)
{
mydatabaseDataContext db = new mydatabaseDataContext();
var results = from c in db.Login
where c.Id == txtCategoryId.Text
select c;
db.Login.DeleteAllOnSubmit(results);
db.SubmitChanges();
Bind();
}
protected void btnInsert_Click(object sender, EventArgs e)
{
mydatabaseDataContext db = new mydatabaseDataContext();
Login login = new Login();
login.Id = txtID.Text;
login.name = txtName.Text;
login.pass = txtPass.Text;
db.Login.InsertOnSubmit(login);
db.SubmitChanges();
}
protected void btnQueryAll_Click(object sender, EventArgs e)
{
mydatabaseDataContext db = new mydatabaseDataContext();
var result = from r in db.Login
select new
{
r.Id,
r.name,
r.pass
};
gvCategory.DataSource = result;
gvCategory.DataBind();
}
protected void btnSearch_Click(object sender, EventArgs e)
{
mydatabaseDataContext db = new mydatabaseDataContext();
var results = from c in db.Login
where System.Data.Linq.SqlClient.SqlMethods.Like(c.Id, "%" + txtSearch.Text + "%")
select c;
if (results.Count() != 0)
{
gvCategory.DataSource = results;
gvCategory.DataBind();
}
else
{
lblMsg.Text = "没有满足条件的数据";
}
}
