title: Error when inserting multiple json string
body: <p>This code will work however it can only can insert one json string to sql db. If the json string are multiple it will insert only one json string, with this error</p>
  
  <blockquote>
    <p>usp_insert_schedule has too many arguments specified. </p>
  </blockquote>
  
  <p>Can someone give me links of tutorial or guide me at least.</p>
  
  <pre><code>using Newtonsoft.Json;
  
  //Object Root
  public class jObt
  {
      public string empid { get; set; }
      public string status { get; set; }
  }
  
  private void insrt_jString()
  {
      iScedule isc = new iScedule();
  
      //sql stored proc
      String Query = iSQL.STORED_PROCEDURE_SCH_ADD;
  
      //sql class for insert
      iEmp usr = new iEmp(Query);
  
      string barc =  txtBarCode.Text.Trim(' ');
      string ddate = isc.get_date();
  
      //http://get w/ barc &amp; ddate as param
      string input = isc.jValue(barc, ddate);
      string input = @"{""empid"":""B14"",""status""}{""empid"":""B15"",""status"":""Morning""}";
  
      var output = input.Split(new[] { '{', '}' }, StringSplitOptions.RemoveEmptyEntries)
             .Select(x =&gt; "{" + x + "}")
             .ToList();
  
      foreach (var json in output) 
      {
          jObt ob = JsonConvert.DeserializeObject&lt;jObt&gt;(json);
          usr.Insert_Schedule(ob.empid, ob.status);
      }   
  }
  
  //Class for Insert_Schedule 
  public class iEmp: iCon
  {
      public string Query;
      public string ComString { get; protected set; }
      public iEmp(string ComS): base(ComS) 
      {
          this.Query = ComS;
          Comm.Parameters.Clear();
          Comm.CommandType = CommandType.StoredProcedure;
          Comm.CommandText = this.ComString;
          Comm.Connection = Conn;
      }
  
      //SCHEDULE 
      public void Insert_Schedule(string empid, string status) 
      {
          Comm.Parameters.AddWithValue("@empid", empid);
          Comm.Parameters.AddWithValue("@status", status);
          Comm.ExecuteNonQuery(); 
      }
  }
  </code></pre>
  
  <p>STORED PROC </p>
  
  <pre><code>CREATE PROC [dbo].[usp_insert_schedule] 
  @empid [varchar](32), 
  @status [varchar](20)
  AS
  INSERT INTO Schedule(Ctrl_ID, Status)
       VALUES (@empid, @status)
  </code></pre>