title: String operations in c# asp.net with respect to GridView and DataSource
body: <p>C# -- ASP.Net -- Webforms</p>
  
  <p>I have a database <strong>X</strong>  (Column1 - PrimaryKey)</p>
  
  <pre><code>`[Column1(int)] -- [Column2(string)]`
  
            `[12] -- [ab]`
  
            `[34] -- [cd]`
  
            `[56] -- [xy]`
  
            `[78] -- [ac]`
  </code></pre>
  
  <p>I have another database <strong>Y</strong> (Column1 - PrimaryKey)</p>
  
  <pre><code>`[Column1(int)] -- [Column2(string)]`
  
            `[A1] -- [12,34,56]`
  </code></pre>
  
  <p>I have a GridView say GV in which I'm displaying the <strong>A1</strong>'s column2 from database <strong>Y</strong>:</p>
  
  <p>as </p>
  
  <p>-- Edit -- Delete -- <code>ab</code></p>
  
  <p>-- Edit -- Delete -- <code>cd</code></p>
  
  <p>-- Edit -- Delete -- <code>xy</code> </p>
  
  <p>with <strong>edit</strong> and <strong>delete</strong> option on each row, </p>
  
  <p>where on each <strong>edit</strong>, I need to update the <strong>string</strong> <code>[12,34,56]</code> of <code>[A1]</code> in database <strong>y</strong>.</p>
  
  <p>Say I'm editing the first row of GridView <strong>ab</strong> as <strong>ac</strong> which maps to the 4th row in databse <strong>X</strong>. My result should be <code>[78,34,56]</code> in <code>[A1]</code> of database <strong>Y</strong>.</p>
  
  <p>Apologies, if post is duplicate..</p>