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;
}
}