private void button1_Click(object sender, EventArgs e)
{
databaseConnection db = new databaseConnection();
db.open();
db.read(int.Parse(label4.Text), textBox1.Text, dataGridView1);
db.close();
}
private void button3_Click(object sender, EventArgs e)
{
databaseConnection x = new databaseConnection();
x.open();
x.insert(int.Parse(label4.Text), textBox2.Text, textBox3.Text, comboBox2.Text, pictureBox2.Image);
x.close();
}
private void button1_Click(object sender, EventArgs e)
{
databaseConnection dc = new databaseConnection();
dc.open();
if (dc.insertdata(int.Parse(textBox2.Text), textBox1.Text, textBox3.Text, textBox4.Text, textBox5.Text))
{
menu obj = new menu(textBox2.Text);
obj.Show();
}
dc.close();
}
private void button1_Click(object sender, EventArgs e)
{
databaseConnection db = new databaseConnection();
db.open();
try
{
db.read("Select * from image where id =@id and catogery=@name", int.Parse(label2.Text), comboBox1.Text, dataGridView1);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
db.close();
}
private void SerachByName_Load(object sender, EventArgs e)
{
databaseConnection db = new databaseConnection();
db.open();
try
{
db.read("SELECT * FROM image Where id=@id", int.Parse(label2.Text), "", dataGridView1);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
db.close();
}
private void button3_Click(object sender, EventArgs e)
{
databaseConnection x = new databaseConnection();
x.open();
try
{
x.insert(int.Parse(label4.Text), textBox2.Text, textBox3.Text, comboBox2.Text, pictureBox2.Image);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
x.close();
}
private void button1_Click(object sender, EventArgs e)
{
databaseConnection db = new databaseConnection();
DataTable dt = new DataTable();
db.open();
if (db.readdata(int.Parse(textBox1.Text), (textBox2.Text)) == true)
{
menu obj = new menu(textBox1.Text);
obj.Show();
}
else
{
MessageBox.Show("incorrect userID or Password");
}
db.close();
text = textBox1.Text;
}
private void button1_Click(object sender, EventArgs e)
{
databaseConnection dc = new databaseConnection();
dc.open();
try
{
if (dc.insertdata(int.Parse(textBox2.Text), textBox1.Text, textBox3.Text, textBox4.Text, textBox5.Text))
{
menu obj = new menu(textBox2.Text);
obj.Show();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
dc.close();
}
private void button1_Click(object sender, EventArgs e)
{
databaseConnection db = new databaseConnection();
DataTable dt = new DataTable();
db.open();
try
{
if (db.readdata(int.Parse(textBox1.Text), (textBox2.Text)) == true)
{
menu obj = new menu(textBox1.Text);
obj.Show();
}
else
{
MessageBox.Show("invalid user id or password");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
db.close();
}