private void Form1_Load(object sender, EventArgs e)
        {
            ds=new DataSet();
            adapter = new System.Data.SqlClient.SqlDataAdapter("dbo.proc_derevo", cn);
            adapter.SelectCommand.CommandType = CommandType.StoredProcedure;
            adapter.SelectCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@id",    SqlDbType.Int));
            adapter.SelectCommand.Parameters["@id"].Value =  1 ;
   adapter.Fill(ds, "Tovar");
          
            dataGridView1.DataSource = ds.Tables["Tovar"].DefaultView;
        }

private void treeView1_AfterSelect(object sender, TreeViewEventArgs e)
        {
            string str;
            int id;
           //тут на клиенте я храню id в текстовой форме
            str=treeView1.SelectedNode.Name;
            id = Convert.ToInt32(str); 
            adapter.SelectCommand.Parameters["@id"].Value = id;
            dataGridView1.Refresh();
        }

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
drop PROCEDURE proc_derevo
GO
CREATE PROCEDURE proc_derevo
(
	@id int
)
AS
BEGIN
	SET NOCOUNT ON;
	with cte([id_razdel],[id_parent_razdel],[Name])
	as
	(
	select a.[id_razdel],a.[id_parent_razdel],a.[Name]
	from [oks].[dbo].[Razdel] a
	where a.[id_razdel]=@id
	union all
	select a.[id_razdel],a.[id_parent_razdel],a.[Name]
	from [oks].[dbo].[Razdel] a
	inner join
	cte b
	on b.[id_razdel]=a.[id_parent_razdel]
	)
	select c.*
	from cte b
	inner join
	[oks].[dbo].[Tovar] c
	on b.[id_razdel]=c.[id_razdel];
END
GO

 private void RetriveData(int id)
        {
            String sqlstr;
            sqlstr = "select * from [Tovar]  where id_razdel=" + id.ToString();
            adapter = new System.Data.SqlClient.SqlDataAdapter(sqlstr, cn);
            ds.Clear();
            adapter.Fill(ds);
            dataGridView1.DataSource = ds.Tables["Tovar"].DefaultView;
        }

private void добавитьToolStripMenuItem_Click(object sender, EventArgs e)
        {
            DataRow workRow = null;
            workRow = oksDataSet.Tovar.NewRow();
            foreach(System.Windows.Forms.DataGridViewRow dRow in dataGridView1.SelectedRows)
            {
                workRow[ 0 ] =  690 ;
                workRow[ 1 ] = dRow.Cells[ 0 ].Value;
                workRow[ 2 ] = dRow.Cells[ 2 ].Value;
                oksDataSet.Tovar.Rows.Add(workRow);
            }
       }

 private void добавитьToolStripMenuItem_Click(object sender, EventArgs e)
        {

            foreach(System.Windows.Forms.DataGridViewRow dRow in dataGridView1.SelectedRows)
            {
                String sqlstr;
                sqlstr="INSERT INTO [Tovar] ";
                sqlstr+="( [Name] , [Ed_izm] ) VALUES ";
                sqlstr+="('"+dRow.Cells[0].Value.ToString()+"','"+ dRow.Cells[2].Value.ToString()+"')";
                sqlstr += " GO";
                System.Data.SqlClient.SqlCommand cmd = cn.CreateCommand();
                System.Data.SqlClient.SqlTransaction transaction;
                transaction = cn.BeginTransaction("SampleTransaction");
                try
                {
                    cmd.CommandText = sqlstr;
                    cmd.ExecuteNonQuery();
                }
                catch (Exception ex)
                { }
            }

cn.ConnectionString=
"Data Source=REYCOMPUTER\SQLEXPRESS;Initial Catalog=oks;Integrated Security=True;TrustServerCertificate=True;Context Connection=False"