I am developing an Multimedia Data management System, where I need to save any folder location path in database using textbox. I retrieve data by Data Grid View and from the Data Grid View I want to click the path and folder should be opened. So how can I do this?

I give my project view picture:

![enter image description here](https://i.stack.imgur.com/vSs1J.jpg)

```
private void Save_button1_Click(object sender, EventArgs e)
{
    try
    {
        string movieName = Name_textBox1.Text;
        string folderLocation = location_textBox2.Text;

        string query = "INSERT INTO movie(Name ,Location ) VALUES('" + movieName + "','" + folderLocation + "')";
        op.SaveInformation(query);
        op.Load_Table1(dataGridView1);        
        Name_textBox1.Text= "";
        location_textBox2.Text= "";
    }
    catch (Exception ex)
    {
        MessageBox.Show(ex.Message);
    }
}

public void Load_Table1(DataGridView dv)
{
    string query = "SELECT * FROM movie;";
    SqlConnection Conn = op.create_connection();
    SqlCommand cmd = new SqlCommand(query, Conn);
    try
    {
        SqlDataAdapter sda = new SqlDataAdapter();
        sda.SelectCommand = cmd;
        dataset = new DataTable();
        sda.Fill(dataset);
        BindingSource bSource = new BindingSource();
        bSource.DataSource = dataset;
        dv.DataSource = bSource;
        sda.Update(dataset);
    }
    catch (Exception ex)
    {
        MessageBox.Show(ex.Message);
    }
}

public void SaveInformation(string query)
{
    try
    {
        SqlConnection Conn = create_connection();
        SqlCommand cmd = new SqlCommand(query, Conn);
        cmd.ExecuteNonQuery();
        Conn.Close();
        MessageBox.Show("InformationSaved Successfully", "Confirmation", MessageBoxButtons.OK, MessageBoxIcon.Information);
    }
    catch (Exception ex)
    {
        MessageBox.Show(ex.Message);
    }
}

```