ATUL_v1.Atul_v1Data.ConfigVariablesGetByScriptName C# (CSharp) Метод

        public DataTable ConfigVariablesGetByScriptName(string ScriptName)
        {
            SqlCommand cmd = new SqlCommand("exec dbo.Atul_ConfigVariablesGetByScriptName_sp @ScriptName", this._connection);
            cmd.Parameters.Add(new SqlParameter("@ScriptName", ScriptName));
            SqlDataAdapter da = new SqlDataAdapter();
            da.SelectCommand = cmd;
            DataTable returnTable = new DataTable(); returnTable.TableName = "atulConfigVars";
            da.Fill(returnTable);
            return returnTable;
        }

 /// <summary>
 /// Gets the variables get by scriptname.
 /// </summary>
 /// <param name="ScriptName">Name of the script.</param>
 /// <returns></returns>
 public string ConfigVariablesGetByScriptName(string ScriptName)
 {
     DataTable returnTable = new DataTable();
     Atul_v1Data adb = new Atul_v1Data();
     returnTable = adb.ConfigVariablesGetByScriptName(ScriptName);
     return JsonMethods.GetJSONString(returnTable);
 }