private void BtnAdd_Click(object sender, EventArgs e) { if (TxbCategory.Text != "") { sql = "select * from tbcategory where category='" + TxbCategory.Text; dt = DBClass.Get_DataTable(sql); if (dt.Rows.Count != 0) { MessageBox.Show("This category already existed!"); return; } else { sql = "insert into tbcategory values('" + TxbCategory.Text + "')"; if (DBClass.Run_SQL(sql) > 0) { CleanControls(); BindDgvCate(); MessageBox.Show("record has been inserted!"); } else { MessageBox.Show("failed!"); } } } else { MessageBox.Show("Fill txb first!"); return; } }
private void DgvCategory_CellClick(object sender, DataGridViewCellEventArgs e) { string cID = DgvCategory.SelectedRows[0].Cells[0].Value.ToString(); sql = "select * from tbcategory where cID=" + cID; dt = DBClass.Get_DataTable(sql); if (dt.Rows.Count != 0) { TxbCID.Text = dt.Rows[0][0].ToString(); TxbCategory.Text = dt.Rows[0][1].ToString(); } }
private void DgvFilePath_CellClick(object sender, DataGridViewCellEventArgs e) { string fID = DgvFilePath.SelectedRows[0].Cells[0].Value.ToString(); sql = "select * from tbfile where fID=" + fID; dt = DBClass.Get_DataTable(sql); if (dt.Rows.Count != 0) { TxbFID.Text = dt.Rows[0][0].ToString(); TxbFName.Text = dt.Rows[0][1].ToString(); TxbFPath.Text = dt.Rows[0][2].ToString(); } }
private void BindDgvFile() { sql = "select * from tbfile"; dt = DBClass.Get_DataTable(sql); if (dt.Rows.Count != 0) { DgvFilePath.DataSource = dt; } else { DgvFilePath.DataSource = null; } }
private void BindDgvCate() { sql = "select * from tbcategory"; dt = DBClass.Get_DataTable(sql); if (dt.Rows.Count != 0) { DgvCategory.DataSource = dt; } else { DgvCategory.DataSource = null; } }