public partial class Form1 : Form
    {
        SqlDataAdapter da;
        DataTable dt;
        public Form1()
        {
            InitializeComponent();
            this.dataGridView1.AutoGenerateColumns = false;

            SqlConnection con = new SqlConnection("Data Source=bcit-dsrv;Initial Catalog=planingrep;Integrated Security=SSPI");
            SqlCommand cmd;
            dt = new DataTable();
            da = new SqlDataAdapter();
            cmd = new SqlCommand();
            cmd.Connection = con;
            cmd.CommandTimeout = 600;
            cmd.CommandType = CommandType.Text;
            cmd.CommandText = "select id, duration from dbo.plan_Listrepertuar";

            // SELECT
            da.SelectCommand = cmd;
            this.dataGridView1.DataSource = dt;

            // UPDATE
            da.UpdateCommand = new SqlCommand("update dbo.plan_Listrepertuar set duration = @duration where id = @id");
            da.UpdateCommand.Connection = con;
            da.UpdateCommand.Parameters.Add("@id", SqlDbType.Int, 10);
            da.UpdateCommand.Parameters.Add("@duration", SqlDbType.Int, 10);

            da.Fill(dt);

            DataGridViewTextBoxColumn id = new DataGridViewTextBoxColumn();
            this.dataGridView1.Columns.Add(id);
            id.Name = "id";
            id.DataPropertyName = "id";
            id.HeaderText = "id";
            id.Width = 350;
            id.FillWeight = 3;
            id.CellTemplate.Style.Alignment = DataGridViewContentAlignment.TopRight;
            id.AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
            id.Visible = false;

            DataGridViewTextBoxColumn duration = new DataGridViewTextBoxColumn();
            this.dataGridView1.Columns.Add(duration);
            duration.Name = "duration";
            duration.DataPropertyName = "duration";
            duration.HeaderText = "wwwww";
            duration.Width = 350;
            duration.FillWeight = 3;
            duration.CellTemplate.Style.Alignment = DataGridViewContentAlignment.TopRight;
            duration.AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
        }

        private void button1_Click(object sender, EventArgs e)
        {
            da.Update(dt);
        }
    }

            da.UpdateCommand.Parameters.Add("@id", SqlDbType.Int, 10);
            da.UpdateCommand.Parameters.Add("@duration", SqlDbType.Int, 10);

            da.UpdateCommand.Parameters.Add("@id", SqlDbType.Int, 10, "id");
            da.UpdateCommand.Parameters.Add("@duration", SqlDbType.Int, 10, "duration");