This is my code and error message when you running say:

> 
> An unhandled exception of type System.Data.SqlClient.SqlException
>  occurred in System.Data.dll
> 
> 
> 

on this `da.fill(dt);`

```
SqlConnection con = new SqlConnection("Data Source=ANTONIANGGA-PC\\SQLEXPRESS;Initial Catalog=FullandStarving;Integrated Security=True");
SqlCommand cmd;
SqlDataAdapter da;
DataTable dt = new DataTable();

public FormProduksi()
{
   InitializeComponent();
   showgridview();     
}

private void showgridview()
{
    con.Open();
    dt.Clear();
    cmd = new SqlCommand("SELECT * FROM Produksi", con);
    //cmd.CommandType = CommandType.StoredProcedure; done :D
    da = new SqlDataAdapter(cmd);
    da.Fill(dt);
    dataGridView1.DataSource = dt;
    con.Close();
}

private void button2_Click(object sender, EventArgs e)
{
    //Datetimepicker to Database
    string dProduksi = DateTime.Parse(dtmProduksi.Text).ToString("yyyy-MM-dd");

    try{
        con.Open();
        cmd = new SqlCommand("insert into Produksi (IDProduksi,IDPhoto,TanggalProduksi,NamaKaryawan,KeteranganPhoto) Values('" + txtIdpro.Text + "','" + txtIdPhoto.Text + "','" + dProduksi + "','" + txtNamaKaryawan.Text + "','" + rxtKtrphoto.Text + "')", con);
        cmd.ExecuteNonQuery();
        MessageBox.Show("Update telah di jalankan");
        showgridview();
        clear();
        con.Close();

    }
    catch (Exception ex)
    {
        MessageBox.Show(ex.Message);
    }
}

```

[![is done now](https://i.stack.imgur.com/SeKPY.jpg)](https://i.stack.imgur.com/SeKPY.jpg)

[![The update successfully](https://i.stack.imgur.com/HzD07.jpg)](https://i.stack.imgur.com/HzD07.jpg)

that update successfully but cant refresh, so i do quit that form and open can see it
[![Update](https://i.stack.imgur.com/VKlrJ.jpg)](https://i.stack.imgur.com/VKlrJ.jpg)