Notes

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SQLite;
using System.IO;


namespace WindowsFormsApp10
{
public partial class Form1 : Form
{
public string path = "Data_table.db";
public string cs = @"URI=file:"
+ Application.StartupPath + "\data_table.db";
private SQLiteConnection con;
private SQLiteCommand cmd;
private SQLiteDataAdapter adapter;
private DataSet ds = new DataSet();
private DataTable dt = new DataTable();
private int index;

public Form1()
{
InitializeComponent();
}

private void SetConnection()
{
con = new SQLiteConnection(cs);
}
private void ExecuteQuery(string txtquery)
{
SetConnection();
con.Open();
cmd= con.CreateCommand();
cmd.CommandText = txtquery;
cmd.ExecuteNonQuery();
con.Close();
}

private void ShowData()
{
SetConnection();
con.Open();
string stm = "SELECT * FROM test";
adapter = new SQLiteDataAdapter(stm, con);
ds.Reset();
adapter.Fill(ds);
dt = ds.Tables[0];
dataGridView1.DataSource = dt;
con.Close();
}

private void CreateDB()
{
if (!System.IO.File.Exists(path))
{
SQLiteConnection.CreateFile(path);
using(var sqlite = new
SQLiteConnection(@"Data Source=" + path))
{
sqlite.Open();
string sql = "create table test(id INTEGER primary key, name varchar(20), username varchar(20), pass varchar(20), image_name varchar(20), Image1 image)";
SQLiteCommand command = new SQLiteCommand(sql,sqlite);
command.ExecuteNonQuery();
}
}
else
{
Console.WriteLine("Database Cannot be created!","Error Message");
return;
}
}



private void Form1_Load(object sender, EventArgs e)
{
CreateDB();
ShowData();
}

private void button1_Click(object sender, EventArgs e)
{
try {
using (OpenFileDialog ofd = new OpenFileDialog()
{ Filter = "Select image(*.jpg; *.png; *.Gif)|*.Jpg; *.png; *.Gif", Multiselect = false })
{
if(ofd.ShowDialog() == DialogResult.OK)
{
pictureBox1.Image = Image.FromFile(ofd.FileName);
textBox3.Text = ofd.FileName;
}
}

} catch {
MessageBox.Show("Data cannot be inserted!");
return;
}
}

private void button2_Click(object sender, EventArgs e)
{
try
{
string txtquery = "update test set name='"
+ textBox2.Text+ "' where id='" + textBox1.Text + "'";
ExecuteQuery(txtquery);
ShowData();
}
catch(Exception)
{
Console.WriteLine("Data cannot be updated!");
return;
}
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
index = e.RowIndex;
DataGridViewRow row = dataGridView1.Rows[index];
textBox1.Text = row.Cells[0].Value.ToString();
textBox2.Text = row.Cells[1].Value.ToString();
}

private void button3_Click(object sender, EventArgs e)
{
string txtquery = "DELETE FROM test WHERE id='" + textBox1.Text + "'";
ExecuteQuery(txtquery);
ShowData();
}

byte[] ConvertImageToBytes(Image img)
{
using(MemoryStream ms = new MemoryStream())
{
img.Save(ms, System.Drawing.Imaging.ImageFormat.Png);
return ms.ToArray();
}
}
public Image ConvertByteArrayToImage(byte[] data)
{
using(MemoryStream ms = new MemoryStream())
{
return Image.FromStream(ms);
}
}


}
}