title: store json data in database using C#
body: <pre><code>temp= {
         "Vikas": 1,
         "Pravin": 2,
         "Akshay": 5,
         "Vijay": 3,
         "Prasad": 4 
        }
  </code></pre>
  
  <p>This is value I am getting in temp variable I want to store this data in database with one additional column like following </p>
  
  <pre><code>name      rank   createdby
  vikas      1       nitin
  pravin     2       nitin
  akshay     5       nitin
  vijay      3       nitin
  Prasad     4       nitin
  
  
  Note:  name column is employee name so it is anything 
  </code></pre>
  
  <p>I tried like getting in C#</p>
  
  <pre><code>[System.Web.Services.WebMethod]
  public static string setAnswer(string jsondata)
  {
      List&lt;string[]&gt; data = JsonConvert.DeserializeObject&lt;List&lt;string[]&gt;&gt;(jsondata);
  }
  </code></pre>
  
  <p><strong>Question.</strong></p>
  
  <p>1) how to get this <code>json data</code> in C# and <code>add additional column</code></p>
  
  <p>2) Is it possible to pass whole data using multiple row insert in one query instead of using loop and insert single row. </p>