create table standard_dictionary
(
code int not null primary key,
name nvarchar(256)
)

create table user_dictionary
(
code int not null primary key,
user_code int not null,
new_code int
)

 private SqlConnection con;
        private SqlDataAdapter adap;
        private DataSet ds;
        private SqlCommandBuilder cmdb;
        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                cmdb=new SqlCommandBuilder(adap);
                adap.Update(ds, "Test");
            }
            catch (Exception x)
            {
                Console.WriteLine(x);
            }
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            try
            {
                con = new SqlConnection();
                con.ConnectionString = @"Server=srv\x14;Database=sample;Trusted_Connection=True;";
                con.Open();
                ds = new DataSet();
                adap = new SqlDataAdapter(string.Format(@"select user_dictionary.code, user_dictionary.new_code, name from user_dictionary inner join standard_dictionary on user_dictionary.code=standard_dictionary.code and user_code={0};",uc), con);
                adap.Fill(ds, @"test");
                dataGridView1.DataSource = ds.Tables[0];
            }
            catch (Exception x)
            {
                Console.WriteLine(x);
            }
        }