private void btsave_Click(object sender, EventArgs e)
{
var db = new LINQDataContext();
db.pSave(Convert.ToInt32(txrow.Text), txname.Text, txfamily.Text);
gvtable1.DataSource = db.Table1s;
}
private void btupdate_Click(object sender, EventArgs e)
{
var db = new LINQDataContext();
db.Pedit(Convert.ToInt32(txrow.Text), txname.Text, txfamily.Text);
Close();
}
private void Form1_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'mydb1DataSet.Table1' table. You can move, or remove it, as needed.
this.table1TableAdapter.Fill(this.mydb1DataSet.Table1);
var db = new LINQDataContext();
gvtable1.DataSource = db.Table1s;
}
private void txfamilysearch_TextChanged(object sender, EventArgs e)
{
var db = new LINQDataContext();
if (txfamilysearch.Text == "")
{
gvtable1.DataSource = db.Table1s; //Load All Records to Grid
}
else
{
gvtable1.DataSource = db.Table1s.Where(c => c.family.Substring(0,
txfamilysearch.Text.Length) == txfamilysearch.Text).Select(c => c);
}
}
private void gvtable1_DoubleClick(object sender, EventArgs e)
{
if (gvtable1.RowCount > 0)
{
var f = new frEdit();
f.txrow.Text = gvtable1.CurrentRow.Cells["row"].Value.ToString();
f.txname.Text = gvtable1.CurrentRow.Cells["Name"].Value.ToString();
f.txfamily.Text = gvtable1.CurrentRow.Cells["Family"].Value.ToString();
f.ShowDialog();
var db = new LINQDataContext();
gvtable1.DataSource = db.Table1s; //Refresh Grid After Edit
}
}
private void btdelete_Click(object sender, EventArgs e)
{
if (gvtable1.RowCount <= 0)
{
return;
}
if (MessageBox.Show("Do you want to delete?", "Delete", MessageBoxButtons.YesNo,
MessageBoxIcon.Question) == DialogResult.Yes)
{
var db = new LINQDataContext();
db.pDelete(Convert.ToInt32(gvtable1.CurrentRow.Cells["Row"].Value));
gvtable1.DataSource = db.Table1s; //refresh grid after update
}
}
private void btcount_Click(object sender, EventArgs e)
{
var db = new LINQDataContext();
int count = db.Table1s.Where(c => c.family == c.name).Count();
txcount.Text = count.ToString();
txcount.Text = db.Table1s.Count().ToString();
txshart.Text = db.Table1s.Where(c => c.name == "reza").Count().ToString();
//object mx = db.Table1s.Select(c => c.Mark).Max();
//var q = db.Table1s.Where(c => c.row == 1).Select(c => c).First();
//gvClass.DataSource = db.Table1s.Where(c => c.Mark < 10).Select(c => c).OrderBy(c => c.Family);
//gvClass.DataSource = db.Table1s.Select(c => c).OrderByDescending(c => c.Family);
//var q = db.Table1s.Select(c => c).OrderByDescending(c => c.row).Take(3);
//cbLesson.DataSource = db.tClasses.Select(c => c.Lesson).Distinct();
//if (db.tLogins.Where(c => c.Password == txPassword.Text).Count() == 0)
//MessageBox.Show("Invalid password!");
}
private void btshowname_Click(object sender, EventArgs e)
{
var db = new LINQDataContext();
cballname.DataSource = db.Table1s.Select(c => c.family);
}